GPES_PP_RSL_VW

(SQL View)
 Index Back

Pension Plan Accumulated Rslts

Pension Plan employee contributions accumulated results

SELECT A.EMPLID , A.EMPL_RCD , A.COMPANY , A.GPES_TAX_LOCATION , A.GPES_MONTH , A.GPES_YEAR , A.GPES_FISCAL_KEY , A.GPES_FISCAL_SUBKEY , A.GPES_PP_CNTRIBUTOR , SUM(B.GPES_SALARY_INCOME) FROM PS_GPES_PP_RSLT A , PS_GPES_PP_RSLT B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.COMPANY = B.COMPANY AND A.GPES_TAX_LOCATION = B.GPES_TAX_LOCATION AND B.GPES_MONTH <= A.GPES_MONTH AND A.GPES_YEAR = B.GPES_YEAR AND A.GPES_FISCAL_KEY = B.GPES_FISCAL_KEY AND A.GPES_FISCAL_SUBKEY = B.GPES_FISCAL_SUBKEY AND A.GPES_PP_REDCTN_OPT = B.GPES_PP_REDCTN_OPT AND A.GPES_PP_CNTRIBUTOR = B.GPES_PP_CNTRIBUTOR AND %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_PP_RSLT, A) AND %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_PP_RSLT, B) GROUP BY A.EMPLID, A.EMPL_RCD, A.COMPANY, A.GPES_TAX_LOCATION, A.GPES_MONTH, A.GPES_YEAR, A.GPES_FISCAL_KEY, A.GPES_FISCAL_SUBKEY, A.GPES_PP_CNTRIBUTOR ORDER BY A.EMPLID, A.EMPL_RCD, 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 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.
5 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
6 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
7 GPES_FISCAL_KEY Character(2) VARCHAR2(2) NOT NULL Fiscal key. Used to identify the earnings.
8 GPES_FISCAL_SUBKEY Character(2) VARCHAR2(2) NOT NULL Fiscal sub-key. Used to identify the earnings.
9 GPES_PP_CNTRIBUTOR Character(1) VARCHAR2(1) NOT NULL Pension Plan Contributor
C=Company
E=Employee

Default Value: C

10 GPES_SALARY_INCOME Signed Number(17,2) DECIMAL(15,2) NOT NULL Salary Income.