|
Time - Daily, by Activity Type (#404)
|
|
Why:
You need a report that shows a detailed listing of time by production,
maintenance, down, non-work, etc., by employee, by day.
Focus:
Focus of Report is to show a listing of hours worked, by basic activity type.
- Report only covers your employees
- The employee pay calculator need not be run in order for entries to
appear in this report.
Selection Window:
The selection window allows you to filter the report by:
- Date Range: You can either select a pay period, or you can simply enter the start and end date directly into the selection criteria window. The Period selection is merely a short-cut for entering a date range, so you can always edit the start and end dates to be any date you choose. For example, you can pick a period defined as 8/1/2004 to 8/12/2004, and then extend the end date by three days to 8/15/2004. If you leave the end time blank, the program will assume you want the entire day for the end date. In the example below, the start date/time is 8/1/2004 00:00:00 (a blank is assumed to be time 00:00:00) and the end date/time is 8/15/2004 00:00:00. Because the end date time is blank (or 00:00:00), the program assumes you want the whole day of the 15th and makes the end date/time 8/16/2004 00:00:00. In the selection query, the program returns records whose start date/time is greater than OR equal to the start/date time and strictly less than the end date/time.
- Employees. You can select any or all employees.
- Your report can be sorted by date or employees. The report sorted by
date is shown in Example Report 1 below; the report sorted by employee is
shown in Example Report 2.
- The "Summary Data Only" will suppress report detail and only
show subtotals and totals
- The "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.

Detailed Description:
The selection criteria determine the date range and employees that appear in
the report. The report is based on the time entries exclusively for Employees;
contractor time
entries are excluded.
The report shows the hours by employee, by type of
basic type of activity.
What is a "Basic Type of Activity"?
Answer: When time slips are entered, you are required to identify the activity that
is performed by the worker/equipment (see below)

Each activity is assigned to a basic "Pay Activity Type," such as
"REG PROD", "EQ_MAINT", "TRAVEL", etc.. These basic activity types
are used to classify the more detailed pay activities. The basic
activities are available under Setup | Pay Activity Types and are show below:

Note that although there are 13 pay activities above, they are all mapped
into one of six basic activity types.
These basic activities for used to classify all hours in the "Time -
Daily, by Activity Type" report. Each basic activity type has its own column in the
report.
The report shows the hours for each employee. The
columns are:
- Date. The date of the time entry (not date paid)
- Employee: Employee name on the time slip
- Total Hours: Total hours on the time slip(s) for the day
- Basic Activity Columns (Maintenance, Non Work Paid Time, Other Chargeable,
...). The columns show the hours by type of basic activity.
Key Notes:
- Report is only for employees
Report:
Example One:
Example Report 1 shows the report where the selection "Sort by
Date/Time" has been selected This version of the report is useful in
that it shows the hours by day for all your employees with a breakdown by
production and other types of time.
Example Report 1
Example Two:
Example Report 2 shows the report where the selection "Sort by Employee" has been selected. This version of the report is useful in that
it shows the hours history for each employee and provides a total by basic
activity type over the date range selected.
Example Report 2