Team: Project Communications

Find definitions of the fields and measures included in the Team: Project Communications dataset organized by folder.

With the Team: Project Communications dataset you can create reports with all of your Team project management data including RFIs, Submittals, Daily logs.
Note: When creating a report, if you use fields that are not related, the Power BI editor may display a message indicating that it cannot determine the relationship between the fields.

Daily Log Measures

Daily Log Delays

This is the count of weather delays.

Daily Log Duration Amount

This is the Call Log Duration in minutes.

Daily Log Hours

This is the hours for the Daily log, as indicated in the Equipment and Work sections.

Daily Log Quantity

This is the quantity for the Daily Log, as indicated in the Equipment and Work sections.

RFI Measures

Count of RFIs

This is a count of RFIs.

RFI Avg Days Overdue

The average number of days the RFI is overdue.

RFI Avg Days to Mark as Answered

The average number of days for the RFI to be marked as answered.

RFI Avg Days to Respond

The average number of days to respond to the RFI.

RFI Avg Total Days for Close

The average number of days for the RFI to close.

RFI Cost Impact

The amount by which the project cost is impacted.

RFI Days Overdue

The number of days the RFI is overdue.

RFI Days to Mark as Answered

The number of days to for the RFI to be marked as answered.

RFI Days to Respond

The number of days to respond to the RFI.

RFI ROM Impact

The rough order of magnitude by which the project cost is impacted.

RFI Schedule Impact

The number of days by which the schedule is impacted.

RFI Total Days for Close

The total number of days for the RFI to close.

Submittal Measures

Count of Submittals

This is a count of submittals.

Submittal Avg Days for Approval

The average number of days for approval.

Submittal Avg Days for Release

The average number of days for release.

Submittal Avg Days for Review

The average number of days for review.

Submittal Avg Days for Submission

The average number of days for submission.

Submittal Avg Days Overdue

The average number of days the submittal is overdue.

Submittal Avg Total Days for Close

The average total number of days for the submittal to close.

Submittal Days for Approval

This value is the number of days for approval.

Submittal Days for Release

This value is the number of days for release.

Submittal Days for Review

This value is the number of days for review.

Submittal Days for Submission

This value is the number of days for submission.

Submittal Days Overdue

The number of days the submittal is overdue.

Submittal Total Days for Close

The total number of days for the submittal to close.

Submittal Lead Days

The lead days for the submittal.

Calendar Date

Day

This is the day of the month. Note that this value is based on the actual date of each record.

Day Name

This is the day of the week.

Day Name Abbreviation

This is the abbreviation for the day of the week.

Month

Includes all dates from the start of the month through the end of the month. Note that this value is based on the actual date of each record.

Month Name Abbreviation

This is the abbreviation of the month.

Week

This is the week number using a 12 month calendar year. Note that this value is based on the actual date of each record.

Week End Date

This the end date of each week listed by month and year.

Week Start Date

This is the start date for each week listed by month and year

Year

Calendar year starting with January 1st and ending on December 31st. This may be different from the company's Fiscal Calendar. Note that this value is based on the actual date of each record.

Daily Log

Daily Log Assigned Date

This is the date the Daily Log was assigned.

Daily Log Assigned to

This represents the contact to whom the Daily Log is assigned.

Daily Log Completed Date

This is the date the Daily Log was completed.

Daily Log Opened Date

This is the date the Daily Log was opened.

Daily Log State

This represents the state of the Daily Log (for example,"Not Started," "In Progress," or "Completed").

Daily Log Submitted Date

This is the date the Daily Log was submitted.

Daily Log Title

This is the Log Title of the Daily Log.

Daily Log Type

This represents the type of Daily Log. It can be either "Company Log" or "Subcontractor Log."

Daily Log Work Summary

This is the work summary for the Daily Log, and may include associated dates.

Daily Log Equipment

Daily Log Equipment Code

This represents the specific equipment code for the Equipment Log field.

Daily Log Equipment Description

This is the description of the equipment for the Equipment Log field.

Daily Log Section

Daily Log Section Call Time

This is the duration of a call in the Daily Log.

Daily Log Section Caller

The is the contact listed as a caller in the Daily Log.

Daily Log Field

This represents a field within a Daily Log section (for example, Weather Observations, or Work Log).

Daily Log Field Description

This represents a field within a Daily Log section (for example, Weather Observations, or Work Log).

Daily Log Section

This represents a Daily Log section (for example, Weather, Work, Activity).

Daily Log Out Going Call

This is the out going call record listed in a Daily Log.

Daily Log Work Log Contact

Daily Log Work Log Contact

This is the name of the contact indicated in the Work Log field.

Daily Log Work Log Organization

Daily Log Work Log Organization

This is the name of the organization for the contact indicated in the Work Log field.

RFI

RFI Answer Marked On

The date that a specific RFI was marked as answered.

RFI Ball in Court Contact

The name of the contact currently assigned to the RFI.

RFI Ball in Court Organization

The organization to which the current RFI assignee belongs.

RFI Created Date

The date the RFI was created.

RFI Drawing Impact

Indicates that the project drawings could be impacted by the information in the RFI or change made due to the RFI.

RFI Due By

The due date of the RFI.

RFI Forwarded On

The date the RFI was forwarded.

RFI From Contact

The name of the contact sending the RFI.

RFI From Organization

The organization to which the "RFI From" contact belongs.

RFI Impact Description

Describes how the project schedule, ROM or cost could be impacted by the information in the RFI or change made due to the RFI.

RFI Notes

The notes that have been entered for the RFI.

RFI Number

This number is used to identify the RFI.

RFI Question

The question that must be answered by the RFI.

RFI Reference

The reference information of the RFI.

RFI Responded On

The date on which the RFI was responded to.

RFI Response

The actual response for the RFI.

RFI Revision

The revision number of the RFI.

RFI Sent On

The date on which the RFI was sent.

RFI Spec Section

The specification section related to the RFI.

RFI Status Code

The status code of the RFI.

RFI Subject

The title or subject of the RFI.

RFI Suggestion

The possible answer that has been added as a suggestion for the RFI.

RFI To Contact

The name of the contact to whom the RFI is sent.

RFI To Organization

The organization to which the "RFI To Contact" belongs.

RFI Type

This code represents the type of RFI.

RFI State

RFI State

The state of the RFI.

RFI Priority

RFI Priority

The priority of the RFI.

RFI Visibility

RFI Visibility

The visibility of the RFI.

Submittal

Submittal Approved On

The date on which the Submittal was approved.

Submittal Approver

The name of the contact approving the submittal.

Submittal Approver Organization

The organization to which the submittal approver belongs.

Submittal Assigned To

The name of the contact currently assigned to the submittal.

Submittal Assigned To Organization

The organization to which the current submittal assignee belongs.

Submittal Closed On

The date on which the submittal was closed.

Submittal Created Date

The date on which the submittal was created.

Submittal Document Type

The type of the submittal.

Submittal Document Type Code

The code associated with the specific submittal type.

Submittal Due From Approver

This is the date the submittal is due from the approver.

Submittal Due From Submitter

This is the date the submittal is due from the submitter.

Submittal Due On Site By

This is the date on which the submittal is due on site.

Submittal Due To Approver

This is the date on which the submittal is due to the approver.

Submittal Due To Submitter

This is the date on which the submittal is due to the submitter.

Submittal Issued On

This is the date on which the submittal was issued.

Submittal Issuer

The name of the contact issuing the submittal.

Submittal Issuer Organization

The organization to which the submittal issuer belongs.

Submittal Note

The text from the Note field in the submittal.

Submittal Number

This number is used to identify the submittal.

Submittal Reference

The reference information of the submittal.

Submittal Rejected On

The date on which the submittal was rejected.

Submittal Response

The response to the submittal.

Submittal Response Code

The code used to indicate the response to the submittal.

Submittal Reviewed On

The date on which the submittal was reviewed.

Submittal Reviewer

The name of the contact reviewing the submittal.

Submittal Reviewer Organization

The organization to which the submittal reviewer belongs.

Submittal Revision

The revision number of the submittal.

Submittal Submitted On

The date on which the submittal was submitted.

Submittal Submitter

The name of the contact submitting the submittal.

Submittal Submitter Organization

The organization to which the contact submitting the submitter belongs.

Submittal Title

The title or subject of the submittal.

Submittal Due Date

Submittal Due Date

The date the submittal is due.

Submittal Due Date Name

This is the day of the week the submittal is due.

Submittal Due Date Name Abbreviation

This is the abbreviation for the day of the week the submittal is due.

Submittal Month Due

The month the submittal is due. Includes all dates from the start of the month through the end of the month.

Submittal Month Due Name Abbreviation

This is the abbreviation for the month the submittal is due.

Submittal Week Due

The week the submittal is due. This is the week number using a 12 month calendar year.

Submittal Week Due End Date

The end date of the week the submittal is due. This is the week number using a 12 month calendar year.

Submittal Week Due Start Date

The start date of the week the submittal is due. This is the week number using a 12 month calendar year.

Submittal Year Due

The calendar year the submittal is due, starting with January 1st and ending on December 31st. This may be different from the company's Fiscal Calendar.

Submittal Package

Submittal Package

The package related to the submittal.

Submittal Package Code

The code associated with the submittal package.

Submittal Priority

Submittal Priority

The priority of the submittal.

Submittal Spec Section

Submittal Spec Section

The specification section related to the submittal.

Submittal Spec Section

The description of the specification section related to the submittal.

Submittal State

Submittal State

The current state of the submittal.

Submittal Visibility

Submittal Visibility

The visibility of the submittal.

Team Project

Project

The name of the Team project.

Project Description

The description of the Team project.

Team Project ID

The ID of the Team project.