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

ATC_ECC_IMPEXP_JOB

This table store the details of COMMS NPI ECC import jobs

Details

  • Schema: FUSION

  • Object owner: ATC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATC_ECC_IMPEXP_JOB_PK

IMPEXP_JOB_ID

Columns

Name Datatype Length Precision Not-null Comments
IMPEXP_JOB_ID NUMBER 18 Yes Unique rowid of the import or export job
JOB_ID VARCHAR2 150 Yes Unique identifier for an import or export job
JOB_TYPE VARCHAR2 255 A String.Indicates the type of the job like import or export.
INCLUDE_REFERENCE CLOB A String.Comma separated values indicating the embedded references to be exported.
CONTENT_TYPE VARCHAR2 255 A string. Indicates the format of the data.The default value is application/json.
PATH VARCHAR2 255 A string. URL of the root resource where the content is imported or exported
QUERY_FILTER CLOB A string. Used to scope the exported data. (identical to GET filter construct using target ID as base)
STATUS VARCHAR2 255 A string. Status of the job (not started, running, succeeded, failed)
URL VARCHAR2 1000 A string. URL of the file containing the data to be imported or exported.
IS_DIRECTORY VARCHAR2 1 A string. Y or N. Indicates if the output URL is a directory.
COMPLETION_DATE TIMESTAMP A date time (DateTime). Date at which the job was completed.
ERROR_DETAIL_LOG CLOB A string. Reason for failure if status is failed.
PARENT_JOB_ID VARCHAR2 150 A string. Id of the corresponding parent Job if any.
START_DATE TIMESTAMP A date field. Represents the start date of the job.
ITEM_ID VARCHAR2 112 A string. Id of the item being imported by the job.
ITEM_NAME VARCHAR2 255 A string. Name of the item being imported by the job.
ITEM_DESCRIPTION VARCHAR2 512 A string. Description of the item being imported by the job.
ITEM_TYPE VARCHAR2 50 A string. Type of the item being imported by the job.
IS_ITEM_BUNDLED VARCHAR2 10 "true" or "f;ase" string- Identifies the item being imported by the job is bundled or not.
JOB_PROGRESS_CODE NUMBER 9 A number. This field represents the progress code of job.
DELETED_FLAG VARCHAR2 1 Indicates if the record is deleted or not
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes 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.
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 Status
ATC_ECC_IMPEXP_JOB_PK Unique Default IMPEXP_JOB_ID
ATC_ECC_IMPEXP_JOB_U1 Unique Default JOB_ID
ATC_ECC_IMPEXP_JOB_U2 Unique Default CREATION_DATE Obsolete