GPGB_SET_EVNTL1

(SQL Table)
 Index Back

Employee Pension Details

Level 1 pension applicant status table for Pension GBR

  • Parent record: JOB

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPGB_PEN_EVENT Character(20) VARCHAR2(20) NOT NULL Pension Events GBR
    2 GPGB_PEN_A_STATUS Character(50) VARCHAR2(50) NOT NULL Pension Applicant Status GBR
    3 GPGB_PENSTAT_ID Character(10) VARCHAR2(10) NOT NULL Pension Applicant Status ID GBR
    4 GPGB_PRC_USED_FLG Character(1) VARCHAR2(1) NOT NULL Process Used Flag for GBR
    0=NO
    1=YES
    5 GPGB_PEN_SRSN_DESC Long Character CLOB Pension Applicant Status Reason Description GBR
    6 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N