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