Understanding the Create Statistics Process
The Create Illness Statistics NLD process generates the illness statistics for the month specified on the run control page and stores this information in the PS_ABS_STAT_NLD table.
Note: The Create Illness Statistics NLD process (GPNLAM01) delivered with Global Payroll for the Netherlands also populates PS_ABS_STAT_NLD table. The only difference between these two processes is the source of the absence data. Global Payroll for the Netherlands uses the absence data entered in Global Payroll while the process in Monitor Absence uses the absence data entered in HR.
This table describes the fields in the PS_ABS_STAT_NLD table:
Fieldname |
Format |
Description |
Values |
---|---|---|---|
EMPLID |
Char (11) |
Employee ID |
|
EMPL_RCD |
Num (3) |
Employment Rcd Nbr |
|
COMPANY |
Char (3) |
Company |
|
SETID |
Char (5) |
SetID |
|
DEPTID |
Char (10) |
Department |
|
NL_FROM_YEAR |
Num (4) |
Year From |
|
NL_FROM_MONTH |
Num (2) |
Month From |
|
BEGIN_DT |
Date |
Begin Date |
|
CREATION_DT |
Date |
Creation Date |
|
SEX |
Char (1) |
Gender |
F or M |
ABSENCE_TYPE |
Char (3) |
Absence Type |
501–507 |
AGE_NLD |
Num (3) |
Age |
|
EMPL_RCD_ILI_NLD |
Num (10,3) |
Factor of employment days (working days divided by the number of days in the period). For example, an employee hired on January 10, would have a factor of 22/31. |
0–1 |
EMPL_RCD_ELI_NLD |
Num (10,3) |
Factor of employment days, excluding long-term illness. Absence days considered long-term illness are not counted as employment days. |
0–1 |
FTE_ILI_NLD |
Num (10,3) |
Employment days multiplied by the FTE factor and divided by the calendar days. For example, if a part-time employee is hired mid-month, with an FTE factor of 0.8, this field is set to 0.4. |
0–1 |
FTE_ELI_NLD |
Num (10,3) |
Employment days, excluding long-term illness, multiplied by the FTE factor and divided by the calendar days. |
0–1 |
ILL_AVDAYS_ILI_NLD |
Num (10,3) |
Available day count (the FTE factor multiplied by the number of days in month). For example, if an part-time employee has an FTE of 0.5, the available day count for January is 0.5*31. |
0–31 |
ILL_AVDAYS_ELI_NLD |
Num (10,3) |
Available day count, excluding long-term illness. |
0–31 |
ILL_START_FULL_NLD |
Char (1) |
Indicates whether an illness started within the reporting month with 100% absence or a partial illness became full-time. |
Y/N |
ILL_START_PART_NLD |
Char (1) |
Indicates whether an illness started within the reporting month as a partial illness. |
Y/N |
ILL_ENDEPI_ELI_NLD |
Char (1) |
Indicates whether a short-term illness ended or became a long-term illness. |
Y/N |
ILL_ENDEPI_ILI_NLD |
Char (1) |
Indicates whether a full-time illness ended. |
Y/N |
ILL_ENDIPI_ELI_NLD |
Char (1) |
Indicates whether a short—term illness ended or became long-term. |
Y/N |
ILL_ENDIPI_ILI_NLD |
Char (1) |
Indicates whether an illness ended in the reporting month. |
Y/N |
ILL_DAYEPI_ELI_NLD |
Num (10,3) |
Number of full-time illness days (Percentage Ill field is 100 percent) in the reporting month multiplied by the FTE factor. This excludes longtime illnesses. For example, an employee who is 100% sick from January 20 to 24 and 40% from January 25, this field is set to 5. If the employee is part-time with an FTE factor of 0.5, the same absence would be calculated as 5*0.5. |
1–31 |
ILL_DAYEPI_ILI_NLD |
Num (10,3) |
Number of full-time illness days in the reporting month, including longtime illnesses, multiplied by the FTE factor. |
1–31 |
ILL_DAYIPI_ELI_NLD |
Num (10,3) |
Number of days of partial illness (Percentage Ill field is less than 100 percent) in the reporting period multiplied by the FTE factor. This excludes longtime illnesses. |
1–31 |
ILL_DAYIPI_ILI_NLD |
Num (10,3) |
Total number of days of illness in the reporting period, multiplied by the FTE factor. This includes both partial and longtime illnesses. |
1–31 |
ILL_LENEPI_ELI_NLD |
Num (10,3) |
Duration of illness. This is the number of days between the begin date and either of the following
|
1–n |
ILL_LENEPI_ILI_NLD |
Num (10,3) |
Duration of illness. This is the number of days between the begin date and either of the following:
|
1–n |
ILL_LENIPI_ELI_NLD |
Num (10,3) |
Duration of illness. This is the number of days between the begin date and either of these dates:
|
1–n |
ILL_LENIPI_ILI_NLD |
Num (10,3) |
Duration of illness. This is the number of days between the begin and the return date. |
1–n |