std_oper

oper_id

string40

Y

N

Identify operation

oper_desc

string80

N

Y

Operation description

def_reject_rate

tfloat

N

Y

Default reject rate assumed in this op; e.g., 0.02 = 2% rejects expected

check_inv

logical

N

N

Is sufficient component inventory required to change state_cd to 2 (Ready)? Default = No.

sched_to_ent_id

int32

N

Y

To which entity to schedule this oper_id. For example, may want to schedule to parent ‘group’ entity. If null defaults to schedule to entities as specified in oper_ent_link table.

oper_type

string80

N

Y

Type of operation – often used to help determine which job instances to create when importing schedules from ERP system

oper_cost

tfloat

N

Y

Additional (non-labor, non-machine, non-material) cost associated specifically with this operation

deviation_above

tfloat

N

N

Portion of start quantity by which total production may deviate above it; default to value of system attribute 103

deviation_below

tfloat

N

N

Portion of start quantity by which total production may deviate below it; default to value of system attribute 104

assoc_file

string254

N

Y

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

assoc_file_type

string254

N

Y

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

notes

nvarchar(max)

N

Y

Notes about this operation

spare1

string80

N

Y

Use defined by language term 290

spare2

string80

N

Y

Use defined by language term 291

spare3

string80

N

Y

Use defined by language term 292

spare4

string80

N

Y

Use defined by language term 293

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.