GP_PKG_TMP (SQL Table)	Index Back
Temporary TBL for PKG Upgrade Temporary TBL for PKG Upgrade

GP_PKG_TMP

(SQL Table)

Temporary TBL for PKG Upgrade

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

2 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)

3 PIN_OWNER Character(1) VARCHAR2(1) NOT NULL Element Owner
C=Customer Maintained
M=PS Delivered/Customer Modified
N=PS Delivered / Not Maintained
P=PS Delivered / Maintained
S=PS Delivered/Maintained/Secure

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	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)
3	PIN_OWNER	Character(1)	VARCHAR2(1) NOT NULL	Element Owner C=Customer Maintained M=PS Delivered/Customer Modified N=PS Delivered / Not Maintained P=PS Delivered / Maintained S=PS Delivered/Maintained/Secure