GPGB_PN_EVNT_VW

(SQL View)
 Index Back

Employee Pension Details

Events table for Pension GBR

SELECT A.EMPLID ,A.EMPL_RCD ,A.PAY_ENTITY ,A.GPGB_EFF_PRC_DT ,A.SEQNO ,A.GPGB_QPEN_SCHEME ,A.GPGB_PRCRN_DATE ,A.GPGB_PRP_END_DT ,A.GPGB_PRP_START_DT ,A.CAL_RUN_ID ,A.GPGB_QEARNING ,A.GPGB_PEN_EVENT ,A.GPGB_PEN_A_STATUS ,A.GPGB_DEFERAL_DT FROM PS_GPGB_PEN_EVENTS A WHERE A.GPGB_PEN_EVENT IN ('ENROLLMENT' , 'ASSESSMENT' , 'POSTPONEMENT' , 'OPT-OUT/CEASE', 'TERMINATION', 'RE-ENROLMENT', 'OPT-OUT', 'TRANSFER') AND A.GPGB_PRCRN_DATE = ( SELECT MAX(A1.GPGB_PRCRN_DATE) FROM PS_GPGB_PEN_EVENTS A1 WHERE A1.EMPLID= A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD) AND A.SEQNO = ( SELECT MAX(A2.SEQNO) FROM PS_GPGB_PEN_EVENTS A2 WHERE A2.EMPLID= A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.GPGB_PRCRN_DATE = A.GPGB_PRCRN_DATE)

  • 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 Record
    3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    4 GPGB_EFF_PRC_DT Date(10) DATE GBR process effdt
    5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    6 GPGB_QPEN_SCHEME Character(10) VARCHAR2(10) NOT NULL Pension Scheme for GBR
    7 GPGB_PRCRN_DATE Date(10) DATE GBR AutoEnrollment Process run date
    8 GPGB_PRP_END_DT Date(10) DATE GBR staging date field
    9 GPGB_PRP_START_DT Date(10) DATE GBR staging date field
    10 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    11 GPGB_QEARNING Signed Number(20,3) DECIMAL(18,3) NOT NULL Qualifying Earning GBR
    12 GPGB_PEN_EVENT Character(20) VARCHAR2(20) NOT NULL Pension Events GBR
    13 GPGB_PEN_A_STATUS Character(50) VARCHAR2(50) NOT NULL Pension Applicant Status GBR

    Prompt Table: GPGB_STATUS_VW

    14 GPGB_DEFERAL_DT Date(10) DATE GBR date field to store deferal date