1. Tables and Views for Loyalty
  2. LOY_ACTCRTR

LOY_ACTCRTR

Loyalty Action and Criteria information.

Details

  • Schema: FUSION

  • Object owner: LOY

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

LOY_ACTCRTR_PK

LOY_ACTRANGE_ID

Columns

Name Datatype Length Precision Not-null Comments
LOY_ACTRANGE_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).
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.
AMOUNT NUMBER Used to capture the Currency Amount or the Pay part of Redeem Points + Pay Action
ATTRIB_ID NUMBER 18 Attribute to update.
BUS_SERVICE_NAME VARCHAR2 75 Business Service Name for custom hooks
CONDITION_OP VARCHAR2 30 Is Equals/Less Than/Is Null etc.
CRITERIA_EXPR VARCHAR2 2000 This column stored Expression generated from the Criteria specified for already existing criteria.For new/updated criteria,CRITERIA_EXPR_LONG column will be used and CRITERIA_EXPR will be made null.
CRITERIA_EXPR_LONG CLOB Expression generated from the Criteria specified. This column would be used for new/updated criteria. When CRITERIA_EXPR has any update, updated value will be stored in this column and CRITERIA_EXPR will be set to NULL by application. Application will use the value from this column if this is not NULL. Otherwise, it would use the existing column CRITERIA_EXPR.
CURCY_EXCH_DT DATE Used to capture the Currency Exchange Date for CURRENCY_CODE
CURRENCY_CODE VARCHAR2 15 Used to capture the Currency Amount or the Pay part of Redeem Points + Pay Action
DESC_TEXT VARCHAR2 500 Description of promotion action and criteria
DISCNT_PCT NUMBER Discount Percentage Value of the Voucher if the Voucher Basis is Percentage.
ENTITY_TYPE VARCHAR2 10 Yes Criteria or Action
EXP_LEN NUMBER Point Expiration Length
EXP_SNAPTO_CODE VARCHAR2 30 indicates the day to which the expiration date should snap to. E.g. End of Month, 1st day of quarter, etc
EXP_UOM VARCHAR2 30 Point Expiration UoM
METHOD_NAME VARCHAR2 75 Business Service Method Name
NAME VARCHAR2 50 Yes Name of the action or criteria.
OBJECT_CODE VARCHAR2 30 Object whose Attribute is to be Updated.
OPERAND_CODE VARCHAR2 30 Add/Subtract/Divide
OPERATOR_CODE VARCHAR2 30 Add/Subtract/Multiply
OTHER_ATTRIB_ID NUMBER 18 Other Attribute.
OTHER_OBJECT_CODE VARCHAR2 30 Other Object.
PMT_ATTRIB_ID NUMBER 18 Attribute to update. This field would only be populated when the Action Type is "Redeem Points + Pay"
PMT_OBJECT_CODE VARCHAR2 30 Object whose Attribute is to be Updated for pay part. This field would only be populated when the Action Type is "Redeem Points + Pay"
PMT_OPERATOR_CODE VARCHAR2 30 Operation to be performed such as Add, Subtract, Multiply etc. This field would only be populated when the Action Type is "Redeem Points + Pay"
PMT_VAL VARCHAR2 50 Attribute Value for the pay part. This field would only be populated when the Action Type is "Redeem Points + Pay"
POINT_TYPE_FLAG VARCHAR2 1 Yes Flag to indicate if Point Type is from Transaction or not
PROD_ID NUMBER 18 Product Id of type electronic voucher for assigning a new voucher
PROMO_RULE_ID NUMBER 18 Yes Promotion Rule to which the Action or Criteria belongs.
PT_SUB_TYPE_ID NUMBER 18 Point Sub Type
QUALIFYING_FLAG VARCHAR2 1 Yes Qualifying or not.
REL_TYPE_CODE VARCHAR2 30 Relationship Type whose Tier needs to change.
SEQ_NUM NUMBER Yes Sequence in which to execute the action or evaluate the criteria.
TIER_ID NUMBER 18 Tier Id of new tier to upgrade/downgrade tier to
TYPE_CODE VARCHAR2 30 Update Attribute/Assign Points for Action and Compare to Object or Compare to Values etc. for Criteria
VAL VARCHAR2 50 Field to capture the value for the Attribute in ATTRIBUTE_ID column. This is relevant for and both Action and Criteria records
VCHR_BASIS_CODE VARCHAR2 30 The basis field denotes if the value specified in the is absolute value (100$) or a percentage value (10%). Possible values viz. Absolute value and Percent.
VOUCHER_QTY NUMBER Specifies the number of Vouchers issued when the Use From Transaction flag is Unchecked.

Foreign Keys

Table Foreign Table Foreign Key Column
LOY_ACTCRTR loy_attrdefn_b ATTRIB_ID
LOY_ACTCRTR loy_attrdefn_b OTHER_ATTRIB_ID
LOY_ACTCRTR loy_attrdefn_b PMT_ATTRIB_ID
LOY_ACTCRTR loy_promo_rl PROMO_RULE_ID
LOY_ACTCRTR loy_ptsubtype PT_SUB_TYPE_ID
LOY_ACTCRTR loy_tier TIER_ID

Indexes

Index Uniqueness Tablespace Columns
LOY_ACTCRTR_F1 Non Unique FUSION_TS_TX_DATA ATTRIB_ID
LOY_ACTCRTR_F2 Non Unique FUSION_TS_TX_DATA OTHER_ATTRIB_ID
LOY_ACTCRTR_F3 Non Unique FUSION_TS_TX_DATA PMT_ATTRIB_ID
LOY_ACTCRTR_F5 Non Unique FUSION_TS_TX_DATA PT_SUB_TYPE_ID
LOY_ACTCRTR_F6 Non Unique FUSION_TS_TX_DATA TIER_ID
LOY_ACTCRTR_U1 Unique FUSION_TS_TX_DATA LOY_ACTRANGE_ID
LOY_ACTCRTR_U2 Unique Default PROMO_RULE_ID, ENTITY_TYPE, NAME, CONFLICT_ID