Table CASHFLOW_SUMMARY_PATTERN

DescriptionCashflow summary pattern identifies the cash flow summary information at individual customer level. This table defines all the necessary features/columns that aid in identifing the cash flow pattern.

Columns
INDIVIDUAL_CUSTOMER_DIMENSIONINDIVIDUAL_CUSTOMER_DIMENSION
INCOME_STDINCOME_STD
INCOME_AVGINCOME_AVG
EXPENSE_STDEXPENSE_STD
EXPENSE_AVGEXPENSE_AVG
SAVINGS_AVGSAVINGS_AVG
PERCENTAGE_AVG_SAVINGSPERCENTAGE_AVG_SAVINGS
EXPENSE_FIRSTWEEK_AVGEXPENSE_FIRSTWEEK_AVG
EXPENSE_FIRSTWEEK_PERCENTAGEEXPENSE_FIRSTWEEK_PERCENTAGE
EXPENSE_LASTWEEK_AVGEXPENSE_LASTWEEK_AVG
EXPENSE_LASTWEEK_PERCENTAGEEXPENSE_LASTWEEK_PERCENTAGE
CREDIT_INTERVAL_AVGCREDIT_INTERVAL_AVG
CREDIT_INTERVAL_STDCREDIT_INTERVAL_STD

Column Details

 INDIVIDUAL_CUSTOMER_DIMENSION
DescriptionThe unique identifier of the Individual customer.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INCOME_STD
DescriptionThis measure identifies the standard deviation of the Income measure.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INCOME_AVG
DescriptionThis measure identifies the average of the income measure of an individual customer.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXPENSE_STD
DescriptionThis measure identified the standard deviation of the expense measure at individual customer level.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXPENSE_AVG
DescriptionThis measure identifies the average of the expense measure of an individual customer.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SAVINGS_AVG
DescriptionThis measure identifies the average of the savings measure of the customer.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERCENTAGE_AVG_SAVINGS
DescriptionThis measure identifies the percentile of the average savings measure.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXPENSE_FIRSTWEEK_AVG
DescriptionThis measure identifies the average of the expense measure in the first week of the month.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXPENSE_FIRSTWEEK_PERCENTAGE
DescriptionThis measure identifies the percentile of the expense inccurred in the in the first week of the month.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXPENSE_LASTWEEK_AVG
DescriptionThis measure identifies the average of the expense measure in the last week of the month.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXPENSE_LASTWEEK_PERCENTAGE
DescriptionThis measure identifies the percentile of the expense inccurred in the in the last week of the month.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CREDIT_INTERVAL_AVG
DescriptionThis measure identifies the average of the credit interval measure.

The credit interval measure is defined as number of days between 2 credits. For example, if the customer receives pay check every 15 days, then the credit interval is defined as 15 days.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CREDIT_INTERVAL_STD
DescriptionThis measure identifies the standard deviation of the credit interval measure.

The credit interval measure is defined as number of days between 2 credits. For example, if the customer receives pay check every 15 days, then the credit interval is defined as 15 days.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse