QS_MFDS_MST_VW(SQL View) |
Index Back |
|---|---|
Characteristic master defs |
| Select a.business_unit, a.qs_app_context, a.qs_mfds_plan_id, a.mfds_id, a.mfds_name, a.mfds_units, a.mfds_sgrp_size, a.mfds_data_type_cd, a.mfds_collect_sw, a.mfds_ual, a.mfds_ual_ind, a.mfds_lal, a.mfds_lal_ind, a.spec_usl, a.spec_usl_ind, a.spec_lsl, a.spec_lsl_ind, a.spec_factor1, a.spec_factor1_ind, a.spec_factor2, a.spec_factor2_ind, a.mfds_inc_cd, a.chart_id, a.proc_id, a.gref_id, a.spec_id, a.mfds_class_type_cd, b.qs_mfds_plan_name From PS_QS_MFDS_MST a, ps_qs_mfds_plan b where b.qs_mfds_plan_id = a.qs_mfds_plan_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 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. |
| 5 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 6 | MFDS_UNITS | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 7 | MFDS_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | Subgroup Size |
| 8 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 9 | MFDS_COLLECT_SW | Character(1) | VARCHAR2(1) NOT NULL | Active |
| 10 | MFDS_UAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper Acceptance Limit |
| 11 | MFDS_UAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 12 | MFDS_LAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower Acceptance Limit |
| 13 | MFDS_LAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 14 | SPEC_USL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper |
| 15 | SPEC_USL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 16 | SPEC_LSL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower |
| 17 | SPEC_LSL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 18 | SPEC_FACTOR1 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 1 |
| 19 | SPEC_FACTOR1_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 20 | SPEC_FACTOR2 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 2 |
| 21 | SPEC_FACTOR2_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 22 | MFDS_INC_CD | Character(4) | VARCHAR2(4) NOT NULL |
Incomplete Subgroup
AVG=Average DONT=Do Not Accept |
| 23 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 24 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 25 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |
| 26 | SPEC_ID | Number(7,0) | INTEGER NOT NULL | Specification |
| 27 | MFDS_CLASS_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | characteristic - class type code |
| 28 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |