PTIASPEDITPKGVW

index back

Change Package View for Edit

This view is used as prompt table for package name. It filters out the packages that have been crated in Change Assistant.
SELECT DBNAME , USERID , PTIASPPKGID , PTIASPSEARCHSCOPED , PTIASPPKGSTATUSD , MIN(LASTUPDDTTM ) , PTIASPPKGDESC FROM( SELECT PKG.DBNAME , PKG.USERID , PKG.PTIASPPKGID , NVL(CODE1.DESCR254 , OPT.PTIASPSEARCHSCOPE) AS PTIASPSEARCHSCOPED , NVL(CODE2.DESCR254 , PKG.PTIASPPKGSTATUS) AS PTIASPPKGSTATUSD , PKG.LASTUPDDTTM , PKG.PTIASPPKGDESC FROM PS_PTIASPPKGS PKG LEFT OUTER JOIN PS_PTIASPCHARCODES CODE2 ON PKG.PTIASPPKGSTATUS=CODE2.PTIASPCHARVALUE AND CODE2.PTIASPLOOKUPCODE='SPPKGSTATUS' , PS_PTIASPPKGOPTS OPT LEFT OUTER JOIN PS_PTIASPCHARCODES CODE1 ON OPT.PTIASPSEARCHSCOPE=CODE1.PTIASPCHARVALUE AND CODE1.PTIASPLOOKUPCODE='SPSEARCHSCOPE' WHERE PKG.PTIASPPKGGUID=OPT.PTIASPPKGGUID) GROUP BY DBNAME , USERID , PTIASPPKGID , PTIASPSEARCHSCOPED , PTIASPPKGSTATUSD , PTIASPPKGDESC

PeopleSoft Field Name Field Type Column Type Description
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PTIASPPKGID Character(25) VARCHAR2(25) NOT NULL Package Name
PTIASPSEARCHSCOPED Character(64) VARCHAR2(64) NOT NULL Search Scope for Selective Patching
PTIASPPKGSTATUSD Character(64) VARCHAR2(64) NOT NULL Package Status
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
PTIASPPKGDESC Character(254) VARCHAR2(254) NOT NULL Package Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20