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

folder_item_oper_ent_link

  • Last UpdatedNov 20, 2024
  • 1 minute read

The folder_item_oper_ent_link table specifies a default folder revision for a given operation, entity and item.

Field

Datatype

PK

Nulls?

Description

process_id

string40

Y

N

Identify process

oper_id

string40

Y

N

Identify operation

ent_id

int32

Y

N

Identify entity

item_id

string40

Y

N

Identify item

ver_id

string40

N

N

Specify default folder version for the above oper, ent, and item

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

row_id

ID 1

N

N

Unique row identifier, for audit trail

FK from item_id, oper_id, ent_id, ver_id to folder. (Cascade delete)

FK from process_id, oper_id, ent_id to oper_ent_link. (Cascade delete implemented by SP)

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