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

MKT_IMP_CAMP_TEAM

This interface table stores staging data for marketing campaign team. The staging data gets populated into MKT_CM_CAMP_RESOURCES and MKT_CM_CAMP_RESOURCE_TEAMS table. The marketing campaign team is composed of resources and resource teams which have different levels of access to the campaign.

Details

  • Schema: FUSION

  • Object owner: MKT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MKT_IMP_CAMP_TEAM_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_ID NUMBER 18 Yes Primary Key. Batch Identifier. Identifier that groups data into a batch.
INTERFACE_ROW_ID NUMBER 18 Yes Primary Key. Interface Row Id. Will be used to link this row with rows in the error table.
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.
IMPORT_STATUS_CODE VARCHAR2 30 Indicates the status of the record to be processed.
ERROR_MESSAGE VARCHAR2 4000 Import error message.
FILE_RECORD_NUM NUMBER 10 Record indicator in the File.
ACTION_CODE VARCHAR2 30 Indicates the operation to be performed on a row, such as Insert, Update etc.
RESOURCE_ORIG_SYS VARCHAR2 30 Resource Original System .Stores a unique identifier denoting the source system
RESOURCE_ORIG_SYS_REF VARCHAR2 255 Resource Original System Reference. Stores the unique identifier of the campaign resource in the source system.
CAMPAIGN_EXT_REF VARCHAR2 100 Campaign Original System Reference. Stores the unique identifier of the campaign in the source system. Used to look up campaign_id
RESOURCE_TEAM_ORIG_SYS_REF VARCHAR2 255 Resource team Original System Reference. Stores the unique identifier of the resource team in the source system.
CAMPAIGN_RESOURCE_ID NUMBER 18 Fusion id of the campaign-resource association in MKT_CM_CAMP_RESOURCES
CAMPAIGN_ID NUMBER 18 Fusion id of the campaign in MKT_CM_CAMPAIGNS
RESOURCE_ID NUMBER 18 Fusion id of the campaign resource in TCA resource schema.
ACCESS_LEVEL_CODE VARCHAR2 30 Access Level Code indicating the type of access the resource/resource team has to the campaign e.g Edit or Full.
OWNER_FLAG VARCHAR2 1 Owner Flag indicating if this resource is the owner of the campaign.
CAMPAIGN_RESOURCE_TEAM_ID NUMBER 18 Fusion id of the campaign-resource association in MKT_CM_CAMP_RESOURCE_TEAMS
RESOURCE_TEAM_ID NUMBER 18 Fusion id of the resource team in TCA resource team schema
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of 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_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.

Indexes

Index Uniqueness Tablespace Columns
MKT_IMP_CAMP_TEAM_PK Unique Default BATCH_ID, INTERFACE_ROW_ID