Entity Definition

Logical Name : RetailShoppingTripType
Physical Name : CO_RTL_SHPPG_TRP_TYP

A retailer defined classification for a customer/consumer shipping trip purpose. This is used when anlyzing and classifying retail transactions to evaluate whether the consumer's purpose is: MAJOR_STOCKUP FILL-IN QUICKTRIP The idea of this classification is to characterize retail transactions in a way that offers insights into how critical a role promotional markdowns, advertising, store layout and other retail experiential factors paly in modifying consumer behavior. For example consumers intereste in quick trips are less likely to look for deals. On the other hand major stockup trips will involve large quantities and typcially consumers will be looking for discounts.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailShoppingTripTypeCode (PK) A code designating the purpose of the shopping trip that is related to a RetailTransaction. Examples: QUICKSTOP FILLIN STOCKUP CD_RTL_SHPPG_TRP_TYP Code varchar(20)
RetailShoppingTripTypeDescription Business description of this RetailShoppingTripType. DE_RTL_SHPPG_TRP_TYP DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
RetailShoppingTripType defines purpose of RetailTransaction

Logical Views containing RetailShoppingTripType

Logical View
Logical 02300 - Retail Transaction - Macro View