Table ACTIVITY_LIKELIHOOD_PRED_FACT_WKLY

DescriptionThis fact table identifies the likelihood of the financial events for all individual customer. This fact table is maintained at the weekly interval.

Columns
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
BALANCEBALANCE
CONFIDENCECONFIDENCE
ASSEMENT_DATEASSEMENT_DATE
TRAN_TYPETRAN_TYPE
AVG_BALANCEAVG_BALANCE

Column Details

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



 BALANCE
DescriptionThis measure identifies the predicted balance.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONFIDENCE
DescriptionThis measure identifies the confidence level of the prediction.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ASSEMENT_DATE
DescriptionThis measure identifies the assessment date of the prediction.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRAN_TYPE
DescriptionThis measure identifies the transaction type.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AVG_BALANCE
DescriptionThis measure identifies the predicted average balance.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse