PTIASPMAXSTEPVW

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_PTIACPTMPLTSTEP 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 Field Type Column Type Description
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package Name
PTIACPCHPTRID Character(10) VARCHAR2(10) NOT NULL Chapter ID
PTIACPTASKID Character(10) VARCHAR2(10) NOT NULL Task ID
PTIACPSTEPID Character(10) VARCHAR2(10) NOT NULL Step ID
PTIACPSTEPRANK Number(5,0) INTEGER NOT NULL Step Version
PTIASPRPTFIXDT DateTime(26) TIMESTAMP Date this Bug was Fixed
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19