Why:
You need a report that lists the equipment and/or operator for on a
load-by-load basis. This report is designed to be used by users that track
their equipment on each load ticket.
Focus:
Focus of Report is to provide a detailed listing, by activity, of the
equipment and worker who worked each load. The report covers both
company-owned equipment and employees, as well as contractor-owned equipment and
contract operators. The report is useful as an audit tool to ensure that
you have listed the correct workers and equipment on each load.
- Loads are limited to those from block where equipment/workers are
assigned by load
- Block are limited to those where equipment/workers are tracked on load
slips
- Report only covers all equipment -- company-owned and contractor equipment
- No calculators must be run to generate the data for the report.
- Report includes subcontractor drivers and employee operators
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.
- Note: for report information that is based on load tickets, the report uses the Date Out (not the Date In).
- Block: You can select any or all of your block. Block are
filtered to show only those where equipment/workers are tracked on load
slips
- The "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.
Detailed Description:
The report shows payments due for each load on an activity-by-activity basis. The
columns are:
- Block Code: Source Block of the loads
- Date: Date of the load
- Ticket: Load ticket number
- Load No: Internal load tracking number (unique number assigned to
each load)
- Date: Exit date/time of the load
- Destination: Destination of the load
- Net Weight: Net (Gross less Tare) load weight
- Volume: Volume of the load. Unit of measure is that defined
for the source block
- Activity: Work activity performed
- Employee: Operator of the unit -- may be employee or contract
worker
- Equipment: Equipment on the load
- Load Percent: Percent of work for the load. In cases where a
load is split between two equipment units, there will be two rows where the
percent will represent the percentage of work performed (and pay received)
by each.
Key Notes:
- This report relies on activities (and equipment) being tracked on each
load ticket. If the equipment is not tracked by load ticket, the
report will be meaningless.
- Where an equipment unit is assigned a fraction of a load (the load
percentage is between 0 and 1), the weight and volume for the loads are not
adjusted. The fractional share (Load Percent) is displayed in the last
column of the report.
Report:
Example:
Example Report 1
