rs_submit_frame_elements

on-site-related topic

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