| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
QS_RPT_ID |
Character(24) |
VARCHAR2(24) NOT NULL |
QS inquiry report ID
|
| 3 |
STREAM_ID |
Number(8,0) |
INTEGER NOT NULL |
Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
|
| 4 |
MFDS_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Characteristic
|
| 5 |
QS_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Generic sequence number
|
| 6 |
SPEC_LSL_WRK |
Character(13) |
VARCHAR2(13) NOT NULL |
Lower Spec Limit
|
| 7 |
SPEC_USL_WRK |
Character(13) |
VARCHAR2(13) NOT NULL |
Upper Spec Limit
|
| 8 |
QS_SUMALARM |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Tally of alarms over time
|
| 9 |
QS_OBSRV |
Number(8,0) |
INTEGER NOT NULL |
QServer # of observations
|
| 10 |
QS_MEAN |
Character(13) |
VARCHAR2(13) NOT NULL |
Statistical mean
|
| 11 |
QS_RANGE |
Character(13) |
VARCHAR2(13) NOT NULL |
Statistical range
|
| 12 |
QS_STDDEV |
Character(13) |
VARCHAR2(13) NOT NULL |
Statistical standard deviation
|
| 13 |
QS_SKEWNESS |
Character(13) |
VARCHAR2(13) NOT NULL |
Statistical skewness
|
| 14 |
QS_KURTOSIS |
Character(13) |
VARCHAR2(13) NOT NULL |
Statistical kurtosis
|
| 15 |
QS_CP |
Character(13) |
VARCHAR2(13) NOT NULL |
Capability index
|
| 16 |
QS_CPK |
Character(13) |
VARCHAR2(13) NOT NULL |
Sided capability index (CPK)
|
| 17 |
QS_CPL |
Character(13) |
VARCHAR2(13) NOT NULL |
Lower capability index (CPL)
|
| 18 |
QS_CPU |
Character(13) |
VARCHAR2(13) NOT NULL |
Upper capability index (CPU)
|
| 19 |
QS_PCLOWER |
Character(13) |
VARCHAR2(13) NOT NULL |
% below spec
|
| 20 |
QS_PCSPEC |
Character(13) |
VARCHAR2(13) NOT NULL |
% of spec
|
| 21 |
QS_PCTOTAL |
Character(13) |
VARCHAR2(13) NOT NULL |
total % out of spec
|
| 22 |
QS_PCUPPER |
Character(13) |
VARCHAR2(13) NOT NULL |
% above spec
|
| 23 |
QS_SUMZ |
Number(8,0) |
INTEGER NOT NULL |
Sum of subgroup sizes
|
| 24 |
QS_SUMDEF |
Number(8,0) |
INTEGER NOT NULL |
sum of all defects
|
| 25 |
QS_DEFPU |
Character(13) |
VARCHAR2(13) NOT NULL |
Defects per unit (average)
|
| 26 |
QS_DEFPH |
Character(18) |
VARCHAR2(18) NOT NULL |
Defects per 100 units
|
| 27 |
QS_DEFPT |
Character(18) |
VARCHAR2(18) NOT NULL |
Defects per 1000 units
|
| 28 |
QS_DEFPM |
Character(18) |
VARCHAR2(18) NOT NULL |
Defects per million units
|