PTIASPPKGDOCVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
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 PTIASPPKGCHPTR Character(50) VARCHAR2(50) NOT NULL Chapter
6 PTIASPPKGTASK Character(50) VARCHAR2(50) NOT NULL Task
7 PTIASPPKGSTEP Character(50) VARCHAR2(50) NOT NULL Step
8 PTIACPNOTEID Character(36) VARCHAR2(36) NOT NULL Note
9 PTIACPNOTETEXT Long Character CLOB Note Text