Quality Statistical Data
This table shows the Infor LN table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| qmptc112 | Quality Statistical Data |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Characteristic Unit | qmptc112.chun |
| Company | qmptc112.compnt |
| Handling Unit | qmptc112.huid |
| Inspection | qmptc112.apno |
| Inspection Sample | qmptc112.saml |
| Inspection Sequence | qmptc112.apsq |
| Lower Limit | qmptc001.llmt |
| Lower Warning | qmptc001.ltwa |
| Nominal Value | qmptc001.nomi |
| Norm | qmptc001.norm |
| Operation | qmptc112.opno |
| Origin Order | qmptc112.orno |
| Origin Order Line | qmptc112.pono |
| Origin Order Sequence | qmptc112.seqn |
| Process Capability | (UPPER LIMIT) - (LOWER LIMIT)) / (6 * STDEV (Measurement Value) |
| Process Capability Index | IF UPPER LIMIT - AVERAGE (Measurement Value) / (3 * STDEV(Measurement Value))
< AVERAGE (Measurement Value) - LOWER LIMIT / (3 * STDEV (Measurement
Value)) THEN UPPER LIMIT - AVERAGE (Measurement Value) / (3 * STDEV (Measurement Value)) ELSE AVERAGE (Measurement Value) - LOWER LIMIT / (3 * STDEV (Measurement Value)) |
| Process Performance Index | IF UPPER LIMIT - MAX ((UPPER LIMIT + LOWER LIMIT) / 2)) / (3 * STDEV (Measurement
Value)) < (UPPER LIMIT + LOWER LIMIT) / 2) - MAX (LOWER_LIMIT)) / (3 * STDEV
(Measurement Value)) THEN UPPER LIMIT - MAX ((UPPER LIMIT + LOWER LIMIT) / 2)) / (3 * STDEV (Measurement Value)) ELSE (UPPER LIMIT + LOWER LIMIT) / 2) - MAX (LOWER_LIMIT)) / (3 * STDEV (Measurement Value)) |
| Scorecard | If Grand mean of measurement value is between upper and lower limit, then pass; else fail |
| Subgroup Size | qmptc112.nosp |
| Tolerance Standard | qmptc001.tost |
| Upper Limit | qmptc001.ulmt |
| Upper Warning | qmptc001.utwa |
| Work Station | qmptc112.wstt |
| Unknown | 1 for null records, else 0 |
| Deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |