PROTECT_BEL

(SQL Table)
 Index Back

Protection Period - Belgium

This record is used for the Belgium Employment Terms.

  • Parent record: PER_ORG_ASGN_VW

    • # 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 Rcd Nbr
    3 PROT_ID_BEL Character(3) VARCHAR2(3) NOT NULL Protection Type
    001=WC - 1st time candidate
    002=WC - 2nd time candidate NE
    003=WC - elected
    004=SHE - 1st time candidate
    005=SHE - 2nd time candidate NE
    006=SHE - elected
    007=Union delegation
    008=Pregnancy leave
    009=Paternity leave
    010=Career interruption
    011=Educational leave
    012=New technologies
    013=Equal treatment
    014=Remarks labour rules
    015=Head of SHE and adjuncts
    016=Industrial physician
    017=Political leave
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    5 END_DT Date(10) DATE NOT NULL end date