GPES_LN_RSLT_VW

(SQL View)
 Index Back

Repayments already processed

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 advance/loan info to avoid any change. It is also use to calculate the remaining amount to be paid by the employee.

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.SEQNUM , A.GPES_YEAR , A.GPES_MONTH , A.GPES_TAKE_XTRPD , A.GPES_DED_AMT , A.CURRENCY_CD , A.RSLT_VER_NUM , A.RSLT_REV_NUM FROM PS_GPES_ADLN_RSLT A WHERE %Sql(GPES_MAX_VER_REV_NUM, PS_GP_PYE_PRC_STAT, A)

# 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
9 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
10 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
11 GPES_TAKE_XTRPD Character(1) VARCHAR2(1) NOT NULL Advance/Loan repayment at extra periods option

Y/N Table Edit

12 GPES_DED_AMT Number(11,2) DECIMAL(10,2) NOT NULL Advance/Loan repayment deduction amount
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
15 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number