GPCH_AL_LGHT_VW(SQL View) |
Index Back |
|---|---|
Latest Hire ViewLatest Hire View |
| SELECT J.EMPLID ,J.EMPL_RCD ,J.EFFDT ,J.EFFSEQ ,J.EMPL_STATUS ,J.PAY_SYSTEM_FLG ,PE.COUNTRY ,PE.PAY_ENTITY ,J.GP_PAYGROUP ,J.ACTION FROM PS_JOB J ,PS_GP_PYGRP PG ,PS_GP_PYENT PE WHERE J.EFFSEQ = ( SELECT MAX(J1.EFFSEQ) FROM PS_JOB J1 , PS_GP_PYGRP PG1 WHERE J.EMPLID = J1.EMPLID AND J.EMPL_RCD = J1.EMPL_RCD AND J.EFFDT = J1.EFFDT AND J.ACTION = J1.ACTION AND J1.GP_PAYGROUP = PG1.GP_PAYGROUP AND PG.PAY_ENTITY = PG1.PAY_ENTITY ) AND J.GP_PAYGROUP = PG.GP_PAYGROUP AND PG.PAY_ENTITY = PE.PAY_ENTITY AND J.ACTION = 'HIR' |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 6 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 8 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 9 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 10 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |