Entity Definition

Logical Name : CustomerAsset
Physical Name : PA_CT_AST

A customer's asset of interest to a retailer. This item may be maintained or enhanced using products and services provided by the retailer. As used in ARTS, a CustomerAsset may be a car, a boat, a home entertainment system, a computer or any big ticket item. A CustomerAsset is something that a customer owns that represents an opportunity for a retailer to sell products and services to maintain or augment the item. For example,a customer that owns a 1965 Ford Mustang may be offered accessories and parts for that make and model car.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAssetID (PK) A unique, automatically assigned identifier for an asset or other item of interest that belongs to or is related to a customer. ID_CT_AST Identity integer
Description A narrative that describes this asset or other item belonging to a CUSTOMER. DE_CT_AST DescriptionNarrative varchar(4000)
Make The trade name or brand name that this asset is typcially sold under. Note brand as used here is for naming purposes it is not the same as the Brand entity which is an identified party in the retailer's suppply chain Examples: CHEVY PANASONIC SONY IKEA etc. DE_MK DescriptionShort varchar(255)
Model A general name that further qualifies a particular CustomerAsset.Make. Models are variation of a base Make. Examples: SONY - TRINITRON APPLE - MACBOOK PRO PENNSYLVANIAHOUSE - WILLIAMSBURG DE_MDL DescriptionShort varchar(255)
FeatureStyle A generic decription that qualifies a Model based on a style. Style as used here is not the same as the Style entity. Here it is a generic descriptive owned attribute used to characterize a given CustomerAsset. DE_FTR_STYL DescriptionShort varchar(255)
FeatureColor A generic color description to qualify a CustomerAsset.FeatureStyle. DE_FTR_CLR DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
CustomerAsset is possessed by CustomerAssetAssociation

Logical Views containing CustomerAsset

Logical View
Logical 07010 - Customer Account Information Extended
Logical 07040 - Customer Segment Dependent Behavior