GPGB_EE_PEN_VW

(SQL View)
 Index Back

Emp pension details.

View for employee pension details.

SELECT A.EMPLID ,A.EMPL_RCD ,A.GPGB_QPEN_SCHEME ,A.GPGB_PEN_SCHEME ,A.START_DATE ,A.END_DATE ,A.GPGB_OPTOUT_ST_DT ,A.GPGB_OPTOUT_END_DT FROM PS_GPGB_EE_PENSION A WHERE A.GPGB_AUTO_ENROLL = '1' AND A.END_DATE IS NOT NULL AND A.START_DATE = ( SELECT MAX(B.START_DATE) FROM PS_GPGB_EE_PENSION B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD ) AND A.STATUS='A'

  • Parent record: JOB

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 GPGB_QPEN_SCHEME Character(10) VARCHAR2(10) NOT NULL Pension Scheme for GBR
    4 GPGB_PEN_SCHEME Character(4) VARCHAR2(4) NOT NULL Pension Scheme Code
    AVC1=AVC1
    FIXA=Fixed Scheme A
    PCTB=Percentage Scheme B
    5 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    6 END_DATE Date(10) DATE End Date
    7 GPGB_OPTOUT_ST_DT Date(10) DATE GBR pension optout start date field
    8 GPGB_OPTOUT_END_DT Date(10) DATE GBR pension optout date field