Project Execution
The Project Execution dataset provides a detailed view into your project's daily operational health by connecting on-site activities with core administrative records. Use this data set to create custom reports.
To learn how permissions impact which objects are available to users in a report, see How do 360 report permissions work?
To learn about the different types of join relationships, see How do I use joins to connect data in 360 Reports?
Summary of Join Relationships
Object | Direct Joins | Indirect Joins via Named Object in Bold | Notes |
|---|---|---|---|
Action Plan | Action Plan Approver, | Action Plan Line Item Record: Correspondence, Form, Inspection, Meeting, Observation, Punch Item, Submittal Action Plan Line Item Reference: Correspondence, Drawing, Form, Meeting, Observation, Specification Section, Submittal | None |
Action Plan Approver | Action Plan, Location, Project | None | None |
Action Plan Line Item | Action Plan, Action Plan Line Item Assignee, Action Plan Line Item Record, Action Plan Line Item Record Request, Action Plan Line Item Reference, Location, Project | Action Plan Line Item Record: Correspondence, Form, Inspection, Meeting, Observation, Photo, Submittal Action Plan Line Item Reference: Correspondence, Drawing, Form, Meeting, Observation, Specification Section, Submittal Daily Log Dumpster: Incident Action | None |
Action Plan Line Item Assignee | Action Plan, Action Plan Line Item, Location, Project | None | None |
Action Plan Line Item Record | Action Plan, Action Plan Line Item, Action Plan Line Item Record Request, Correspondence, Form, Inspection, Location, Meeting, Photo, Project, Submittal | None | None |
Action Plan Line Item Record Request | Action Plan, Action Plan Line Item, Action Plan Line Item Record, Location, Project | Action Plan Line Item Record: Correspondence, Form, Inspection, Observation, Photo, Submittal | None |
Action Plan Line Item Reference | Action Plan, Action Plan Line Item, Correspondence, Location, Meeting, Observation, Project, Specification Section, Submittal | None | None |
Action Plan Receiver | Action Plan, Location, Project | None | None |
Change Event | Change Event Line Item, Correspondence | None | None |
Change Event Line Item | Change Event, Correspondence Assignee, Meeting, Project | None | None |
Commitment | Commitment Line Item, Project | Commitment Line Item: Daily Log Productivity | None |
Commitment Line Item | Commitment, Daily Log Productivity, Project | None | None |
Company Folder/Document | None | None | None |
Coordination Issue | Action Plan Line Item, Drawing Markup Link, Location, Observation, Project, RFI | Drawing Markup Link: Drawing | None |
Correspondence | Action Plan Line Item Record, Action Plan Line Item Reference, Change Event, Change Event Line Item, Correspondence Assignee, Correspondence Distribution List, Correspondence Response, Correspondence Schedule Task, Drawing Markup Link, Location, Project, RFI, RFI Ball in Court, Schedule Task, Specification Section | Action Plan Line Item Record: Action Plan, Action Plan Line Item, Action Plan Line Item Record Request Action Plan Line Item Reference: Action Plan, Action Plan Line Item Drawing Markup Link: Drawing | None |
Correspondence Assignee | Correspondence, Location, Project, RFI, Specification Section | None | None |
Correspondence Distribution List | Correspondence, Location, Project, RFI, Specification Section | None | None |
Correspondence Response | Correspondence, Location, Project, RFI, Specification Section | None | None |
Correspondence Schedule Task | Correspondence, Location, Project, RFI, Schedule Task | None | None |
Daily Log Accident | Project | None | None |
Daily Log Completion | Project | None | None |
Daily Log Construction Report | Project | None | None |
Daily Log Delay | Location, Project | None | None |
Daily Log Delivery | Project | None | None |
Daily Log Dumpster | Project | None | None |
Daily Log Equipment | Location, Project | None | None |
Daily Log Inspection | Location, Project | None | None |
Daily Log Manpower | Location, Project | None | None |
Daily Log Note | Location, Project | None | None |
Daily Log Observed Weather Condition | Project | None | None |
Daily Log Phone Call | Project | None | None |
Daily Log Plan Revision | Project | None | None |
Daily Log Productivity | Commitment Line Item, Project | Commitment Line Item: Commitment | None |
Daily Log Quantity | Location, Project | None | None |
Daily Log Safety Violation | Project | None | None |
Daily Log Scheduled Work | Project | None | None |
Daily Log Scheduled Work Task | Project | None | None |
Daily Log Visitor | Project | None | None |
Daily Log Waste | Project | None | None |
Drawing | Drawing Markup Link, Inspection Item Reference | Action Plan Item Reference: Action Plan, Action Plan Line Item Drawing Markup Link: Coordination Issue, Folder/Document, Inspection, Observation, Photo, Punch Item, RFI, Submittal Inspection Item Reference: Inspection, Inspection Item, Inspection Schedule | None |
Drawing Markup Link | Coordination Issue, Drawing, Form, Folder/Document, Inspection, Observation, Photo, Project, Punch Item, RFI, Submittal | None | None |
Equipment | Inspection, Project | None | None |
Folder/Document | Drawing Markup Link, Folder/Document Watcher, Project | Drawing Markup Link: Drawing | None |
Folder/Document Watcher | Folder/Document, Project | None | None |
Form | Inspection Item Reference, Project | Action Plan Line Item Record: Action Plan, Action Plan Line Item Action Plan Line Item Reference: Action Plan, Action Plan Line Item Inspection Item Reference: Inspection, Inspection Schedule Inspection Item: Inspection Item Reference | None |
Incident | Incident Action, Incident Alert, Incident Distribution Member, Incident Injury Body Part, Incident Record, Location, Observation, Project | None | None |
Incident Action | Form, Location, Observation, Project | Observation: Action Plan Line Item, Inspection Item | None |
Incident Alert | Form, Location, Project | None | None |
Incident Distribution Member | Incident, Location, Project | None | None |
Incident Injury Body Part | Incident, Location, Project | None | None |
Incident Record | Form, Location, Project | None | None |
Incident Witness Statement | Incident, Location, Project | None | None |
Inspection | Action Plan Line Item Record, Drawing Markup Link, Equipment, Inspection Assignee, Inspection Distribution List, Inspection Item, Inspection Item Activity, Inspection Item Comment, Inspection Item Reference, Inspection Item Signature Request, Inspection Request, Inspection Signature Request, Location, Observation, Observation Activity, Observation Distribution Member, Project, Specification Section | Action Plan Line Item Record: Action Plan, Action Plan Line Item, Action Plan Line Item Record Request Drawing Markup Link: Drawing Inspection Item Reference: Drawing, Form, Photo | None |
Inspection Assignee | Inspection, Location, Project, Specification Section | None | None |
Inspection Distribution List | Inspection, Location, Project, Specification Section | None | None |
Inspection Item | Inspection, Inspection Item Activity, Inspection Item Comment, Inspection Item Reference, Inspection Item Signature Request, Location, Observation, Observation Activity, Observation Distribution Member, Project, Specification Section | Inspection Item Reference: Drawing, Form, Photo | None |
Inspection Item Activity | Inspection, Inspection Item, Location, Project, Specification Section | None | None |
Inspection Item Comment | Inspection, Inspection Item, Location, Project, Specification Section | None | None |
Inspection Item Reference | Drawing, Form, Inspection, Inspection Item, Inspection Schedule, Location, Photo, Project | None | None |
Inspection Item Signature Request | Inspection, Inspection Item, Location, Project | None | None |
Inspection Schedule | Inspection, Inspection Item Reference, Inspection Schedule Assignee, Inspection Schedule Distribution List, Project | None | None |
Inspection Schedule Assignee | Inspection Schedule, Project | None | None |
Inspection Schedule Distribution List | Inspection Schedule, Project | None | None |
Inspection Signature Request | Inspection, Location, Project, Specification Section | None | None |
Instruction | Project | None | None |
Location | Action Plan, Action Plan Approver, Action Plan Line Item, Action Plan Line Item Assignee, Action Plan Line Item Recor, Action Plan Line Item Record Request, Action Plan Line Item Reference, Action Plan Receiver, Correspondence, Correspondence Assignee, Correspondence Distribution List, Correspondence Response, Correspondence Schedule Task, Daily Log Accident, Daily Log Delay, Daily Log Equipment, Daily Log Inspection, Daily Log Manpower, Daily Log Note, Daily Log Observed Weather Condition, Daily Log Quantity, Incident, Incident Action, Incident Alert, Incident Distribution Member, Incident Injury Body Part, Incident Record, Incident Witness Statement, Inspection, Inspection Assignee, Inspection Distribution List, Inspection Item, Inspection Item Activity, Inspection Item Comment, Inspection Item Signature Request, Inspection Signature Request, Observation, Observation Activity, Observation Distribution Member, Photo, Project, Punch Item, Punch Item Assignee, Punch Item Ball in Court, Punch Item Distribution Member, RFI, RFI Assignee, RFI Ball in Court, RFI Distribution List, RFI Response, Submittal, Submittal Approver, Submittal Ball in Court, Submittal Distribution List | None | None |
Meeting | Action Plan Line Item Record, Action Plan Line Item Reference, Change Event, Change Event Line Item, Meeting Attendee, Meeting Item, Meeting Item Assignee, Project | Action Plan Line Item Record: Action Plan, Action Plan Line Item Action Plan Line Item Reference: Action Plan, Action Plan Line Item | None |
Meeting Attendee | Meeting, Project | None | None |
Meeting Item | Meeting, Project | None | None |
Meeting Item Assignee | Meeting, Project | None | None |
Observation | Action Plan Line Item Record, Action Plan Line Item Reference, Change Event, Coordination Issue, Drawing Markup Link, Incident, Incident Action, Inspection, Inspection Item, Location, Observation Activity, Observation Distribution Member, Specification Section | Action Plan Line Item Record: Action Plan, Action Plan Line Item, Action Plan Line Record Request Action Plan Line Item Reference: Action Plan, Action Plan Line Item Drawing Markup Link: Drawing | None |
Observation Activity | Inspection, Inspection Item, Location, Observation, Project, Specification Section | None | None |
Observation Distribution Member | Inspection, Inspection Item, Location, Observation, Project, Specification Section | None | None |
Photo | Action Plan Line Item Record, Drawing Markup Link, Inspection Item Reference, Location, Project | Action Plan Line Item Record: Action Plan, Action Plan Line Item, Action Plan Line Item Record Request Drawing Markup Link: Drawing Inspection Item Reference: Inspection, Inspection Item, Inspection Schedule | None |
Project | All data objects except Company Folder/Document and Project | None | None |
Punch Item | Drawing Markup Link, Location, Punch Item Assignee, Punch Item Ball in Court, Punch Item Distribution Member | Drawing Markup Link: Drawing | None |
Punch Item Assignee | Location, Punch Item | None | None |
Punch Item Ball in Court | Location, Punch Item | None | None |
Punch Item Distribution Member | Location, Punch Item | None | None |
RFI* | Change Event, Change Event Line Item, Correspondence Distribution List, Correspondence Response, Drawing Markup Link, Location, RFI Assignee, RFI Ball in Court, RFI Distribution List, RFI Response, Specification Section | Drawing Markup Link: Drawing | None |
RFI Assignee | Location, RFI, Specification Section | None | None |
RFI Ball in Court | Location, RFI, Specification Section | None | None |
RFI Distribution List | Location, RFI, Specification Section | None | None |
RFI Response | Location, RFI, Specification Section | None | None |
Schedule Calendar Item | None | None | None |
Schedule Lookahead | Schedule Lookahead Task | Schedule Lookahead Task: Schedule Task | None |
Schedule Lookahead Task | Schedule Lookahead, Schedule Task | None | None |
Schedule Task | Coordination Issue, Correspondence Schedule Task, Schedule Lookahead Task, Schedule Task Change, Schedule Task Request, Submittal | Schedule Lookahead Task: Schedule Task | None |
Schedule Task Change | Schedule Task | None | None |
Schedule Task Request | Schedule Task | None | None |
Specification Section | Action Plan Line Item Reference, Coordination Issue, Correspondence, Correspondence Assignee, Correspondence Distribution List, Inspection, Inspection Assignee, Inspection Distribution List, Inspection Item, Inspection Item Activity, Inspection Item Comment, Inspection Signature Request, Observation, Observation Activity, Observation Distribution Member, RFI, RFI Assignee, RFI Bakk in Court, RFI Distribution List, RFI Response, Submittal, Submittal Approver, Submittal Ball in Court, Submittal Distribution List | None | None |
Submittal | Action Plan Line Item Record, Action Plan Line Item Record Request, Drawing Markup Link, Location, Schedule Task, Specification Section, Submittal Approver, Submittal Ball in Court, Submittal Distribution List | Action Plan Line Item Record: Action Plan, Action Plan Line Item, Action Plan Line Item Record Request Action Plan Line Item Reference: Action Plan, Action Plan Line Item Drawing Markup Link: Drawing | None |
Submittal Approver | Location, Specification Section, Submittal | None | None |
Submittal Ball in Court | Location, Specification Section, Submittal | None | None |
Task | Task Activity, Task Assignee, Task Distribution Member | None | None |
Task Activity | Task | None | None |
Task Assignee | Task | None | None |
Task Distribution Member | Task | None | None |
Timecard Entry | None | None | None |