Data Views and Standard Log Reports - Projects and Project Directory

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_ProjectClassifications
• vw_ProjectDirectory
• vw_ProjectDirectoryContactsAll
• vw_ProjectDirectoryContactsSpecified

Data Views - Optional

• vw_CompanyInfo
• vw_CompanyInfoSimple
• vw_ContactInfo

Standard Log Reports - Projects

Report Name	Filter Parameters
Active Projects (No Grouping)	EstStartFromDate, EstStartToDate
Active Projects Grouped by Bid Contact	BidContactId, EstStartFromDate, EstStartToDate
Active Projects Grouped by Classification Type	ClassificationType, ClassificationTypeOptionId, EstStartFromDate, EstStartToDate
Active Projects Grouped by PM Contact	PMContactId, EstStartFromDate, EstStartToDate
Active Projects Grouped by Salesperson	SalesContactId, EstStartFromDate, EstStartToDate
InActive Projects	EstStartFromDate, EstStartToDate

Standard Log Reports - Individual Project - Project Directory

Report Name	Filter Parameters
Project Directory Company Listing Grouped By Classification	ProjectId, AddressType, ClassificationType, ClassificationCodeId
Project Directory Company Listing Grouped By TeamLink Role	ProjectId, AddressType, TeamLinkRole
Project Directory Company Listing With Expired Insurance	InsuranceGeneralOrProject, ProjectId
Project Directory Company Listing Without General and Project Specific Insurance	InsuranceGeneralOrProject, ProjectId
Project Directory Company Listing	ProjectId, AddressType
Project Directory Contacts Grouped by Company	ProjectId, AddressType
Project Directory Specified Contacts Grouped by Company	ProjectId, AddressType