PTIAAUCRTCP_VW

(SQL View)
Index Back

SELECT PTIASPPKGNAME , PTIASPPKGTYPE , DBNAME FROM PS_PTIASPPKGS WHERE (PTIASPPKGSTATUS = 'C' OR PTIASPPKGSTATUS = 'R') AND PTIASPPKGMGRTSTAT <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package Name
2 PTIASPPKGTYPE Character(4) VARCHAR2(4) NOT NULL Package Type
DLT=Object Delta Package
PUM=Update
RFU=Required For Upgrade
TDP=Translations Delta Package
UPG=Application Upgrade
3 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name