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

oper_ent_link

  • Last UpdatedNov 20, 2024
  • 2 minute read

The oper_ent_link table defines which entities are capable of performing each operation and the setup and runtime standards in each case.

Field

Datatype

PK

Nulls?

Description

process_id

string40

Y

N

Identify process

oper_id

string40

Y

N

Identify operation for this process

ent_id

int32

Y

N

Entity on which operation could be done

est_fixed_lab

tfloat

N

Y

Estimated fixed labor hours – setup/cleanup

est_lab_rate

tfloat

N

Y

Estimated variable labor batch time, depending on prod_uom.

est_setup_time

tfloat

N

Y

Estimated entity hours for setup

est_teardown_time

tfloat

N

Y

Estimated entity hours for teardown

est_prod_rate

tfloat

N

N

Estimated entity batch rate or time, depending on prod_uom.

Must be ≥ 0.

prod_uom

int32

N

N

Unit of measure for est_lab_rate and est_prod_rate:

0 = hours/batch (default)

1 = minutes/batch

2 = seconds/batch

3 = batches/hour

4 = batches/minute

5 = batches/second

batch_size

tfloat

N

N

(default = 1)

est_transfer_time

tfloat

N

Y

Transfer time after operation - hours

init_prod_pct

tfloat

N

Y

Specifies the initial production % required at this entity (if the first operation is done at multiple entities), null for other cases.

parent_contingent_ent

logical

N

N

Is this for a group that will really be run on one or more children? Default = No.

child_contingent_ent

logical

N

N

Is this potentially for one of a group of entities? Default = No.

last_edit_comment

string254

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

mod_id

timestamp

N

N

A binary number that increments each time the row is modified.

row_id

ID 1

N

N

Unique row identifier, for audit trail.

FK from process_id, oper_id to oper. (Cascade delete)

FK from ent_id to job_sched_exec. (Cascade delete)

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