Daily Time Record Summary

Default Access Rights

This report can be run by the following roles: Manager

Overview

Shows a daily aggregate of employee time record information. Time record entry information is aggregated by workday and employee, organization, or supervisor (depending on the Group by option).

For the Group by Employee option, there is an entry for each time record (normally one per day). All time record entries that belong to a time record that begins on same workday are counted on that workday. The time entry itself does not actually have to begin on that workday.

Daily Time Record Summary

When grouped by employee, supervisors or managers can use this report to verify the amount of time worked by individual employees during a specific period, including verifying hours worked on specific days and totals for a pay period. Managers can compare this data with submitted timesheets or other work records to find discrepancies.

Inputs

Employee Filter: Indicates the set of employees to report on. (This report is in organization time zone.)
Group by:
- Employee: Aggregates time entries per employee.
- Organization: Aggregates time entries per organization.
- Supervisor: Aggregates time entries per supervisor.
Time Frame (reports that are by day and in organization time zone):
- Last <X> days: This field specifies which days to report on. This mode should return the last X completed workdays for an organization, however, as implemented, it sets the From-date to the current day in the time zone of the SQL Server computer minus X days and the To-date to the current day in the time zone of the SQL Server computer. Depending on the difference between the SQL Server computer's time zone and the organization's time zone and day/week boundary, this may not be the last X completed workdays.
- From/To date (reports that are in organization time zone): These reports are generally by day or by week. Here, by day/week means the organization's workday or workweek, considering day and week boundaries. So, let’s say we want to report on the workdays 1/10/04 - 1/15/04. The workday named, 1/10/04, is actually 1/10/04 8:00am - 1/11/04 8:00am (in the organization's time zone). It will map differently in GMT. Now let’s also assume that we are reporting on multiple organizations, each with different time zones and day/week boundaries. We are requesting data on 1/10/04 - 1/15/04, but this could map to different absolute times for each organization. For example:
  
  Org A: 1/10/04 3:00 a.m. - 1/11/04 3:00 a.m., 1/11/04 3:00 a.m. - 1/12/04 3:00 a.m....
  
  Org B: 1/10/04 8:00 a.m. - 1/11/04 8:00 a.m., 1/11/04 8:00 a.m. - 1/12/04 8:00 a.m....

Outputs

When the report has been run using the Last <x> days parameter, the report header’s From field shows the value of that parameter, such as From: Last 30 days. This is in contrast to previous releases, where the From field showed a date.

Group Name: Employee, Organization, or Supervisor name.
Employee ID: Group by employee only.
Manager Name: The active manager given the input date (Group by employee only).
Date: The workday being aggregated (Group by organization and supervisor only).
Start Date: The workday that the time record begins (Group by employee only).
Start Time (HH:MM): The time of day that the time record begins (Group by employee only).
End Date: The workday that the time record ends (Group by employee only)
End Time (HH:MM): The time of day that the time record ends (Group by employee only).
Paid Time (Hours): Paid hours are counted as follows. If a time record starts on some workday, then all time entries that belong to that time record are counted on that workday.

In reports that show hours, minutes are shown as decimal portions of an hour. For example, 2 hours 30 minutes would be shown as 2.5 hours.
Unpaid Time (Hours): See paid time above.
Total Time (Hours): See paid time previously.