Table POLICY_SCORE_FACT

Columns
PERSON_IDPERSON_ID
SCORE_IDSCORE_ID
SCORE_MINI_DIMENSION_IDSCORE_MINI_DIMENSION_ID
CALENDAR_DATE_IDCALENDAR_DATE_ID
PERSON_MINI_DIMENSION_IDPERSON_MINI_DIMENSION_ID
SCORE_VALUESCORE_VALUE
INSURANCE_POLICY_IDINSURANCE_POLICY_ID
INSURANCE_POLICY_MINI_DIMENSION_IDINSURANCE_POLICY_MINI_DIMENSION_ID

Foreign Key
POLICY_SCO_PERS_FKPOLICY_SCO_PERS_FK
POLICY_SCO_SCOR_FKPOLICY_SCO_SCOR_FK
POLIC_SCORE_MI_FKPOLIC_SCORE_MI_FK
POLICY_SC_CALEN_FKPOLICY_SC_CALEN_FK
POLIC_PERSON_MI_FKPOLIC_PERSON_MI_FK
POLICY__INSURA_FKPOLICY__INSURA_FK
POLI_INSURANCE__FKPOLI_INSURANCE__FK

Primary Key
POLICY_SCORE_FACT_PKPOLICY_SCORE_FACT_PK

Column Details

 PERSON_ID
DescriptionThe unique identifier of the Person
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCORE_ID
DescriptionThe unique identifier of the Score
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCORE_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Score mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_ID
DescriptionThe unique identifier of the Calendar date
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSON_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Person mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCORE_VALUE
Data TypeCHAR(5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INSURANCE_POLICY_ID
DescriptionThe unique identifier of the Top level financial services agreement
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INSURANCE_POLICY_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Top level financial services agreement mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 POLICY_SCO_PERS_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePOLICY_SCORE_FACT
Child Role NameVerb1
Child Multiplicity*
Key ColumnPERSON_ID [BIGINT]
Parent TablePERSON
Parent Multiplicity1
Unique ConstraintPERSON_PK



 POLICY_SCO_SCOR_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePOLICY_SCORE_FACT
Child Role NameVerb2
Child Multiplicity*
Key ColumnSCORE_ID [BIGINT]
Parent TableSCORE
Parent Multiplicity1
Unique ConstraintSCORE_PK



 POLIC_SCORE_MI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePOLICY_SCORE_FACT
Child Role NameVerb3
Child Multiplicity*
Key ColumnSCORE_MINI_DIMENSION_ID [BIGINT]
Parent TableSCORE_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintSCORE_MINI_DIMENSION_PK



 POLICY_SC_CALEN_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePOLICY_SCORE_FACT
Child Role NameVerb4
Child Multiplicity*
Key ColumnCALENDAR_DATE_ID [BIGINT]
Parent TableCALENDAR_DATE
Parent Multiplicity1
Unique ConstraintCALENDAR_DATE_PK



 POLIC_PERSON_MI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePOLICY_SCORE_FACT
Child Role NameVerb6
Child Multiplicity*
Key ColumnPERSON_MINI_DIMENSION_ID [BIGINT]
Parent TablePERSON_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintPERSON_MINI_DIMENSION_PK



 POLICY__INSURA_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePOLICY_SCORE_FACT
Child Role NameVerb5
Child Multiplicity*
Key ColumnINSURANCE_POLICY_ID [BIGINT]
Parent TableINSURANCE_POLICY
Parent Multiplicity1
Unique ConstraintINSURANCE_POLICY_PK



 POLI_INSURANCE__FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePOLICY_SCORE_FACT
Child Role NameVerb7
Child Multiplicity*
Key ColumnINSURANCE_POLICY_MINI_DIMENSION_ID [BIGINT]
Parent TableINSURANCE_POLICY_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINSURANCE_POLICY_MINI_DIMENSION_PK

Primary Key Details

 POLICY_SCORE_FACT_PK
MemberPERSON_ID [BIGINT]
MemberSCORE_ID [BIGINT]
MemberCALENDAR_DATE_ID [BIGINT]
MemberINSURANCE_POLICY_ID [BIGINT]