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