HS_EMPL_REL_CAN

(SQL Table)
Index Back

HS Worker Relationship

  • Related Language Record: EMPLOYMENT_LNG2
  • 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 Rcd Nbr
    3 REL_DESCR_CAN Long Character CLOB Worker Relationship