HR_SALCHG_PH_V

(SQL View)
 Index Back

Adhoc Salary Change HTML Email

Adhoc Salary Change. Used to retrieve data for the header section of HTML email

SELECT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ , EMP.NAME_DISPLAY , A.ORIGINATORID , REQN.NAME_DISPLAY ,B.EMPLOYEE_PHOTO , %DateNull ,E.DESCR FROM PS_HR_SALCHG_DAT A LEFT OUTER JOIN PS_NAMES EMP ON A.EMPLID = EMP.EMPLID , PS_JOB D , PS_JOBCODE_TBL E , %Table (USER_PH_LIST_FL) B , PSOPRDEFN REQ LEFT OUTER JOIN PS_NAMES REQN ON REQ.EMPLID = REQN.EMPLID WHERE A.EMPLID=D.EMPLID AND D.EFFDT=( SELECT MAX(D2.EFFDT) FROM PS_JOB D2 WHERE D2.EMPLID=D.EMPLID AND D.EFFDT=D2.EFFDT) AND D.SETID_JOBCODE = E.SETID AND D.JOBCODE=E.JOBCODE AND A.ORIGINATORID = REQ.OPRID AND EMP.NAME_TYPE = 'PRI' AND A.EMPLID = B.EMPLID AND EMP.EFFDT = ( SELECT MAX(EMP2.EFFDT) FROM PS_NAMES EMP2 WHERE EMP.EMPLID = EMP2.EMPLID AND EMP.NAME_TYPE = EMP2.NAME_TYPE AND EMP2.EFFDT <= %CurrentDateIn) AND REQN.NAME_TYPE = 'PRI' AND REQN.EFFDT = ( SELECT MAX(REQN2.EFFDT) FROM PS_NAMES REQN2 WHERE REQN.EMPLID = REQN2.EMPLID AND REQN.NAME_TYPE = REQN2.NAME_TYPE AND REQN2.EFFDT <= %CurrentDateIn)

  • Related Language Record: HR_SALCHG_PHL_V

    • # 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
    3 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 NAME_DISPLAY1 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    6 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    7 NAME_DISPLAY2 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    8 EMPLOYEE_PHOTO Image / Attachment(256) VARCHAR2(256) Employee Photograph
    9 EFFDT Date(10) DATE Effective Date
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description