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

MKT_IMP_JOBS

This table stores information about the import jobs being kicked off by the user. It contains the header level details for the import process for example the import job name, object being imported, scheduling information, file information etc.

Details

  • Schema: FUSION

  • Object owner: MKT

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

MKT_IMP_JOBS_PK

IMPORT_JOB_ID

Columns

Name Datatype Length Precision Not-null Comments
IMPORT_JOB_ID NUMBER 18 Yes Primary key
SIMPL_IMPORT_JOB_FLAG VARCHAR2 1 Flag used to distinguish between classic and simplified import jobs
UI_JOB_STATUS_CODE VARCHAR2 60 Contains new File Import Status values
MASS_UPDATE_DTL_ID NUMBER 18 Mass Update Detail Id for Import Job
JOB_PARAMETERS VARCHAR2 1000 To hold job parameters
UCM_FILE_NAME VARCHAR2 250 To hold the fusion file name.
IMPORT_JOB_NUMBER VARCHAR2 130 Alternate key for Import Jobs
CDM_BATCH_ID NUMBER 18 CDM Batch Id
NAME VARCHAR2 100 Yes Import job name
DESC_TEXT VARCHAR2 250 Job description
OBJECT_TYPE_CD VARCHAR2 128 Import object type (lead, response, account, contact, prospect)
FILE_TYPE_CD VARCHAR2 30 Source file type (text file, xml file)
FILE_FORMAT_CD VARCHAR2 30 File format (comma separated, tab delimited, other delimiter, fixed width, xml)
FILE_SELECTION_CD VARCHAR2 30 File selection (use exact file name, use most recent file)
IMPORT_MODE_CD VARCHAR2 30 Import mode (import new records, update existing records)
MATCH_RESOLUTION_TYPE_CD VARCHAR2 30 Match Resolution Guideline (create additional records, overwrite existing records, reject import record)
ERROR_THRESHOLD NUMBER 10 Max number of errors allowed for the import job
DELIMITER VARCHAR2 10 File delimiter
HEADER_ROW_INCLUDED VARCHAR2 1 Indicates whether the header row will be included
ENABLE_TURBO_IMPORT VARCHAR2 1 Indicates whether an Import job supports TURBO import for Base Table Upload
NUM_LEAD_DUP_DAYS NUMBER 10 Duplicate lead lookback range in number of days
FILE_NAME VARCHAR2 250 Full path of network-shared file
ACTIVE_FLAG VARCHAR2 1 Indicate whether the task is active
SCHEDULE_MODE_CD VARCHAR2 30 Schedule mode - repeating, one time(manually started), one time(scheduled)
SCHEDULE_STATUS_CD VARCHAR2 30 Schedule status (scheduled, not scheduled, running, complete, error)
START_TM TIMESTAMP Start date for schedule
NEXT_SCHEDULE_TM DATE Next scheduled date
REPEAT_FREQUENCY NUMBER 10 Number of repeat frequency
END_DATE_TM TIMESTAMP Repeat end date
REPEAT_UNIT_CD VARCHAR2 30 Repeat unit code (hours, days, weeks, months)
CALL_LST_ID NUMBER 18 Identifies theList for storing records
IMPORT_FILE_ID NUMBER 18 Reference to the current file being imported
IMPORT_MAP_ID NUMBER 18 Identifies the Import Mapping used for field mappings
EMAIL_ADDRESS VARCHAR2 500 Email address for notification of job completion
NOTIFICATION_FLAG VARCHAR2 1 Enable email notification (Y or N)
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PARENT_REQUEST_ID NUMBER 18 Parent Scheduler Request in case of Repeating Stages
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes 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.
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.
FILE_ENCODING_CODE VARCHAR2 30 File encoding code
TIMESTAMP_FORMAT VARCHAR2 120 Timestamp format
DATE_FORMAT VARCHAR2 120 Date format
DECIMAL_SEPARATOR VARCHAR2 120 Decimal separator
SYSTASK_ID NUMBER 18 System Task Id
CONTENT_FILE_NAME VARCHAR2 200 Full path of network-shared attached document
SEEDED_FLAG VARCHAR2 1 Seeded Flag to indicate whether the job is a seeded job or not
VISIBLE_FLAG VARCHAR2 1 Visible Flag to indicate whether the job is going to be visible in the jobs listing page.
CONTENT_DOC_ID VARCHAR2 100 Content Doc Id is to hold the internal document id from the UCM when the file is download or upload from UCM
FILE_DATA_SOURCE VARCHAR2 30 File Data Source to hold the source of the file. Example - Desktop, Network, URL, UCM etc
NEXT_SCHEDULED_TIME TIMESTAMP Next Scheduled Time is going to hold the date and time of the next run of the job when the job is recurring type.
ATTCH_CONTENT_DOC_ID VARCHAR2 100 Attachement Content Document Id to store the doument id of the attachemnts used in the file import.
ATTCH_CONTENT_FILE_NAME VARCHAR2 120 Attachemnt Content File Name to hold the name of the attachment file name for the job, which is uploaded to the UCM.
MAP_AUTOMATICALLY VARCHAR2 1 Column can have the values Y or N. The column value will be used to indicate whether a map was created automatically or not during the file import activity.
OBJECT_DETAIL_NAME VARCHAR2 100 This column holds File Import Object Name
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
IMPORT_TYPE VARCHAR2 100 Import type specifies the type of import job, whether it is Simplified, standard, Optimized or classic.
JOB_TYPE VARCHAR2 100 This column indicates if its job or template
OBJECT_PARENT_LIC VARCHAR2 2000 Comma separated list of 'LANG_INDEPENDENT_CODE' values used to identify potential parent of object of a current object. Will be used for hierarchical display purpose
OBJECT_TYPE VARCHAR2 100 These will be used for defining the security predicates. Possible values could be: StandardObject, StandardChild, CustomChildOfStandard, CustomObject, CustomChildOfCustom, IntersectionObject.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
MKT_IMP_JOBS mkt_call_lst CALL_LST_ID
MKT_IMP_JOBS mkt_imp_map IMPORT_MAP_ID
mkt_imp_args mkt_imp_jobs IMPORT_JOB_ID
zca_import_progress mkt_imp_jobs IMPORT_JOB_ID
mkt_imp_stg_members_t mkt_imp_jobs IMPORT_JOB_ID
mkt_imp_files mkt_imp_jobs IMPORT_JOB_ID
mkt_imp_call_lst_con_t mkt_imp_jobs IMPORT_JOB_ID
mkt_imp_leads_t mkt_imp_jobs IMPORT_JOB_ID

Indexes

Index Uniqueness Tablespace Columns
MKT_IMP_JOBS_N1 Non Unique Default UPPER("NAME")
MKT_IMP_JOBS_N2 Non Unique Default IMPORT_MAP_ID
MKT_IMP_JOBS_N3 Non Unique Default CALL_LST_ID
MKT_IMP_JOBS_N4 Non Unique Default OBJECT_TYPE_CD
MKT_IMP_JOBS_N5 Non Unique Default LAST_UPDATE_DATE
MKT_IMP_JOBS_PK Unique Default IMPORT_JOB_ID, ORA_SEED_SET1
MKT_IMP_JOBS_PK1 Unique Default IMPORT_JOB_ID, ORA_SEED_SET2