GPNL_WAO_DATA(SQL Table) |
Index Back |
|---|---|
WAO NetherlandsThis table holds the employee WAO information for the Netherlands. Including the WAO Date and Classification. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GPNL_WAO_DATE |
Date(10) | DATE NOT NULL | WAO Date |
| 4 | GPNL_WAO_CLASS | Character(3) | VARCHAR2(3) NOT NULL |
WAO Class replaces the WAO Percent for The Netherlands to track the employment incapacity.
0=Not Applicable 100=WAO 80-100 Percent 25=WAO 15-25 Percent 34=WAO 25-34 Percent 44=WAO 35-44 Percent 54=WAO 45-54 Percent 65=WAO 55-65 Percent 80=WAO 65-80 Percent 80+=WIA 80-100 (IVA) <35=WIA 0-35 percent <80=WIA 35-80 percent (WGA) >80=WIA 80-100 (WGA) |
| 5 | GPNL_WAO_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | WAO Amount to Pay |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | BGN_DT | Date(10) | DATE | Begin Date |
| 8 | END_DT | Date(10) | DATE | end date |