Table RISK_THRESHOLD_FACT

Columns
MARKET_SEGMENT_IDMARKET_SEGMENT_ID
RISK_CATEGORY_IDRISK_CATEGORY_ID
RISK_THRESHOLD_AMOUNTRISK_THRESHOLD_AMOUNT
RISK_THRESHOLD_PERCENTAGE_LOWRISK_THRESHOLD_PERCENTAGE_LOW
KEY_PERFORMANCE_INDICATOR_IDKEY_PERFORMANCE_INDICATOR_ID
RISK_STATUSRISK_STATUS
RISK_THRESHOLD_PERCENTAGE_HIGHRISK_THRESHOLD_PERCENTAGE_HIGH

Foreign Key
RISK_THRE_MARK_FKRISK_THRE_MARK_FK
RISK_THRES_CATE_FKRISK_THRES_CATE_FK
RISK_THRES_SCOR_FKRISK_THRES_SCOR_FK

Primary Key
RISK_THRESHOLD_FACT_PKRISK_THRESHOLD_FACT_PK

Column Details

 MARKET_SEGMENT_ID
DescriptionThe unique identifier of the Role player category
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 RISK_THRESHOLD_AMOUNT
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RISK_THRESHOLD_PERCENTAGE_LOW
DescriptionLower boundary for the threshold
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 KEY_PERFORMANCE_INDICATOR_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



 RISK_STATUS
DescriptionE.g. low, on track
Data TypeCHAR(5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RISK_THRESHOLD_PERCENTAGE_HIGH
Descriptionupper boundary foir threshold
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 RISK_THRE_MARK_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableRISK_THRESHOLD_FACT
Child Role NameVerb1
Child Multiplicity*
Key ColumnMARKET_SEGMENT_ID [BIGINT]
Parent TableMARKET_SEGMENT
Parent Multiplicity1
Unique ConstraintMARKET_SEGMENT_PK



 RISK_THRES_CATE_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableRISK_THRESHOLD_FACT
Child Role NameVerb2
Child Multiplicity*
Key ColumnRISK_CATEGORY_ID [BIGINT]
Parent TableCATEGORY
Parent Multiplicity1
Unique ConstraintCATEGORY_PK



 RISK_THRES_SCOR_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableRISK_THRESHOLD_FACT
Child Role NameVerb3
Child Multiplicity*
Key ColumnKEY_PERFORMANCE_INDICATOR_ID [BIGINT]
Parent TableSCORE
Parent Multiplicity1
Unique ConstraintSCORE_PK

Primary Key Details

 RISK_THRESHOLD_FACT_PK
MemberMARKET_SEGMENT_ID [BIGINT]
MemberRISK_CATEGORY_ID [BIGINT]
MemberKEY_PERFORMANCE_INDICATOR_ID [BIGINT]