GPDE_SI_EE

(SQL Table)
 Index Back

EE Social Insurance Data

EE Social Insurance Data

  • Related Language Record: GPDE_SI_EE_LNG

  • Parent Record Of GPDE_SI_EE_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE Effective Date

    Default Value: EMPLOYMENT.HIRE_DT

    4 GPDE_DO_SV_CODE Character(3) VARCHAR2(3) NOT NULL SI Code
    5 GPDE_SI_PV_CD Character(1) VARCHAR2(1) NOT NULL Home Care Insurance Code
    6 GPDE_DV_SV_CODE Character(4) VARCHAR2(4) NOT NULL DEUEV Contribution Group Code
    7 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code

    Default Value: GPDE_BACODE_VW.BA_CD

    Prompt Table: BA_CD_TBL

    8 GPDE_SI_POS_IN_JOB Character(1) VARCHAR2(1) NOT NULL Position
    0=0 Apprentice
    1=1 Blue Collar, non prof
    2=2 Blue Collar Prof
    3=3 BC Foreman
    4=4 White Collar
    5=5 Disabled
    6=6 Rehabilitation
    7=7 Homeworker;domestic business
    8=8 Part Time < 18 Hrs.
    9=9 Part Time >= 18 Hrs.

    Prompt Table: GPDE_SI_POS_VW

    9 GPDE_SI_EDUCATION Character(1) VARCHAR2(1) NOT NULL Education
    0=0 unknown
    1=1General Secondary w/o Prof
    2=2 General Secondary with Prof
    3=3 Gen Univ Entr no Prof Train
    4=4 Gen Univ Entr w/Prof Train
    5=5 Technical College Degree
    6=6 University Degree
    7=7 unknown degree
    10 GPDE_SI_EMPL_TYPE Character(20) VARCHAR2(20) NOT NULL Employment Type

    Default Value: GPDE_BACODE_VW.DESCR

    11 GPDE_BA_SCHL_DGR Character(1) VARCHAR2(1) NOT NULL SCHOOL DEGREE
    1=Without School Leave certifict
    2=certi of Secondary Education
    3=secondary school levelI certi
    4=gen qual - univ entr/Voc dipl
    9=Certificate not known
    12 GPDE_BA_PRF_DGR Character(1) VARCHAR2(1) NOT NULL PROFESSIONAL DEGREE
    1=without professional educatio
    2=Certificate of accepted profn
    3=Master Craftsman, technican
    4=Bachelor
    5=Mast of Arts/ Dipl/State Exam
    6=Conferal of a Doctorate
    9=Profesionl Education not known
    13 GPDE_BA_EMPL_TMP Character(1) VARCHAR2(1) NOT NULL TEMP EMPLOYMENT
    1=No
    2=Yes
    14 GPDE_BA_CNTRCT_WRK Character(1) VARCHAR2(1) NOT NULL BA CONTRACT WORK
    1=FullTmEmpl-Unlimited Empl Cont
    2=PartTmEmpl-Unlimited Empl Cont
    3=FullTmEmpl-Limited Empl Contrt
    4=PartTmEmpl-Limited Empl Contrt
    15 GPDE_SI_PENS_APPLI Character(1) VARCHAR2(1) NOT NULL Pension Type
    0=No Pension Applic'n/Payments
    1=Pension Application
    2=Partial Disability Pension
    3=General Disability Pension
    4=Retirement Pension
    5=Old Age Part Time Pension
    6=Widow/Orphan Pension
    7=Educational Pension
    8=Miners' Pension
    9=Farmers' Retirement Pension

    Default Value: 0

    Prompt Table: GPDE_SI_PEN_VW

    16 GPDE_SI_EMPL_INSIG Character(1) VARCHAR2(1) NOT NULL Insignificant Employment
    0=Not Insignificant
    1=Insignificant Employment
    2=Short Term Employment

    Default Value: 0

    17 GPDE_SI_CARD_PRES Date(10) DATE SI Card Date Presented
    18 HAZARD Character(8) VARCHAR2(8) NOT NULL Hazard

    Default Value: DEPT_TBL.HAZARD

    Prompt Table: ACCDT_INS_HAZ

    19 GPDE_SI_MINER Character(1) VARCHAR2(1) NOT NULL Miners' Social Insurance
    G=Not Applicable
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    20 GPDE_DV_EMPL_CAT Character(3) VARCHAR2(3) NOT NULL Employee Category
    101=Regular SI Taxable
    102=Apprentice
    103=Old-Age Part Time
    104=Consultant
    105=Trainee
    106=Student Trainee
    107=Disabled
    108=Early Retirement
    109=Low Income Earner
    110=Short-Term Employment
    111=EE in Rehabilitation
    112=Family member in agriculture
    113=Part-time Farmer
    114=PT Farmer, seasonal
    116=FEI Compensation Receiver
    118=Casual Worker
    119=Old Age Pensioner
    120=Pretended Freelancer
    190=Insured only for Accident Ins
    900=Public Servant
    901=Managing Partner
    903=Health Insured Pensioner
    910=SI free Employee

    Default Value: 101

    Prompt Table: GPDE_SI_CAT_VW

    21 GPDE_MJ_GZ_CALC Character(1) VARCHAR2(1) NOT NULL Glidezone Calculation Method Xlats 0 - None 1 - Normal 2 - No Pension Reduction
    0=None
    1=Glidezone Normal
    2=Glidezone-Pension unreduced
    22 GPDE_SI_EMPL_MULT Character(1) VARCHAR2(1) NOT NULL Multiple Employment Records
    0=No
    1=Yes
    23 GPDE_SI_BAEGV Character(1) VARCHAR2(1) NOT NULL DEUEV Employment Status
    0=Regular Employment
    1=Employed Family Member
    2=Owning Manager

    Default Value: 0

    24 GPDE_SI_SPCL_HIR Character(1) VARCHAR2(1) NOT NULL Special Hire Report for DEUEV

    Y/N Table Edit

    Default Value: N