Entity Definition

Logical Name : CustomerAssetAssociation
Physical Name : ST_AST_CT_ASCTN

A cross reference of customers to assets they own or possess.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerID (FK)(PK) A unique system assigned identifier for the Customer. ID_CT Identity integer Customer(PA_CT)
CustomerAssetID (FK)(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 CustomerAsset(PA_CT_AST)
OwnedSinceDate A self-reported original ownership/lease/acquisition date for a CUSTOMER ASSET. DC_OWN DateCalendar date
VerifiedDate The date that an asset is verified as being in the possession of a CUSTOMER. DC_VR DateCalendar date


Parent Entity Verb Phrase Child Entity
Customer posesses CustomerAssetAssociation
CustomerAsset is possessed by CustomerAssetAssociation

Logical Views containing CustomerAssetAssociation

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