HRS_EMPL_NM_I

(SQL View)
 Index Back

Interface View for Employee Nm

Interface view for employee name using person name and per org.

SELECT A.EMPLID ,A.NAME_DISPLAY ,A.NAME_TYPE ,A.ASOFDATE FROM PS_HRS_PERSON_NM_I A , PS_HRS_PER_ORG_A_I B WHERE A.EMPLID = B.EMPLID AND B.PER_ORG = 'EMP' AND B.EMPL_RCD = ( SELECT MIN(C.EMPL_RCD) FROM PS_HRS_PER_ORG_A_I C WHERE B.EMPLID = C.EMPLID AND C.PER_ORG = 'EMP' )

  • Related Language Record: HRS_EMPL_NM_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: HRS_PERSON_NM_I

    2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    3 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL

    4 ASOFDATE Date(10) DATE As of Date