| BANKING Data Model |
Description | Segment Summary Pattern provides the summary information at the individual customer level. The attributes captured in the Segment Summary Pattern are used to classify the Individual Customer into a pre-defined Behavior Segment. |
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 | A measure that indicates the "WHAT DO THEY SPEND ON" dimension. It indicates the percentile of expense incurred by the Individual customer in the "Home" expense category |
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 | A measure that indicates the "WHAT DO THEY SPEND ON" dimension. It indicates the percentile of expense incurred by the Individual customer in the "Eating out" expense category |
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 | A measure that indicates the "WHAT DO THEY SPEND ON" dimension. It indicates the percentile of expense incurred by the Individual customer in the "Gas/Fuel" expense category |
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 | A measure that indicates the "WHAT DO THEY SPEND ON" dimension. It indicates the percentile of expense incurred by the Individual customer in the "Entertainment" expense category |
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 | A measure that indicates the "WHAT DO THEY SPEND ON" dimension. It indicates the percentile of expense incurred by the Individual customer in the "Travel" expense category |
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 | A measure that indicates the "WHAT DO THEY SPEND ON" dimension. It indicates the percentile of expense incurred by the Individual customer in the "Education" expense category |
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 | A measure that indicates the "WHAT DO THEY SPEND ON" dimension. It indicates the percentile of expense incurred by the Individual customer in the "Groceries" expense category |
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 indicates the percentile of expense incurred by the Individual customer in the "Kids" expense category |
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 | A measure that indicates the "WHEN DO THEY SPEND ON" dimension. This measure indicates the percentile of expense incurred by the Individual customer during the "Day". Based on the timestamp of the transaction, it is decided whether the expense is incurred during the "Day" or "Night". |
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 | A measure that indicates the "WHEN DO THEY SPEND ON" dimension. This measure indicates the percentile of expense incurred by the Individual customer during the "Night". Based on the timestamp of the transaction, it is decided whether the expense is incurred during the "Day" or "Night". |
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 | A measure that indicates the "WHERE DO THEY SPEND ON" dimension. It is determined by the location where the expense is incurred and the contact location of the Individual customer. This measure indicates the percentile of the expense incurred by the customer in the near by areas where the Individual customer is living. |
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 | A measure that indicates the "WHERE DO THEY SPEND ON" dimension. It is determined by the location where the expense is incurred and the contact location of the Individual customer. This measure indicates the percentile of the expense incurred by the customer in the remote areas. In other words, the expense is incurred at the location which is farther from the location where the Individual customer is living. |
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 | A measure that indicates the "WHERE DO THEY SPEND ON" dimension. It is determined by the location where the expense is incurred and the contact location of the Individual customer. This measure indicates the percentile of the expense incurred by the customer in the surrounding areas. In other words, the expense is incurred at the location which is in the surrounding areas from the location where the Individual customer is living. |
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 |
| BANKING Data Model |