GPES_PP_RSLT_VW

(SQL View)
 Index Back

Pension Plan Result view

Store the Global Payroll Result for each employee

SELECT A.EMPLID ,A.GPES_TAX_LOCATION ,A.COMPANY ,A.GPES_YEAR ,A.GPES_PP_ID ,A.GPES_FISCAL_KEY ,A.GPES_FISCAL_SUBKEY ,MAX(B.FIRST_NAME) ,MAX(B.LAST_NAME) ,MAX(B.SECOND_LAST_NAME) ,SUM(A.GPES_SALARY_INCOME) FROM PS_GPES_PP_RSLT A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_PP_RSLT, A) GROUP BY A.EMPLID ,A.GPES_TAX_LOCATION ,A.COMPANY ,A.GPES_YEAR ,A.GPES_PP_ID ,A.GPES_FISCAL_KEY , A.GPES_FISCAL_SUBKEY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
5 GPES_PP_ID Character(10) VARCHAR2(10) NOT NULL Pension Plan Identifier
6 GPES_FISCAL_KEY Character(2) VARCHAR2(2) NOT NULL Fiscal key. Used to identify the earnings.
7 GPES_FISCAL_SUBKEY Character(2) VARCHAR2(2) NOT NULL Fiscal sub-key. Used to identify the earnings.

Default Value: 1

8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
11 GPES_SALARY_INCOME Signed Number(17,2) DECIMAL(15,2) NOT NULL Salary Income.