EMPLIDEMPL_RCDACTION_DT_SSEFFSEQHR_SALCHG_HDRV2(SQL View) |
Index Back |
|---|---|
Adhoc Salary Change HTML EmailAdhoc 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 , %DateNull , C.COMMENTS , 'X' FROM PS_HR_SALCHG_DAT A LEFT OUTER JOIN PS_NAMES EMP ON A.EMPLID = EMP.EMPLID , PS_HR_SALCHG_STA C , PSOPRDEFN REQ LEFT OUTER JOIN PS_NAMES REQN ON REQ.EMPLID = REQN.EMPLID WHERE A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND A.ACTION_DT_SS = C.ACTION_DT_SS AND A.EFFSEQ = C.EFFSEQ AND C.HR_WF_ACTION = 'SUB' 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 | 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 | Termination 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 | EFFDT | Date(10) | DATE | Effective Date |
| 9 | COMMENTS | Long Character | CLOB | Comment |
| 10 | DESCR_COMMENTS_HIS | Long Character | CLOB | This field is used in a complex query that shows many descr fields. |