UPG_RENUM_PIN (SQL Table)	Index Back
List of pins to renumber Contains the PINs that need to be renumbered during the upgrade by upgrade path.

UPG_RENUM_PIN

(SQL Table)

List of pins to renumber

Contains the PINs that need to be renumbered during the upgrade by upgrade path.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 UPG_PATH Character(4) VARCHAR2(4) NOT NULL Definition of supported upgrade paths
HC90=From 9.0
HC91=From 9.1

2 UPG_OLD_PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

3 UPG_NEW_PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

4 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	UPG_PATH	Character(4)	VARCHAR2(4) NOT NULL	Definition of supported upgrade paths HC90=From 9.0 HC91=From 9.1
2	UPG_OLD_PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	UPG_NEW_PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
4	PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)