oper
- Last UpdatedNov 20, 2024
- 2 minute read
The oper table contains the "blueprint" for all operations required to make this item.
Use of this table is optional as work orders and jobs may be entered without routings and operations being defined.
Multiple operations may be defined which may be scheduled to occur at the same or different entities. Actual data for each operation is also stored in this table.
The auto_create_job_specs field is a flag to allow all operation_specs to automatically be copied to job_specs when a job was created. This allows for tracking planned parameter values in the case that the operation specs may be changed after a job is completed.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
process_id |
string40 |
Y |
N |
Identify process |
|
oper_id |
string40 |
Y |
N |
Identify operation for this process |
|
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 |
|
first_oper |
logical |
N |
N |
First operation of process? Default = No. |
|
final_oper |
logical |
N |
N |
Final operation of process? Default = No. |
|
display_seq |
int32 |
N |
N |
To specify sequence of operations independently of oper_id. Used to sequence operations in tree and flow diagram |
|
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, you 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. |
|
rework_cd |
string40 |
N |
Y |
The rework behavior for this operation |
|
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 |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
mod_id |
timestamp |
N |
N |
A binary number that increments each time the row is modified. |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail. |
FK from process_id to process. (Cascade delete)