PTIAPRPPKGCF_VW

 index back

SELECT PS_PTIASPPKGS.PTIASPPKGNAME , PS_PTIASPPKGS.PTIASPPKGTYPE , PS_PTIAPRPCNFLCTBS.PTIASPPKGCNFRSV , PS_PTIAPRPCNFLCTBS.PTIASPPKGINIBUGCNT , TO_CHAR(PS_PTIAPRPCNFLCTBS.PTIASPPKGRSVBUGCNT) , PS_PTIASPPKGS.LASTUPDDTTM , PS_PTIASPPKGS.USERID FROM PS_PTIAPRPCNFLCTBS , PS_PTIASPPKGS WHERE PS_PTIAPRPCNFLCTBS.PTIASPPKGNAME=PS_PTIASPPKGS.PTIASPPKGNAME

PeopleSoft Field Name Field Type Column Type Description
PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package Name
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
PTIASPPKGCNFRSV Character(1) VARCHAR2(1) NOT NULL Conflict Resolved
E=Error
N=No
P=Processing
Y=Yes
PTIASPPKGINIBUGCNT Signed Number(9,0) DECIMAL(8) NOT NULL Initial Bug Count
PTIASPRSVBUGCNTDES Character(32) VARCHAR2(32) NOT NULL Resolved Bug Count
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.
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20