PTIASPPKGS

index back

Change Packages

change packages created for a specific target database

PeopleSoft Field Name Field Type Column Type Description
PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package Name
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
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.
PTIASPPKGSTATUS Character(1) VARCHAR2(1) NOT NULL Package Status
C=Complete
I=Incomplete
R=Package Created

Default: I

PTIASPPKGMGRTSTAT Character(1) VARCHAR2(1) NOT NULL Migrated
N=No
Y=Yes
PTIASPPKGDESC Character(254) VARCHAR2(254) NOT NULL Package Description
PTIAPKGCREATEDTTM DateTime(26) TIMESTAMP Package Create Date
PTIASPPKGID Character(25) VARCHAR2(25) 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
PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20