RPT_RERUN_STATUS
This table stores records of the completion of tasks during initial data load in order that tasks already completed will not be run again if the process has to be restarted.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
RERUN_STATUS_ID |
NOT NULL |
NUMBER |
Uniquely identify a record |
COMPLETION_DATE |
NOT NULL |
DATE |
When the task was completed |
FILE_NAME |
NULLABLE |
VARCHAR2(512) |
The file containing the code for the task |
ACTION_NAME |
NULLABLE |
VARCHAR2(512) |
Name of the completed action |
RUN_ID |
NULLABLE |
NUMBER |
The run in which this action completed, taken from the RPT_RERUN_RUN_S sequence |
VERSION |
NULLABLE |
VARCHAR2(100) |
Version of PPM this load was run against |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
SYS_C007867316 |
UNIQUE |
1 |
RERUN_STATUS_ID |
UNIQUE_ACTION |
UNIQUE |
1 |
FILE_NAME |
UNIQUE_ACTION |
UNIQUE |
2 |
ACTION_NAME |
UNIQUE_ACTION |
UNIQUE |
3 |
VERSION |
Sequences
Sequence Name |
Sequence Type |
---|---|
RPT_RERUN_RUN_S |
RUN_ID |
RPT_RERUN_STATUS_S |
RERUN_STATUS_ID |