Table SEGMENT_SUMMARY_PATTERN

DescriptionSegment Summary Pattern provides the summary of the customer profile. The features identified in this table aid the customer segmentation process.

Columns
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
ASSET_PERCENTAGE_IN_MONEY_MARKETASSET_PERCENTAGE_IN_MONEY_MARKET
ASSET_PERCENTAGE_IN_STOCKSASSET_PERCENTAGE_IN_STOCKS
ASSET_PERCENTAGE_IN_BONDSASSET_PERCENTAGE_IN_BONDS
ASSET_PERCENTAGE_IN_OTHERSASSET_PERCENTAGE_IN_OTHERS
TRADING_PERCENTAGE_IN_MONEY_MARKETTRADING_PERCENTAGE_IN_MONEY_MARKET
TRADING_PERCENTAGE_IN_STOCKSTRADING_PERCENTAGE_IN_STOCKS
TRADING_PERCENTAGE_IN_BONDSTRADING_PERCENTAGE_IN_BONDS
TRADING_PERCENTAGE_IN_OTHERSTRADING_PERCENTAGE_IN_OTHERS
FUNDING_TYPEFUNDING_TYPE
FUNDING_FREQUENCYFUNDING_FREQUENCY
INTERACTION_TYPEINTERACTION_TYPE
INTERACTION_FREQUENCYINTERACTION_FREQUENCY
LUMPY_FUNDING_TYPELUMPY_FUNDING_TYPE
LUMPY_FUNDING_FREQUENCYLUMPY_FUNDING_FREQUENCY

Column Details

 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionUnique identifier of the Individual Customer.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ASSET_PERCENTAGE_IN_MONEY_MARKET
DescriptionThis measure indicates the percentage of the customer asset in the Money market.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ASSET_PERCENTAGE_IN_STOCKS
DescriptionThis measure indicates the percentage of the customer asset in the Stocks.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ASSET_PERCENTAGE_IN_BONDS
DescriptionThis measure indicates the percentage of the customer asset in Bonds.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ASSET_PERCENTAGE_IN_OTHERS
DescriptionThis measure indicates the percentage of the customer asset in Others (other high risk funds)
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRADING_PERCENTAGE_IN_MONEY_MARKET
DescriptionThis measure indicates the percentage of the customer trade in the Money market.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRADING_PERCENTAGE_IN_STOCKS
DescriptionThis measure indicates the percentage of the customer trade in Stocks.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRADING_PERCENTAGE_IN_BONDS
DescriptionThis measure indicates the percentage of the customer trade in Bonds.
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRADING_PERCENTAGE_IN_OTHERS
DescriptionThis measure indicates the percentage of the customer trade in others (Other high risk funds).
Data TypeDECIMAL(10 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FUNDING_TYPE
DescriptionThis measures indicates the Funding Type pattern.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FUNDING_FREQUENCY
DescriptionThis measure identifies the Funding Frequency pattern
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INTERACTION_TYPE
DescriptionThis measure indicates the Interaction Type pattern.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INTERACTION_FREQUENCY
DescriptionThis measure indicates the Interaction Frequency Pattern.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LUMPY_FUNDING_TYPE
DescriptionThis measure indicates the Lumpy Funding Type.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LUMPY_FUNDING_FREQUENCY
DescriptionThis measure indicates the Lumpy funding frequency pattern.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse