Not all objects are available to all companies. See below for what objects are in the dataset and who they are available to. Not all users see all objects in a company, please see permissions for more information on how a user’s tool permissions impact what objects are available to them.

How are objects in the Dataset Joined?

Objects that have a relationship are linked by a join. When two objects in Enhanced Reporting are joined, they appear in the same row in a report. For example, a Correspondence is joined to an RFI, therefore they will appear in the same row. Sometimes, two objects aren’t directly joined, but are joined through a third object. In this case, a field from that third object must be added to a report to show the connection between the first two. For example, an Inspection and an Action Plan Item do not have a direct relationship, but a field from an Action Plan Line Item Record that does have a direct relationship with both will be added to a report, all three objects will appear in the same line.

The table below shows the joins of the objects in the dataset. To determine if two objects are joined, search for one across the top and the other on the side. The cell that corresponds to the column and row of the objects tells you if they are joined.

• If the cell shows “Join”, the objects are joined directly and fields from these objects will appear in the same row.

• If the cell shows “Join through numbered object,” the objects are indirectly joined through a third object. A field from that third object must be added to the report to see the data in the same row.

• If the cell shows “No join,” the objects do not have a relationship and data will not appear in the same row (the exception to this is if only measures from these objects have been added to the report).

Join Table RFIs

Click to View Join Table

Legend

*RFIs join to Correspondence through the Correspondence Origin RFI ID. Therefore Correspondence and RFI can only appear in the same row if the Correspondence originated from the RFI. RFI’s that originate from Correspondence will not appear in the same row.

Join

Join through numbered object

1. Action Plan

2. Action Plan Approver

3. Action Plan Line Item

4. Action Plan Line Item Assignee

5. Action Plan Line Item Record

6. Action Plan Line Item Record Request

7. Action Plan Line Item Reference

8. Action Plan Receiver

9. Change Event

10. Change Event Line Item

11. Commitment

12. Commitment Line Item

13. Company Folder/Document

14. Coordination Issue

15. Correspondence*

16. Correspondence Assignee

17. Correspondence Distribution List

18. Correspondence Response

19. Correspondence Schedule Task

20. Daily Log Accident

21. Daily Log Completion

22. Daily Log Construction Report

23. Daily Log Delay

24. Daily Log Delivery

25. Daily Log Dumpster

26. Daily Log Equipment

27. Daily Log Inspection

28. Daily Log Manpower

29. Daily Log Note

30. Daily Log Observed Weather Condition

31. Daily Log Phone Call

32. Daily Log Plan Revision

33. Daily Log Productivity

34. Daily Log Quantity

35. Daily Log Safety Violation

36. Daily Log Scheduled Work

37. Daily Log Scheduled Work Task

38. Daily Log Visitor

39. Daily Log Waste

40. Drawing

41. Drawing Markup Link

42. Equipment

43. Folder/Document

44. Folder/Document Watcher

45. Form

46. Incident

47. Incident Action

48. Incident Alert

49. Incident Distribution Member

50. Incident Injury Body Part

51. Incident Record

52. Incident Witness Statement

53. Inspection

54. Inspection Assignee

55. Inspection Distribution List

56. Inspection Item

57. Inspection Item Activity

58. Inspection Item Comment

59. Inspection Item Reference

60. Inspection Item Signature Request

61. Inspection Schedule

62. Inspection Schedule Assignee

63. Inspection Schedule Distribution List

64. Inspection Signature Request

65. Instruction

66. Location

67. Meeting

68. Meeting Attendee

69. Meeting Item

70. Meeting Item Assignee

71. Observation

72. Observation Activity

73. Observation Distribution Member

74. Photo

75. Project

76. Punch Item

77. Punch Item Assignee

78. Punch Item Ball in Court

79. Punch Item Distribution Member

80. RFI*

81. RFI Assignee

82. RFI Ball in Court

83. RFI Distribution List

84. RFI Response

85. Schedule Calendar Item

86. Schedule Lookahead

87. Schedule Lookahead Task

88. Schedule Task

89. Schedule Task Change

90. Schedule Task Request

91. Specification Section

92. Submittal

93. Submittal Approver

94. Submittal Ball in Court

95. Submittal Distribution List

96. Task

97. Task Activity

98. Task Assignee

99. Task Distribution Member

100. Timecard Entry

Updated Jointable CSS and JS