GPGB_EE_PENSION

(SQL Table)
 Index Back

Employee Pension Details

Captures employee pension details.

  • 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 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    4 GPGB_QPEN_SCHEME Character(10) VARCHAR2(10) NOT NULL Pension Scheme for GBR

    Prompt Table: GPGB_PEN_SCM_VW

    5 GPGB_PEN_SCHEME Character(4) VARCHAR2(4) NOT NULL Pension Scheme Code
    AVC1=AVC1
    FIXA=Fixed Scheme A
    PCTB=Percentage Scheme B
    6 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    7 GPGB_EE_PCTG_CONT Number(6,2) DECIMAL(5,2) NOT NULL Employee's Percentage Contribution
    8 GPGB_ER_PCTG_CONT Number(6,2) DECIMAL(5,2) NOT NULL Employer's Percentage Contribution
    9 GPGB_EE_PEN_AMT Number(10,2) DECIMAL(9,2) NOT NULL Employers Flat Amount Contribution
    10 GPGB_ER_PEN_AMT Number(10,2) DECIMAL(9,2) NOT NULL Employers Pension Fixed Amount
    11 END_DATE Date(10) DATE End Date
    12 GPGB_AUTO_ENROLL Character(1) VARCHAR2(1) NOT NULL Auto Enrollment Flag for GBR
    0=NO
    1=YES
    13 GPGB_PEN_REFUND Character(1) VARCHAR2(1) NOT NULL Refund Flag for GBR
    0=NO
    1=YES
    14 GPGB_OPTOUT_ST_DT Date(10) DATE GBR pension optout start date field
    15 GPGB_OPTOUT_END_DT Date(10) DATE GBR pension optout date field
    16 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    17 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A