| BANKING Data Model |
Description | Cashflow 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. |
Column Details |
Description | The unique identifier of the Individual customer. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the standard deviation of the Income measure. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the average of the income measure of an individual customer. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identified the standard deviation of the expense measure at individual customer level. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the average of the expense measure of an individual customer. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the average of the savings measure of the customer. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the percentile of the average savings measure. |
Data Type | DECIMAL(10 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the average of the expense measure in the first week of the month. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the percentile of the expense inccurred in the in the first week of the month. |
Data Type | DECIMAL(10 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the average of the expense measure in the last week of the month. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the percentile of the expense inccurred in the in the last week of the month. |
Data Type | DECIMAL(10 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This 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 Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This 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 Type | DECIMAL(10 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
| BANKING Data Model |