Format/Length:	max n4
NWDS ID:	AWHL
NWDS Field Name:	Working Hours Lost due to Absence
National Codes:
Default Codes:

Notes:
EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD) is the sum total of each EMPLOYEE ABSENCE WORKING HOURS LOST due to EMPLOYEE ABSENCE of an EMPLOYEE within an ORGANISATION during the REPORTING PERIOD.

To be included within the sum total the EMPLOYEE ABSENCE END DATE of the EMPLOYEE ABSENCE should be on or after the REPORTING PERIOD START DATE or where no EMPLOYEE ABSENCE END DATE is recorded i.e. not yet ended, then the EMPLOYEE ABSENCE START DATE should be before or on the REPORTING PERIOD END DATE.

For an EMPLOYEE ABSENCE which either starts before and ends after the REPORTING PERIOD START DATE or starts before the REPORTING PERIOD END DATE and ends after or has not ended on the REPORTING PERIOD END DATE, the sum total EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD) should be adjusted as:

	a.	where the EMPLOYEE ABSENCE START DATE is before the REPORTING PERIOD START DATE
		and
		where the date difference is one week or more, then the EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD) should be reduced by EMPLOYMENT CONTRACT WORKING HOURS * calculated number of whole weeks difference between the EMPLOYEE ABSENCE START DATE and the REPORTING PERIOD START DATE
		otherwise
		where the date difference is less than one week, then no adjustment should be made
	b.	where the EMPLOYEE ABSENCE END DATE is after the REPORTING PERIOD END DATE
		and
		where the date difference is one week or more, then the EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD) should be reduced by EMPLOYMENT CONTRACT WORKING HOURS * calculated number of whole weeks difference between the EMPLOYEE ABSENCE END DATE and the REPORTING PERIOD END DATE
		otherwise
		where the date difference is less than one week, then no adjustment should be made
	c.	where no EMPLOYEE ABSENCE END DATE is recorded and the EMPLOYEE ABSENCE START DATE is after the REPORTING PERIOD START DATE
		and
		where the date difference is one week or more, then the sum total EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD) should be increased by EMPLOYMENT CONTRACT WORKING HOURS * calculated number of whole weeks difference between the EMPLOYEE ABSENCE START DATE and the REPORTING PERIOD END DATE
		otherwise
		where the date difference is less than one week, then no adjustment should be made
	d.	where no EMPLOYEE ABSENCE END DATE is recorded and the EMPLOYEE ABSENCE START DATE is before the REPORTING PERIOD START DATE
		and
		where the date difference is one week or more, then the sum total EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD) should be increased by EMPLOYMENT CONTRACT WORKING HOURS * calculated number of whole weeks difference between the REPORTING PERIOD START DATE and the REPORTING PERIOD END DATE
		otherwise
		where the date difference is less than one week, then no adjustment should be made

Where the absence relates to staff whose contracted time is measured in EMPLOYMENT CONTRACT WORKING SESSIONS, then the lost working sessions should be converted into lost working hours by using the conversion factor of a session representing 3.5 hours.

 

This data element is also known by these names:

Context	Alias
plural	EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD)