QS_STREAM8(SQL Table) |
Index Back |
|---|---|
Stream Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUQS_NONVW |
| 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_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). |
| 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 Default Value: NONE |
| 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
Y/N Table Edit |
| 28 | QS_LOCK_CASCADE | Character(1) | VARCHAR2(1) NOT NULL |
No changes from Meas Plan
Default Value: N |