MKT_IMP_TRMT_PROM_ASSOC

This interface table stores staging data for the treatment-promotion associations. The data gets populated into MKT_TM_TRMT_PROM_ASSOC table.

Details

• Schema: FUSION

• Object owner: MKT

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
MKT_IMP_TRMT_PROM_ASSOC_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
BATCH_ID	NUMBER		18	Yes	Primary Key - Identifier that groups data into a batch	Active
INTERFACE_ROW_ID	NUMBER		18	Yes	Primary Key - Used to link with rows in the error table	Active
IMPORT_STATUS_CODE	VARCHAR2	30			Indicates the status of the record to be processed	Active
ACTION_CODE	VARCHAR2	30			Indicates the operation to be performed on a row, such as Insert, Update, etc.	Active
FILE_RECORD_NUM	NUMBER		10		File Record Number. Record indicator in the File.
TRMT_EXT_REF	VARCHAR2	64			Treatment External Reference. Stores the unique identifier of the treatment in the source system.	Active
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.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
TREATMENT_ID	NUMBER		18		Treatment id. Fusion id of the treatment.	Active
PROM_EXT_REF	VARCHAR2	100			Promotion external reference. Stores the unique identifier of the promotion in the source system.	Active
PROMOTION_ID	NUMBER		18		Promotion Id. Fusion id of the promotion.	Active
PRIMARY_FLAG	VARCHAR2	1			Primary flag indicating if this is the primary promotion associated with the treatment	Active
COUPON_ID	NUMBER		18		Coupon id. Fusion id of the coupon.	Active
COUPON_EXT_REF	VARCHAR2	100			Coupon external reference. Stores the unique identifier of the coupon in the source system.	Active
PROMOTION_ASSOC_ID	NUMBER		18		Fusion id of the treatement-promotion association	Active
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.	Active
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MKT_IMP_TRMT_PROM_ASSOC_PK	Unique	FUSION_TS_TX_IDX	BATCH_ID, INTERFACE_ROW_ID	Active