QS_API_STR83_VW(SQL View) |
Index Back |
|---|---|
Stream Definition API viewSecond API view, stream info for subgroups to be analyzed, used by the message that retrieves all streams referenced in a particular session. Used in ongoing analysis (rather than analysis startup). This selects by a particular API session identifier (API_SESSION_GRP, NODE, API_SESSN_ID). The key structure is the only difference between this an QS_API_STRM8_VW - these should be kept in sync. |
| SELECT ST.BUSINESS_UNIT , ST.STREAM_ROOT_ID , ST.STREAM_ID , ST.MFDS_ID , ST.CLIM_STS_CD , ST.STR_SGRP_CNT , ST.STR_SGRP_SEQ , ST.CLIM_ID , ST.CUR_SGRP_SIZE , ST.CUR_SPEC_VIO_CNT , ST.CUR_PLOT_VALUE1 , ST.CUR_PLOT_VALUE2 , ST.RUN_MOMENT , ST.TSWIN_BUFFER1 , ST.TSWIN_BUFFER2 , MF.MFDS_SGRP_SIZE , MF.CHART_ID , MF.PROC_ID , ST.SPEC_ID , ST.SPEC_LSL , ST.SPEC_LSL_IND , ST.SPEC_USL , ST.SPEC_USL_IND , MF.MFDS_LAL , MF.MFDS_LAL_IND , MF.MFDS_UAL , MF.MFDS_UAL_IND , ST.SPEC_FACTOR1 , ST.SPEC_FACTOR1_IND , ST.SPEC_FACTOR2 , ST.SPEC_FACTOR2_IND , ST.MFDS_COLLECT_SW , CL.CLIM_UPPER_X , CL.CLIM_UX_IND , CL.CLIM_MEAN_X , CL.CLIM_MX_IND , CL.CLIM_LOWER_X , CL.CLIM_LX_IND , CL.CLIM_UPPER_MRANGE , CL.CLIM_UMRANGE_IND , CL.CLIM_MEAN_RANGE , CL.CLIM_MRANGE_IND , CL.CLIM_LOWER_MRANGE , CL.CLIM_LMRANGE_IND , MF.MFDS_DATA_TYPE_CD , MF.MFDS_FORMULA , MF.MFDS_NAME , MF.MFDS_INC_CD FROM PS_QS_STREAM8 ST , PS_QS_CNTL_LIM_HIS CL , PS_QS_MFDS_MST MF WHERE ST.MFDS_ID = MF.MFDS_ID AND ST.CLIM_ID = CL.CLIM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 3 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 4 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 5 | 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 Default Value: NONE |
| 6 | STR_SGRP_CNT | Number(7,0) | INTEGER NOT NULL | SubGroup Count |
| 7 | STR_SGRP_SEQ | Number(7,0) | INTEGER NOT NULL | SubGroup Sequence |
| 8 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 9 | 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). |
| 10 | CUR_SPEC_VIO_CNT | Number(2,0) | SMALLINT NOT NULL | Violation Count |
| 11 | CUR_PLOT_VALUE1 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Plot 1 |
| 12 | CUR_PLOT_VALUE2 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Plot 2 |
| 13 | RUN_MOMENT | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Run Moment |
| 14 | TSWIN_BUFFER1 | Character(50) | VARCHAR2(50) NOT NULL | Buffer 1 |
| 15 | TSWIN_BUFFER2 | Character(50) | VARCHAR2(50) NOT NULL | Buffer 2 |
| 16 | MFDS_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL |
Subgroup Size
Default Value: 0 |
| 17 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 18 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 19 | SPEC_ID | Number(7,0) | INTEGER NOT NULL | Specification |
| 20 | SPEC_LSL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower |
| 21 | SPEC_LSL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified Default Value: N |
| 22 | SPEC_USL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper |
| 23 | SPEC_USL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified Default Value: N |
| 24 | MFDS_LAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower Acceptance Limit |
| 25 | MFDS_LAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified Default Value: N |
| 26 | MFDS_UAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper Acceptance Limit |
| 27 | MFDS_UAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified Default Value: N |
| 28 | SPEC_FACTOR1 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 1 |
| 29 | SPEC_FACTOR1_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified Default Value: N |
| 30 | SPEC_FACTOR2 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 2 |
| 31 | SPEC_FACTOR2_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified Default Value: N |
| 32 | MFDS_COLLECT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Active
Default Value: Y |
| 33 | CLIM_UPPER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 34 | CLIM_UX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined |
| 35 | CLIM_MEAN_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 36 | CLIM_MX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display--indicates if value is a zero or null
N=Null S=System Assigned U=User Defined |
| 37 | CLIM_LOWER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 38 | CLIM_LX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display. Indicates whether value is zero or null
N=Null S=System Assigned U=User Defined |
| 39 | CLIM_UPPER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 40 | CLIM_UMRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined |
| 41 | CLIM_MEAN_RANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 42 | CLIM_MRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display. Indicates if the value is a zero or a null
N=Null S=System Assigned U=User Defined |
| 43 | CLIM_LOWER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 44 | CLIM_LMRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined |
| 45 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 46 | MFDS_FORMULA | Character(254) | VARCHAR2(254) NOT NULL | Formula |
| 47 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 48 | MFDS_INC_CD | Character(4) | VARCHAR2(4) NOT NULL |
Incomplete Subgroup
AVG=Average DONT=Do Not Accept |