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 |
|
| None |
Action Plan Approver |
| None | None |
Action Plan Line Item |
|
| None |
Action Plan Line Item Assignee |
| None | None |
Action Plan Line Item Record |
| None | None |
Action Plan Line Item Record Request |
| Action Plan Line Item Record: Correspondence, Form, Inspection, Observation, Photo, Submittal | None |
Action Plan Line Item Reference |
| None | None |
Action Plan Receiver |
| None | None |
Asset |
| None | None |
Asset Attachment |
| None | None |
Change Event |
| None | None |
Change Event Line Item |
| None | None |
Commitment |
| Commitment Line Item: Daily Log Productivity | None |
Commitment Line Item |
| None | None |
Company Folder/Document | None | None | None |
Coordination Issue |
| Drawing Markup Link: Drawing | None |
Correspondence |
|
| None |
Correspondence Assignee |
| None | None |
Correspondence Distribution List |
| None | None |
Correspondence Response |
| None | None |
Correspondence 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 |
| None | None |
Daily Log Delivery | Project | None | None |
Daily Log Dumpster | Project | None | None |
Daily Log Equipment |
| None | None |
Daily Log Inspection |
| None | None |
Daily Log Manpower |
| None | None |
Daily Log Note |
| 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: Commitment | None |
Daily Log Quantity |
| 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 |
Document Management | Project | None | None |
Document Management Placeholder | Project | None | None |
Drawing |
|
| None |
Drawing Markup Link |
| None | None |
Equipment |
| None | None |
Folder/Document |
| Drawing Markup Link: Drawing | None |
Folder/Document Watcher |
| None | None |
Form |
|
| None |
Incident |
| None | None |
Incident Action |
| Observation: Action Plan Line Item, Inspection Item | None |
Incident Alert |
| None | None |
Incident Distribution Member |
| None | None |
Incident Injury Body Part |
| None | None |
Incident Record |
| None | None |
Incident Witness Statement |
| None | None |
Inspection |
|
| None |
Inspection Assignee |
| None | None |
Inspection Distribution List |
| None | None |
Inspection Item |
| Inspection Item Reference: Drawing, Form, Photo | None |
Inspection Item Activity |
| None | None |
Inspection Item Comment |
| None | None |
Inspection Item Reference |
| None | None |
Inspection Item Signature Request |
| None | None |
Inspection Schedule |
| Inspection Item Reference: Drawing, Form, Photo | None |
Inspection Schedule Assignee |
| None | None |
Inspection Schedule Distribution List |
| None | None |
Inspection Signature Request |
| None | None |
Instruction | Project | None | None |
Location |
| None | None |
Meeting |
|
| None |
Meeting Attendee |
| None | None |
Meeting Item |
| None | None |
Meeting Item Assignee |
| None | None |
Observation |
|
| None |
Observation Activity |
| None | None |
Observation Distribution Member |
| None | None |
Photo |
|
| None |
Project | All data objects except Company Folder/Document and Project | None | None |
Punch Item |
| Drawing Markup Link: Drawing | None |
Punch Item Assignee |
| None | None |
Punch Item Ball in Court |
| None | None |
Punch Item Distribution Member |
| None | None |
RFI* |
| Drawing Markup Link: Drawing | None |
RFI Assignee |
| None | None |
RFI Ball in Court |
| None | None |
RFI Distribution List |
| None | None |
RFI Response |
| None | None |
Schedule Calendar Item | None | None | None |
Schedule Lookahead | Schedule Lookahead Task | Schedule Lookahead Task: Schedule Task | None |
Schedule Lookahead Task |
| None | None |
Schedule Task |
| Schedule Lookahead Task: Schedule Task | None |
Schedule Task Change | Schedule Task | None | None |
Schedule Task Request | Schedule Task | None | None |
Scheduling Type |
| None | None |
Scheduling Activity |
| None | None |
Scheduling Relationship |
| None | None |
Specification Section |
| None | None |
Submittal |
|
| None |
Submittal Approver |
| None | None |
Submittal Ball in Court |
| None | None |
Submittal Distribution List |
| None | None |
Task |
| None | None |
Task Activity | Task | None | None |
Task Assignee | Task | None | None |
Task Distribution Member | Task | None | None |
Timecard Entry | None | None | None |
Workflow Instance |
| None | None |
Workflow Step |
Note: Direct joins apply only when the workflow is attached to that object. A workflow on a parent item (for example, a Commitment or Purchase Order) does not join to related Change Orders or other child objects. | Workflow Instance: Correspondence, Document Management | None |
Workflow Step Assignees |
Note: Direct joins apply only when the workflow is attached to that object. A workflow on a parent item (for example, a Commitment or Purchase Order) does not join to related Change Orders or other child objects. | Workflow Instance: Correspondence, Document Management | None |