1. Tables and Views for Loyalty
  2. LOY_ACTCRTR_INT

LOY_ACTCRTR_INT

It is Loyalty Action and Criteria Information Interface Table for Bulk Import purpose. Mapped to LOY_ACTCRTR and LOY_ACTRANGE.

Details

  • Schema: FUSION

  • Object owner: LOY

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

LOY_ACTCRTR_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
LOY_ACTCRTR_INT_ID NUMBER 18 Unique identifier of the Action and Criteria line in the interface table. System generated.
BATCH_ID NUMBER 18 Yes Unique Identifier for a Batch
IMPORT_STATUS_CODE VARCHAR2 30 Status for the data in the interface table
INTERFACE_ROW_ID NUMBER 18 Yes Unique identifier of the interface record. Internal use only.
ACTION_CODE VARCHAR2 30 Indicates delete action entered by user
INTERNAL_ACTION_CODE VARCHAR2 30 This column is created for internal use and will be populated and used by bulk import logic.
INTERNAL_ACTCRTR_OVN NUMBER 9 Object Version Number copied from corresponding Action and Criteria record. This is used for UPDATE cases to see if record is updated by another user during processing of bulk import and throw error appropriately.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 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 Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
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.
LOY_ACTRANGE_ID NUMBER 18 Reference Column to the LOY_ACTCRTR (Primary Key to LOY_ACTCRTR table)
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_CD
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 22 Discount Percentage Value of the Voucher if the Voucher Basis is Percentage.
ENTITY_TYPE VARCHAR2 10 Criteria or Action
EXP_LEN NUMBER 22 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 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 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 Promotion Rule to which the Action or Criteria belongs.
PT_SUB_TYPE_ID NUMBER 18 Point Sub Type
QUALIFYING_FLAG VARCHAR2 1 Qualifying or not.
REL_TYPE_CODE VARCHAR2 30 Relationship Type whose Tier needs to change.
SEQ_NUM NUMBER 22 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.
ACTION_ID NUMBER 18 Action identifier
PER_UNIT_VAL NUMBER 22 Points assigned per unit for the given range
RANGE_END_UNITS NUMBER 22 Number of units at which the range ends
RANGE_START_UNITS NUMBER 22 Number of units at which the range starts

Indexes

Index Uniqueness Tablespace Columns
LOY_ACTCRTR_INT_U1 Unique Default BATCH_ID, INTERFACE_ROW_ID