Employee Activity Summary

Default Access Rights

This report can be run by the following roles: Manager

Overview

This report returns detailed time entry information per employee, per day, per activity.

Compare with the Detailed Time Record report.

Employee Activity Summary

This report is similar to the Employee Activity Roll-up report, but for each activity, this report gives a summary of the time spent in the activity for each day within the selected time period. You can also run this report for a week or a month and analyze it to identify any trends in how much time is spent in particular activities day after day.

Inputs

  • Employee Filter: Lists the organization on which to report.

  • 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 you want to report on the workdays 1/10/04 through 1/15/04. The workday n a.m.ed 1/10/04 is actually 1/10/04 8:00 a.m. through 1/11/04 8:00 a.m. (in the organization's time zone). It will map differently in GMT. Now let’s also assume that you are reporting on multiple organizations, each with different time zones and day/week boundaries. We are requesting data on 1/10/04 through 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.

  • Organization: The organization to which the employee belongs.

  • Activity: The activity being reported on.

  • Employee Name: The employee being reported on.

  • Employee ID: The ID of the employee.

  • Manager Name: The employee’s manager as of the date of the time period.

  • Start Date: The start day of the time entry.

  • Start Time (HH:MM): The start time of the time entry.

  • End Date: The end day of the time entry.

    A time entry belongs to the day in which its time record begins.

  • End Time (HH:MM): The end time of the time entry.

  • Paid Time (Hours): Returns the paid hours for intersecting portion of time entries.

    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.

  • Total Time (Hours): See paid time.

  • Daily Total: The total time (paid/unpaid/total) for that day, employee, and activity.

  • Group Total: The total time (paid/unpaid/total) for all days for that employee and activity.

  • Combined Total: The total time (paid/unpaid/total) for all days and all employees for that activity.

Detailed Time Record