PTIASPMAXSTEPVW

(SQL View)
 Index Back

Max Step Versions

This view derives the maximum step versions for all steps being applied for a group of BUGS

SELECT PKG.PTIASPPKGGUID ,PKG.DBNAME ,PKG.PTIASPPKGNAME ,TMPLTSTEP.PTIACPCHPTRID ,TMPLTSTEP.PTIACPTASKID ,TMPLTSTEP.PTIACPSTEPID ,MAX(TMPLTSTEP.PTIACPSTEPRANK) ,MAX(TMPLTSTEP.PTIACPTMPLTDTTM) FROM PS_PTIASPPKGS PKG , PS_PTIASPPKGCALC CALC , PS_PTIASPRPTHEAD RPT , PS_PTIACPTMPLTDEFN TMPLT , PS_PTIACPTMPLSTPVW TMPLTSTEP WHERE 1=1 AND PKG.PTIASPPKGGUID = CALC.PTIASPPKGGUID AND CALC.PTIASPRPTNO = RPT.PTIASPRPTNO AND CALC.PTIASPRPTNOAPLD <> 'Y' AND (CALC.PTIASPTLSIMPCTFLG = ' ' OR CALC.PTIASPTLSIMPCTFLG = 'N') AND CALC.PTIASPRPTNO = TMPLT.PTIASPRPTNO AND TMPLT.PTIACPTMPLT = TMPLTSTEP.PTIACPTMPLT GROUP BY PKG.PTIASPPKGGUID, PKG.DBNAME, PKG.PTIASPPKGNAME ,TMPLTSTEP.PTIACPCHPTRID ,TMPLTSTEP.PTIACPTASKID ,TMPLTSTEP.PTIACPSTEPID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
3 PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package Name
4 PTIACPCHPTRID Character(10) VARCHAR2(10) NOT NULL Chapter ID
5 PTIACPTASKID Character(10) VARCHAR2(10) NOT NULL Task ID
6 PTIACPSTEPID Character(10) VARCHAR2(10) NOT NULL Step ID
7 PTIACPSTEPRANK Number(5,0) INTEGER NOT NULL Step Version
8 PTIASPRPTFIXDT DateTime(26) TIMESTAMP Date this Bug was Fixed