PTIASPPKGNAMEPTIASPPKGGUIDDLT=Object Delta Package
PUM=Update
RFU=Required For Upgrade
TDP=Translations Delta Package
UPG=Application Upgrade
PTIAMMCPKGAPPDT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPPKGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 2 | PTIASPPKGGUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 3 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 4 | PTIASPPKGAPPLYDTTM | DateTime(26) | TIMESTAMP | Apply Date |
| 5 | PTIASPSPVERS | Number(5,0) | INTEGER NOT NULL | Numeric value for Patch Database Version Number |
| 6 | 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 |
| 7 | PTIAMMCPKGBYCUR | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 8 | PTIAMMCPKIBYCUR | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 9 | PTIAMMCPKRBYCUR | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 10 | PTIAMMCPKGBYMAX | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |