queue_job_attr
- Last UpdatedNov 12, 2024
- 1 minute read
The queue_job_attr table displays as columns all the job attributes to be visible in a job queue grid, for each job. This table initially has three columns, the wo_id, the oper_id, and the seq_no, with an additional pair of columns being added whenever visible_in_queue is set to Yes for a job attribute or whenever a job attribute is created with this set to Yes. A pair of columns is removed whenever visible_in_queue is set to No for a job attribute or whenever a job attribute with this set to Yes is deleted. A row is added whenever a new job record is created.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
queue_job_wo_id_h |
string40 |
Y |
N |
Identify work order of the job whose attributes are to be displayed in the queue |
|
queue_job_oper_ |
string40 |
Y |
N |
Identify operation of the job whose attributes are to be displayed in the queue |
|
queue_job_seq_no_h |
int32 |
Y |
N |
Identify row of the job whose attributes are to be displayed in the queue |
|
attr<attr_id> |
string1700 |
N |
Y |
Value of the job attribute whose ID is the numeric part of the field name following "attr_id" |
|
attr<attr_id>d_h |
string80 |
N |
N |
Description of the attribute whose ID is the numeric part of the field name following "attr" and preceding "d_h". This will be the same for every row. |
|
... |
string80 |
N |
Y |
(additional pairs of rows per above, one for every job attribute where "visible_in_queue" is Yes) |
|
... |
string80 |
N |
N |
FK from queue_job_wo_id_h, queue_job_oper_id_h, queue_job_seq_no_h to job. (Cascade delete)