PTIA_UPG_PATHPrompt Table: PTIA_UPGPATHS
UPG_PI_LEVELUPG_ORIG_RECNAMEUPG_ORIG_FIELDNAMEUPG_NEW_FIELDNAMEPrompt Table: PSDBFIELD
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
UPG_DMS_RENRF(SQL Table) |
Index Back |
|---|---|
Upgrade SQL RenamesContains SQL Table Renames (at Database Level) for Upgrades |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIA_UPG_PATH |
Character(15) | VARCHAR2(15) NOT NULL |
Definition of supported upgrade paths
Prompt Table: PTIA_UPGPATHS |
| 2 | UPG_PI_LEVEL |
Character(2) | VARCHAR2(2) NOT NULL | PUM Image Level |
| 3 | UPG_ORIG_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Original Record Name |
| 4 | UPG_ORIG_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Original Field Name |
| 5 | UPG_NEW_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
New Field Name
Prompt Table: PSDBFIELD |
| 6 | UPG_PLAT_DB2 | Character(1) | VARCHAR2(1) NOT NULL |
DB2 z/OS
Y/N Table Edit |
| 7 | UPG_PLAT_DBX | Character(1) | VARCHAR2(1) NOT NULL |
DB2 UNIX
Y/N Table Edit |
| 8 | UPG_PLAT_IFX | Character(1) | VARCHAR2(1) NOT NULL |
Informix
Y/N Table Edit |
| 9 | UPG_PLAT_MSS | Character(1) | VARCHAR2(1) NOT NULL |
Microsoft SQL Sever
Y/N Table Edit |
| 10 | UPG_PLAT_ORA | Character(1) | VARCHAR2(1) NOT NULL |
Oracle
Y/N Table Edit |
| 11 | UPG_PLAT_SYB | Character(1) | VARCHAR2(1) NOT NULL |
Sybase
Y/N Table Edit |