LOY_ATTR_ITM_VOLUME_INT

It is Loyalty Attribute Item Interface Table for Bulk Import purpose. Mapped to LOY_ACTCRTR and LOY_ATTR_ITM.

Details

Schema: FUSION
Object owner: LOY
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
LOY_ATTR_ITM_VOLUME_INT_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Unique Identifier for a Batch
INTERFACE_ROW_ID	NUMBER		18	Yes	Unique identifier of the interface record. Internal use only.
IMPORT_STATUS_CODE	VARCHAR2	30			Status for the data in the interface table
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.
FILE_RECORD_NUM	NUMBER		18		This column is required by import wizard to relate record in the interface table to the file row, and used for reporting purposes. Import framework would populate this value.
INTERNAL_ATTR_ITM_OVN	NUMBER		9		Object Version Number copied from corresponding Attribute Item 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.
FILE_NAME_SYSTASK_ID	NUMBER		18		FILE_NAME_SYSTASK_ID
LOY_ATTR_ITM_ID	NUMBER		18		Reference Column to the LOY_ATTR_ITM (Primary Key to LOY_ATTR_ITM table)
ATTRIB_DEFN_ID	NUMBER		18		Attribute definition for promotion attribute, which doesnt have parent Attribute
PROGRAM_ID	NUMBER		18		Program ID
DISPLAY_NAME	VARCHAR2	30			Display Name
MEMBER_ID	NUMBER		18		Member ID
PROGRAM_NUMBER	VARCHAR2	30			Program Number
PROMO_NUM	VARCHAR2	30			Promotion Number
ATTRIB_ID	NUMBER		18		Header of this Attribute Item.
MEM_NUM	VARCHAR2	30			Member Number. PROGRAM_NAME, MEM_NUM, ATTR_OBJECT_CODE, ATTR_TYPE_CODE, ATTR_INTERNAL_NAME are composite alternate key for ATTRIB_ID
COMMENTS	VARCHAR2	250			Comments Column
PROMO_BUCKET_ID	NUMBER		18		Promotion Bucket due to which this Point Item was rewarded.
BUCKET_UID	VARCHAR2	30			Bucket unique identifier. Alternate key of PROMO_BUCKET_ID
PROMO_ID	NUMBER		18		Promotion for which this item was created.
TXN_ID	NUMBER		18		Transaction for which this item was given
TXN_NUM	VARCHAR2	30			Transaction Number. Alternate key of TXN_ID
VALUE	VARCHAR2	250			Value of this item.
OPERATOR_CODE	VARCHAR2	30			This column is used to track the operator that was used during the update attribute (action during transaction). E.g. Set, Multiply, Add, Divide and Substract.
ACTION_NOTE	VARCHAR2	1000			It is a marker. Action Notes captured from Action Definition are stamped here. E.g. Member promoted from Gold to Platinum through xyz promotion.
UPDATE_DATE	TIMESTAMP				The data time on which this object was updated.LAST_UPDATE_DATE is not set through code so this column is needed to set the date time through code so that this can be used to sort and identify the sequence in which the records were updated.
ERROR_MESSAGE	VARCHAR2	20			ERROR_MESSAGE
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated 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.

Indexes

Index	Uniqueness	Tablespace	Columns
LOY_ATTR_ITM_VOLUME_INT_U1	Unique	Default	BATCH_ID, INTERFACE_ROW_ID