process
- Last UpdatedNov 20, 2024
- 3 minute read
The process table defines a method by which something is produced, and from which work orders may be instantiated. Use of this table is optional as work orders and jobs may be entered without processes being defined.
It is possible to define more than one ‘method of manufacture’ of an item within a facility, or more than one item may be manufactured using the same process but different ingredients/components. The process is not item specific; this linkage is handled by the item_process_link table.
We define a process status (-1=Disabled, 1=Experimental, 2=Approved, 3= Certified). Certified processes may not be changed without required privilege, and also do not allow overriding of values for specific work order instances. Special privilege is also required to create a work order from an experimental process.
There is also a process level corresponding to the three levels of recipe in S88 above the control recipe actually used to make something. 1=General, 2=Site, 3=Master. General and site processes represent abstract processes which exists for the express purpose of cloning other processes (i.e. a process template). No work order can be created for a general or site process.
Note that the definition of Processes, Operations and Steps is decoupled from the definition of BOMs and also from the routing on specific machines. This provides maximum flexibility without having to repeat data when any specific data is changed.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
process_id |
string40 |
Y |
N |
Identify a version of a process |
|
process_class_id |
string40 |
N |
N |
Of which process class this is a version. |
|
process_ver_id |
string40 |
N |
N |
Identify the version |
|
process_desc |
string80 |
N |
N |
Description of this process version |
|
process_level |
int32 |
N |
N |
Enumeration of process level: 1 = General 2 = Site 3 = Master (default) |
|
process_status |
int32 |
N |
N |
Enumeration of process status: -1 = Disabled 1 = Experimental (default) 2 = Approved 3 = Certified |
|
creator |
string40 |
N |
N |
User_id who created this process version. |
|
approver |
string40 |
N |
Y |
User_id who approved this process version. Note: This field is currently not used. |
|
created_at |
tdatetime |
N |
N |
When this process version was created, in UTC |
|
last_user_to_change_ |
string40 |
N |
Y |
User_id of last person who changed the status of this process version. (Default = null) |
|
last_status_change_at |
tdatetime |
N |
Y |
When this process version’s status was last changed, in UTC. (Default = null) |
|
checked_out_by |
string40 |
N |
Y |
User_id who currently has this process version checked out. Null for not checked out. (Default = null) |
|
last_instantiated |
tdatetime |
N |
Y |
Last time a work order was successfully instantiated from this process, in UTC. |
|
disassembly |
logical |
N |
N |
If Yes, this process is disassembling something (BOM_pos = 0) into its components (BOM_pos > 0). Default = No. Note: This field is currently not used. |
|
may_override_route |
logical |
N |
N |
If Yes, certain methods would include operations other than those immediately upstream or downstream from the current one. Default No. |
|
rework |
logical |
N |
N |
This process is for rework, not production. Default = No. |
|
notes |
nvarchar(max) |
N |
Y |
Notes about this process |
|
spare1 |
string80 |
N |
Y |
Use defined by language term 5161 |
|
spare2 |
string80 |
N |
Y |
Use defined by language term 5162 |
|
spare3 |
string80 |
N |
Y |
Use defined by language term 5163 |
|
spare4 |
string80 |
N |
Y |
Use defined by language term 5164 |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_editor |
string40 |
N |
N |
User_id who last edited this process version, or its creator if unedited. |
|
last_edit_at |
tdatetime |
N |
N |
When this process version was created or last edited. |
|
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_class_id to process_class.(Cascade delete)