Data views and standard log reports for work orders (WOs)
-
Go to Reports.
-
Select Project Specific Reports from the Report Category dropdown.
-
Select Work Orders from the Report Sub-Category dropdown.
-
Select Single Project Reports and select the Project from the dropdown.
-
Select the appropriate report in the Standard Reports tab.
Alternatively, you can access the reports using one of the following options on the Project Home page:
- Select Work Orders in the Documentation section and select Reports on the Work Orders page.
- Select Documentation Overview in the Documentation section and select the reports icon (
) in the Work Orders row of the Stats section.
Primary data views
- vw_ProjectInfo
- vw_ProjectInfoSimple
- vw_PrimeContractInfo
- vw_PrimeContractInfoSimple
- vw_WorkOrderInfo
- vw_WorkOrderInfoSimple
- vw_WorkOrderItems
Optional data views
- vw_CompanyInfo
- vw_CompanyInfoSimple
- vw_ContactInfo
- vw_JobCostCodes
- vw_PrimeInvoiceInfo
- vw_PrimeInvoiceItemsCostPlus
Single project standard log reports for work orders
| Report name | Filter parameters |
|---|---|
| WO Items Grouped by Prime Contract, Billable Status and Cost Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, WOBillableStatus, JCCId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
| WO Items Grouped by Prime Contract, Closed Status and Cost Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, JCCId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
| WO Items Grouped by Prime Contract, Closed Status and Division | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, JCCDivision, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
| WO Items Grouped by Prime Contract, Closed Status and Owner Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, OwnerCostCodeId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
| WO Items Grouped by Prime Contract, Issued To and Cost Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, JCCId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
| Work Orders Grouped by Closed Status And Reference Field | ProjectId, PrimeContractId, EstORActual, Reference, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
| Work Orders Grouped by Prime Contract and Closed Status | ProjectId, PrimeContractId, EstORActual, WOIssuedToCompanyId, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
| Work Orders Grouped by Prime Contract, Billable Status and Type | ProjectId, PrimeContractId, EstORActual, WOType, WOApprovalStatus, WOClosedStatus, WOBillableStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
| Work Orders Grouped by Prime Contract, Closed Status and Issued To | ProjectId, PrimeContractId, EstORActual, WOIssuedToCompanyId, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
| Work Orders Grouped by Prime Contract, Closed Status and Type | ProjectId, PrimeContractId, EstORActual, WOType, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |