Entity Definition

Logical Name : WalletShareEstimate
Physical Name : CO_WLLT_SHR_ESTM

An estimated total purchase value of a product/service category by a key customer for a reporting period. This estimate is used to assess the relative portion of a customer's total spend on a product category for a given reporting period a retailer owns. This is a modeling entity type and is NOT BASED ON OPERATIONAL OR TRANSACTIONAL DATA from the retailer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WalletShareID (PK) Token ID to identify an instance of a WalletShareEstimate entity type. ID_WLLT_SHR Identity integer
CustomerID (FK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_CT Identity integer KeyCustomer(PA_KY_CT)
ReportingPeriodID (FK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
MerchandiseHierarchyGroupID (FK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
CreateDateTime Date and time this WalletShareEstimate is created. DT_CRT AuditDateTime datetime
SourceDataDescription A description of where this information came from. For example the US Census, UK Census, etc. It's purpose is to identify the data source used to derive the wallet share estimate. DE_SRC_DAT DescriptionShort varchar(255)
EstimationMethodologyNarrative A short narrative describing how the wallet share estimate is derived. NA_ESTM_MTH DescriptionNarrative varchar(4000)
EstimatedWalletAmount Estimated monetary value of the total wallet amount a customer spends on a given categroy of item for a given reporting period. This is the amount used as the divisor (the cumulative retailer's customer-category-reporting period sales is the dividend) in determning the percentage of wallet a retailer "owns". MO_ESTM_WLLT Money decimal(16,5)
EffectiveDate Date this wallet share estimate is usable. DC_EF EffectiveDate date
ExpirationDate Date this wallet share estimate is no longer usable. DC_EP ExpirationDate date
StatusCode Current status of the wallet share estimate. Valid values are: A- Active I - Inactive CD_STS Code2Status char(2)
RetailVerticalCategoryCode (FK) Category code for retail vertical (e.g. GROCERY, HME_IMPRVMT, APPRAL, AUTOPARTS, etc.) CD_RTL_VRTL_CTGY Code varchar(20) RetailVerticalReference(LU_RTL_VRTL_RFC)


Parent Entity Verb Phrase Child Entity
KeyCustomer has WalletShareEstimate
ReportingPeriod defines time interval for WalletShareEstimate
RetailVerticalReference classifies WalletShareEstimate
MerchandiseHierarchyGroup defines merchandise category for WalletShareEstimate

Logical Views containing WalletShareEstimate

Logical View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07042 - Customer Wallet Share