Summary/Use Case
Report Summary
The Campaign Details report provides a detailed view of active work orders associated with specific campaigns. It includes information on work order status, labor hours, costs, and completion percentages for various tasks under a campaign. This report is valuable for fleet managers to track the progress, labor, and costs associated with ongoing campaigns, ensuring efficient resource allocation and project completion.
Use Case
Monitor the progress and completion rates of active campaigns across facilities.
Evaluate labor and part costs associated with each campaign.
Track and manage work orders tied to specific vehicle campaigns.
Identify areas where additional resources may be required to expedite campaign completion.
Optimize budget allocation by analyzing campaign-specific costs.
Location: Where to Find It
Reports > RTA Standard Reports > Work Order > Campaign Details
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options.
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Facility | Is Between | 1 - 99999 | 1 to 99999 | Range represents all possible facility numbers |
Report Output and Data Elements
The Campaign Details report output displays information sorted by Facility and includes columns that track the specifics of each work order within the campaign. Key highlights include the vehicle associated with each work order, labor and part costs, completion percentage, and total costs per campaign.
Report Output
Report Data Elements - Campaign Overview
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Name | Name of the Campaign |
2 | Description | Description of what the campaign is for |
3 | Due Date | Due date that has been assigned to the campaign |
4 | Type | Indicates whether work is planned or will create a work order upon creation |
5 | Lines | Number of work order lines that will be created from the campaign |
6 | VMRS Code | VMRS Code of the work order (if assigned) |
7 | Job Desc | Description of the VMRS code of the campaign |
8 | Completion % | Percent of the campaign that has been completed |
9 | Total Cost | Cumulative cost of all campaign work |
Report Data Elements - Campaign Dropdown Details
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Vehicle | The vehicle involved in the work order |
2 | Status | Type of order or status (e.g., "Work Order") |
3 | WO # | Unique work order number |
4 | WO Status | Current status of the work order (e.g., "Open") |
5 | Line Status | Assignment status of the work line |
6 | Labor Hours | Hours of labor logged on the work order |
7 | Labor Cost | Cost of the labor recorded |
8 | Part Cost | Cost of parts used in the work order |
9 | Work Order Line Cost | Total cost for each line item in the work order |