Entity Definition

Logical Name : CustomerGroup
Physical Name : PA_GP_CT

A group of customers based on specific demographic and marketing attributes and properties. Examples include over 65 year old customers, students, unions, and other associations. Note this entity is different from PartyAffiliation which captures relationships between specific parites and classifies those relationships. PartyAffiliation involves linking two identifiable parties together. CustomerGroup is a kind of global category that customers are assigned to for marketing, accounting or administrative purposes. Also used to classify customer's known taxability; eg: Hospital, Charity, etc.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerGroupID (PK) A unique identification number assigned to a customer group ID_GP_ID Identity integer
CustomerGroupTypeCode (FK) A retailer assigned, mnemonic code denoting a kind of CustomerGroup. Eg: Taxation Exemption, Promotions. CD_TYP_CT_GP Code4 char(4) CustomerGroupType(CO_TYP_GP_CT)
Name The business name applied to a customer group. NM_GP Name varchar(40)
Description The text description applied to a customer group. DE_GP_CT DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
CustomerGroupType classifies CustomerGroup
CustomerGroup is composed of CustomerAffiliation
CustomerGroup defines TaxGroupRule
CustomerGroup may trigger CustomerRewardDerivationRuleEligibility

Logical Views containing CustomerGroup

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 06310 - Party - Role View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended