5/13/05 - INCIDENT 723893000 - Alter view so that it suppresses inactive measurement characteristics 03/03/2010 Incident 1954722000 - Modified view so that no peoplecode error occurs when stream id and measurement plan id are different

QS_DE_TMPLT_VW

(SQL View)
 Index Back

SELECT B.BUSINESS_UNIT , B.QS_APP_CONTEXT , B.STREAM_ROOT_ID , B.QS_DE_TMPLT_SAMPLE FROM PS_QS_STREAM8 A , PS_QS_DE_TMPLT B ,PS_QS_MFDS_MST C , PS_QS_STREAM_ROOT D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.QS_APP_CONTEXT = A.QS_APP_CONTEXT AND B.QS_APP_CONTEXT = C.QS_APP_CONTEXT AND C.QS_APP_CONTEXT = D.QS_APP_CONTEXT AND B.STREAM_ROOT_ID = A.STREAM_ROOT_ID AND B.STREAM_ROOT_ID = D.STREAM_ROOT_ID AND D.QS_MFDS_PLAN_ID = C.QS_MFDS_PLAN_ID AND B.QS_DE_TMPLT_SAMPLE = A.STREAM_ID AND A.MFDS_ID = C.MFDS_ID AND C.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 QS_DE_TMPLT_SAMPLE Number(8,0) INTEGER NOT NULL DE Template Sample