Data Views and Standard Log Reports - Work Orders (WO)

Data Views - Primary

  • vw_ProjectInfo
  • vw_ProjectInfoSimple
  • vw_PrimeContractInfo
  • vw_PrimeContractInfoSimple
  • vw_WorkOrderInfo
  • vw_WorkOrderInfoSimple
  • vw_WorkOrderItems

Data Views - Optional

  • vw_CompanyInfo
  • vw_CompanyInfoSimple
  • vw_ContactInfo
  • vw_JobCostCodes
  • vw_PrimeInvoiceInfo
  • vw_PrimeInvoiceItemsCostPlus

Standard Log Reports - Individual Project - Work Orders (WO)

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