| BANKING Data Model |
Description | Grouping of attributes used to perform analysis on instances of Customer that share the same segment characteristics. |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Customer Segment Mini Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Income Segment classifies Customers based on the band in which the Customer's total income falls. |
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 | Importance Rating classifies Customers based on the degree to which the Customer should be given special treatment. |
Data Type | DECIMAL(5 , 2) |
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 | Loyalty Rating classifies Customer based on tendency of the Customer to remain loyal to the Financial Institution, indicating the likelihood that the Customer may or may not purchase from another Company. For example, a Loyalty Score may be High, Medium or Low depending upon how likely a Customer is to shop around for the best price and change financial service providers. |
Data Type | DECIMAL(5 , 2) |
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 | Market classifies Customers based on their industry category or characteristics. |
Data Type | VARCHAR(50) |
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 | Net Worth classifies Customers based on how much the Customer is worth to the Financial Institution. |
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 | Performance Rating classifies Customers based on performance achieved during a given time period. |
Data Type | DECIMAL(5 , 2) |
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 | Performance Status classifies Customer based on the degree to which the Customer is judged to be performing or non-performing. * Domain * Performing Potential Non Performing Non Performing Write-off |
Data Type | CHAR(10) |
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 | Primary Branch Proximity classifies Customers based on the distance of their home location to their primary branch of the Financial Institution. |
Data Type | VARCHAR(50) |
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 | Profitability classifies Customers based on their expected effect on the net income of the Financial Institution. |
Data Type | DECIMAL(10 , 2) |
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 | Relationship Age classifies Customers based on the continuous time they have had active Arrangements with the Financial Institution from the date of their first active arrangement. |
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 | Relationship Valuation classifies Customers based on the importance the Financial Institution places in the relationship with the Customer.* Domain * Normal Customer Concession Customer -- Employee Customer -- Employee Relation Customer Special Treatment Customer -- Key Business Influencer -- Strategic Customer |
Data Type | CHAR(10) |
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 | Retention Rating classifies Customers based on an evaluation of the probability that the Financial Institution will retain the particular relationship over time.* Domain * Certain To Stay Probably Will Stay Neutral Probably Will Leave |
Data Type | DECIMAL(5 , 2) |
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 | Satisfaction Rating classifies Customers based on their level of contentment with the Financial Institution. |
Data Type | DECIMAL(5 , 2) |
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 | Population Date indicates the date on which the instance of the entity was last updated. |
Data Type | DATE |
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 | Population Time indicates the time on which the instance of the entity was last updated. |
Data Type | TIMESTAMP |
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 | Population Description indicates the textual description of the population cycle. |
Data Type | VARCHAR(2000) |
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 | Source System Name indicates the textual name by which the Source System is known. |
Data Type | VARCHAR(50) |
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 | Source System Code indicates the code by which the Source System is known. |
Data Type | CHAR(10) |
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 | Unique Id In Source System indicates the unique identifier of the populated instance in the Source System. |
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 |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Member | CUSTOMER_SEGMENT_MINI_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | CUSTOMER_SEGMENT_MINI_DIMENSION_ID [BIGINT] Ascending |
| BANKING Data Model |