Loyalty Flowchart and Formula

This ERD (see the following figure) illustrates how Loyalty Promotion flowcharts help to execute promotions in a particular sequence. They can be used to validate the sequence of the promotions and calculate the points awarded for a particular flow.

Loyalty Formulas are used to create and store a set of objects and operators specific to a loyalty program. Values can be calculated based on input from third parties and then the resulting value can be taken into account within a promotion. A formula can be available for use by a promotion only if it is associated with the same loyalty program as that promotion. Once validated, a formula is available for use in promotion criteria and actions. When used in promotion criteria and actions, the object is the formula and the attributes are a list of user-defined formulas.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Attribute Definition	S_LOY_ATTRDEFN
Loyalty Flow Connector	S_LOY_FLW_CNCTR
Loyalty Flow Step	S_LOY_FLOW_STEP
Loyalty Formula Step	S_LOY_FRML_STEP
Loyalty Process Flowchart	S_LOY_PROC_FLOW
Loyalty Program	S_LOY_PROGRAM
Loyalty Program Formula	S_LOY_PRG_FRML
Loyalty Promotion	S_LOY_PROMO
Loyalty Promotion Phase	S_LOY_PHASE_PRM
Program Partner	S_ORG_EXT, S_LOY_PROG_ORG