Table SEGMENT_SUMMARY_PATTERN

DescriptionSegment Summary Pattern provides the summary information at the individual customer level. The attributes captured in the Segment Summary Pattern are used to classify the Individual Customer into a pre-defined Behavior Segment.

Columns
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
HOME_PERCENTAGEHOME_PERCENTAGE
EATING_OUT_PERCENTAGEEATING_OUT_PERCENTAGE
GAS_FUEL_PERCENTAGEGAS_FUEL_PERCENTAGE
ENTERTAINMENT_PERCENTAGEENTERTAINMENT_PERCENTAGE
TRAVEL_PERCENTAGETRAVEL_PERCENTAGE
EDUCATION_PERCENTAGEEDUCATION_PERCENTAGE
GROCERIES_PERCENTAGEGROCERIES_PERCENTAGE
KIDS_PERCENTAGEKIDS_PERCENTAGE
DAY_PERCENTAGEDAY_PERCENTAGE
NIGHT_PERCENTAGENIGHT_PERCENTAGE
LOCAL_PERCENTAGELOCAL_PERCENTAGE
REMOTE_PERCENTAGEREMOTE_PERCENTAGE
SURROUNDING_PERCENTAGESURROUNDING_PERCENTAGE

Column Details

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



 HOME_PERCENTAGE
DescriptionA measure that indicates the "WHAT DO THEY SPEND ON" dimension.
It indicates the percentile of expense incurred by the Individual customer in the "Home" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EATING_OUT_PERCENTAGE
DescriptionA measure that indicates the "WHAT DO THEY SPEND ON" dimension.
It indicates the percentile of expense incurred by the Individual customer in the "Eating out" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GAS_FUEL_PERCENTAGE
DescriptionA measure that indicates the "WHAT DO THEY SPEND ON" dimension.
It indicates the percentile of expense incurred by the Individual customer in the "Gas/Fuel" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ENTERTAINMENT_PERCENTAGE
DescriptionA measure that indicates the "WHAT DO THEY SPEND ON" dimension.
It indicates the percentile of expense incurred by the Individual customer in the "Entertainment" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRAVEL_PERCENTAGE
DescriptionA measure that indicates the "WHAT DO THEY SPEND ON" dimension.
It indicates the percentile of expense incurred by the Individual customer in the "Travel" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EDUCATION_PERCENTAGE
DescriptionA measure that indicates the "WHAT DO THEY SPEND ON" dimension.
It indicates the percentile of expense incurred by the Individual customer in the "Education" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GROCERIES_PERCENTAGE
DescriptionA measure that indicates the "WHAT DO THEY SPEND ON" dimension.
It indicates the percentile of expense incurred by the Individual customer in the "Groceries" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 KIDS_PERCENTAGE
DescriptionThis measure indicates the percentile of expense incurred by the Individual customer in the "Kids" expense category
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DAY_PERCENTAGE
DescriptionA measure that indicates the "WHEN DO THEY SPEND ON" dimension.

This measure indicates the percentile of expense incurred by the Individual customer during the "Day".
Based on the timestamp of the transaction, it is decided whether the expense is incurred during the "Day" or "Night".
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NIGHT_PERCENTAGE
DescriptionA measure that indicates the "WHEN DO THEY SPEND ON" dimension.

This measure indicates the percentile of expense incurred by the Individual customer during the "Night".
Based on the timestamp of the transaction, it is decided whether the expense is incurred during the "Day" or "Night".
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LOCAL_PERCENTAGE
DescriptionA measure that indicates the "WHERE DO THEY SPEND ON" dimension. It is determined by the location where the expense is incurred and the contact location of the Individual customer.

This measure indicates the percentile of the expense incurred by the customer in the near by areas where the Individual customer is living.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REMOTE_PERCENTAGE
DescriptionA measure that indicates the "WHERE DO THEY SPEND ON" dimension. It is determined by the location where the expense is incurred and the contact location of the Individual customer.

This measure indicates the percentile of the expense incurred by the customer in the remote areas. In other words, the expense is incurred at the location which is farther from the location where the Individual customer is living.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SURROUNDING_PERCENTAGE
DescriptionA measure that indicates the "WHERE DO THEY SPEND ON" dimension. It is determined by the location where the expense is incurred and the contact location of the Individual customer.

This measure indicates the percentile of the expense incurred by the customer in the surrounding areas. In other words, the expense is incurred at the location which is in the surrounding areas from the location where the Individual customer is living.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse