MKT_CM_SYSTASKS
This table stores the Stage execution progress in form of the actual server tasks being executed.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MKT_CM_SYSTASKS_PK |
SYSTASK_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SYSTASK_ID | NUMBER | 18 | Yes | Column holds the systask id. This is a primary key as well | |
| OBJECT_DETAIL_NAME | VARCHAR2 | 100 | This Column specifies the language independent code of the object | ||
| OBJECT_SEQUENCE | NUMBER | 18 | Column holds the object sequence corrsponding to the systask | ||
| ENABLE_OBJECT | VARCHAR2 | 1 | This Column specifies the object selected for import. | ||
| ROOT_SYSTASK_ID | NUMBER | 18 | Column holds the root systask id for an import job | ||
| IMPORT_MAP_ID | NUMBER | 18 | Column holds the import map id corrsponding to the systask | ||
| FILES_PATH | VARCHAR2 | 2000 | Column holds the path for all the improt files(SQLLDR Cntrl file, Data file, log file, BAD file, zip files and individual csv files) created in the system | ||
| BATCH_LEVEL | NUMBER | 3 | Column holds the level of the system task. Parent Level system task will be 1, next child level will be 2 and so on. | ||
| INTERFACE_TABLE_NAME | VARCHAR2 | 100 | Column holds the interface table name | ||
| PARTITION_NAME | VARCHAR2 | 128 | Column holds the partition name created for an interface table | ||
| IMPORT_OBJECT_CD | VARCHAR2 | 128 | Column holds the import object code (Ex: LEAD,ASSET) | ||
| TASK_DETAILS16 | VARCHAR2 | 150 | Indicates whether the value was invoked from UI | ||
| TASK_DETAILS17 | VARCHAR2 | 150 | Contains new File Import Status values | ||
| TASK_DETAILS15 | VARCHAR2 | 150 | Holds the number of data elements being processed by an import job, [sum of (row*column product), for all csv files in an import job], used for calculating estimated time to completion for an import job | ||
| TASK_DETAILS14 | VARCHAR2 | 150 | Used for storing estimated time to completion for an import job | ||
| TASK_DETAILS13 | VARCHAR2 | 150 | Would hold a flag denoting whether the file import was invoked using UI or a web-service | ||
| TASK_DETAILS12 | VARCHAR2 | 150 | Number of records with warnings | ||
| TASK_DETAILS11 | VARCHAR2 | 150 | It will hold import_job_number from mkt_imp_jobs. It will be used primarily by the seeded jobs created by file import. | ||
| TASK_DETAILS6 | VARCHAR2 | 150 | Column holds the Accept Log file name | ||
| TASK_DETAILS10 | VARCHAR2 | 150 | Column holds the value MULTI_CSV if import job is ZIP Import | ||
| TASK_DETAILS7 | VARCHAR2 | 150 | Column holds the Reject Log file name | ||
| TASK_DETAILS8 | VARCHAR2 | 150 | Column holds the Error Log file name | ||
| TASK_DETAILS9 | VARCHAR2 | 1000 | Column holds the import Job parameters | ||
| PARENT_TASK_ID | NUMBER | 18 | Column holds the pareant systask id of the systask | ||
| TASK_TYPE_CD | VARCHAR2 | 30 | Column holds the task type code | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Column holds the Schedule Program | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Column holds the Scheduler Program Application | ||
| ERROR_MESSAGE | VARCHAR2 | 1000 | Column holds the error message for systask | ||
| STATUS_CD | VARCHAR2 | 30 | Column holds the System Task Status | ||
| START_DT | DATE | Column holds the start date of systask | |||
| END_DT | DATE | Column holds the end date of systask | |||
| OBJECT_TYPE_CD | VARCHAR2 | 128 | Column holds the object type code | ||
| OBJECT_ID | NUMBER | 18 | Column holds the import job id corrsponds to the systask | ||
| TASK_DETAILS1 | VARCHAR2 | 150 | Column holds the total no of records in the import Job | ||
| TASK_DETAILS2 | VARCHAR2 | 150 | Column holds the number of Success records | ||
| TASK_DETAILS3 | VARCHAR2 | 150 | Column holds the Load Error Row Count | ||
| TASK_DETAILS4 | VARCHAR2 | 150 | Column holds the Format Error Row Count | ||
| TASK_DETAILS5 | VARCHAR2 | 150 | Column holds the name of Source CSV in ZIP Import | ||
| 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. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| IMPORT_TYPE | VARCHAR2 | 100 | Import Type Specifies the type of import, whether it is simplified, standard, optimized or classic import | ||
| PURGE_FLAG | VARCHAR2 | 1 | This column is to store if the batch is purged or not. Accepted values Y/N. | ||
| VISIBLE_FLAG | VARCHAR2 | 1 | This column is to store the visible flag. This can take value Y or N. If it is N, batch will not be shown on UI | ||
| UCM_PURGE_FLAG | VARCHAR2 | 1 | This column is to store the UCM purge flag. If the flag is 'Y' then the files of the corresponding batch is purged. | ||
| MESSAGE_CODE | VARCHAR2 | 100 | This column is used to store MessageCode |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| zca_import_progress | mkt_cm_systasks | SYSTASK_ID |
| mkt_cm_systsk_logs | mkt_cm_systasks | SYSTASK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_CM_SYSTASKS_F1 | Non Unique | Default | PARENT_TASK_ID |
| MKT_CM_SYSTASKS_N1 | Non Unique | Default | OBJECT_TYPE_CD, OBJECT_ID |
| MKT_CM_SYSTASKS_PK | Unique | Default | SYSTASK_ID |