UPG_SQL_RENAMES

(SQL Table)
Index Back

Upgrade SQL Renames

Contains 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