EFFDTDefault Value: %date
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 Record |
| 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 |