GPGB_PEN_EVENTS

(SQL Table)
Index Back

Employee Pension Details

Events table for Pension GBR

  • 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 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    5 GPGB_PRCRN_DATE Date(10) DATE NOT NULL GBR AutoEnrollment Process run date
    6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    7 GPGB_QPEN_SCHEME Character(10) VARCHAR2(10) NOT NULL Pension Scheme for GBR

    Prompt Table: GPGB_PNSCL0_TBL

    8 GPGB_EFF_PRC_DT Date(10) DATE GBR process effdt
    9 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GPGB_PEN_CAL_VW

    10 GPGB_QEARNING Signed Number(20,3) DECIMAL(18,3) NOT NULL Qualifying Earning GBR
    11 GPGB_PEN_EVENT Character(20) VARCHAR2(20) NOT NULL Pension Events GBR

    Prompt Table: GPGB_EVENT_VW

    12 GPGB_PEN_A_STATUS Character(50) VARCHAR2(50) NOT NULL Pension Applicant Status GBR

    Prompt Table: GPGB_STATUS_VW

    13 GPGB_PRP_END_DT Date(10) DATE GBR staging date field
    14 GPGB_PRP_START_DT Date(10) DATE GBR staging date field
    15 GPGB_DEFERAL_DT Date(10) DATE GBR date field to store deferal date
    16 GPGB_ELG_ASMT_DT Date(10) DATE GBR date field to store the date value on which the employee was assessed and found eligible to be auto enrolled.