job_exec
- Last UpdatedNov 20, 2024
- 4 minute read
The job_exec table defines the characteristics of a job executor, which is an extended set of parameters that may be defined for any physical entity that is capable of running a job, i.e., processing work.
Multi-spindle lathes, 4 sided ‘tombstones’ for mills, saws that gang cut, or machines that can fill or package different products concurrently are handled by defining "sub-machines" for each possible job that can be run simultaneously, and assigning each a job executor. If these sub-machines are indistinguishable, their ent_ids are the same but the job_pos differs. In this case the records will be identical except for the fields relating to the current job (cur_*).
This table defines parameters which apply to a specific job executor. These include all the options available for controlling jobs.
The default values may be overridden by specific operations, or job instances, or by data collected at runtime.
The current values store the current state of each job_exec entity.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
Y |
N |
Linked to one entity only |
|
job_pos |
int32 |
Y |
N |
To allow > 1 jobs to run on this entity concurrently. Defaults to 0 when only a single job may run on the entity at a time. |
|
next_job_only |
logical |
N |
N |
Start next job only or select any – an inverse of override queue privilege, but by physical entity rather than by user group. Default = No |
|
item_based_desc |
logical |
N |
N |
Messages use item not oper desc. Default = No. Note: This field is currently not used. |
|
job_end_confirm_ |
string80 |
N |
Y |
Operation end confirm message |
|
def_to_ent_id |
int32 |
N |
Y |
Default storage entity for good production items, and rejects if def_reject_ent_id is null |
|
def_reject_ent_id |
int32 |
N |
Y |
Default storage entity for reject production items |
|
def_from_ent_id |
int32 |
N |
Y |
Default storage entity for item issues |
|
def_prod_reas_cd |
int32 |
N |
N |
Default reas_cd for good production |
|
def_cons_reas_cd |
int32 |
N |
Y |
Default reas_cd for normal consumption. Nullable in case BOM option not licensed. |
|
def_lot_no |
string40 |
N |
Y |
Default lot number for production |
|
def_sublot_no |
string40 |
N |
Y |
Default sublot number for production |
|
autoload_job_specs |
logical |
N |
N |
Auto load job specs to tags. Default = No. |
|
auto_seq_start_ |
int32 |
N |
N |
Enumeration of condition to automatically start the job with the current W/O and op. and next seq_no: 0 = Don’t start automatically (default) 1 = Start job with next sequence when previous done |
|
auto_job_start_ |
int32 |
N |
N |
Enumeration of condition to automatically start a job: 0 = Don’t start automatically (default) 1 = Start next scheduled job as soon as ready 2 = Start next scheduled job with W/O specified in tag that just changed |
|
auto_job_end_ |
int32 |
N |
N |
Enumeration of condition to automatically end a job: 0 = Don’t end automatically (default) 1 = when QtyDone >= QtyReqd |
|
incl_class_reas |
logical |
N |
N |
Yes if item reasons for item class should also be available to choose from if there are entity-related item reasons defined. (Default = No) |
|
must_complete_ |
logical |
N |
N |
Must all steps be completed/bypassed to end job? Default = Yes. |
|
must_prod_reqd_ |
logical |
N |
N |
Must req’d quantity be produced (good) to end job? Default = Yes. |
|
local_movable_ |
logical |
N |
N |
Do movable storage entities supplying consumption need to be at/in the entity consuming it? Default = No. Note: This field is currently not used. |
|
local_movable_ |
logical |
N |
N |
Do movable storage entities receiving production need to be at/in the entity producing it? Default = No. Note: This field is currently not used. |
|
run_without_ |
logical |
N |
N |
Yes (default) if jobs may run without an operator logged on to this entity; if no, running jobs are suspended when last operator logs off. If this entity may collect labor, this means when no more labor is being attributed to the job, which may be prior to having no operator logged on this entity. |
|
apply_post_exec_ |
logical |
N |
N |
Yes (default) if production counts received from Factory connector when no job is running should be applied to the last job that ran on the entity. No means such counts are ignored. Note: This field is currently not used. |
|
suppress_start_ |
logical |
N |
N |
Yes if the prompt to specify a quantity to start that is typically displayed when the Start Some button is pressed is to be suppressed; No (default) if this quantity prompt is to be shown normally. |
|
allow_zero_qty_ |
logical |
N |
N |
Yes if default quantities to be used for Start Some are 0; No (default) if they are to be 1. |
|
auto_alloc_qty_to_ |
logical |
N |
N |
Yes if overages in reported production are to be covered by moving quantities from a scheduled, non-running job if available; No (default) if reporting an overage is to result in an error. |
|
cur_wo_id |
string40 |
N |
Y |
Current work order on this entity |
|
cur_oper_id |
string40 |
N |
Y |
Current operation on this entity |
|
cur_seq_no |
int32 |
N |
Y |
Current operation split |
|
cur_step_no |
int32 |
N |
Y |
Last step started on this entity. Null if not using steps. |
|
cur_step_start |
tdatetime |
N |
Y |
When last step was started on this entity, in UTC |
|
spare1 |
string1000 |
N |
Y |
Use defined by language term 510 |
|
spare2 |
string1000 |
N |
Y |
Use defined by language term 511 |
|
spare3 |
string1000 |
N |
Y |
Use defined by language term 512 |
|
spare4 |
string1000 |
N |
Y |
Use defined by language term 513 |
|
last_edit_comment |
notes |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail. |
FK from ent_id to ent. (Cascade delete)
FK from def_to_ent_id to storage_exec. (Set null)
FK from def_from_ent_id to storage_exec. (Set null)
FK from def_reject_ent_id to storage_exec. (Set null)
FK from def_prod_reas_cd to item_reas. (Set null)
FK from def_cons_reas_cd to item_reas. (Set null)
FK from cur_wo_id, cur_oper_id, cur_seq_no to job. (Inhibit delete)