Table SEGMENT_DATA_DIC

DescriptionA data dictionary table which contains the categories which are being used in the segmentation process.

Eg : Policy Score, Campaign Score.. etc.,

These categories are being used in segmenting the customer

Columns
CATEGORY_IDCATEGORY_ID
CATEGORY_NAMECATEGORY_NAME
CATEGORY_DIMENSIONCATEGORY_DIMENSION
SUB_CATEGORY_IDSUB_CATEGORY_ID
SUB_CATEGORY_NAMESUB_CATEGORY_NAME

Column Details

 CATEGORY_ID
DescriptionUniquely identifies the Category
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CATEGORY_NAME
DescriptionName of the Category .

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



 CATEGORY_DIMENSION
Descriptionname of the database table which stores different category types.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUB_CATEGORY_ID
DescriptionUnique ID column of the category table
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUB_CATEGORY_NAME
DescriptionColumn which identifies the name of the sub Category
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse