HR_SALCHG_HDR_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.TRANSACTION_NAME , A.SS_GRP_ID , A.SS_TRANS_ID , A.EMPLID , EMP.NAME_DISPLAY , A.EMPL_RCD , A.ORIGINATORID , REQN.NAME_DISPLAY , %DateNull , C.COMMENTS , 'X' FROM PS_SS_KEYS A LEFT OUTER JOIN PS_NAMES EMP ON A.EMPLID = EMP.EMPLID , PS_SS_PROCESS_DTL C , PSOPRDEFN REQ LEFT OUTER JOIN PS_NAMES REQN ON REQ.EMPLID = REQN.EMPLID WHERE A.TRANSACTION_NAME = C.TRANSACTION_NAME AND A.SS_GRP_ID = C.SS_GRP_ID AND A.SS_TRANS_ID = C.SS_TRANS_ID AND C.SS_ROLETYPE = 'ORG' AND A.ORIGINATORID = REQ.OPRID AND EMP.NAME_TYPE = 'PRI' 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)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
2 SS_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
3 SS_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 NAME_DISPLAY1 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
7 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
8 NAME_DISPLAY2 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
9 EFFDT Date(10) DATE Effective Date
10 COMMENTS Long Character CLOB Comment
11 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.