Table SEGMENT_DEFNITION_LIB

DescriptionEntity that records the rules that forms a segment

Columns
CUSTOMER_SEGMENT_IDCUSTOMER_SEGMENT_ID
CATEGORY_IDCATEGORY_ID
RULE_IDRULE_ID
SUB_CATEGORY_IDSUB_CATEGORY_ID
CATEGORY_VALUECATEGORY_VALUE
OPERATOROPERATOR

Column Details

 CUSTOMER_SEGMENT_ID
DescriptionUnique ID which identifies the segment
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CATEGORY_ID
DescriptionThe category for which is the rule is defined
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RULE_ID
DescriptionUnique ID which identifies the rule
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUB_CATEGORY_ID
DescriptionUnqiue ID which identifies the sub category which is a part of the rule
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CATEGORY_VALUE
Descriptionthe deviation measure from the mean

Eg : 1 standard deviation away from the population average
Data TypeDOUBLE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OPERATOR
Descriptionidenitifes whether the deviation is should be greater or lesser thatn the population average

Eg: 2 standard deviations less than the population average
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse