RCS_EXTRACT_JOBS
This table contains the list of extract jobs defined by the user. Information related to each extract job including details of extract definition and schedule id are also stored.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RCS_EXTRACT_JOBS_PK |
EXTRACT_JOB_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTRACT_JOB_ID | NUMBER | 18 | Yes | Indicates the Unique identifier for an extract job. | |
| EXTRACT_JOB_NAME | VARCHAR2 | 100 | Yes | The user supplied name of the extract job. | |
| EXTRACT_JOB_DESCRIPTION | VARCHAR2 | 1000 | The user supplied description of the extract job. | ||
| EXTRACT_DEFINITION_ID | NUMBER | 18 | Yes | Foreign key for the user defined extract definition selected to run the extract job. | |
| SCHEDULE_ID | NUMBER | 18 | Foreign key of the Enterprise Scheduler Service job id triggered for this extract job. | ||
| EXTERNAL_STORAGE_ID | NUMBER | 18 | Yes | Foreign key of the configured external storage where the output files of the extract job will be uploaded. | |
| FREQUENCY | VARCHAR2 | 10 | Yes | Frequency of occurance of the schedule. | |
| FREQUENCY_HOURLY_INTERVAL | NUMBER | 6 | In case the schedule is in Hour, the value of the interval. | ||
| FREQUENCY_DAILY_INTERVAL | NUMBER | 6 | In case the schedule is in Daily, the value of the interval. | ||
| FREQUENCY_WEEKLY_INTERVAL | NUMBER | 6 | In case the schedule is in weeks, the value of interval. | ||
| FREQUENCY_MONTHLY_INTERVAL | NUMBER | 6 | In case the schedule is in Months, the value of interval. | ||
| FREQUENCY_YEARLY_INTERVAL | NUMBER | 6 | In case the schedule is in Years, the value of interval. | ||
| STARTTIME | TIMESTAMP | Yes | The designated start time of the schedule. | ||
| ENDTIME | TIMESTAMP | The designated end time of the schedule. | |||
| 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. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCS_EXTRACT_JOBS_U1 | Unique | Default | EXTRACT_JOB_ID |