PIN_ENT_NUMPIN_NUMUNIT_TYPED=Days
H=Hours
HGA_ENT_UNIT_VW(SQL View) |
Index Back |
|---|---|
Absence Entitlement UnitsAbsence Entitlement Units |
| SELECT DISTINCT TE.PIN_ENT_NUM , TE.PIN_NUM , SS.UNIT_TYPE FROM PS_GP_ABS_TAKE_ENT TE , PS_GP_ABS_SS SS WHERE TE.EFFDT = ( SELECT MAX(TE1.EFFDT) FROM PS_GP_ABS_TAKE_ENT TE1 WHERE TE1.PIN_NUM = TE.PIN_NUM AND TE1.EFFDT <= %CurrentDateIn) AND SS.PIN_TAKE_NUM = TE.PIN_NUM AND SS.COUNTRY = ( SELECT MAX(SS1.COUNTRY) FROM PS_GP_ABS_SS SS1 WHERE SS1.PIN_TAKE_NUM = SS.PIN_TAKE_NUM) AND SS.EFFDT = ( SELECT MAX(SS1.EFFDT) FROM PS_GP_ABS_SS SS1 WHERE SS1.COUNTRY = SS.COUNTRY AND SS1.PIN_TAKE_NUM = SS.PIN_TAKE_NUM AND SS1.EFFDT <= %CurrentDateIn) AND SS.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_ENT_NUM |
Number(8,0) | INTEGER NOT NULL | Element number field |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | UNIT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Unit Type in which the absence balances are displayed
D=Days H=Hours |