| Workstation_identifier |
The identifier of the workstation where the
resource is defined. |
character |
16 |
| Workstation_name |
The name of the workstation where the resource
is defined. |
string |
16 |
| Resource_identifier |
The identifier of the resource on which the
jobs and job streams depend. |
character |
16 |
| Resource_name |
The name of the resource on which the jobs and
job streams depend. |
string |
148 |
| Units_available |
The number of this resource available for allocation. |
integer |
4 |
| Units_allocated |
The number of this resource to be allocated
to satisfy the dependency. |
integer |
4 |
| Dep_job_stream_wks_identifier |
The identifier of the workstation where the
job stream that depends on the resource specified in the Resource_identifier column
is defined. |
character |
16 |
| Dep_job_stream_wks_name |
The name of the workstation where the job stream
that depends on the resource specified in the Resource_name column
is defined. |
string |
16 |
| Dep_job_stream_identifier |
The identifier of the job stream that depends
on the resource specified in the Resource_identifier column. |
character |
16 |
| Dep_job_stream_name |
The name of the job stream that depends on the
resource specified in the Resource_name column. |
string |
16 |
| Dep_job_stream_valid_from |
The starting date from which the dependent job
stream is included in a production plan if selected by a run cycle. |
date |
- 10
- In DB2®
- 9
- In Oracle
|
| Dep_job_stream_valid_to |
The last date that the dependent job stream
is included in a production plan if selected by a run cycle. |
date |
- 10
- In DB2
- 9
- In Oracle
|
| Dep_job_wks_identifier |
The identifier of the workstation where the
job that depends on the prompt specified in the Prompt_identifier column
is defined. |
character |
16 |
| Dep_job_wks_name |
The name of the workstation where the job that
depends on the prompt specified in the Prompt_name column is
defined. |
string |
16 |
| Dep_job_identifier |
The identifier of the job that depends on the
resource specified in the Resource_identifier column. |
character |
16 |
| Dep_job_name |
The name of the job that depends on the resource
specified in the Resource_name column. |
string |
40 |
| Dep_job_definition_identifier |
The identifier of the job definition that depends
on the resource specified in the Resource_identifier column. |
character |
16 |
| Dep_job_definition_name |
The name of the job definition that depends
on the resource specified in the Resource_name column. |
string |
40 |
| Job_refs_js_id |
The identifier of the job's job stream that
depends on the resource specified in the Resource_id column |
character |
16 |