GPBR_ABSENCE_CODE10=Sickness
20=Work Accident
30=Vacations
GPBR_SEF_ABS_VW(SQL View) |
Index Back |
|---|---|
SEFIP Absence GroupSEFIP Absence Group |
| SELECT A.GPBR_ABSENCE_CODE FROM PS_GPBR_SEFIP_ABS A WHERE A.STATUS = 'A' AND A.EFFDT IN ( SELECT MAX(B.EFFDT) FROM PS_GPBR_SEFIP_ABS B WHERE B.GPBR_ABSENCE_CODE = A.GPBR_ABSENCE_CODE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_ABSENCE_CODE |
Character(2) | VARCHAR2(2) NOT NULL |
Absence Code
10=Sickness 20=Work Accident 30=Vacations |