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

data_log_grp_job_step_link

  • Last UpdatedNov 20, 2024
  • 1 minute read

The data_log_grp_job_step_link table allows a many-to-many relation between data log groups and job steps.

Field

Datatype

PK

Nulls?

Description

grp_id

int32

Y

N

The ID of the data log group

wo_id

int32

Y

N

The work order ID, operation ID, and sequence number that identify the job to which this data log group is linked

oper_id

string40

Y

N

seq_no

int32

Y

N

step_no

int32

Y

N

Identify step to which data log group is linked

cert_name

string40

N

Y

The name of the certification that is necessary to confirm data

cert_level

int32

N

Y

The level of certification necessary to confirm data

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 identifier for row

FK wo_id, oper_id, seq_no, step_no to job_step. (Cascade delete)

FK from grp_id to data_log_grp. (Cascade delete)

FK from cert_name to cert_type. (Set null)

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