QS_ALL_SGRP_VW

(SQL View)
 Index Back

V8 View of all Subgroups


SELECT A.BUSINESS_UNIT , A.SESSN_ID , A.STREAM_ID , A.SESSN_STREAM_SEQ , A.SESSN_SGRP_SEQ , A.SESSN_STRM_STS , A.QS_SUBGROUP_STATUS , A.SESSN_SGRP_SIZE , A.SESSN_SUBMIT_DTTM , A.MFDS_DATA_TYPE_CD , A.CLIM_ID , A.SPEC_ID , A.SRSLT_P1 , A.SRSLT_P1_IND , A.SRSLT_P2 , A.SRSLT_P2_IND , A.SRSLT_P3 , A.SRSLT_P3_IND , A.CLIM_STS_CD , A.SPEC_VIO_SW , A.QS_ALARM_CNT , A.QS_ACTION_CNT , A.QS_CAUSE_CNT , A.QS_COMM_CNT , A.OPERATOR , A.QS_NVALUES , A.QS_VALUEREADING_1 , A.QS_VALUEREADING_2 , A.QS_VALUEREADING_3 , A.QS_VALUEREADING_4 , A.QS_VALUEREADING_5 , A.QS_VALUEREADING_6 , A.QS_VALUEREADING_7 , A.QS_VALUEREADING_8 , A.QS_VALUEREADING_9 , A.QS_VALUEREADING_10 , A.QS_VALUEREADING_11 , A.QS_VALUEREADING_12 , A.QS_VALUEREADING_13 , A.QS_VALUEREADING_14 , A.QS_VALUEREADING_15 , A.QS_VALUEREADING_16 , A.QS_VALUEREADING_17 , A.QS_VALUEREADING_18 , A.QS_VALUEREADING_19 , A.QS_VALUEREADING_20 FROM PS_QS_SUBGROUP A WHERE A.SESSN_STRM_STS = 'ANLZ' AND A.QS_SUBGROUP_STATUS >= 200

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SESSN_ID Character(30) VARCHAR2(30) NOT NULL Session ID
3 STREAM_ID Number(8,0) INTEGER NOT NULL Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
4 SESSN_STREAM_SEQ Number(6,0) INTEGER NOT NULL Stream Seq #
5 SESSN_SGRP_SEQ Number(6,0) INTEGER NOT NULL Subgroup ID
6 SESSN_STRM_STS Character(4) VARCHAR2(4) NOT NULL Session Stream Status
7 QS_SUBGROUP_STATUS Signed Number(6,0) DECIMAL(5) NOT NULL Status
8 SESSN_SGRP_SIZE Number(13,5) DECIMAL(12,5) NOT NULL Subgroup Size
9 SESSN_SUBMIT_DTTM DateTime(26) TIMESTAMP Date Submitted
10 MFDS_DATA_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Data Type
DEF=Defects
DEFS=Defectives
DFTV=Defectives
VAR=Variables
11 CLIM_ID Character(30) VARCHAR2(30) NOT NULL Object used for Contorl Limits storage,calculation, and/or display
12 SPEC_ID Number(7,0) INTEGER NOT NULL Specification
13 SRSLT_P1 Signed Number(14,5) DECIMAL(12,5) NOT NULL Chart 1 Result
14 SRSLT_P1_IND Character(1) VARCHAR2(1) NOT NULL
15 SRSLT_P2 Signed Number(14,5) DECIMAL(12,5) NOT NULL Chart 2 Result
16 SRSLT_P2_IND Character(1) VARCHAR2(1) NOT NULL
17 SRSLT_P3 Signed Number(14,5) DECIMAL(12,5) NOT NULL Point value, chart 3 (when chart 3 gets implemented)
18 SRSLT_P3_IND Character(1) VARCHAR2(1) NOT NULL
19 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
20 SPEC_VIO_SW Character(1) VARCHAR2(1) NOT NULL Spec Violation
21 QS_ALARM_CNT Signed Number(4,0) DECIMAL(3) NOT NULL # control test violations occuring for a single subgroup
22 QS_ACTION_CNT Number(3,0) SMALLINT NOT NULL Corrective Actions
23 QS_CAUSE_CNT Number(3,0) SMALLINT NOT NULL Pobable Causes
24 QS_COMM_CNT Number(2,0) SMALLINT NOT NULL Comments
25 OPERATOR Character(30) VARCHAR2(30) NOT NULL User ID
26 QS_NVALUES Number(3,0) SMALLINT NOT NULL number of values
27 QS_VALUEREADING_1 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
28 QS_VALUEREADING_2 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
29 QS_VALUEREADING_3 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
30 QS_VALUEREADING_4 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
31 QS_VALUEREADING_5 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
32 QS_VALUEREADING_6 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
33 QS_VALUEREADING_7 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
34 QS_VALUEREADING_8 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
35 QS_VALUEREADING_9 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
36 QS_VALUEREADING_10 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
37 QS_VALUEREADING_11 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
38 QS_VALUEREADING_12 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
39 QS_VALUEREADING_13 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
40 QS_VALUEREADING_14 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
41 QS_VALUEREADING_15 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
42 QS_VALUEREADING_16 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
43 QS_VALUEREADING_17 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
44 QS_VALUEREADING_18 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
45 QS_VALUEREADING_19 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value
46 QS_VALUEREADING_20 Signed Number(15,6) DECIMAL(13,6) NOT NULL Value