GPES_PP_DATA_VW

(SQL View)
 Index Back

Pension Plan Data

Allow to bring the data in array PP_AR_CONTRIB.

SELECT A.EMPLID , A.EMPL_RCD , A.GPES_PP_ID , A.EFFDT , B.DESCR ,B.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 FROM PS_GPES_PP_CONTRIB A , PS_GPES_PP_DEFN B WHERE A.GPES_PP_ID=B.GPES_PP_ID AND B.STATUS = 'A'

# 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 Rcd Nbr
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.