QS_XFER_STRM_VW(SQL View) |
Index Back |
|---|
| SELECT STR.BUSINESS_UNIT ,STR.QS_APP_CONTEXT ,STR.STREAM_ROOT_ID ,STR.STREAM_ID ,STR.MFDS_ID ,MFDS.MFDS_DATA_TYPE_CD ,STR.MFDS_SEQ ,STR.CUR_SGRP_SIZE ,STR.CLIM_ID ,STR.SPEC_ID ,STR.MFDS_COLLECT_SW FROM PS_QS_STREAM8 STR , PS_QS_MFDS_MST MFDS WHERE STR.MFDS_ID = MFDS.MFDS_ID AND STR.MFDS_COLLECT_SW = 'Y' |
| # | 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_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 6 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 7 | 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). |
| 8 | 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). |
| 9 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 10 | SPEC_ID | Number(7,0) | INTEGER NOT NULL | Specification |
| 11 | MFDS_COLLECT_SW | Character(1) | VARCHAR2(1) NOT NULL | Active |