ZCA_IMPORT_PROGRESS
The table will hold the status of the progress of the import jobs. The table stores the information like the time taken to complete each step, total steps that would be executed during the import activity and also the current step of execution during the import activity.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_IMPORT_PROGRESS_PK |
ZCA_IMPORT_PROGRESS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ZCA_IMPORT_PROGRESS_ID | NUMBER | 18 | Yes | Primary key | |
| PARENT_PROGRESS_ID | NUMBER | 18 | This is used to store parent progress id information. | ||
| TRACKING_ID | NUMBER | 18 | This is used to store Tracking id information. | ||
| PARENT_TRACKING_ID | NUMBER | 18 | This is used to store Parent Tracking id information. | ||
| IMPORT_JOB_ID | NUMBER | 18 | Yes | FK to parent import job systask, MKT_IMP_JOBS | |
| SYSTASK_ID | NUMBER | 18 | FK to parent import job systask, MKT_CM_SYSTASKS | ||
| STEP_NAME | VARCHAR2 | 100 | Yes | Name of the step which is being tracked | |
| STEP_STATUS | VARCHAR2 | 100 | Current status of the step, updated as the import job progresses | ||
| TRACKING_STEP | VARCHAR2 | 64 | To store name of the step which is being tracked | ||
| TRACKING_STEP_STATUS | VARCHAR2 | 64 | To store status of the step which is being tracked | ||
| THREAD_NUMBER | NUMBER | 5 | To store thread number information of the particular thread | ||
| THREAD_RECORDS | VARCHAR2 | 64 | To store thread record information of the particular thread | ||
| COMMIT_SIZE | NUMBER | 5 | To store commit size information for the tracking step | ||
| PROCESS_TIME | NUMBER | 18 | To indicate the process time of current tracking step | ||
| TOTAL_MEMORY_STATE | NUMBER | 18 | To indicate the memory state of the process involved | ||
| CLEANUP_COUNTER | NUMBER | 18 | To store cleanup counter value for the tracking step | ||
| ECID | VARCHAR2 | 64 | This field is used to store Ecid information | ||
| ERROR_DETAILS | VARCHAR2 | 4000 | This field is used to store detailed error message | ||
| ESS_REQUEST_ID | NUMBER | 18 | This field is used to store ESS request identifier | ||
| START_TIME | TIMESTAMP | Start time of the current step | |||
| END_TIME | TIMESTAMP | End time of the current step | |||
| TIME_TAKEN | NUMBER | 9 | Total time taken by the current step (in milliseconds), i.e. END_TIME - START_TIME | ||
| ESTIMATED_TIME | NUMBER | 9 | Total estimated time which might be taken for completion of the current step (in milliseconds) | ||
| TOTAL_RECORDS | NUMBER | 9 | Total number of records processed by the current step | ||
| ERROR_RECORDS | NUMBER | 9 | Number of records which errored out during processing of the current step | ||
| SUCCESS_RECORDS | NUMBER | 9 | Number of records successfully processed by the current step | ||
| WARNING_RECORDS | NUMBER | 9 | Number of records processed with warning by the current step | ||
| TOTAL_SUBSTEPS | NUMBER | 9 | Total number of sub-steps that would be executed in the current step | ||
| CURRENT_SUBSTEP | NUMBER | 9 | Current sub-step that is being executed in the step, this would be continously updated as the step progresses | ||
| 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. | |
| 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. | |
| 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZCA_IMPORT_PROGRESS | mkt_cm_systasks | SYSTASK_ID |
| ZCA_IMPORT_PROGRESS | mkt_imp_jobs | IMPORT_JOB_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_IMPORT_PROGRESS_U1 | Unique | Default | ZCA_IMPORT_PROGRESS_ID |
| ZCA_IMPORT_PROGRESS_U2 | Unique | Default | SYSTASK_ID, STEP_NAME |