TRANSACTION_NAMESS_GRP_IDHR_SALCHG_JOB_V(SQL View) |
Index Back |
|---|---|
Adhoc Salary Change HTML EmailAdhoc 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 , B.DESCR , C.COMMENTS , 'X' FROM PS_SS_KEYS A LEFT OUTER JOIN PS_NAMES EMP ON A.EMPLID = EMP.EMPLID , PS_SS_PROCESS_DTL C , PS_JOB D , PS_JOBCODE_TBL B , 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 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 = B.SETID AND D.JOBCODE=B.JOBCODE 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | COMMENTS | Long Character | CLOB | Comment |
| 12 | DESCR_COMMENTS_HIS | Long Character | CLOB | This field is used in a complex query that shows many descr fields. |