Entity Definition

Logical Name : ConsumerRegistrationState
Physical Name : CO_CNS_RGSTN_ST

ConsumerRegistrationState tracks the registration state history of a Consumer. It uses a CurrentStatusCode to indicate which state reflects the current condition.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ConsumerRegistrationStateID (PK) Token ID for an instance of a ConsumerRegistrationState. ID_CNS_RGSTN_ST Identity integer
ConsumerID (FK) Token ID for a Consumer instance. ID_CNS Identity integer Consumer(PA_CNS)
RegistrationStateCode (FK) Code value that designates a type of enrollment condition. The list is determined by the retailer. Common examples include: REGISTERED_VALIDATED - consumer is registered but information is not validated REGISTERED_UNVALIDATE - consumer is registered and information has been validated UNREGISTERED - consumer has NOT registered. Others as required by the retailer. CD_CNS_RGSTN_ST Code varchar(20) RegistrationState(CO_ST_RGSTN)
CurrentStatusCode Indicated the current status of this memorialized consumer registration state. Valid values are: ACTIVE INACTIVE CD_CRT_RGSTN_ST Code varchar(20)
EffectiveDate Date this registration state applies to this consumer DT_EF EffectiveDate date
ExpirationDate Date this registration state no longer applies to this consumer. DT_EP ExpirationDate date
ConsumerRegistrationDoNotCallFlag Boolean attribute that indicates if a retailer is allowed to call a consumer or not. If "FALSE' it means DO NOT CALL FL_CNS_DO_NOT_CALL Flag integer
ConsumerRegistrationDoNotShareFlag Boolean indicator that if FALSE means a retaile may NOT SHARE consumer information with other retailers, vendors or other external parties. FL_CNS_DO_NOT_SHR Flag integer
ConsumerRegistrationDoNotEmailFlag Boolean indicator that if FALSE means a retailer may not send unsolicited emails to the consumer. FL_CNS_DO_NOT_EMAIL Flag integer
ConsumerRegistrationDoNotTrackFlag A boolean indicator that if FALSE means a retailer may not track and analyze a consumer's purchasing patterns for analytic and reporting purposes. FL_CNS_DO_NOT_TRK Flag integer
RegistrationEventID (FK) Token ID for a registration event ID_RGSTN_EV Identity integer RegistrationEvent(EV_RGSTN)


Parent Entity Verb Phrase Child Entity
RegistrationEvent triggers change in ConsumerRegistrationState
RegistrationState defines state of ConsumerRegistrationState
Consumer is in a state determined by ConsumerRegistrationState
ConsumerRegistrationState captures PartyContactMethod
ConsumerRegistrationState captures registration of KeyCustomer

Logical Views containing ConsumerRegistrationState

Logical View
Logical 07015 - Customer Lifecycle and Registration
Logical 07017 - Consumer-Customer Lifecycle Context View
Logical 07030 - Customer Segment Independent Characteristics