rs_submit_frame_elements
The following table lists the columns for the rs_submit_frame_elements view. The equivalent jcs_submit_frame_elements view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
Column | Datatype | Description |
SUBMIT_FRAME_PARTITION | VARCHAR2 | The partition of the submit frame |
SUBMIT_FRAME_NAME | VARCHAR2 | The name of the submit frame |
ELEMENT | NUMBER | The submit frame element number |
SEQUENCE_NUMBER | NUMBER | The submit frame element sequence number |
TIME_WINDOW_PARTITION | VARCHAR2 | The partition of the time window used for the submit frame |
TIME_WINDOW_NAME | VARCHAR2 | The name of the time window used for the submit frame |
MINUTES_BETWEEN | NUMBER | The cycle in minutes |
DAYS_BETWEEN | NUMBER | The cycle in days |
MONTHS_BETWEEN | NUMBER | The cycle in months |
ORIGINAL_TIME | VARCHAR2 | Is the job to be rescheduled based upon its original requesttime? |
STARTTIME | VARCHAR2 | The explicitly defined base starttime |
TIMEZONE_NAME | VARCHAR2 | The timezone for the base starttime |
PRESERVE_TIMES | VARCHAR2 | Preserve times when daylight saving time changes |
note
ELEMENT: This number is not starting from 1 anymore, but an internal number
note
SEQUENCE_NUMBER: This number is not starting from 1 anymore, but an internal number
note
PRESERVE_TIMES: Not implemented
plsqlTopic
onsiteTopic