PTIASPEDITPKGVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
3 PTIASPPKGID Character(25) VARCHAR2(25) NOT NULL Package Name
4 PTIASPSEARCHSCOPED Character(64) VARCHAR2(64) NOT NULL Search Scope for Selective Patching
5 PTIASPPKGSTATUSD Character(64) VARCHAR2(64) NOT NULL Package Status
6 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.
7 PTIASPPKGDESC Character(254) VARCHAR2(254) NOT NULL Package Description