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 Name Field Type Column Type Description
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
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
PTIASPPKGCHPTR Character(50) VARCHAR2(50) NOT NULL Chapter
PTIASPPKGTASK Character(50) VARCHAR2(50) NOT NULL Task
PTIASPPKGSTEP Character(50) VARCHAR2(50) NOT NULL Step
PTIACPNOTEID Character(36) VARCHAR2(36) NOT NULL Note
PTIACPNOTETEXT Long Character CLOB Note Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19