Data views and standard log reports for daily logs
Access the reports
-
Go to Reports.
-
Select Project Specific Reports in the Report Category dropdown.
-
Select Daily Logs in the Report Sub-Category dropdown.
-
Select either Single Project Reports or Multi-Project Reports and select one or more relevant projects.
-
Select the appropriate report in the Standard Reports section.
Alternatively, you can access the reports using one of the following options on the Project Home page:
- Select Daily Logs in the Documentation section and select Reports on the Daily Logs page.
- Select Documentation Overview in the Documentation section and select the reports icon (
) in the Daily Logs row of the Stats section.
Primary data views
- vw_ProjectInfo
- vw_ProjectInfoSimple
- vw_DailyLogInfo
- vw_DailyLogAcivities
- vw_DailyLogManpower
- vw_DailyLogMajorEquipment
- vw_DailyLogConditions
Optional data views
- vw_CompanyInfo
- vw_CompanyInfoSimple
- vw_ContactInfo
- vw_PrimeContractInfo
- vw_PrimeContractInfoSimple
Multi-project standard log reports for daily logs
| Report Name | Filter Parameters |
| Cross Project - Daily Log Activities Grouped by Job Cost Code | ProjectIds, RecordedByContactId, JCCId, ActivityLocation, DailyLogDateFrom, DailyLogDateTo |
| Cross Project - Daily Log Activities Grouped by Recorded By Contact | ProjectIds, RecordedByContactId, ActivityType, ActivityLocation, DailyLogDateFrom, DailyLogDateTo |
| Cross Project - Daily Log Activities Grouped by Type | ProjectIds, RecordedByContactId, ActivityType, ActivityLocation, DailyLogDateFrom, DailyLogDateTo |
| Cross Project - Daily Log Major Equipment Grouped by Owner | ProjectIds, RecordedByContactId, EqpOwnerCompanyId, DailyLogDateFrom, DailyLogDateTo |
| Cross Project - Daily Log Manpower Grouped by Company | ProjectIds, RecordedByContactId, ManpowerCompanyId, DailyLogDateFrom, DailyLogDateTo |
| Cross Project - Daily Log Manpower Grouped by Job Cost Code | ProjectIds, RecordedByContactId, JCCId, ManpowerCompanyId, DailyLogDateFrom, DailyLogDateTo |
| Cross Project - Daily Log Manpower Grouped by Year and Week | ProjectIds, RecordedByContactId, ManpowerCompanyId, DailyLogDateFrom, DailyLogDateTo |
Single project standard log reports for 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 |