Entity Definition

Logical Name : RewardEligibilityRule
Physical Name : CO_EL_PRDV

Defines the conditions which must be satisfied before a RewardDerivationRule may be applied to a transaction or transaction line item.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardDerivationRuleEligibilityID (PK) A unique identifier for a Reward Derivation Rule Eligibility. ID_EL_PRDV Identity integer
RewardEligibilitySequenceNumber (AK) Specifies the relative execution order for the eligibility rule tied to a Reward. AI_RWD_EL_SQN_NMB LineNumber smallint
RewardID (AK)(FK) A token identifier for a Reward instance. ID_RWD Identity integer Reward(TR_RWD)
RewardEligibilityPropertyTypeCode (FK) A short code used to identify a valid RewardEligibilityPropertyType. Valid values are: BRAND_NAME Brand ARTS ODM V7.2 CALENDAR_ID Calendar Period part 1 ARTS ODM V7.2 CALENDAR_LEVEL_ID Calendar Period part 2 ARTS ODM V7.2 CALENDAR_PERIOD_ID Calendar Period part 3 ARTS ODM V7.2 CHANNEL_ID Channel ARTS ODM V7.2 CUSTOMER_ACCOUNT_ID Customer Account ARTS ODM V7.2 CUSTOMER_MEMBER_PROGRAM_ACCOUNT_ID Customer Membershipp Prog Acct ARTS ODM V7.2 EMPLOYEE_DISCOUNT_GROUP_ID Employee Discount Group ARTS ODM V7.2 ITEM_ID Single Item ID (SKU) ARTS ODM V7.2 MANUFACTURER_ID Manufacturer ARTS ODM V7.2 MARKET_BASKET_TRIGGER_ID (follow up on this one) ARTS ODM V7.2 MERCHANDISE_HIERARCHY_GROUP Merch Hier. Group (we're simplifying this will require tree view to create UI) ARTS ODM V7.2 PRICE_LINE_ID Price Line ARTS ODM V7.2 PRICE_OVERRIDE Flagged overriden price - no ARTS equivalent SALE_RTN_CLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_DEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_ITEM_CLEARANCE no ARTS equivalent SALE_RTN_ITEM_DISCOUNTED Sale Return item is already discounted SALE_RTN_ITEM_STOCK_STATUS no ARTS equivalent SALE_RTN_ITEM_VENDOR This should be handled by mfg / brand SALE_RTN_QUANTITY Eligibilty trigger qty SALE_RTN_SKU Handled by ITEM_ID SALE_RTN_STYLE This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBCLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBDEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_UNIT_PRICE Eligibilty trigger retail price SEASON see Calendar SEQ_NUMBER Comparison is between the line item number from sale return row and the value in VALUE1 TENDER_MEDIA_BRAND_ID Branded Tender Type part 2 ARTS ODM V7.2 TENDER_TYPE_CODE Branded Tender Type part 1 ARTS ODM V7.2 CD_RWD_EL_PRY_TYP_CD Code varchar(20) RewardEligibilityPropertyType(CO_RWD_EL_PRY_TYP)
EligibilityVerbTypeCode A controlled vocabulary attribute used to standardize the representation of customer actions that must be taken to trigger a RewardDerivationRule. Valid Values: BUY RENT TRADEIN IS_A (customer is a GOLD) RETURN Others may be added by the retailer. CD_EL_VRB_TYP Code varchar(20)
CompareCode A code that indicates the kind of comparison excuted to determine if an eligibility condition applies to a specific retail transaction and/or a sale return line item's property type. Valid values are: EQ equals NE not equal GT greater than GE greater than or equal to LT less than LE less than or equal to IN value is GE and LE value1 and value 2 CD_CMPR Code2 char(2)
EligibilityPropertyValueDataTypeCode Indicates whether the value is a string, a date, a monetary value, or a quantity. CD_EL_PRY_VL_DAT_TYP Code varchar(20)


Parent Entity Verb Phrase Child Entity
Reward is executed based on RewardEligibilityRule
RewardEligibilityPropertyType classifies RewardEligibilityRule
RewardEligibilityRule is a member in RewardDerivationRuleEligibilityAssociation
RewardEligibilityRule is part of ZPromotionalOfferRewardDerivationRule
RewardEligibilityRule is a member in RewardDerivationRuleEligibilityAssociation
RewardEligibilityRule defines conditions for application of RewardDerivationRule
RewardEligibilityRule is maintained by RewardEligibilityRuleMaintenance
RewardEligibilityRule can be a MerchandiseHierarchyRewardDerivationRuleEligibility
RewardEligibilityRule can be a PriceLineRewardDerivationRuleEligibility
RewardEligibilityRule can be a CombinationRewardDerivationRuleEligibility
RewardEligibilityRule can be a ChannelRewardDerivationRuleEligibility
RewardEligibilityRule can be a BrandRewardDerivationRuleEligibility
RewardEligibilityRule can be a ItemRewardDerivationRuleEligibility
RewardEligibilityRule can be a TotalPurchaseMarketBasketRewardDerivationRuleEligibility
RewardEligibilityRule can be a CustomerMembershipProgramAccountRewardDerivationRuleEligibiliy
RewardEligibilityRule can be a BrandedTenderMediaPromotionRewardEligibility
RewardEligibilityRule can be a ManufacturerRewardDerivationRuleEligibility
RewardEligibilityRule can be a CustomerAccountRewardDerivationRuleEligibility
RewardEligibilityRule can be a CustomerRewardDerivationRuleEligibility
RewardEligibilityRule can be a WorkerDiscountGroupRewardDerivationRuleEligibility
RewardEligibilityRule can be a CalendarPeriodRewardDerivationRuleEligibility

Logical Views containing RewardEligibilityRule

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level