PROCESS_INSTANCE751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
UPG_SPRO1_AET(SQL Table) |
Index Back |
|---|---|
sPro Upg StateRcd-One Time UseThis sPro upgrade state record is intended for storing static parameters that are loaded only once and the value will be retained for the duration of the upgrade process. This record will be loaded at the begining of the process. DO NOT perform a %SelectInit to this record in subsequent steps of the Upgrade AE. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SP | Character(1) | VARCHAR2(1) NOT NULL | Services Procurement |
| 3 | PO | Character(1) | VARCHAR2(1) NOT NULL | Purchasing |
| 4 | PC | Character(1) | VARCHAR2(1) NOT NULL | Projects |
| 5 | UPG_RELEASE | Character(4) | VARCHAR2(4) NOT NULL |
Upgrade Application Release
751=7.51 Release 752=7.52 Release 753=7.53 Release 801=8 SP1 Release 803=8 SP3 Release 840=8.40 Release 841=8.40 SP1 880=8.80 Release |
| 6 | DAYS_UOM | Character(3) | VARCHAR2(3) NOT NULL | the unit of measure for days |
| 7 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 8 | USE_PAY_TYPES | Character(1) | VARCHAR2(1) NOT NULL | Use Pay Types (Installation & BU) |
| 9 | UPG_DSTLST_ID1 | Character(18) | VARCHAR2(18) NOT NULL | Upgrade options prompt for Distribution List for Requester Role |
| 10 | UPG_DSTLST_ID2 | Character(18) | VARCHAR2(18) NOT NULL | Upgrade options prompt for Distribution List for Time Approver |
| 11 | UPG_DSTLST_ID3 | Character(18) | VARCHAR2(18) NOT NULL | Upgrade options prompt for Distribution List for Invoice Approver |
| 12 | UPG_DSTLST_DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Upgrade options prompt for Distribution List Description for Requester Role |
| 13 | UPG_DSTLST_DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Upgrade options prompt for Distribution List Description for Invoice Approver Role |
| 14 | UPG_DSTLST_DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Upgrade options prompt for Distribution List Description for Time Approver Role |
| 15 | UPG_ALRT_MSG1 | Character(24) | VARCHAR2(24) NOT NULL | Used by Upgrade to store Work Order Alert message text for conversion. |
| 16 | UPG_ALRT_MSG2 | Character(24) | VARCHAR2(24) NOT NULL | Used by Upgrade to store Work Order Alert message text for conversion. |