| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUQS_NONVW
|
| 2 |
QS_APP_CONTEXT |
Character(18) |
VARCHAR2(18) NOT NULL |
QC application context identifier
Prompt Table:
QS_APP_DEF
|
| 3 |
QS_MFDS_PLAN_ID |
Number(8,0) |
INTEGER NOT NULL |
ADDED label field name for display purposes
|
| 4 |
MFDS_ID |
Number(6,0) |
INTEGER NOT NULL |
ID of the Characteristic.
Default Value: 1
|
| 5 |
MFDS_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Characteristic
|
| 6 |
MFDS_UNITS |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure
Prompt Table:
UNITS_TBL
|
| 7 |
MFDS_SGRP_SIZE |
Number(13,5) |
DECIMAL(12,5) NOT NULL |
Subgroup Size
Default Value: 0
|
| 8 |
MFDS_DATA_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects
DEFS=Defectives
DFTV=Defectives
VAR=Variables
Default Value: VAR
|
| 9 |
MFDS_CLASS_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
characteristic - class type code
Prompt Table:
QS_CLASS_TYPE
|
| 10 |
MFDS_COLLECT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit
Default Value: Y
|
| 11 |
SPEC_ID |
Number(7,0) |
INTEGER NOT NULL |
Specification
|
| 12 |
MFDS_UAL |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Upper Acceptance Limit
|
| 13 |
MFDS_UAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
N=Null
U=User Specified
Default Value: N
|
| 14 |
MFDS_LAL |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Lower Acceptance Limit
|
| 15 |
MFDS_LAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
N=Null
U=User Specified
Default Value: N
|
| 16 |
SPEC_USL |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Upper
|
| 17 |
SPEC_USL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
N=Null
U=User Specified
Default Value: N
|
| 18 |
SPEC_LSL |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Lower
|
| 19 |
SPEC_LSL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
N=Null
U=User Specified
Default Value: N
|
| 20 |
SPEC_FACTOR1 |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Factor 1
|
| 21 |
SPEC_FACTOR1_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
N=Null
U=User Specified
Default Value: N
|
| 22 |
SPEC_FACTOR2 |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Factor 2
|
| 23 |
SPEC_FACTOR2_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
N=Null
U=User Specified
Default Value: N
|
| 24 |
MFDS_INC_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Incomplete Subgroup
AVG=Average
DONT=Do Not Accept
Default Value: DONT
|
| 25 |
MFDS_FORMULA |
Character(254) |
VARCHAR2(254) NOT NULL |
Formula
|
| 26 |
CHART_ID |
Number(4,0) |
SMALLINT NOT NULL |
Quality control chart ID
Prompt Table:
QS_CL_CHART
|
| 27 |
PROC_ID |
Number(4,0) |
SMALLINT NOT NULL |
Control Procedure
Prompt Table:
QS_CL_PROC_VW
|
| 28 |
GREF_ID |
Number(4,0) |
SMALLINT NOT NULL |
Graph Preference ID
Prompt Table:
QS_GRSET_VW
|
| 29 |
QS_RESULTS_RTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Results (Integration)
N=Char doesn't return results
Y=Char returns results
|