QS_QSX_DATA_VW(SQL View) |
Index Back |
|---|---|
Extraction data viewThis is the view that is used to pull session data off for extractions; the data in this view is scrollselected to a panel then peoplecode pulls the data off & writes the cld/dta files. This view retrieves a row for each reading, by joining with the trace table - if a trace record is not written for each record in a subset, this view will not work correctly. |
| SELECT SG.BUSINESS_UNIT , SG.SESSN_ID , SG.STREAM_ID , TRC.SAMPLE , SG.SESSN_SUBMIT_DTTM , SG.SESSN_SGRP_SEQ , SG.SESSN_SGRP_SIZE , SG.SESSN_STRM_STS , SG.QS_SUBGROUP_STATUS , SG.QS_NVALUES , SG.QS_VALUEREADING_1 , SG.QS_VALUEREADING_2 , SG.QS_VALUEREADING_3 , SG.QS_VALUEREADING_4 , SG.QS_VALUEREADING_5 , SG.QS_VALUEREADING_6 , SG.QS_VALUEREADING_7 , SG.QS_VALUEREADING_8 , SG.QS_VALUEREADING_9 , SG.QS_VALUEREADING_10 , SG.QS_VALUEREADING_11 , SG.QS_VALUEREADING_12 , SG.QS_VALUEREADING_13 , SG.QS_VALUEREADING_14 , SG.QS_VALUEREADING_15 , SG.QS_VALUEREADING_16 , SG.QS_VALUEREADING_17 , SG.QS_VALUEREADING_18 , SG.QS_VALUEREADING_19 , SG.QS_VALUEREADING_20 , SG.CLIM_ID , SG.SPEC_ID , SG.SPEC_VIO_SW , SG.QS_ALARM_CNT , SG.QS_ACTION_CNT , SG.QS_CAUSE_CNT , SG.QS_COMM_CNT , SG.OPERATOR , STR8.MFDS_ID , str8.str_sgrp_seq , STRMRT.QS_APP_CONTEXT , STRMRT.STREAM_ROOT_ID , STRMRT.INV_ITEM_ID , STRMRT.WORK_CENTER_CODE , STRMRT.MACHINE_CODE , STRMRT.STATION_CODE , STRMRT.CUST_ID , STRMRT.VENDOR_ID , STRMRT.TASK_CODE , STRMRT.PRDN_AREA_CODE , STRMRT.CREW_CODE , STRMRT.TOOL_CODE , STRMRT.COMPL_OP_SEQ , STRMRT.PRODUCTION_TYPE , STRMRT.QC_STEP_ID , STRMRT.QS_MFDS_PLAN_ID , STRMRT.DE_SETUP_NAME , STRMRT.QS_ATTRIB_SET_ID , MFDS.MFDS_NAME , MFDS.MFDS_DATA_TYPE_CD , MFDS.CHART_ID , MFDS.PROC_ID , MFDS.MFDS_SGRP_SIZE , MFDS.MFDS_LAL , MFDS.MFDS_LAL_IND , MFDS.MFDS_UAL , MFDS.MFDS_UAL_IND , MPLAN.QS_MFDS_PLAN_NAME , TRC.BOM_CODE , TRC.COMPL_OP_SEQ , TRC.CONFIG_CODE , TRC.CONTAINER_ID , TRC.CREW_CODE , TRC.CUST_ID , TRC.DISTRIB_LINE_NUM , TRC.DISTRIB_SEQ_NUM , TRC.DT_TIMESTAMP , TRC.INV_ITEM_ID , TRC.INV_LOT_ID , TRC.LOT_ID , TRC.MACHINE_CODE , TRC.OPERATOR , TRC.OPRID , TRC.OP_SEQUENCE , TRC.PRDN_AREA_CODE , TRC.PRDN_DUE_SHIFT , TRC.PRODUCTION_ID , TRC.PRODUCTION_TYPE , TRC.QC_STEP_ID , TRC.QTY_INV_RECV , TRC.RECEIPT_DTTM , TRC.RECEIVER_ID , TRC.RECV_LN_NBR , TRC.RETURN_FR_CUST_ID , TRC.RETURN_FROM_BU , TRC.RMA_ID , TRC.RMA_LINE_NBR , TRC.RTG_CODE , TRC.SERIAL_ID , TRC.STAMP_DTTM , TRC.STATION_CODE , TRC.STORAGE_AREA , TRC.TAG_NUMBER , TRC.TASK_CODE , TRC.TOOL_CODE , TRC.VENDOR_ID , TRC.VENDOR_LOT_ID , TRC.WORK_CENTER_CODE FROM PS_QS_SESSN_TRACE8 TRC , PS_QS_SUBGROUP SG , PS_QS_STREAM8 STR8 , PS_QS_STREAM_ROOT STRMRT , PS_QS_MFDS_MST MFDS , PS_QS_MFDS_PLAN MPLAN WHERE TRC.SESSN_ID = SG.SESSN_ID AND STR8.STREAM_ID = SG.STREAM_ID AND STRMRT.STREAM_ROOT_ID = STR8.STREAM_ROOT_ID AND MFDS.MFDS_ID = STR8.MFDS_ID AND MPLAN.QS_MFDS_PLAN_ID = STRMRT.QS_MFDS_PLAN_ID |
| # | 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 | SAMPLE |
Number(4,0) | SMALLINT NOT NULL | Sample |
| 5 | SESSN_SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Date Submitted |
| 6 | SESSN_SGRP_SEQ | Number(6,0) | INTEGER NOT NULL | Subgroup ID |
| 7 | SESSN_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | Subgroup Size |
| 8 | SESSN_STRM_STS | Character(4) | VARCHAR2(4) NOT NULL | Session Stream Status |
| 9 | QS_SUBGROUP_STATUS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Status |
| 10 | QS_NVALUES | Number(3,0) | SMALLINT NOT NULL | number of values |
| 11 | QS_VALUEREADING_1 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 12 | QS_VALUEREADING_2 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 13 | QS_VALUEREADING_3 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 14 | QS_VALUEREADING_4 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 15 | QS_VALUEREADING_5 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 16 | QS_VALUEREADING_6 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 17 | QS_VALUEREADING_7 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 18 | QS_VALUEREADING_8 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 19 | QS_VALUEREADING_9 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 20 | QS_VALUEREADING_10 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 21 | QS_VALUEREADING_11 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 22 | QS_VALUEREADING_12 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 23 | QS_VALUEREADING_13 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 24 | QS_VALUEREADING_14 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 25 | QS_VALUEREADING_15 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 26 | QS_VALUEREADING_16 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 27 | QS_VALUEREADING_17 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 28 | QS_VALUEREADING_18 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 29 | QS_VALUEREADING_19 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 30 | QS_VALUEREADING_20 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
| 31 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 32 | SPEC_ID | Number(7,0) | INTEGER NOT NULL | Specification |
| 33 | SPEC_VIO_SW | Character(1) | VARCHAR2(1) NOT NULL | Spec Violation |
| 34 | QS_ALARM_CNT | Signed Number(4,0) | DECIMAL(3) NOT NULL | # control test violations occuring for a single subgroup |
| 35 | QS_ACTION_CNT | Number(3,0) | SMALLINT NOT NULL | Corrective Actions |
| 36 | QS_CAUSE_CNT | Number(3,0) | SMALLINT NOT NULL | Pobable Causes |
| 37 | QS_COMM_CNT | Number(2,0) | SMALLINT NOT NULL | Comments |
| 38 | OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 39 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 40 | STR_SGRP_SEQ | Number(7,0) | INTEGER NOT NULL | SubGroup Sequence |
| 41 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 42 | STREAM_ROOT_ID |
Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 43 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 44 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 45 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 46 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 47 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 48 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 49 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 50 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 51 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 52 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 53 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
| 54 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 55 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 56 | QS_MFDS_PLAN_ID | Number(8,0) | INTEGER NOT NULL | ADDED label field name for display purposes |
| 57 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |
| 58 | QS_ATTRIB_SET_ID | Number(5,0) | INTEGER NOT NULL | Attribute set ident |
| 59 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 60 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 61 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 62 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 63 | MFDS_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | Subgroup Size |
| 64 | MFDS_LAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower Acceptance Limit |
| 65 | MFDS_LAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 66 | MFDS_UAL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper Acceptance Limit |
| 67 | MFDS_UAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 68 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |
| 69 | BOM_CODE_TR | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 70 | COMPL_OP_SEQ_TR | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
| 71 | CONFIG_CODE_TR | Character(50) | VARCHAR2(50) NOT NULL | Configuration Code |
| 72 | CONTAINER_ID_TR | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 73 | CREW_CODE_TR | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 74 | CUST_ID_TR | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 75 | DISTRIB_LINE_NUMTR | Number(5,0) | INTEGER NOT NULL | Distribution Line Number |
| 76 | DISTRIB_SEQ_NUM_TR | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
| 77 | DT_TIMESTAMP_TR | DateTime(26) | TIMESTAMP | Date Timestamp |
| 78 | INV_ITEM_ID_TR | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 79 | INV_LOT_ID_TR | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 80 | LOT_ID_TR | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 81 | MACHINE_CODE_TR | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 82 | OPERATOR_TR | Character(30) | VARCHAR2(30) NOT NULL | Operator ID |
| 83 | OPRID_TR | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 84 | OP_SEQUENCE_TR | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 85 | PRDN_AREA_CODE_TR | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 86 | PRDN_DUE_SHIFT_TR | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 87 | PRODUCTION_ID_TR | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 88 | PRODUCTION_TYPE_TR | Character(2) | VARCHAR2(2) NOT NULL |
Production Type
PR=Production RW=Rework SV=Service TD=Teardown |
| 89 | QC_STEP_ID_TR | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 90 | QTY_INV_RECV_TR | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Received |
| 91 | RECEIPT_DTTM_TR | DateTime(26) | TIMESTAMP | Receipt Datetime |
| 92 | RECEIVER_ID_TR | Character(10) | VARCHAR2(10) NOT NULL | Receiver ID Number |
| 93 | RECV_LN_NBR_TR | Number(5,0) | INTEGER NOT NULL | Receiver Line Number |
| 94 | RETURN_FR_CUST_ITR | Character(15) | VARCHAR2(15) NOT NULL | Return From Cust ID |
| 95 | RETURN_FROM_BU_TR | Character(5) | VARCHAR2(5) NOT NULL | Return From Location |
| 96 | RMA_ID_TR | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 97 | RMA_LINE_NBR_TR | Number(5,0) | INTEGER NOT NULL | RMA Line Number |
| 98 | RTG_CODE_TR | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 99 | SERIAL_ID_TR | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 100 | STAMP_DTTM_TR | DateTime(26) | TIMESTAMP | Date Stamp |
| 101 | STATION_CODE_TR | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 102 | STORAGE_AREA_TR | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 103 | TAG_NUMBER_TR | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 104 | TASK_CODE_TR | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 105 | TOOL_CODE_TR | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 106 | VENDOR_ID_TR | Character(10) | VARCHAR2(10) NOT NULL | Supplier ID |
| 107 | VENDOR_LOT_ID_TR | Character(15) | VARCHAR2(15) NOT NULL | Supplier Lot |
| 108 | WORK_CENTER_CODETR | Character(10) | VARCHAR2(10) NOT NULL | Work Center |