SSRS Report Directory: Employee Reports

This report shows the regular hours, overtime hours and total hours for employees with approved time cards for the week ending date you enter.

By default, the week ending date will be the previous Friday. The results can be grouped by Employee, Shop, Shift, Status, Classification and Pay Grade. Hours are displayed in both the hour and minute and the hour and hundredths of a minute formats.

This report changed to use time card end date instead of date approved. This prevents time cards from previous periods from showing up on the report. The report will only display one line per employee.

The Driver Cost Detail Report is very similar to the Unit Cost Summary Report except the primary grouping is by Driver ID instead of Unit ID. The report will provide the Cost, Utilization and Cost Per Mile (CPM) for each unit assigned to a driver with the cost and CPM reflecting the date range the unit was assigned to the driver.

For example, if you run the report from 1/1/2008 to 3/31/2008 and the unit was assigned to the driver on 3/1/2008, the report will only reflect the cost incurred between 3/1/2008 and 3/31/2008 for that driver. Similarly, if you run the report for a date range where a unit was not assigned to a driver, that driver will not appear on the report.

The report can be sorted by Unit, Total CPM, Maintenance CPM, Fuel CPM and Tire CPM for each driver.

The Driver Cost Summary Report is the summary version of the Driver Cost Detail Report. It does not report any unit detail, only the totals for each driver. The report can be sorted by Driver, Total CPM, Maintenance CPM, Fuel CPM and Tire CPM for each driver.

This report displays a list of all drivers, along with their contact information, shop, shift and driver’s license information. The report can be sorted by driver first name, driver last name, primary shift or status.

List each employee’s indirect labor charges by indirect labor code based on the selection criteria and date range. Both Open and Closed indirect charges will be returned when this report is run.

Lists each employee’s direct labor and indirect labor charges based on the selection criteria and date range.

The report returns both Open and Closed indirect charges when you run it.

This report displays a list of the employees and shows how their time breaks down by direct and indirect categories. Each order, the login and logout times, the unit, component code and description, repair reason, cause and correction, and total time are displayed.

The report includes a pie chart on the last page that shows total direct and indirect time spent in hours, and in percentage of time. The report uses the database function [dbo].[TMT_ORDERLNACT_CAUSE_CORRECTION].

This report displays a list of all employees, along with their contact information, shop, shift and status. The report can be sorted by first name, last name, primary shift, and status.

This report displays an individual employee and information, such as name, shop, division, department, classification, shift, address, phone numbers, hired date, and manager. For Employees, the Direct and Indirect Labor logged for the week and the Top 10 Repair Orders. For Drivers, the units assigned to the driver will be shown.

The Employee Time Analysis Report provides a detailed analysis for the labor time entered through the Interactive Works Station. The report breaks down each employee’s labor hours by Repair Order total, Indirect Total, Lunch/Break Total, Idle Time Total, Total shift Time and Total Paid Time. Time for each category is listed in Hours: Minutes and Hours: Hundredths format.

This report displays an employee’s time card. The report includes start and end times, description of job, order number, unit and component. The report also has a graph and chart that break down hours logged on each task, and a graph that shows the percentage of direct time worked.

The Estimated Time Vs. Actual Time Report lists each employee’s actual time and compares it to the estimated time, SRT Time or Flat Rate Time for the Jobcode assigned to the employee section assignment on the repair order. It may also be run for a component code range.

Notes:

The Mechanic Time Vs. Billed Hours Report lists each employee’s actual time and compares it to the time billed on invoices.

The report is designed to return approved time cards for a week from Sunday through Saturday based on the date provided. Total time spent each day by each employee for Repair Orders, Indirect Orders, Idle Time, and Breaks are shown in the report and is converted into hundreds.

The report lets you print multiple time cards for one or more employees.

The TINA Employee Time Card Report returns for each day in a date range the clocking/out time before lunch, the clock in/out time after lunch, the paid hours for the day and a total running hours paid for the date range entered.