RUN_CYCLE_REFS_V

The RUN_CYCLE_REFS_V view displays information about when job streams run.
Table 1. The RUN_CYCLE_REFS_V view
Column name Description Type Length
Job_stream_wks_identifier The identifier of the workstation where the job stream is defined. character 16
Job_stream_wks_name The name of the workstation where the job stream is defined. string 16
Job_stream_folder_id The identifier of the folder that contains the job stream. character 16
Job_stream_folder_name The name of the folder that contains the job stream. string

4000  Oracle
4095  DB2

Job_stream_identifier The identifier of the job stream. character 16
Job_stream_name The name of the job stream. string 16
Job_stream_valid_from The starting date from which the job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Job_stream_valid_to The last date that the job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Run_cycle_identifier The identifier of the run cycle associated with the job stream. character 16
Run_cycle_name The name of the run cycle associated with the job stream. string 40
Run_cycle_valid_from The starting date from which the run cycle is included in a production plan. date
10
In DB2®
9
In Oracle
Run_cycle_valid_to The last date that the run cycle is included in a production plan. date
10
In DB2®
9
In Oracle
Run_cycle_type The type of run cycle associated with the job stream. Possible values are:
S
Simple
C
Calendar-based
R
Rule-based
character 1
Run_cycle_definition The rules defined for the run cycle. If this field is not specified, the run cycle associated with the job stream and specified in the Run_cycle_type column is calendar-based. string not defined
Free_days_rule The non-working day rule associated with the run cycle. Possible values are:
N
None. Follow no rule. Schedule the job stream regardless of whether the schedule falls on a non-working day or on a workday.
B
Nearest workday before a non-working day. Counts both workdays and non-working days. If the scheduled date falls on a non-working day, schedule the job stream on the preceding workday.
A
Nearest workday after a non-working day. Counts both workdays and non-working days. If the scheduled date falls on a non-working day, schedule the job stream on the following workday.
X
Do not select. Counts both workdays and non-working days. If the scheduled date falls on a non-working day, do not schedule the job stream.
character 1
Run_cycle_inclusive Whether the run cycle associated with the job stream is inclusive or exclusive. Possible values are:
Y
Inclusive
N
Exclusive
character 1
Calendar_identifier The identifier of the calendar on which the run cycle is defined. character 16
Calendar_name The name of the calendar on which the run cycle is defined. string 16
Calendar_folder_id The identifier of the folder where the calendar is stored. character 16
Calendar_folder_name The name of the folder where the calendar is stored. string 801
Offset_type The type of offset associated with the calendar on which the run cycle is defined. Possible values are:
D
Days. The day indicated in the calendar plus the specified offset value.
W
Workdays. The day indicated in the calendar plus the number of workdays.
A
Weekdays. The day indicated in the calendar plus the weekdays (Monday to Friday).
character 1
Offset_value The value of the offset associated with the offset type. integer 4
Job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream. character 16
Job_stream_wks_folder_name The name of the folder containing the workstation of the job stream. string 801
Job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream. string 16