Table LIFE_EVENT_ACTIVITY_FACT

DescriptionThis fact table captures the facts on the Life events of individuals and also the action performed by the individual over the life event. For example. Customer at the age of 21 may achieve the life event of "New Job" and perform actions like "Open IRA Account" or "Open Health Insurance".

Columns
PRODUCT_DIMENSION_IDPRODUCT_DIMENSION_ID
LIFE_EVENT_DIMENSION_IDLIFE_EVENT_DIMENSION_ID
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
INDIVIDUAL_ACTVITY_DIMENSION_IDINDIVIDUAL_ACTVITY_DIMENSION_ID
LIFE_EVENT_ACTIVITY_ID_LIFE_EVENT_ACTIVITY_ID_
CUSTOMER_SEGMENT_MINI_DIMENSION_IDCUSTOMER_SEGMENT_MINI_DIMENSION_ID
AGEAGE
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
EVENT_COSTEVENT_COST

Foreign Key
LIFE_EVENT_PROD_FKLIFE_EVENT_PROD_FK
LIFE_EVEN_LIFE__FKLIFE_EVEN_LIFE__FK
LIFE_EV_CALEND_FKLIFE_EV_CALEND_FK
LIFE_INDIVIDUA_FKLIFE_INDIVIDUA_FK
LIFE_INDIVIDUA_FK1LIFE_INDIVIDUA_FK1

Primary Key
LIFE_EVENT_ACTIVITY_FACT_PKLIFE_EVENT_ACTIVITY_FACT_PK

Indexes
LIFE_EVENT_ACTIVITY_FACT_PKLIFE_EVENT_ACTIVITY_FACT_PK

Column Details

 PRODUCT_DIMENSION_ID
DescriptionThe unique identifier of the Product Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_EVENT_DIMENSION_ID
DescriptionThe unique identifier of the Event Characteristics Mini Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_DIMENSION_ID
DescriptionThe unique identifier of the Calendar Date Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_ACTVITY_DIMENSION_ID
DescriptionUnique identifier of the Individual Activity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_EVENT_ACTIVITY_ID_
DescriptionUnique Identifier of the Life Event Activity Fact.
Data TypeINTEGER
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_SEGMENT_MINI_DIMENSION_ID
DescriptionUnique identifier of the customer segment.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AGE
DescriptionCustomer Age at the time of Life Event.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Customer Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EVENT_COST
DescriptionThis measure indicates the cost incurred during the life event.
Data TypeDECIMAL(10 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 LIFE_EVENT_PROD_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableLIFE_EVENT_ACTIVITY_FACT
Child Multiplicity*
Key ColumnPRODUCT_DIMENSION_ID [BIGINT]
Parent TablePRODUCT_DIMENSION
Parent Multiplicity0..1
Unique ConstraintPRODUCT_DIMENSION_PK



 LIFE_EVEN_LIFE__FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableLIFE_EVENT_ACTIVITY_FACT
Child Multiplicity*
Key ColumnLIFE_EVENT_DIMENSION_ID [BIGINT]
Parent TableLIFE_EVENT_DIMENSION
Parent Multiplicity0..1
Unique ConstraintLIFE_EVENT_DIMENSION_PK



 LIFE_EV_CALEND_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableLIFE_EVENT_ACTIVITY_FACT
Child Multiplicity*
Key ColumnCALENDAR_DATE_DIMENSION_ID [BIGINT]
Parent TableCALENDAR_DATE_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCALENDAR_DATE_DIMENSION_PK



 LIFE_INDIVIDUA_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableLIFE_EVENT_ACTIVITY_FACT
Child Multiplicity*
Key ColumnINDIVIDUAL_ACTVITY_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_ACTIVITY_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_ACTIVITY_DIMENSION_PK



 LIFE_INDIVIDUA_FK1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableLIFE_EVENT_ACTIVITY_FACT
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK

Primary Key Details

 LIFE_EVENT_ACTIVITY_FACT_PK
DescriptionUnique identifier of the Life Event Activity Fact table.
MemberLIFE_EVENT_ACTIVITY_ID_ [INTEGER]

Index Details

 LIFE_EVENT_ACTIVITY_FACT_PK
Is Uniquetrue
Is Clusteredfalse
MemberLIFE_EVENT_ACTIVITY_ID_ [INTEGER] Ascending