1. Tables and Views for Sales and Fusion Service
  2. MKT_IMP_CALL_LST_CON_T

MKT_IMP_CALL_LST_CON_T

The Import Interface table to populate MKT_CALL_LST_CON: This table stores references to the customers targetted when the list is used during a campaign launch process. A marketing list will typically have many list contacts (members).

Details

  • Schema: FUSION

  • Object owner: MKT

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

MKT_IMP_CALL_LST_CON_T_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments Status
IMPORT_JOB_ID NUMBER 18 Import Job Identifier, no longer part of Primary Key Active
BATCH_ID NUMBER 18 Yes Primary Key - Batch Identifier that groups data into a batch Active
INTERFACE_ROW_ID NUMBER 18 Yes Primary Key - Interface Row ID. Used to link this record with the error record. 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
IMPORT_STATUS_CODE VARCHAR2 30 Status flag - similar to IMPORT_STATUS_CODE Active
ACTION_CODE VARCHAR2 30 Action Code to indicate Insert or Update action Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
CALL_LST_CON_T_ID NUMBER 18 Alternate Key. Interface Row Id. Will be used to link this row with rows in the error table. Active
CALL_LST_CON_ID NUMBER 18 Call list contact id. Fusion Primary key. Active
CALL_LST_ID NUMBER 18 Call List Identifier to the Call List table Active
CON_PER_ID NUMBER 18 Contact Person Identifier to the Person table Active
RELATIONSHIP_ID NUMBER TCA Relationship Identifier of the call list for this record Active
VALID_FLAG VARCHAR2 1 Valid Flag indicates call list validity for this record Active
ERROR_MESSAGE VARCHAR2 4000 Call List Error Message for this record Active
PARTY_ORIG_SYSTEM VARCHAR2 30 Party Original System. Stores a unique identifier for the party in the source system. Used to lookup CON_PER_ID. Active
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Party Original System Reference. Stores a unique identifier for the party reference in the source system. Used to lookup CON_PER_ID. Active
ORG_PARTY_ORIG_SYS VARCHAR2 30 Org Party Original System. Stores a unique identifier for the Organization party in the source system. Used to lookup ORG_PARTY_ID.
ORG_PARTY_ORIG_SYS_REF VARCHAR2 240 Org Party Original System Reference. Stores a unique identifier for the Organization party in the source system. Used to lookup ORG_PARTY_ID.
ORG_PARTY_ID NUMBER 18 Org Party Identifier. Stores a unique identifier for the Organization party in the source system. Used as OBJECT_ID to lookup RELATIONSHIP_ID from HZ_ORIG_SYS_REFERENCES.
LIST_EXT_REF VARCHAR2 30 List External Reference. Stores a unique identifier of the list/segment proxy in the source system. Used to lookup CALL_LST_ID. 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
FILE_RECORD_NUM NUMBER 10 File record indicator in the file.

Foreign Keys

Table Foreign Table Foreign Key Column
MKT_IMP_CALL_LST_CON_T mkt_imp_jobs IMPORT_JOB_ID

Indexes

Index Uniqueness Tablespace Columns Status
MKT_IMP_CALL_LST_CON_T_FK1 Non Unique FUSION_TS_TX_IDX PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE Active
MKT_IMP_CALL_LST_CON_T_PK Unique FUSION_TS_TX_IDX BATCH_ID, INTERFACE_ROW_ID Active