PTIASPPKGGUIDC=Complete
I=Incomplete
R=Package Created
Default Value: I
N=No
Y=Yes
DLT=Object Delta Package
PUM=Update
RFU=Required For Upgrade
TDP=Translations Delta Package
UPG=Application Upgrade
PTIASPPKGS(SQL Table) |
Index Back |
|---|---|
Change Packageschange packages created for a specific target database |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPPKGNAME | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 2 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 3 | PTIASPPKGGUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 4 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 5 | 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. |
| 6 | PTIASPPKGSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Package Status
C=Complete I=Incomplete R=Package Created Default Value: I |
| 7 | PTIASPPKGMGRTSTAT | Character(1) | VARCHAR2(1) NOT NULL |
Migrated
N=No Y=Yes |
| 8 | PTIASPPKGDESC | Character(254) | VARCHAR2(254) NOT NULL | Package Description |
| 9 | PTIAPKGCREATEDTTM | DateTime(26) | TIMESTAMP | Package Create Date |
| 10 | PTIASPPKGID | Character(25) | VARCHAR2(25) NOT NULL | Package Name |
| 11 | 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 |
| 12 | PTIASPSPVERS | Number(5,0) | INTEGER NOT NULL | Numeric value for Patch Database Version Number |