Entity Definition

Logical Name : CombinationRewardDerivationRuleEligibility
Physical Name : CO_EL_CMBN_PRDV

A kind of RewardDerivationRule Eligibility which enables price derivation rules to be combined using AND, OR and XOR (exclusive OR) conditions. This entity references one or more RewardDerivationRuleEligibilityAssociation entity types. This approach allows the combination rule to represent complex rules that connect simple rules together using AND/OR conjunctions. This allows complex rules like: Account Level Elig: If customer membership level = (PLATINUM or GOLD) Line Item Group: AND ( if customer buys $150 or more of merchandise in Dept 219) OR Line Item: (if customer buys brand XYZ sneakers that sell for $150 or more) then get $25 off those items These eligibility rules result in a $25 discount taken from the line items that meet the eligibility requirements (a line item group RewardDerivation) that is represented as a set of related RetailPriceModifiers.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardDerivationRuleEligibilityID (FK)(PK) A unique identifier for a Price Derivation Rule Eligibility. ID_EL_PRDV Identity integer
CombinationCode A retailer assigned code denoting the style of combination that is to be applied across the child eligibilities that've been defined in MultiplePriceDerivationRuleEligibilities Examples include: OR, AND, XOR CD_CMBN Code2 char(2)
RewardDerivationConditionGroupName A short name used to identify this COMBINED eligibility rule for reporting and inqiury purposes. DE_RWD_DRVN_CN_GP_NM DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
CombinationRewardDerivationRuleEligibility is a combination of RewardDerivationRuleEligibilityAssociation
RewardEligibilityRule can be a CombinationRewardDerivationRuleEligibility

Logical Views containing CombinationRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level