LOY_PROMO_RL

This table contains Promotion Rules and Promotion Rules Library related info for a Loyalty Promotion. Whether a record is a rule or library is indicated by the value in the TYPE_CD column.

Details

• Schema: FUSION

• Object owner: LOY

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
LOY_PROMO_RL_PK	LOY_PROMO_RL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LOY_PROMO_RL_ID	NUMBER		18	Yes	Who column.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
CONFLICT_ID	NUMBER		18	Yes	Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
APPLY_TO_CODE	VARCHAR2	30			APPLY_TO_CODE
DESC_TEXT	VARCHAR2	500			Description text of the promotion rule.
LIBRARY_CATG_CODE	VARCHAR2	30			This stores the category to which the Library belongs. Possible values are 1. Accrual 2. Tier 3. Redemption. This column would be NULL for Promotion Rule record
LIB_BASE_PROMO_FLAG	VARCHAR2	1		Yes	This field indicates whether the Rule Library can be imported to Base Promotion or not
NAME	VARCHAR2	50		Yes	Name of the rule.
PAR_ROW_ID	NUMBER		18		Parent Rule Id for a hierarchical promotion
PROMO_ID	NUMBER		18	Yes	Promotion to which the Rule belongs.
SEQ_NUM	NUMBER			Yes	Sequence # in which to evaluate rules.
TYPE_CODE	VARCHAR2	30			Indicates whether this is a Promotion Rule record or Promotion Rule Library record. Possible values are: 1. Promotion Rule 2. Criteria Library 3. Action Library
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
LOY_PROMO_RL	loy_promo_rl	PAR_ROW_ID
LOY_PROMO_RL	loy_promo	PROMO_ID
loy_actcrtr	loy_promo_rl	PROMO_RULE_ID
loy_promo_rl	loy_promo_rl	PAR_ROW_ID

Indexes

Index	Uniqueness	Tablespace	Columns
LOY_PROMO_RL_FK1	Non Unique	FUSION_TS_TX_DATA	PAR_ROW_ID
LOY_PROMO_RL_U1	Unique	FUSION_TS_TX_DATA	LOY_PROMO_RL_ID
LOY_PROMO_RL_U2	Unique	Default	PROMO_ID, NAME, CONFLICT_ID