PERS_DATA_CHE

(SQL Table)
Index Back

Extension of PERSON fo CHE

Extension of the PERSON object for Swiss specific fields with EFFDT

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: PERSON.EMPLID

    Prompt Table: PERSON

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 GUARDIAN_CHE Character(40) VARCHAR2(40) NOT NULL In Switzerland, it is a requirement for an employee who is 18 years of age or younger to have a guardian on record