oper_ent_spec
- Last UpdatedNov 20, 2024
- 2 minute read
The oper_ent_spec table contains setup parameters specific to an operation being done on a specific entity, usually independent of which item is being consumed or produced. 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 |
Y |
N |
Identify process |
|
oper_id |
string40 |
Y |
N |
Identify operation |
|
step_no |
int32 |
Y |
N |
Identify step no. Default = –1 (not associated with a step) |
|
ent_id |
int32 |
Y |
N |
Identify entity |
|
ver_id |
string40 |
Y |
N |
Identify spec version |
|
spec_id |
string40 |
Y |
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 |
|
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 ent_id to ent. (Cascade delete implemented by SP)
FK from process_id, oper_id, ver_id to oper_spec_ver. (Cascade delete)
FK from spec_id to spec. (Cascade delete)