PTIASPPKGDOCVW

index back

Template Doc View

This view is used for CA Template doc generation
SELECT A.PTIASPPKGGUID ,A.PTIACPCHPTRID ,A.PTIACPTASKID ,A.PTIACPSTEPID ,A.PTIASPPKGCHPTR ,A.PTIASPPKGTASK ,A.PTIASPPKGSTEP ,A.PTIACPNOTEID ,B.PTIACPNOTETEXT FROM ( SELECT DISTINCT A.PTIASPPKGGUID ,A.PTIACPCHPTRID ,' ' AS PTIACPTASKID ,' ' AS PTIACPSTEPID ,A.PTIASPPKGCHPTR ,' ' AS PTIASPPKGTASK ,' ' AS PTIASPPKGSTEP ,B.PTIACPNOTEID FROM PS_PTIASPPKGSTRH A , PS_PTIACPCHPTR B WHERE 1=1 AND A.PTIACPCHPTRID = B.PTIACPCHPTRID UNION ALL SELECT DISTINCT A.PTIASPPKGGUID ,A.PTIACPCHPTRID ,A.PTIACPTASKID ,' ' AS PTIACPSTEPID ,A.PTIASPPKGCHPTR ,A.PTIASPPKGTASK ,' ' AS PTIASPPKGSTEP ,B.PTIACPNOTEID FROM PS_PTIASPPKGSTRH A , PS_PTIACPTASK B WHERE 1=1 AND A.PTIACPTASKID = B.PTIACPTASKID UNION ALL SELECT DISTINCT A.PTIASPPKGGUID ,A.PTIACPCHPTRID ,A.PTIACPTASKID ,A.PTIACPSTEPID ,A.PTIASPPKGCHPTR ,A.PTIASPPKGTASK ,A.PTIASPPKGSTEP ,B.PTIACPNOTEID FROM PS_PTIASPPKGSTRH A , PS_PTIACPSTEP B WHERE 1=1 AND A.PTIACPSTEPID = B.PTIACPSTEPID AND A.PTIACPSTEPRANK = B.PTIACPSTEPRANK ) A, PS_PTIACPNOTETEXT B WHERE 1=1 AND A.PTIACPNOTEID = B.PTIACPNOTEID

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPPKGGUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
PTIACPCHPTRIDCharacter(10)VARCHAR2(10) NOT NULLChapter ID
PTIACPTASKIDCharacter(10)VARCHAR2(10) NOT NULLTask ID
PTIACPSTEPIDCharacter(10)VARCHAR2(10) NOT NULLStep ID
PTIASPPKGCHPTRCharacter(50)VARCHAR2(50) NOT NULLChapter
PTIASPPKGTASKCharacter(50)VARCHAR2(50) NOT NULLTask
PTIASPPKGSTEPCharacter(50)VARCHAR2(50) NOT NULLStep
PTIACPNOTEIDCharacter(36)VARCHAR2(36) NOT NULLNote
PTIACPNOTETEXTLong CharacterCLOBNote Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19