GPTH_DIS_NM_VW

(SQL View)
 Index Back

Current Primary Name View

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. If a Person only exists in the Future, then that person's most future dated row will be returned. 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 G.PROCESS_INSTANCE ,A.EMPLID ,A.NAME_TITLE ,A.NAME_PREFIX ,%TrimSubstr(A.FIRST_NAME %Concat ' ' %Concat A.MIDDLE_NAME, 1, 61) ,A.FIRST_NAME ,A.MIDDLE_NAME ,A.LAST_NAME ,A.NAME_TYPE ,A.EFFDT FROM PS_NAMES A , PS_GPTH_DIS_RPT G WHERE A.EMPLID=G.EMPLID AND A.NAME_TYPE = 'PRI' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_NAMES B WHERE B.EMPLID = A.EMPLID AND B.NAME_TYPE = A.NAME_TYPE AND B.EFFDT <= G.DATE_DUE )

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    3 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Name Title
    4 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    5 GPTH_NAME1 Character(80) VARCHAR2(80) NOT NULL Tax-Payee's First Name
    6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    7 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    9 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL

    10 ASOFDATE Date(10) DATE As of Date