oper_item_spec
- Last UpdatedNov 20, 2024
- 2 minute read
The oper_item_spec table contains setup parameters specific to an operation being done which will produce or consume a specific item or an item from a specific item class. The data may be downloaded from the ERP system if it maintains this data, or it may be maintained within our database if necessary. The data can be displayed on the shop floor or automatically downloaded to a PLC or equivalent when a job is started.
The ‘step_no’ field is used to allow a spec to optionally be linked to a step. This field is set = -1 for specs that apply to the operation as a whole and not any specific step.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
process_id |
string40 |
N |
N |
Identify process |
|
oper_id |
string40 |
N |
N |
Identify operation |
|
step_no |
int32 |
N |
N |
Identify step no. Default = -1 (not associated with a step) |
|
item_id |
string40 |
N |
Y |
Identify item |
|
item_class_id |
string40 |
N |
Y |
Identify item class |
|
ver_id |
string40 |
N |
N |
Identify spec version |
|
spec_id |
string40 |
N |
N |
Identify spec for operation |
|
spec_value |
string1700 |
N |
N |
Value for this spec |
|
assoc_file |
string254 |
N |
Y |
The path and file name of the file associated with the spec. |
|
assoc_file_type |
string254 |
N |
Y |
The file type of the file that is associated with the spec. This value is entered internally, based on the file extension of the file specified in the assoc_file field. |
|
comments |
string1700 |
N |
Y |
Comments/instructions to operator |
|
min_value |
string80 |
N |
Y |
Minimum acceptable value for the spec. Default = null which means no minimum value defined. |
|
max_value |
string80 |
N |
Y |
Maximum acceptable value for the spec. Default = null which means no maximum value defined. |
|
access_level |
int32 |
N |
Y |
Required security access level for modifying this spec. Default = null which means no extra security defined (null has same meaning as value = 0). |
|
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 |
Y |
N |
Unique row identifier, for audit trail |
process_id, oper_id, step_no, item_id, item_class_id, ver_id, spec_id is UK
FK from process_id, oper_id, ver_id to oper_spec_ver. (Cascade delete)
FK from spec_id to spec. (Cascade delete)
FK from item_id to item. (Cascade delete)
FK from item_class_id to item_class. (Cascade delete)