HR_EMP_ALL_VW

(SQL View)
 Index Back

ERN - Employee Records view

List of the available combinations of EMPLID and EMPL_RCD.

SELECT DISTINCT A.EMPLID , P.NAME FROM PS_PER_ORG_ASGN A , PS_PERSON_NAME P WHERE A.EMPLID = P.EMPLID

  • Related Language Record: PERSON_NAME_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 NAME Character(50) VARCHAR2(50) NOT NULL Name