GPDE_LN_RSL_HST (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_RSL_HST

(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 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

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

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

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

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

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

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

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

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

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

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

15 PRD_END_DT Date(10) DATE Pay Period End Date

16 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date

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

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

19 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

20 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

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

22 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
11	GPDE_LN_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
12	GPDE_LN_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
15	PRD_END_DT	Date(10)	DATE	Pay Period End Date
16	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
17	GPDE_LN_DED_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Loan repayment deduction amount
18	GPDE_LN_DED_AMTINT	Number(9,2)	DECIMAL(8,2) NOT NULL	Loan interest deduction amount
19	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
20	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
21	GPDE_LN_REM_BAL_PY	Number(11,2)	DECIMAL(10,2) NOT NULL	Loans - Remaining Balance
22	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