| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
MFDS_ID |
Number(6,0) |
INTEGER NOT NULL |
ID of the Characteristic.
|
| 2 |
SPEC_ID |
Number(7,0) |
INTEGER NOT NULL |
Specification
|
| 3 |
STREAM_ID |
Number(8,0) |
INTEGER NOT NULL |
Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
|
| 4 |
CHART_ID |
Number(4,0) |
SMALLINT NOT NULL |
Quality control chart ID
|
| 5 |
PROC_ID |
Number(4,0) |
SMALLINT NOT NULL |
Control Procedure
|
| 6 |
TEST_ID |
Number(4,0) |
SMALLINT NOT NULL |
Control Test ID
|
| 7 |
STATS_ID |
Number(3,0) |
SMALLINT NOT NULL |
Statistic ID
|
| 8 |
GREF_ID |
Number(4,0) |
SMALLINT NOT NULL |
Graph Preference ID
|
| 9 |
STREAM_ROOT_ID |
Number(8,0) |
INTEGER NOT NULL |
Stream Root ID - hierarchal structure
|
| 10 |
QS_DCC_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Remove from qs_auto_numbers if no longer in use
|
| 11 |
QS_TRACESET_ID |
Number(5,0) |
INTEGER NOT NULL |
Trace Set ID
|
| 12 |
QS_ATTRIB_SET_ID |
Number(5,0) |
INTEGER NOT NULL |
Attribute set ident
|
| 13 |
QS_MFDS_PLAN_ID |
Number(8,0) |
INTEGER NOT NULL |
ADDED label field name for display purposes
|
| 14 |
QUEUE_QCPLAN_ID |
Number(8,0) |
INTEGER NOT NULL |
Stream Root ID - hierarchal structure
|