HRS_ACT_PERS_I1

(SQL View)
 Index Back

Interface View for Curr PRI NM

This view retrieves the currently effective Names record for all the Primary Name. Only one row per emplid is returned. The EFFDT is included only for reference back to NAMES as ASOFDATE. No Query Security record is specified because in query this would be one of the joined in records. The main record should contain the query security.

SELECT DISTINCT A.EMPLID ,A.NAME_DISPLAY ,A.NAME_TYPE ,A.ASOFDATE FROM PS_HRS_PERSON_NM_I A WHERE EXISTS (SELECT 'X' FROM PS_JOB J WHERE A.EMPLID = J.EMPLID AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT <= %CurrentDateIn) AND J.EFFSEQ = (SELECT MAX(J1.EFFSEQ) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT = J.EFFDT) AND (J.BAS_ACTION NOT IN ('TER', 'RET')))

  • Related Language Record: HRS_ACT_PERS_L1

  • 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 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