Quality
The main data tables for quality are:
| Table Name | Description |
|---|---|
| Events | Production events |
| Tests | Variable results |
| Var_Specs | Variable specifications |
| Production_Starts | Product/Grade changes |
The main configuration tables for quality are:
| Table Name | Description |
|---|---|
| Variables | Variable configuration |
| Products | Product configuration |
Variable specifications are stored in the Var_Specs table. The logical key for the table is as follows:
| Field | Description |
|---|---|
| Var_Id | The variable the specifications were entered on. |
| Prod_Id | The product the specifications were entered on. |
| Effective_Date | The time stamp of when the specification transaction was approved. |
| Expiration_Date | The time stamp of when the specification transaction expired. For the current time, this is normally NULL and is set when a new transaction is created. However, if a timed-limited transaction is created it will be preset. |
The behavior of the Var_Specs table is similar to that of the Production_Starts table in that the specification records have to be in sequence and cannot overlap (for example, the Effective_Time of a record must be the greater than or equal to the Expiration_Date of the previous record). This behavior is enforced by the Plant Applications when creating transactions through the Administrator.
Central specifications are stored in the Active_Specs table and are automatically copied to the Var_Specs table when changes are made. As such, Var_Specs is the preferred table to report on.