GPBR_ES_EMPL_VW

(SQL View)
 Index Back

Current Primary Name View

eSocial Current Primary Name View

SELECT J1.EMPLID , J1.EMPL_RCD ,A.NAME_DISPLAY_SRCH ,A.NAME_TYPE ,A.EFFDT ,A.NAME FROM PS_NAMES A , PS_JOB J1 WHERE A.NAME_TYPE = 'PRI' AND A.EMPLID = J1.EMPLID 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 <= %CurrentDateIn) AND J1.ACTION IN ( SELECT T1.ACTION FROM PS_GPBR_TER_ACTREA T1 WHERE T1.EFFDT =( SELECT MAX (T2.EFFDT) FROM PS_GPBR_TER_ACTREA T2 WHERE T2.EFFDT <= %CurrentDateIn)) AND J1.ACTION_REASON IN ( SELECT T3.ACTION_REASON FROM PS_GPBR_TER_ACTREA T3 WHERE T3.EFFDT =( SELECT MAX (T4.EFFDT) FROM PS_GPBR_TER_ACTREA T4 WHERE T4.EFFDT <= %CurrentDateIn)) AND J1.EFFDT =( SELECT MAX (J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J1.EMPLID AND J2.EMPL_RCD = J1.EMPL_RCD AND J2.EFFDT <= %CurrentDateIn)

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: GP_ERC_SEC_VW

    3 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    4 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL

    5 ASOFDATE Date(10) DATE As of Date
    6 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI