GPCH_RP_FTE_VW(SQL View) |
Index Back |
---|---|
Fte ViewFte View |
SELECT J1.EMPLID , J1.EMPL_RCD , MIN(J1.EFFDT) , J1.FTE , MIN(J1.EFFDT) FROM PS_JOB J1 WHERE NOT EXISTS ( SELECT 'x' FROM PS_JOB J2 WHERE J1.EMPLID = J2.EMPLID AND J1.EMPL_RCD = J2.EMPL_RCD AND J1.COMPANY = J2.COMPANY AND J1.FTE <> J2.FTE AND J2.EFFDT > J1.EFFDT ) GROUP BY J1.EMPLID, J1.FTE, J1.EMPL_RCD |
# | 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 Rcd Nbr |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
5 | EFFDT_USED | Date(10) | DATE | Date driving 'processed' code |