Data Views and Standard Log Reports - Subcontracts

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple
• vw_SubcontractInfo
• vw_SubcontractInfoSimple
• vw_SubcontractItemsFLS
• vw_SubcontractItemsUnitPrice

Data Views - Optional

• vw_CompanyInfo
• vw_CompanyInfoSimple
• vw_ContactInfo
• vw_JobCostCodes
• vw_ChangeOrderInfo
• vw_ChangeOrderInfoSimple
• vw_WorkOrderInfo
• vw_WorkOrderInfoSimple

Standard Log Reports - Cross Projects - Subcontracts

Report Name	Filter Parameters
Cross Project - Revised Subcontract Summary by Vendor	SubcontractFromDate, SubcontractToDate, SubcontractorCompanyId, BillingType

Standard Log Reports - Individual Project - Subcontracts

Report Name	Filter Parameters
Fixed Lump Sum Subcontract Items Grouped by Prime, Status and Cost Code	ProjectId, PrimeContractId, SubcontractStatus, JCCId
Fixed Lump Sum Subcontract Items Grouped by Prime, Status and Division	ProjectId, PrimeContractId, SubcontractStatus, JCCDivision
Fixed Lump Sum Subcontract Items Grouped by Prime, Status and Owner Code	ProjectId, PrimeContractId, SubcontractStatus, OwnerCostCodeId
Subcontracts and Approved SCOs Grouped By Prime and Billing Type	ProjectId, PrimeContractId
Subcontracts Grouped by Prime Contract and CO	ProjectId, PrimeContractId, COId, SubcontractStatus
Subcontracts Grouped by Prime Contract, Status and Billing Type	ProjectId, PrimeContractId, SubcontractStatus, BillingType
Unit Price Subcontract Items Grouped by Prime, Status and Cost Code	ProjectId, PrimeContractId, SubcontractStatus, JCCId