Data Views and Standard Log Reports - Daily Logs

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PhotosAlbumNames
• vw_PhotosAlbumImages
• vw_Photos

Data Views - Optional

• vw_CompanyInfo
• vw_CompanyInfoSimple
• vw_ContactInfo
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple

Standard Log Reports - Individual Project - Daily Logs

Report Name	Filter Parameters
Daily Log Activities by Year and Week	ProjectId, PrimeContractId, RecordedByContactId, ActivityType, ActivityLocation, DailyLogDateFrom, DailyLogDateTo
Daily Log Activities Grouped by Prime and Description	ProjectId, PrimeContractId, JCCId, ActivityDescription, ActivityLocation, EntryType, DailyLogDateFrom, DailyLogDateTo
Daily Log Activities Grouped by Prime Contract and Job Cost Code	ProjectId, PrimeContractId, JCCId, RecordedByContactId, ActivityType, ActivityLocation, EntryType, DailyLogDateFrom, DailyLogDateTo
Daily Log Activities Grouped by Type	ProjectId, PrimeContractId, RecordedByContactId, ActivityType, ActivityLocation, DailyLogDateFrom, DailyLogDateTo
Daily Log Major Equipment by Owner	ProjectId, PrimeContractId, RecordedByContactId, EqpOwnerCompanyId, DailyLogDateFrom, DailyLogDateTo
Daily Log Major Equipment by Year and Week	ProjectId, PrimeContractId, RecordedByContactId, EqpOwnerCompanyId, DailyLogDateFrom, DailyLogDateTo
Daily Log Manpower by Company	ProjectId, PrimeContractId, RecordedByContactId, ManpowerCompanyId, DailyLogDateFrom, DailyLogDateTo
Daily Log Manpower by Year and Week	ProjectId, PrimeContractId, RecordedByContactId, ManpowerCompanyId, DailyLogDateFrom, DailyLogDateTo
Daily Log Summary by Year and Week	ProjectId, PrimeContractId, RecordedByContactId, DailyLogDateFrom, DailyLogDateTo
Daily Log Summary Grouped by Recorded By Contact	ProjectId, PrimeContractId, RecordedByContactId, DailyLogDateFrom, DailyLogDateTo
Daily Log Weather and Field Conditions by Year and Week	ProjectId, PrimeContractId, RecordedByContactId, DailyLogDateFrom, DailyLogDateTo