SENIORITY_BELVW

(SQL View)
 Index Back

Seniority - Belgium

This record is used for the Belgium Employment Terms.

SELECT DISTINCT EMPLID , EMPL_RCD , SENIORITY_TYPE_BEL FROM PS_SENIORITY_BEL

  • 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 Record
    3 SENIORITY_TYPE_BEL Character(1) VARCHAR2(1) NOT NULL Seniority Type
    1=Legal Seniority
    2=Company Seniority

    Default Value: 1