Table NETWORTH_DIMENSION

DescriptionThis dimension table defines the Networth Categories identified in the Financial Institution to peer group the customer.

Columns
NETWORTH_DIMENSION_IDNETWORTH_DIMENSION_ID
NETWORTH_GROUPNETWORTH_GROUP

Primary Key
NETWORTH_DIMENSIO1NETWORTH_DIMENSIO1

Indexes
NETWORTH_DIMENSIO1NETWORTH_DIMENSIO1

Column Details

 NETWORTH_DIMENSION_ID
DescriptionUnique identifier of the network dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NETWORTH_GROUP
DescriptionNetworth group identifies the name of the networth group such as "High Networth", "Mass Affluent" and others.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 NETWORTH_DIMENSIO1
DescriptionUnique identifier of the Networth Dimension.
MemberNETWORTH_DIMENSION_ID [INTEGER]

Index Details

 NETWORTH_DIMENSIO1
Is Uniquetrue
Is Clusteredfalse
MemberNETWORTH_DIMENSION_ID [INTEGER] Ascending