| 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 |