Auditor Rate (Month)

Canceled Meal Breaks Rate

Ratio of canceled meals to worked shift count.

canceled_meals_to_worked_shift_ratio

NUMBER

Final Punch Time Edits Rate

Ratio of final punch time edited to final punch count.

final_punch_time_edited _to_final_punch_ratio

NUMBER

High Risk Location Group Number

Unique pattern identifier. Note that -1 indicates an outlier.

auditor_id

NUMBER

Late Out to Early In Exceptions Rate

Ratio of extra time exceptions to extra time and lost time exceptions.

extra_time_exception_ratio

NUMBER

Less than Scheduled

Ratio of lost time exceptions to worked shift count.

lost_time_exception_to_worked_shift_ratio

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

More than Scheduled

Ratio of extra time exceptions to worked shift count.

extra_time_exception_ to_worked_shift_ratio

NUMBER

Punch Deletions Rate

Ratio of deleted punches to final punch count.

deleted_punches_to_ final_punch_ratio

NUMBER

Punch Time Edits Rate

Ratio of punch time edits to final punch count.

punch_time_edits_to_ final_punch_ratio

NUMBER

Rate Change % (Previous Month to Current Month)

Change in Rate as % from previous month to current month.

rate_change_percent

NUMBER

Retro Schedule Edits Rate

Ratio of retro schedule changes to final shift count.

retro_sched_changes_ to_final_shift_ratio

NUMBER

Retro Shift Deletions Rate

Ratio of retro deleted shifts to final shift count.

retro_deleted_shifts_ to_final_shift_ratio

NUMBER

Retro Shift Edits Rate

Ratio of retro shift edits to final shift count.

retro_shift_edits_to_ final_shift_ratio

NUMBER

Risk Indicator

Pattern Indicator for the rate data column configured to be used in pattern identification (-1 for low, 0 for none, 1 for high)

auditor_pattern_indicator

STRING

Risk Name

Description of the pattern found. Represents a list of pattern names in square brackets based on the ratio analyzed. Each pattern is prefixed with +/- to indicate a high/low pattern. Can be null when no pattern is found. E.g. [+extra_time_exception_to_worked_shift_ratio,-punch_time_edits_to_final_punch_ratio] indicates a high extra time exceptions to worked shift ratio combined with a low punch time edits to final punch ratio.

auditor_pattern

STRING

Small Punch Time Edits Rate

Ratio of punch time edited less or equal than 15 mins to final punch count.

final_punch_time_edited_less_or_eq_15min_to_final_punch_ratio

NUMBER

Update Date and Time

Date and Time of freshness of Auditor data.

auditor_data_update_datetime

DATETIME

Year

Calendar Year

year

NUMBER