UPG_SQL_RENAMES(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
Default Value: 00 |
3 | UPG_ORIG_TBLNAME | Character(18) | VARCHAR2(18) NOT NULL | Original Record Name |
4 | UPG_NEW_TBLNAME | Character(18) | VARCHAR2(18) NOT NULL | Original Record Name |
5 | UPG_PLAT_DB2 | Character(1) | VARCHAR2(1) NOT NULL |
DB2 z/OS
Y/N Table Edit |
6 | UPG_PLAT_DBX | Character(1) | VARCHAR2(1) NOT NULL |
DB2 UNIX
Y/N Table Edit |
7 | UPG_PLAT_IFX | Character(1) | VARCHAR2(1) NOT NULL |
Informix
Y/N Table Edit |
8 | UPG_PLAT_MSS | Character(1) | VARCHAR2(1) NOT NULL |
Microsoft SQL Sever
Y/N Table Edit |
9 | UPG_PLAT_ORA | Character(1) | VARCHAR2(1) NOT NULL |
Oracle
Y/N Table Edit |
10 | UPG_PLAT_SYB | Character(1) | VARCHAR2(1) NOT NULL |
Sybase
Y/N Table Edit |