EMPLIDEMPL_RCDERNCDSETID_DEPTSETID_JOBCODEDEPTIDJOBCODEBUSINESS_UNITEFFDTDefault Value: %date
HPY_ADDL_PY_VW(SQL View) |
Index Back |
|---|---|
Additional pay for PNAThis record is created to get all the earning codes for employees |
| SELECT DISTINCT B.EMPLID ,B.EMPL_RCD ,A.ERNCD ,B.SETID_DEPT ,B.SETID_JOBCODE ,B.DEPTID ,B.JOBCODE ,B.BUSINESS_UNIT , A.EFFDT FROM PS_JOB B ,PS_ADDL_PAY_DATA A WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND B.EFFDT <=A.EFFDT AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ADDL_PAY_EFFDT A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.EMPL_RCD = A_ED.EMPL_RCD AND A.ERNCD = A_ED.ERNCD AND A_ED.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 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 4 | SETID_DEPT |
Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 5 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 6 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |