HR_SS_PERNM_SRC

(SQL View)
 Index Back

SS Pers/Name view

This view is used by Employee Self service transactions - contains EMPLID, OPRID, and current Primary name. Rowlevel security is on OPRID.

SELECT P.EMPLID , O.OPRID ,P.NAME FROM PS_PERSON_NAME P , PSOPRDEFN O WHERE P.EMPLID = O.EMPLID

  • Related Language Record: PERSON_NAME_LNG

  • Parent record: PERSON

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

    Prompt Table: PERSON

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name