Entity Definition

Logical Name : RelationshipStage
Physical Name : CO_RLtN_Stg

Identifies high-level phase of development of a customer relationship. Retailers may create their own values and definitions. ARTS sample values are: CUST_ACQUISITION - pre-customer (has not purchased product/services) CUSTOMER - Consumer purchased product INACTIVE_CUSTOMER - has not purchased anything in last N periods, where N is designated by the retailer EX_CUSTOMER - "Dead" customer - no anticipated reactivation

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RelationshipStageCode (PK) Code that identifies a partiular stage of development for customer conversion analysis. A list of proposed stages is provided in the entity definition. This code may be assigned by the retailer. ARTS recommends at least four stages: CUST_ACQUISITION CUSTOMER INACTIVE_CUSTOMER EX_CUSTOMER Retailers may define their own codes. CD_RLTN_STG Code varchar(20)
RelationshipStageDescription Short business description of the relationship stage. DE_RLTN_STG DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
RelationshipStage includes ConversionState

Logical Views containing RelationshipStage

Logical View
Logical 06310 - Party - Role View
Logical 07010 - Customer Account Information Extended
Logical 07015 - Customer Lifecycle and Registration
Logical 07017 - Consumer-Customer Lifecycle Context View