Entity Definition

Logical Name : ProcessChannel
Physical Name : CO_PCS_CHNL

An association between a Channel and an Activity. This enables a retailer to specify different channels for mediating common activities llike customer ordering.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ChannelID (FK)(PK) Token Identifier for a channel instance ID_CHNL Identity integer Channel(CO_CHNL)
ProcessID (FK)(PK) Token ID for a Process instance. ID_PCS Identity integer Process(CO_PCS)
EffectiveDateTime Date and time this ActivityChannel association is active. DT_EF EffectiveDateTime datetime
ExpirationDateTime Date time this ActivityChannel becomes inactive DT_EP ExpirationDateTime datetime
NarrativeRemarks Short narrative description/remarks about an ActivityChannel instance. This may include constraints, business rules, retailer specific implementation details, etc. NA_RMRK DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
Channel mediates execution of ProcessChannel
Process is mediated through ProcessChannel

Logical Views containing ProcessChannel

Logical View
Logical 07017 - Consumer-Customer Lifecycle Context View
Logical 07040 - Customer Segment Dependent Behavior
Logical 10400 - Enterprise - Channels