QS_MFDSSPEC_VW

(SQL View)
 Index Back

Spec limit history view

Modified View on 11/01/99. Caren Sidhu Added field mfds_collect_sw

SELECT A.BUSINESS_UNIT , A.QS_APP_CONTEXT , A.MFDS_COLLECT_SW , B.QS_MFDS_PLAN_NAME , A.MFDS_NAME , C.SPEC_ID , C.SPEC_USL , C.SPEC_USL_IND , C.SPEC_LSL , C.SPEC_LSL_IND , C.SPEC_FACTOR1 , C.SPEC_FACTOR1_IND , C.SPEC_FACTOR2 , C.SPEC_FACTOR2_IND , C.QS_ORIGIN_CD , C.QS_ORIGIN_ID , C.QS_MOD_DATE , C.QS_MOD_BY FROM PS_QS_MFDS_MST A , PS_QS_MFDS_PLAN B , PS_QS_SPECLIM_HIS C WHERE (A.MFDS_ID = C.QS_ORIGIN_ID) AND (B.QS_MFDS_PLAN_ID = A.QS_MFDS_PLAN_ID) AND (C.QS_ORIGIN_CD = 'MFDS')

# 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 MFDS_COLLECT_SW Character(1) VARCHAR2(1) NOT NULL Active
4 QS_MFDS_PLAN_NAME Character(38) VARCHAR2(38) NOT NULL Measurement plan identifier Note: replaces qc_step_id for release 8.
5 MFDS_NAME Character(30) VARCHAR2(30) NOT NULL Characteristic
6 SPEC_ID Number(7,0) INTEGER NOT NULL Specification
7 SPEC_USL Signed Number(14,5) DECIMAL(12,5) NOT NULL Upper
8 SPEC_USL_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
9 SPEC_LSL Signed Number(14,5) DECIMAL(12,5) NOT NULL Lower
10 SPEC_LSL_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
11 SPEC_FACTOR1 Signed Number(14,5) DECIMAL(12,5) NOT NULL Factor 1
12 SPEC_FACTOR1_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
13 SPEC_FACTOR2 Signed Number(14,5) DECIMAL(12,5) NOT NULL Factor 2
14 SPEC_FACTOR2_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
15 QS_ORIGIN_CD Character(4) VARCHAR2(4) NOT NULL Origination Code
16 QS_ORIGIN_ID Number(8,0) INTEGER NOT NULL Origination ID
17 QS_MOD_DATE DateTime(26) TIMESTAMP General modification date for record change tracking
18 QS_MOD_BY Character(30) VARCHAR2(30) NOT NULL Modified by "operator"