Final Attendance Calculation - File Layout and Data Mapping

The default file names for the Final Attendance Calculation report are:

PDF: EMIS Staff Final Attendance_<MMDDYYYY_hhmmss>.pdf
Excel: EMIS Staff Final Attendance_<MMDDYYYY_hhmmss>.csv

The following table shows the columns, column names, descriptions, and data sources or valid values for the Final Attendance Calculation report’s .csv file format.

Column	Column Name	Description	Data Source or Valid Values
A	EMPLOYEE NUMBER	The unique employee identification number.	Retrieved from the Employee Number field on the Attendance Information page.
B	EMPLOYEE NAME	The employee’s full name.	Retrieved from the Last Name and First Name fields on the Demographic tab of the EMIS Staff Report page. The system concatenates these values in the "Last Name, First Name" format during the Final Attendance calculation.
C	LEAVE DATE	The start date of the leave record being processed.	Retrieved from the Start Date field on the Attendance Information page.
D	STATUS MESSAGE	A message describing the update action performed during the Final Attendance calculation. Contains messages such as: Updated: Added X.X Absence days Long term illness days updated from X to Y	Calculated during the data load process. The system automatically generates this message based on the type of update performed.