Auditor Count (Month)

The Auditor Count (Month) entity provides data related to timecard transactions for the current month, including the addition, edit, or removal of meals, punches, paycode edits, and exceptions. It also provides the change in the Auditor Count from the previous month to the current month as a percentage.

Supported Dataview types

Employee Dataview	Business Structure Dataview
X

Data granularity

Provides one row per primary location type per month.

Columns

Label	Description	Key	Data Type
All Exceptions Count	Number of exceptions.	exception_count	NUMBER
All Punch Edits Count	Number of punch edits.	punch_edits_count	NUMBER
All Punches Count	Number of punches entered.	punch_count	NUMBER
All Shifts Count	Number of shifts created.	shift_count	NUMBER
Auditor Primary Job	The primary job of the employee at the time of Auditor count transaction.	job	STRING
Auditor Primary Job Description	The primary job of the employee at the time of Auditor count transaction.	job_dsc	STRING
Cancelled Meal Break Count	Number of canceled meals.	canceled_meals_count	NUMBER
Count Change % (Previous Month to Current Month)	Change in Count as % from previous month to current month.	count_change_percent	NUMBER
Deleted Punch Count	Number of deleted punches.	deleted_punches_count	NUMBER
Early In Count	Number of early-in exceptions.	in_early_count	NUMBER
Early Out Count	Number of early-out exceptions.	out_early_count	NUMBER
Extra Time Exception Count	Number of extra time exceptions (i.e., early-in and late-out).	extra_time_count	NUMBER
Final Punch Time Edit Count	Number of punch edits changing the punch time when comparing the first and last punch transactions (i.e. final punch).	final_punch_time_edited_count	NUMBER
Final Punches Count	Number of non-deleted punches.	final_punch_count	NUMBER
Final Shifts Count	Number of non-deleted shifts.	final_shift_count	NUMBER
Forward Schedule Edits Count	Number of schedule changes done before or up to the start of the shift. Counts shift edits and deleted shifts.	forward_sched_changes_count	NUMBER
Forward Shift Deletions Count	Number of shifts deleted before or up to the start of the shift.	forward_deleted_shifts_count	NUMBER
ForwardShift Edits Count	Number of shift edits done before or up to the start of the shift. Only applies to non-deleted shifts.	forward_shift_edits_count	NUMBER
Late In Count	Number of late-in exceptions.	in_late_count	NUMBER
Late Out Count	Number of late-out exceptions.	out_late_count	NUMBER
Lost Time Exception Count	Number of lost time exceptions (i.e., early-out and late-in).	lost_time_count	NUMBER
Month Name	Name of the calendar month.	month_name	STRING
Month Number	Number of the calendar month.	month	NUMBER
Month Year Name	Name of the calendar month and calendar year.	month_year_name	STRING
Punch Time Edit Count	Number of punch edits changing the punch time.	punch_time_edits_count	NUMBER
Retro Schedule Edit Count	Number of schedule changes done after the start of the shift. Only applies to non-deleted shifts. Counts shift edits and deleted shifts.	retro_sched_changes_count	NUMBER
Retro Shift Deletion Count	Number of shifts deleted after the start of the shift.	retro_deleted_shifts_count	NUMBER
Retro Shift Edit Count	Number of shift edits done after the start of the shift. Only applies to non-deleted shifts.	retro_shift_edits_count	NUMBER
Small Punch Time Edit Count	Number of punch edits changing the punch time less than or equal to 15 minutes when comparing the first and last punch transactions (i.e. final punch).	final_punch_time_edited_less_or_ eq_15min_count	NUMBER
Update Date and Time	Date and Time of freshness of Auditor data.	auditor_data_update_datetime	DATETIME
Worked Shifts Count	Number of worked shifts.	worked_shift_count	NUMBER
Year	Calendar Year.	year	NUMBER

Related entities

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
	X

Relationship

One-to-One	One-to-Many
X