Table CUSTOMER

DescriptionA party to whom the modelled organisation has sold products.
Services, goods or benefits are currently, have been previously or will be supplied.

e.g. Brigitte Hydragou, as an ex-customer of Acme Insurance Company.

Columns
CUSTOMER_IDCUSTOMER_ID
ANCHOR_IDANCHOR_ID
CLAIMS_AMOUNTCLAIMS_AMOUNT
CLAIMS_COUNTCLAIMS_COUNT
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
FULL_NAMEFULL_NAME
IMPORTANCE_LEVELIMPORTANCE_LEVEL
PRIORITY_LEVELPRIORITY_LEVEL
STATUSSTATUS
STATUS_DATESTATUS_DATE
STATUS_REASONSTATUS_REASON
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
CUSTOMER_PKCUSTOMER_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 CUSTOMER_ID
DescriptionThe unique identifier of the Customer
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLAIMS_AMOUNT
DescriptionThe total monetary amount of claims, across all lines of business, related to this customer. It only includes claims made to the modelled organisation.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLAIMS_COUNT
DescriptionThe total number of claims, across all line of business, related to this customer. It only includes claims made to the modelled organisation.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionThe textual representation of information or free form comments about a role player.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FULL_NAME
DescriptionThe complete aggregated name used for identifying a role player when the components of the name are unavailable or inapplicable.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IMPORTANCE_LEVEL
DescriptionThe level of importance the customer has to the modelled organisation.

e.g. 1 (Highest priority/ VIP)
e.g. 2 (High priority)
e.g. 3 (Normal priority)
e.g. 4 (Low priority)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIORITY_LEVEL
DescriptionThe relative priority of the party role against other party roles of the same type. For example, it indicates whether a person considers a particular job to be a primary or alternative source of income.

e.g. Primary
e.g. Secondary
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionThe position of the customer within a life-cycle model consisting of a number of statuses.

e.g. Active
e.g. Ex-Customer
e.g. Prospect
e.g. Suspect
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_DATE
DescriptionThe date at which the party role becomes effective in a given status.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe reason explaining why there was a status change.

e.g. Commenced
e.g. Leave of absence
e.g. Misconduct
e.g. Resignation
e.g. Retirement
e.g. Temporary reassignment
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Customer.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CUSTOMER_PK
DescriptionThe unique identifier of the Customer
MemberCUSTOMER_ID [BIGINT]

Dependency Details

 AWM - Transformation