QS_STREAM8_VW(SQL View) |
Index Back |
|---|---|
Stream/Mfds View |
| SELECT A.BUSINESS_UNIT ,A.QS_APP_CONTEXT ,A.STREAM_ROOT_ID ,A.STREAM_ID ,A.MFDS_SEQ ,A.MFDS_ID ,A.CLIM_STS_CD ,A.STR_SGRP_CNT , A.STR_SGRP_SEQ ,A.CLIM_ID ,A.CUR_SGRP_SIZE ,A.CUR_SPEC_VIO_CNT ,A.CUR_PLOT_VALUE1 ,A.CUR_PLOT_VALUE2 ,A.RUN_MOMENT , A.TSWIN_BUFFER1 ,A.TSWIN_BUFFER2 ,A.SPEC_ID ,A.SPEC_LSL ,A.SPEC_LSL_IND ,A.SPEC_USL ,A.SPEC_USL_IND ,A.SPEC_FACTOR1 , A.SPEC_FACTOR1_IND ,A.SPEC_FACTOR2 ,A.SPEC_FACTOR2_IND ,A.MFDS_COLLECT_SW , B.MFDS_SGRP_SIZE ,B.CHART_ID ,B.PROC_ID ,B.MFDS_DATA_TYPE_CD ,B.MFDS_UNITS ,B.GREF_ID ,B.MFDS_INC_CD ,B.MFDS_NAME , B.MFDS_FORMULA ,B.MFDS_UAL ,B.MFDS_UAL_IND ,B.MFDS_LAL ,B.MFDS_LAL_IND ,B.QS_RESULTS_RTN ,D.CHART_C1_LABEL ,D.CHART_C2_LABEL FROM PS_QS_STREAM8 A , PS_QS_MFDS_MST B , PS_QS_CL_CHART D WHERE A.MFDS_ID = B.MFDS_ID AND A.MFDS_COLLECT_SW = 'Y' AND D.CHART_ID=B.CHART_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 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 4 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 5 | MFDS_SEQ | Number(3,0) | SMALLINT NOT NULL | If in table QS_STREAM8: Sort order of streams with a common stream root id (used in data entry). |
| 6 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 7 | CLIM_STS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Status of Control Limit Calculations
ASGN=Assigned MON=Monitor NONE=None ONG=OnGoing PRE=Preliminary RCLC=ReCalc RSET=Reset |
| 8 | STR_SGRP_CNT | Number(7,0) | INTEGER NOT NULL | SubGroup Count |
| 9 | STR_SGRP_SEQ | Number(7,0) | INTEGER NOT NULL | SubGroup Sequence |
| 10 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 11 | CUR_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | At the point of analysis, it is the subgroup size for a variable subgroup (data types of Defects or Defectives have variable subgroups sizes). |
| 12 | CUR_SPEC_VIO_CNT | Number(2,0) | SMALLINT NOT NULL | Violation Count |
| 13 | CUR_PLOT_VALUE1 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Plot 1 |
| 14 | CUR_PLOT_VALUE2 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Plot 2 |
| 15 | RUN_MOMENT | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Run Moment |
| 16 | TSWIN_BUFFER1 | Character(50) | VARCHAR2(50) NOT NULL | Buffer 1 |
| 17 | TSWIN_BUFFER2 | Character(50) | VARCHAR2(50) NOT NULL | Buffer 2 |
| 18 | SPEC_ID | Number(7,0) | INTEGER NOT NULL | Specification |
| 19 | SPEC_LSL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower |
| 20 | SPEC_LSL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 21 | SPEC_USL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper |
| 22 | SPEC_USL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 23 | SPEC_FACTOR1 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 1 |
| 24 | SPEC_FACTOR1_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 25 | SPEC_FACTOR2 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 2 |
| 26 | SPEC_FACTOR2_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 27 | MFDS_COLLECT_SW | Character(1) | VARCHAR2(1) NOT NULL | Active |
| 28 | MFDS_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | Subgroup Size |
| 29 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 30 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 31 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 32 | MFDS_UNITS | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 33 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |
| 34 | MFDS_INC_CD | Character(4) | VARCHAR2(4) NOT NULL |
Incomplete Subgroup
AVG=Average DONT=Do Not Accept |
| 35 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 36 | MFDS_FORMULA | Character(254) | VARCHAR2(254) NOT NULL | Formula |
| 37 | MFDS_UAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper Acceptance Limit |
| 38 | MFDS_UAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 39 | MFDS_LAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower Acceptance Limit |
| 40 | MFDS_LAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 41 | QS_RESULTS_RTN | Character(1) | VARCHAR2(1) NOT NULL |
Return Results (Integration)
N=Char doesn't return results Y=Char returns results |
| 42 | CHART_C1_LABEL | Character(12) | VARCHAR2(12) NOT NULL | Object used for Charts |
| 43 | CHART_C2_LABEL | Character(12) | VARCHAR2(12) NOT NULL | Object used for Charts |