Data Views and Standard Log Reports - Subcontract Change Orders (SCO)

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple
• vw_SubcontractInfo
• vw_SubcontractInfoSimple
• vw_SCOInfo
• vw_SCOInfoSimple
• vw_SCOItems

Data Views - Optional

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

Standard Log Reports - Individual Project - SCOs

Report Name	Filter Parameters
SCO Items Grouped by Prime Contract, Status and Cost Code	ProjectId, PrimeContractId, SCOStatus, JCCId
SCO Items Grouped by Prime Contract, Status and Division	ProjectId, PrimeContractId, SCOStatus, JCCDivision
SCO Items Grouped by Prime Contract, Status and Owner Code	ProjectId, PrimeContractId, SCOStatus, OwnerCostCodeId
SCOs Grouped by Prime Contract, CO and Subcontract	ProjectId, PrimeContractId, COId, SCOStatus
SCOs Grouped by Prime Contract, Initiated By and Subcontract	ProjectId, PrimeContractId, SCOStatus, SCOInitiatedBy
SCOs Grouped by Prime, Subcontract and Status	ProjectId, PrimeContractId, SCOStatus, SCOInitiatedBy