JPM_PERSON_NAME

(SQL View)
 Index Back

Curent Job - All Persons

Selects all Persons with HR status active in JOB and shows their NAMES for each EMPLID. This view will include Employees, Contingent Workers, and Persons of Interest.

SELECT A.EMPLID ,A.NAME_DISPLAY ,A.LAST_NAME_SRCH ,A.FIRST_NAME_SRCH ,A.SECOND_LAST_SRCH ,A.NAME_AC FROM PS_NAMES A WHERE A.NAME_TYPE = 'PRI'

  • 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_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    5 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name