GPAU_PSM_AC_TAO (SQL Table)	Index Back
PSM Create - Accumulator Temp PSM Creation - Temporary Table to hold Accumulators

GPAU_PSM_AC_TAO

(SQL Table)

PSM Create - Accumulator Temp

PSM Creation - Temporary Table to hold Accumulators

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

4 SOVR_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Supporting Element Character Value

5 GPAU_SRC_PIN_NUM Number(8,0) INTEGER NOT NULL This field stores Pin Number for the TER FM DUR START used in EOY processing

#	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)
4	SOVR_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Supporting Element Character Value
5	GPAU_SRC_PIN_NUM	Number(8,0)	INTEGER NOT NULL	This field stores Pin Number for the TER FM DUR START used in EOY processing