PTIACPTMPLSTPVW

(SQL View)
 Index Back

SELECT PTIACPTMPLT , PTIACPCHPTRID , PTIACPTASKID , PTIACPSTEPID , PTIACPSTEPRANK , PTIACPSTEP , PTIACPSTEPSCRPT , PTIACPSTEPFILEN , PTIACPSTEPFILET , PTIACPSTEPTYPE , PTIACPSTEPSEQ , PTIACPNOTEID , PTIACPTMPLTDTTM FROM ( SELECT TMP.PTIACPTMPLT , TMP.PTIACPCHPTRID , TMP.PTIACPTASKID , TMP.PTIACPSTEPID , TMP.PTIACPSTEPRANK , TMP.PTIACPSTEP , TMP.PTIACPSTEPSCRPT , TMP.PTIACPSTEPFILEN , TMP.PTIACPSTEPFILET , TMP.PTIACPSTEPTYPE , TMP.PTIACPSTEPSEQ , TMP.PTIACPNOTEID , TMP.PTIACPTMPLTDTTM , TMP.PTIACPTMPLSTEPTYPE AS TMPLTYPE , TMP.PTIASPTMPLTVERS AS TMPLVER , SRC.PTIASPIMAGETYPE AS IMGTYPE , SRC.PTIASPTMPLTVERS AS IMGVER FROM PS_PTIACPTMPLTSTEP TMP , PS_PTIASPSRCINFO SRC) WHERE TMPLVER = IMGVER AND ((IMGTYPE = 'E' AND BITAND(1, TMPLTYPE) = 1) OR (IMGTYPE = 'I' AND BITAND(2, TMPLTYPE) = 2) OR (IMGTYPE = 'P' AND BITAND(4, TMPLTYPE) = 4) OR(IMGTYPE = 'M' AND BITAND(8, TMPLTYPE) = 8))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIACPTMPLT Character(50) VARCHAR2(50) NOT NULL Structure Name
2 PTIACPCHPTRID Character(10) VARCHAR2(10) NOT NULL Chapter ID
3 PTIACPTASKID Character(10) VARCHAR2(10) NOT NULL Task ID
4 PTIACPSTEPID Character(10) VARCHAR2(10) NOT NULL Step ID
5 PTIACPSTEPRANK Number(5,0) INTEGER NOT NULL Step Version
6 PTIACPSTEP Character(50) VARCHAR2(50) NOT NULL Step
7 PTIACPSTEPSCRPT Character(50) VARCHAR2(50) NOT NULL Step Script
8 PTIACPSTEPFILEN Character(50) VARCHAR2(50) NOT NULL Step File Name
9 PTIACPSTEPFILET Character(30) VARCHAR2(30) NOT NULL Step File Type Code
10 PTIACPSTEPTYPE Character(50) VARCHAR2(50) NOT NULL Step Type
11 PTIACPSTEPSEQ Number(10,0) DECIMAL(10) NOT NULL Step
12 PTIACPNOTEID Character(36) VARCHAR2(36) NOT NULL Note
13 PTIACPTMPLTDTTM DateTime(26) TIMESTAMP Structure Date. If this Strucutre is based on a UOW relating to BUG, then this is the BUG fix date. The Structure Date is used for aggregation of BUG fixes