WAO_DATA_NLD (SQL Table)	Index Back
WAO Netherlands This table holds the employee WAO information for the Netherlands. Including the WAO Date and Classification.

WAO_DATA_NLD

(SQL Table)

WAO Netherlands

This 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 BEGIN_DT Date(10) DATE NOT NULL Begin Date
Default Value: %date

4 ABSENCE_TYPE Character(3) VARCHAR2(3) NOT NULL Absence Type
Prompt Table: ABS_TYPE_PNL_VW
Set Control Field: REG_REGION

5 WAO_DATE_NLD Date(10) DATE NOT NULL WAO/WIA Date

6 WAO_CLASS_NLD 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)

#	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	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date Default Value: %date
4	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type Prompt Table: ABS_TYPE_PNL_VW Set Control Field: REG_REGION
5	WAO_DATE_NLD	Date(10)	DATE NOT NULL	WAO/WIA Date
6	WAO_CLASS_NLD	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)