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_step_file

  • Last UpdatedNov 20, 2024
  • 1 minute read

The oper_step_file table provides the ability to link any number of files to an operation step.

Field

Datatype

PK

Nulls?

Description

process_id

string40

Y

N

Identify process

oper_id

string40

Y

N

Identify operation

step_no

int32

Y

N

Identify step

assoc_file

string254

Y

N

The path and file name of the file associated with the step.

assoc_file_type

string254

N

N

The file type of the file that is associated with the step. This value is entered internally, based on the file extension of the file specified in the assoc_file field.

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 process_id, oper_id, step_no to oper_step. (Cascade delete)

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