GPES_PP_DATA_VW

(SQL View)
 Index Back

Pension Plan Data

Allow to bring the data in array PP_AR_CONTRIB.

SELECT E.EMPLID , E.EMPL_RCD , E.GPES_PP_ID , E.EFFDT , B.DESCR , E.STATUS , B.GPES_PP_TYPE , B.GPES_PP_CNTRIBUTIO , A.GPES_PP_CNTRIBUTOR , A.AMOUNT , A.CURRENCY_CD , A.GPES_JANUARY , A.GPES_FEBRUARY , A.GPES_MARCH , A.GPES_APRIL , A.GPES_MAY , A.GPES_JUNE , A.GPES_JULY , A.GPES_AUGUST , A.GPES_SEPTEMBER , A.GPES_OCTOBER , A.GPES_NOVEMBER , A.GPES_DECEMBER , A.GPES_PP_RETRIB_TYP , A.GPES_FISCAL_KEY , A.GPES_FISCAL_SUBKEY , B.GPES_PP_FUND_PRVDR , A.GPES_PP_REDCTN_OPT FROM PS_GPES_PP_CONTRIB A , PS_GPES_PP_EMP E , PS_GPES_PP_DEFN B WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.EFFDT = A.EFFDT AND E.GPES_PP_ID = A.GPES_PP_ID AND B.GPES_PP_ID = A.GPES_PP_ID AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_GPES_PP_DEFN B2 WHERE B2.GPES_PP_ID = B.GPES_PP_ID AND B2.EFFDT <= E.EFFDT)

# 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 GPES_PP_ID Character(10) VARCHAR2(10) NOT NULL Pension Plan Identifier
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

7 GPES_PP_TYPE Character(1) VARCHAR2(1) NOT NULL Collective or Individual Pension Plan
C=Collective
I=Individual

Default Value: C

8 GPES_PP_CNTRIBUTIO Character(1) VARCHAR2(1) NOT NULL Pension Plan Contribution

Y/N Table Edit

Default Value: N

9 GPES_PP_CNTRIBUTOR Character(1) VARCHAR2(1) NOT NULL Pension Plan Contributor
C=Company
E=Employee

Default Value: C

10 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

12 GPES_JANUARY Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

13 GPES_FEBRUARY Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

14 GPES_MARCH Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

15 GPES_APRIL Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

16 GPES_MAY Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

17 GPES_JUNE Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

18 GPES_JULY Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

19 GPES_AUGUST Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

20 GPES_SEPTEMBER Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

21 GPES_OCTOBER Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

22 GPES_NOVEMBER Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

23 GPES_DECEMBER Character(1) VARCHAR2(1) NOT NULL Use in GPES_PP_CONTRIB record

Y/N Table Edit

Default Value: N

24 GPES_PP_RETRIB_TYP Character(1) VARCHAR2(1) NOT NULL Type of retribution
D=Deduction
E=Earnings
K=Earnings in kind
25 GPES_FISCAL_KEY Character(2) VARCHAR2(2) NOT NULL Fiscal key. Used to identify the earnings.
26 GPES_FISCAL_SUBKEY Character(2) VARCHAR2(2) NOT NULL Fiscal sub-key. Used to identify the earnings.
27 GPES_PP_FUND_PRVDR Character(5) VARCHAR2(5) NOT NULL Pension plan provider
28 GPES_PP_REDCTN_OPT Character(1) VARCHAR2(1) NOT NULL RDL 12/22 pension plan reducion flag