GPAU_FRN_AM_TAO

(SQL Table)
Index Back

FRN Create - Amount Temp tbl

FRN Creation - Temporary table to hold Pay Amounts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
4 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.
5 SOVR_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Supporting Element Character Value
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
7 GPAU_PSM_GROSS_PAY Signed Number(17,2) DECIMAL(15,2) NOT NULL Gross Pay - End of Year Processing