HS_EMPL_SUB_CAN

(SQL Table)
 Index Back

HS Emp Sub Cont Details

Used in Health and Safety for additonal employment details on people who are involved in incidents.

  • Related Language Record: EMPLOYMENT_LNG3

  • 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

    Default Value: PERSON.EMPLID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 SUBCON_DESCR_CAN Long Character CLOB Employment Details