GPAU_REC_RETBRK (SQL Table)	Index Back
Retro details for STP Process Retro details for STP Process

GPAU_REC_RETBRK

(SQL Table)

Retro details for STP Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 GPAU_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Used for capturing the REG/FRN category for STP

3 GPAU_RETRO_TYPE Character(4) VARCHAR2(4) NOT NULL Used for capturing the retro type for STP Processing

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)

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

6 COUNT_RESULT Character(6) VARCHAR2(6) NOT NULL Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPAU_EMPL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Used for capturing the REG/FRN category for STP
3	GPAU_RETRO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Used for capturing the retro type for STP Processing
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)
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
6	COUNT_RESULT	Character(6)	VARCHAR2(6) NOT NULL	Count