GPAU_FBT_AC_TAO (SQL Table)	Index Back
FBT Creation - Accumulator Tmp FBT Creation for EOY - temporary table to hold FBT Accumulator data

GPAU_FBT_AC_TAO

(SQL Table)

FBT Creation - Accumulator Tmp

FBT Creation for EOY - temporary table to hold FBT Accumulator data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	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)