RCS_EXTRACT_SCHEDULES
This table contains the list of extract schedules defined by the user. Information related to each extract schedule 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_SCHEDULES_PK |
EXTRACT_SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| EXTRACT_SCHEDULE_ID | NUMBER | 18 | Yes | Indicates the Unique identifier for an extract schedule. | ||
| EXTRACT_SCHEDULE_NAME | VARCHAR2 | 4000 | Yes | The user supplied name of the extract schedule. | ||
| EXTRACT_SCHEDULE_DESCRIPTION | VARCHAR2 | 1000 | The user supplied description of the extract schedule. | Obsolete | ||
| EXTRACT_DEFINITION_ID | NUMBER | 18 | Yes | Foreign key for the user defined extract definition selected to run the extract schedule. | ||
| SCHEDULE_ID | NUMBER | 18 | Foreign key of the Enterprise Scheduler Service job id triggered for this extract schedule. | |||
| EXTERNAL_STORAGE_ID | NUMBER | 18 | Foreign key of the configured external storage where the output files of the extract schedule will be uploaded. | |||
| EXTRACT_SCHEDULE_STATUS | VARCHAR2 | 20 | Stores the status of the scheduled schedule. | |||
| FILENAME_PREFIX | VARCHAR2 | 20 | Prefix to be appended to the output file in UCM. | |||
| 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. | Obsolete | ||
| FREQUENCY_WEEKLY_INTERVAL | NUMBER | 6 | In case the schedule is in weeks, the value of interval. | Obsolete | ||
| FREQUENCY_MONTHLY_INTERVAL | NUMBER | 6 | In case the schedule is in Months, the value of interval. | Obsolete | ||
| FREQUENCY_YEARLY_INTERVAL | NUMBER | 6 | In case the schedule is in Years, the value of interval. | Obsolete | ||
| STARTTIME | TIMESTAMP | Yes | The designated start time of the schedule. | |||
| ENDTIME | TIMESTAMP | The designated end time of the schedule. | ||||
| EXTRACT_TYPE | VARCHAR2 | 20 | Yes | Column value determines whether the schedule would be incremental or full | ||
| 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. | ||
| FREQ_DAY_IN_MONTH_CODE | VARCHAR2 | 60 | The value of the selected day in a month to extract data when the frequency is either Monthly or Yearly. | |||
| FREQ_MONTH_CODE | VARCHAR2 | 60 | The value of the selected month to extract data when the frequency is Yearly. | |||
| FREQ_DAYS_IN_WEEK | VARCHAR2 | 60 | The selected days of the week to extract data when the frequency is Weekly. | |||
| NOTIFICATION | VARCHAR2 | 20 | Identifies the selected milestones in the extract process to notify the specified users via email. | |||
| EMAILS | VARCHAR2 | 2000 | A delimited list of valid email addresses where notifications about the extract process will be sent. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCS_EXTRACT_SCHEDULES_U1 | Unique | Default | EXTRACT_SCHEDULE_ID |