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

  • The return date.

  • The date that the illness became partial or longtime.

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:

  • The return date.

  • The date that the illness became partial.

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:

  • The return date.

  • The date that the illness becomes a longtime illness.

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