GP_PAYGROUPEMPLIDEMPL_RCDGP_PGRP_JOB_VW(SQL View) |
Index Back |
|---|---|
See Payees Pay Groups from JobView shows all GP Paygroups a payee has ever been assigned to based on highest EFFSEQ for each EFFDT |
| SELECT DISTINCT J.GP_PAYGROUP ,J.EMPLID ,J.EMPL_RCD ,J.COMPANY ,D.DESCR ,JC.DESCR FROM PS_JOB J ,PS_DEPT_TBL D ,PS_JOBCODE_TBL JC WHERE J.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB JJ WHERE JJ.EMPLID=J.EMPLID AND JJ.EMPL_RCD=J.EMPL_RCD AND JJ.EFFDT=J.EFFDT) AND J.SETID_JOBCODE = JC.SETID AND J.JOBCODE=JC.JOBCODE AND %EffdtCheck(JOBCODE_TBL, JC, %CurrentDateIn) AND J.SETID_DEPT = D.SETID AND J.DEPTID = D.DEPTID AND %EffdtCheck(DEPT_TBL, D, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |