Table CUSTOMER_SEGMENT_MINI_DIMENSION

DescriptionGrouping of attributes used to perform analysis on instances of Customer that share the same segment characteristics.

Columns
CUSTOMER_SEGMENT_MINI_DIMENSION_IDCUSTOMER_SEGMENT_MINI_DIMENSION_ID
ANNUAL_INCOMEANNUAL_INCOME
IMPORTANCE_RATINGIMPORTANCE_RATING
LOYALTY_RATINGLOYALTY_RATING
MARKETMARKET
NET_WORTHNET_WORTH
PERFORMANCE_RATINGPERFORMANCE_RATING
PERFORMANCE_STATUSPERFORMANCE_STATUS
PRIMARY_BRANCH_PROXIMITYPRIMARY_BRANCH_PROXIMITY
PROFITABILITYPROFITABILITY
RELATIONSHIP_AGERELATIONSHIP_AGE
RELATIONSHIP_VALUATIONRELATIONSHIP_VALUATION
RETENTION_RATINGRETENTION_RATING
SATISFACTION_RATINGSATISFACTION_RATING
POPULATION_DATEPOPULATION_DATE
POPULATION_TIMEPOPULATION_TIME
POPULATION_DESCRIPTIONPOPULATION_DESCRIPTION
SOURCE_SYSTEM_NAMESOURCE_SYSTEM_NAME
SOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE
UNIQUE_ID_IN_SOURCE_SYSTEMUNIQUE_ID_IN_SOURCE_SYSTEM
SEGMENT_NAMESEGMENT_NAME

Primary Key
CUSTOMER_SEGMENT_MINI_DIMENSION_PKCUSTOMER_SEGMENT_MINI_DIMENSION_PK

Indexes
CUSTOMER_SEGMENT_MINI_DIMENSION_PKCUSTOMER_SEGMENT_MINI_DIMENSION_PK

Column Details

 CUSTOMER_SEGMENT_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Customer Segment Mini Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANNUAL_INCOME
DescriptionIncome Segment classifies Customers based on the band in which the Customer's total income falls.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IMPORTANCE_RATING
Description Importance Rating classifies Customers based on the degree to which the Customer should be given special treatment.
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LOYALTY_RATING
DescriptionLoyalty 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 TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARKET
DescriptionMarket classifies Customers based on their industry category or characteristics.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NET_WORTH
DescriptionNet Worth classifies Customers based on how much the Customer is worth to the Financial Institution.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERFORMANCE_RATING
DescriptionPerformance Rating classifies Customers based on performance achieved during a given time period.
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERFORMANCE_STATUS
DescriptionPerformance 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_BRANCH_PROXIMITY
DescriptionPrimary Branch Proximity classifies Customers based on the distance of their home location to their primary branch of the Financial Institution.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PROFITABILITY
DescriptionProfitability classifies Customers based on their expected effect on the net income of the Financial Institution.
Data TypeDECIMAL(10 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RELATIONSHIP_AGE
DescriptionRelationship 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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RELATIONSHIP_VALUATION
DescriptionRelationship 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RETENTION_RATING
DescriptionRetention 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 TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SATISFACTION_RATING
DescriptionSatisfaction Rating classifies Customers based on their level of contentment with the Financial Institution.
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DATE
DescriptionPopulation Date indicates the date on which the instance of the entity was last updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIME
DescriptionPopulation Time indicates the time on which the instance of the entity was last updated.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DESCRIPTION
DescriptionPopulation Description indicates the textual description of the population cycle.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_NAME
DescriptionSource System Name indicates the textual name by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_CODE
DescriptionSource System Code indicates the code by which the Source System is known.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIQUE_ID_IN_SOURCE_SYSTEM
DescriptionUnique Id In Source System indicates the unique identifier of the populated instance in the Source System.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SEGMENT_NAME
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CUSTOMER_SEGMENT_MINI_DIMENSION_PK
MemberCUSTOMER_SEGMENT_MINI_DIMENSION_ID [BIGINT]

Index Details

 CUSTOMER_SEGMENT_MINI_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberCUSTOMER_SEGMENT_MINI_DIMENSION_ID [BIGINT] Ascending