Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

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

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

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

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

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

logical

N

N

Must all steps be completed/bypassed to end job? Default = Yes.

must_prod_reqd_
qty

logical

N

N

Must req’d quantity be produced (good) to end job? Default = Yes.

local_movable_
cons_ent

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

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

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

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

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

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

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)

TitleResults for “How to create a CRG?”Also Available in