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

std_oper_ent_link

  • Last UpdatedNov 20, 2024
  • 1 minute read

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

Field

Datatype

PK

Nulls?

Description

oper_id

string40

Y

N

Identify operation

ent_id

int32

Y

N

Entity on which operation could be done

est_fixed_lab

tfloat

N

Y

Est fixed labor hours – setup/cleanup

est_lab_rate

tfloat

N

Y

Est. variable labor batch time, depending on prod_uom.

est_setup_time

tfloat

N

Y

Est. entity hours for setup

est_teardown_time

tfloat

N

Y

Est. entity hours for teardown

est_prod_rate

tfloat

N

N

Est. entity batch rate or time, depending on prod_uom.

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.

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

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 oper_id to std_oper. (Cascade delete)

FK from ent_id to job_sched_exec. (Cascade delete)

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