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

New Job_Util_Log_Link Table (in FI_Large)

  • Last UpdatedDec 18, 2018
  • 1 minute read

Field

Datatype

PK

Nulls?

Description

log_id

int32

N

N

Reference to a particular util_log record

job_pos

int32

N

N

Position on which job ran

wo_id

string40

N

N

Work order identifier

oper_id

string40

N

N

Operation identifier

seq_no

int32

N

N

Identify row in job table

item_id

string40

N

N

Which item being produced

job_start

tdatetime

N

N

When the job started during this utilization event

duration

int32

N

N

Duration of this job during this utilization event in seconds

last_edit_comment

string254

N

Y

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 0

Y

N

Unique row identifier, for audit trail.

FK from log_id to util_log. (Cascade delete)

log_id, pos_no, job_start is UK.

log_id, wo_id, oper_id, seq_no, job_start is UK.

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