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