Entity Definition

Logical Name : RewardDerivationRuleEligibilityAssociation
Physical Name : ST_ASCTN_EL_PRDV

The RewardDerivationRuleEligibilityAssociation entity type establishes an association between two or more RewardDerivationRuleEligibility entity types and is used to enable compound eligibility rules to be defined by retailers. This entity type, along with the CombinationRewardDerivationRuleEligibility entity type allows a retailer to "stack" promotion eligibility requirements using AND and OR conditions. This allows retailers to define very precisely targeted rewards.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LeftRewardEligibilityRuleID (FK)(PK) A unique identifier for a Price Derivation Rule Eligibility that is a member of the combination. ID_LFT_RWD_DRVN_RU Identity integer RewardEligibilityRule(CO_EL_PRDV)
RightRewardEligibilityRuleID (FK)(PK) A unique identifier for a Reward Derivation Rule Eligibility. ID_RT_RWD_DRVN_RU Identity integer RewardEligibilityRule(CO_EL_PRDV)
CombinationEligibilityID (FK)(PK) A unique identifier for the Combination Price Derivation Rule Eligibility. ID_EL_CMBN Identity integer CombinationRewardDerivationRuleEligibility(CO_EL_CMBN_PRDV)
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)
GroupingID Identifies a group of conditions to be evaluated to yield a single boolean value (like using parantheses in a select statement). This allows the eligibility rules to incorporate sub-rules and handle more complex compound conditions. Example Eligibility Rule 1 - Customer is registered in Loyalty Program 2 - Customer buys Brand X 3 - Item is in cateogry A 4 - Item is in category B 5 - Combined Eligibility 1 and 2 and (3 OR 4) The "(3 or 4)" is a group and is used to allows groups of rules to be evaluated and combined as a single boolean value with the other items in the combined rule set. This is a mechanism to handle complex, combined conditions. ID_GRP LineNumber smallint
PrecedenceSequenceNumber The relative order for evaluating combined eligibility rules. For example in a scenario where you have three rules: 1 - Customer is member of ABC Club AND 2 - Item is XYZ Brand AND 3 - Quantity Brand XYZ items > =5 The numbers, 1, 2 and 3 are precedence numbers and dictate the sequcen in which the orders are fired. In this instance the first test is determining of the customer is a member of ABC Club. If not the combination rule does not apply (since the rules are tied together with an AND conjunction they must all be true for the combination rule to fire). AI_PRCDN_SQN_NMB LineNumber smallint


Parent Entity Verb Phrase Child Entity
RewardEligibilityRule is a member in RewardDerivationRuleEligibilityAssociation
CombinationRewardDerivationRuleEligibility is a combination of RewardDerivationRuleEligibilityAssociation
RewardEligibilityRule is a member in RewardDerivationRuleEligibilityAssociation

Logical Views containing RewardDerivationRuleEligibilityAssociation

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level