GPDE_LN_RSLT (SQL Table)	Index Back
Repayments processing results Each time a repayment has been deducted in a payroll run a new row is inserted here during the processing. This is used to identify deducted repayments and thus gray out the oan info to avoid any change. It is also use to calculate the remaining amount to be paid by the employee it also determines whether the active flag will be set or not..

GPDE_LN_RSLT

(SQL Table)

Repayments processing results

Each time a repayment has been deducted in a payroll run a new row is inserted here during the processing. This is used to identify deducted repayments and thus gray out the oan info to avoid any change. It is also use to calculate the remaining amount to be paid by the employee it also determines whether the active flag will be set or not..

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

8 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

9 GPDE_LN_YEAR Number(4,0) SMALLINT NOT NULL Year

10 GPDE_LN_MONTH Number(2,0) SMALLINT NOT NULL Month

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

12 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

13 PRD_END_DT Date(10) DATE Pay Period End Date

14 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date

15 GPDE_LN_DED_AMT Number(10,2) DECIMAL(9,2) NOT NULL Loan repayment deduction amount

16 GPDE_LN_DED_AMTINT Number(9,2) DECIMAL(8,2) NOT NULL Loan interest deduction amount

17 GPDE_LN_TAXED_AMT Number(11,2) DECIMAL(10,2) NOT NULL used on GPDE_LN_RSLT (loan calculation result table) set the complete amount that was taxed. i.E. if a loan was waived the entire remaining balance must be taxed SI and Income

18 GPDE_LN_REM_BAL Number(11,2) DECIMAL(10,2) NOT NULL Loans Remaining Balance. Used to keep track of loan balances for reporting and/or to figure out whether income tax/si has to be/was deducted for this loan instance

19 GPDE_LN_REM_BAL_PY Number(11,2) DECIMAL(10,2) NOT NULL Loans - Remaining Balance

20 GPDE_LN_ACTIVE Character(1) VARCHAR2(1) NOT NULL yes/no, defines whether a loan is active or not active. Will be use by Payroll processing to determine whether a monthly payment has to be deducted

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
9	GPDE_LN_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
10	GPDE_LN_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
13	PRD_END_DT	Date(10)	DATE	Pay Period End Date
14	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
15	GPDE_LN_DED_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Loan repayment deduction amount
16	GPDE_LN_DED_AMTINT	Number(9,2)	DECIMAL(8,2) NOT NULL	Loan interest deduction amount
17	GPDE_LN_TAXED_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	used on GPDE_LN_RSLT (loan calculation result table) set the complete amount that was taxed. i.E. if a loan was waived the entire remaining balance must be taxed SI and Income
18	GPDE_LN_REM_BAL	Number(11,2)	DECIMAL(10,2) NOT NULL	Loans Remaining Balance. Used to keep track of loan balances for reporting and/or to figure out whether income tax/si has to be/was deducted for this loan instance
19	GPDE_LN_REM_BAL_PY	Number(11,2)	DECIMAL(10,2) NOT NULL	Loans - Remaining Balance
20	GPDE_LN_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	yes/no, defines whether a loan is active or not active. Will be use by Payroll processing to determine whether a monthly payment has to be deducted