Share

Insight Builder Dataset Schema

The Insight Builder Dataset Schema documentation is made up of the datasets listed on this page.

Note: Project Attributes are available in each non-administrative dataset.

Project Attributes

The following project attributes are available in all non-administrator datasets:

  • adsk_project_id
  • construction_type
  • contractor_type
  • currency
  • job_number
  • latitude
  • longitude
  • project_address_line1
  • project_address_line2
  • project_city
  • project_country
  • project_postal_code
  • project_state_or_province
  • project_created_at
  • project_end_date
  • project_start_date
  • project_name
  • project_status
  • project_timezone
  • project_type
  • value

Cost

In addition to the Project Attributes listed above, the Cost dataset is made up of the following datasets:

cost-budgets

Column name Data type Description
budget_id string: UUID Unique identifier for the budget item.
budget_code string Unique code that complies with the Budget Code Template defined by the project administrator.
budget_name string Name of the budget.
description string Detailed description of the budget.
quantity number Quantity for the budget item.
unit_price number Unit price for the budget item.
unit string Unit of measure for the budget item.
original_amount number Original amount of the budget (quantity × unit_price).
internal_adjustment number Internal transfers between budgets.
approved_owner_changes number Total changes approved by the owner.
pending_owner_changes number Total changes pending owner approval.
original_commitment number Original amount committed to the supplier contract.
approved_change_orders number Total changes committed to the supplier.
approved_in_scope_change_orders number Total in-scope changes approved and committed to the supplier.
pending_change_orders number Total changes not yet committed.
reserves number Total changes under estimation.
actual_cost number Total actual cost.
main_contract_id string: UUID ID of the main contract the budget belongs to.
main_contract_item_amount number Amount of the main contract item.
adjustments_total number Total of all actual cost adjustments.
uncommitted number Amount approved by owner but not committed to supplier: approved_owner_changes - (approved_change_orders - approved_in_scope_change_orders).
revised number Total approved budget from owner (original_amount + internal_adjustment + approved_owner_changes).
projected_cost number For budget: original_commitment + approved_change_orders + pending_change_orders + reserves. For contract: awarded + approved_change_orders + pending_change_orders + reserves.
projected_budget number revised + pending_owner_changes
forecast_final_cost number projectedCost + adjustmentsTotal.
forecast_variance number projectedBudget - forecastFinalCost.
forecast_cost_complete number forecastFinalCost - actualCost.
variance_total number Variance of a budget - equals projectedBudget - projectedCost.
created_at timestamp: SQL Time the item was created.
updated_at timestamp: SQL Time the item was last updated.
code_segment_values string Composition of the budget code.

cost-contracts

Column name Data type Description
contract_id string: UUID Unique identifier of the Contract.
contract_code string Human readable code of the Contract.
contract_name string Name of the contract.
description string Detailed description of a Contract.
type string Type of the contract; for example, consultant - purchase order - which is customizable by Project Admin.
contract_status string Status of this contract - status includes [draft - closed - open - executed - sent].
awarded number Amount of the original contract.
original_budget number Original amount of budgets associated with this Contract.
internal_adjustment number Internal transfers of budgets associated to this Contract.
approved_owner_changes number Changes approved by Owner.
pending_owner_changes number Changes pending approval from Owner.
approved_change_orders number Total changes committed to the Supplier.
approved_in_scope_change_orders number Total in-scope changes committed to the Supplier.
pending_change_orders number Total changes not committed.
reserves number Total changes under estimating.
actual_cost number Total actual cost.
uncommitted number Amount that has been approved by owner but not committed to Supplier: approvedOwnerChanges - (approvedChangeOrders - approvedInScopeChangeOrders).
revised number Total of the approved budget from owner - equals originalAmount + internalAdjustment + approvedOwnerChanges.
projected_cost number For budget - it is equal to originalCommitment + approvedChangeOrders + pendingChangeOrders + reserves. For contract - it is equal to awarded + approvedChangeOrders + pendingChangeOrders + reserves.
projected_budget number revised + pending_owner_changes
forecast_final_cost number projectedCost + adjustmentsTotal
forecast_variance number projectedBudget - forecastFinalCost
forecast_cost_complete number forecastFinalCost - actualCost
variance_total number Variance of a budget - equals projectedBudget - projectedCost.
awarded_at timestamp: SQL Time the contract was awarded.
status_changed_at timestamp: SQL Time the status was last updated.
sent_at timestamp: SQL Time the contract was sent to the Supplier.
responded_at timestamp: SQL Time the Supplier responds.
returned_at timestamp: SQL Time the Contract was signed and returned.
onsite_at timestamp: SQL Time the Supplier arrived on site for the job.
offsite_at timestamp: SQL Time the Supplier completed the job.
procured_at timestamp: SQL Duration of the purchase order.
approved_at timestamp: SQL Time the Contract was approved.
created_at timestamp: SQL Time the item was created.
updated_at timestamp: SQL Time the item was last updated.
adjustments_total number Total of all actual cost adjustments.
executed_at timestamp: SQL Time the item was executed.
contract_currency string Code of the currency specified for the contract if it's awarded in a foreign currency.
exchange_rate number Exchange rate for the specified currency, applied as a multiplier of the contract's base currency. For example, 1 base currency = 0.7455 foreign currency.
integration_state string A field indicating the record integration status, possible values: "integrated", "locked", "failed", null.
integration_state_changed_at timestamp: SQL Time the integration state changed.
external_id string ID of the entity in an external system.
external_system string Name of the external system.
message string Comment added by the integration.
compliance_status enum: string Compliance status of the contract.

cost-expenses

Column name Data type Description
expense_id string: UUID An auto-generated unique identifier of an expense.
number string A system-generated sequence.
expense_name string Name of an expense.
description string Detailed description of an expense.
supplier_name string Name of the supplier company.
amount number Total amount of the expense.
paid_amount number Total paid amount of the expense.
expense_status string Status of the expense.
expense_type string Type of the expense.
payment_type string How is the expense paid, e.g. Cash, Check, Electronic Transfer.
payment_reference string Reference info how the expense is paid.
created_at timestamp: SQL Time the expense was created.
updated_at timestamp: SQL Time the expense was last modified.
issued_at timestamp: SQL Thime the expense was issued.
received_at timestamp: SQL Time the expense was received.
approved_at timestamp: SQL Time the expense was approved.
paid_at timestamp: SQL Time the expense is paid.
reference_number string References to the expense; for example, the invoice number.
integration_state string A field indicate the record integration status, possible values: "integrated", "locked", "failed", null.
integration_state_changed_at timestamp: SQL Time the integration state changed.
external_id string ID of the entity in external system.
external_system string Name of the external system.
message string Comment added by the integration.

cost-budget-payments

Column name Data type Description
budget_payment_id string: UUID A unique identifier of a budget payment.
budget_payment_name string Name of a budget payment.
budget_payment_status string Status of the budget payment.
description string Detailed description of a budget payment.
number string Number of a budget payment.
start_date timestamp: SQL Start date of the payment billing period.
end_date timestamp: SQL End date of the payment billing period.
due_date timestamp: SQL Due date of the payment.
original_amount number Original contracted amount of the budget payments.
amount number Work completed of this period of the payment.
previous_amount number Work completed in the previous payment.
materials_on_store number Materials on site during this billing period.
previous_materials_on_store number Materials on site of previous billing period.
approved_change_orders number Total of approved change orders.
contract_amount number Current total of the contracted amount: orginal_amount + approved_change_orders.
completed_work_retention number Total retention for all completed work.
materials_on_store_retention number Total retention for material on site.
net_amount number Net amount of current work completed + material on site - retentions.
paid_amount number Amount paid by owner.
payment_type string How is the expense paid, e.g. Cash, Check, Electronic Transfer.
payment_reference string Reference info how the expense is paid.
created_at timestamp: SQL Time the payment was created.
updated_at timestamp: SQL Time the payment was last modified.
approved_at timestamp: SQL Time the payment was approved.
paid_at timestamp: SQL Time the payment was paid.
submitted_at timestamp: SQL Time the payment is submitted.
note string Additional notes.
materials_billed number Amount of the materials billed in this period.
materials_retention number Percentage of the retention for the materials billed.
integration_state string A field indicate the record integration status, possible values: "integrated", "locked", "failed", null.
integration_state_changed_at timestamp: SQL Time the integration state changed.
external_id string ID of the entity in external system.
external_system string Name of the external system.
message string Comment added by the integration.

cost-cost-payments

Column name Data type Description
cost_payment_id string: UUID An auto generated unique identifier of a budget payment.
cost_payment_name string Name of a cost payment.
cost_payment_status string Status of the budget payment.
start_date timestamp: SQL Start date of the payment billing period.
end_date timestamp: SQL End date of the payment billing period.
due_date timestamp: SQL Due date of the payment.
description string Detailed description of a payment.
original_amount number Original contracted amount of the cost payments.
amount number Work completed of this period of the payment.
previous_amount number Total of work completed of before this billing period.
materials_on_store number Material on site of this billing period.
previous_materials_on_store number Material on site during the previous billing period.
approved_change_orders number Total of approved change orders.
contract_amount number Current total of the contracted amount: orginal_amount + approved_change_orders.
completed_work_retention number Total of the retention for total work complete.
materials_on_store_retention number Total of the retention for materials on site.
net_amount number Net amount of current work completed + material on site - retentions.
paid_amount number Amount paid by the Owner.
payment_type string How is the expense paid; for example, Cash, Check, Electronic Transfer.
payment_reference string Reference info on how the expense is paid.
created_at timestamp: SQL Time the payment was created.
updated_at timestamp: SQL Time the payment was last modified.
approved_at timestamp: SQL Time the payment was approved.
paid_at timestamp: SQL Time the payment was paid.
submitted_at timestamp: SQL Time the payment was submitted.
note string Additinal note of the payment.
materials_billed number Amount of the materials billed in this period.
materials_retention number Percentage of the retention for the materials billed.
integration_state string A field indicates the record integration status, possible values: "integrated", "locked", "failed", null.
integration_state_changed_at timestamp: SQL Time the integration state changed.
external_id string Uniquw ID of the entity in external system.
external_system string Name of the external system.
message string Comment added by the integration.

cost-cost-items

Column name Data type Description
number string Number of a Cost item.
name string Name of a Cost Item.
description string Detailed description of a Cost Item.
scope string Scope of a Cost Item. Possible values: out - in
type string Regular is the default type, and markup is generated against Markup Formula.
Possible values: regular - markup
estimated number Rough estimation of this item without quotation.
proposed number Quoted cost of the item.
submitted number Amount sent to Owner for approval.
approved number Amount approved by Owner.
committed number Amount committed to the Supplier.
pco string Number of a PCO.
rfq string Number of an RFQ.
cor string Number of a COR.
oco string Number of an OCO.
sco string Number of an SCO.
pco_id string A unique identifier of a PCO.
rfq_id string A unique identifier of a RFQ.
cor_id string A U unique identifier of a COR.
oco_id string A unique identifier of an OCO.
sco_id string A unique identifier of an SCO.
pco_name string Name of a PCO.
rfq_name string Name of an RFQ.
cor_name string Name of a COR.
oco_name string Name of an OCO.
sco_name string Name of an SCO.
pco_budget_status string Budget status of a PCO.
cor_budget_status string Budget status of a COR.
oco_budget_status string Budget status of a OCO.
pco_cost_status string Cost status of a PCO.
rfq_cost_status string Cost status of an RFQ.
sco_cost_status string Cost status of a SCO.
pco_type string Customized type of a PCO.
rfq_type string Customized type of an RFQ.
cor_type string Customized type of the COR.
oco_type string Customized type of an OCO.
sco_type string Customized type of an SCO.
pco_source_type string Source type of the PCO.
rfq_source_type string A source type of an RFQ.
cor_created_at timestamp: SQL Time the item was created.
cor_approved_at timestamp: SQL Time the item was approved.
cor_submitted_at timestamp: SQL Time the item was submitted.
budget_id string A unique identifier of a budget.
budget_name string Name of the budget.
budget_code string A unique code compliant to the Budget Code Template defined by the Project Admin.

cost-cost-items-with-segments

Note: This table contains all columns from the cost-cost-items dataset, with the addition of two supplementary segment columns:
Column name Data type Description
segment_name string Name of the budget code segment.
segment_code string Display code of the budget code segment.

Forms

In addition to the Project Attributes listed above, the Forms dataset is made up of the following:

Column name Data type Description
form_id string: UUID Unique identifier of the form.
form_name string Name of the form.
template_name string Name of the form template.
template_type string Template type of the form.
status string Status of the form.
assigned_to string Assignee of the form.
number number User-facing form number.
form_date date Date specified on the form.
notes string Notes entered by the user.
description string Description entered by the user.
created_by string Name of the user who created the form.
created_at timestamp Date and time the form was created.
updated_at timestamp Date and time the form was last updated.
location_path string Full location tree path.
last_reopened_by string Name of the person who last reopened the form.
last_submitter_signed boolean Indicates if the user provided a signature.
due_date timestamp Date and time the form is due.
last_submitted_at timestamp Date and time the form was submitted.
assignee_type string Type of an assignee.
Native or PDF (calculated field) boolean Indicates if the form is a native form or Smart PDF.
weather_id number Weather record ID.
weather_date date Date of the weather event.
summary_key string Weather summary.
temperature_min number Minimum temperature of the day (°F).
temperature_max number Maximum temperature of the day (°F).
humidity number Humidity percentage for the day.
wind_speed number Average wind speed (mph).
wind_gust number Maximum wind speed (mph).
wind_bearing number Wind direction in degrees (0 = north, clockwise).
fetched_at timestamp Date and time weather data was fetched.
precipitation_accumulation number Total precipitation for the day (inches).

forms-with-questions (only for native forms)

In addition to the Project Attributes listed above, the forms-with-questions dataset includes the following columns:

Column name Data type Description
form_id string: UUID A unique ID of the form.
native_form_id string: UUID ID of the native form the value belongs to.
template_name string The name of the template.
template_type string The template type of the form.
status string The status of the form.
assigned_to string The person the form is assigned to.
number number A user-facing report number.
form_date date The date set on the form.
notes string User-filled notes.
description string User-filled description.
created_by string The person who created the form.
created_at timestamp The date and time the form created.
updated_at timestamp The date the form was last updated.
location_path string The full location free path.
last_reopened_by string The person that last reopened the form.
last_submitter_signed boolean Signed or not.
due_date timestamp The date the form is due, may be null.
last_submitted_at timestamp The date on which the form was submitted.
assignee_type string The type of an assignee.
section_index number The index of a form section.
section_name string The name of the form section.
section_assignee string The section assignee.
question_index number The index of the form question.
question string The description of the form question.
answer string The form question answer.
answer_id string: UUID A unique ID of the answer.
answer_rank number The rank of the answer.
answer_type string
Possible values:
- array_val, - choice_val, date_val, - number_val, - svg_val, -text_val, -toggle_val		 The type of an answer.
signature_name string The text name of the signer.
answer_notes string Notes added to a response.

forms-with-worklog

In addition to the Project Attributes listed above, the forms-with-worklog dataset includes the following columns:

Column name Data type Description
native_form_id string: UUID ID of the native form the value belongs to.
form_id string: UUID A unique ID of the form.
form_name string The name of the form.
status string The status of the form.
template_name string The name of the form template.
form_date date The date set on the form.
status string The status of the form.
template_name string The name of the form template.
form_date date The date specified on the form.
number number The user facing form number.
discipline string Discipline for work log item.
company string The company for work log item.
role string Role for work log item.
number_of_workers number The number of workers for the work log item.
number_regular_hours number The number of regular hours for work log item.
number_of_hours number The number of overtime hours for work log item.
total_regular_hours number The total regular hours (number of workers * number of regular hours.)
total_of_hours number The total overtime hours (number of workers * number of overtime hours.)
work_performed string Description of performed work.

Issues

Note the following considerations:

  • The issues dataset contains distinct rows of issues.
  • The issues-with-custom-attributes dataset can have multiple rows of the same issue because custom attributes are presented in rows, and one issue can have multiple custom attributes
  • For metrics relying on distinct rows (for example, "average days to close issues"), use the issues dataset
  • For metrics requiring the count of issues (for example, count of issues by assignee), either issues dataset or issues-with-custom-attributes can be used. If issues-with-custom-attributes is used, please keep in mind to select "Count distinct" as opposed to "Count" in the Visuals pane

In addition to the Project Attributes listed above, the Issues dataset includes the following columns:

Column name Data type Description
ask_account_id string: UUID Autodesk Account Identifier
assigned_company string Name of the company that the issue was assigned to.
assigned_role string Name of the role that the issue was assigned to.
assigned_to string Name of the user, role, or company that the issue was assigned to.
assigned_type string: null
Possible values: - user
- company
- role
 The type of the current assignee of this issue.
assigned_user string: null Name of the user that the issue was assigned to.
closed_at timestamp: SQL Date and time the issue was closed.
closed_by_user string: null Name of the user that closed the issue.
created_at timestamps: SQL Date and time the issue was created.
created_by_user string Name of the user that created the issue type.
deleted_at timestamp: SQL Date and time the issue type was deleted.
description string: null Description of the purpose of the issue.
display_id number Chronological, user-friendly identifier of the issue.
due_date timestamp: SQL Due date of the issue.
gps_coordinates string GPS location of the issues in (latitude, longitude) format
gps_latitude string Specifies the latitude for the issue location.
gps_longitude string Specifies the longitude for the issue location.
issue_id string: UUID Unique identifier of the issue.
issue_subtype string Title of the issue type.
issue_type string Title of issue category.
lcoation_details string: null Location as plain text that relates to the issue.
location_id string: UUID Unique LBS (Location Breakdown Structure) identifier that relates to the issue.
location_path string Full location tree path.
opened_at timestamp: SQL Date and time the issue was opened.
opened_by_user string:null Name of the user that opened the issue.
published Boolean Indicates whether the issue is published or not.
root_cause string Title of the root cause.
start_date timestamp: SQL Start date of the issue.
status string: null
Status can be one of the following:
- open
- work_completed
- ready_to_inspect
- not_approved
- in_dispute
- closed
- void
- answered
- draft
- pending
-in_progress
- completed
- in_review		 Unique identifier of the current status of the issue.
title string: null Name of the issue.
updated_at timestamp: SQL Time the issue was updated.
updated_by_user string: null Name of the user that updated the issue.

The following attributes are available in the issues dataset:

Attribute Type Note
attribute_title string Title of the custom attribute.
attribute_value string Description of the custom attribute.

Meetings

In addition to the Project Attributes listed above, the Meetings dataset is made up of the following datasets:

meetings

Column name Data type Description
meeting_id string: UUID A unique identifier of the meeting.
series_id string: UUID A unique identifier for a meeting series. All follow-up meetings within the same series share the same ID.
title string The title of the meeting.
meeting_description string Text describing the meeting's agenda or purpose.
summary string The summary of the meeting.
meeting_status enum: string
Possible values:
open
minutes		 The current status of the meeting.
num_in_series number Index of the meeting within its series.
meeting_location string The location of the meeting.
starts_at timestamp: SQL The scheduled start time of the meeting.
duration number The total duration of the meeting.
video_conference_link string The URL link to join the video conference associated with the meeting.
created_by string The ID of the user that created the meeting.
updates_by string The ID of the user that last updated the meeting.
created_at timestamp: SQL The time the meeting was created.
updated_at timestamp: SQL The time the meeting was last updated.
deleted_at timestamp: SQL The time the meeting was deleted.

meeting_items

Column name Data type Description
meeting_id string: UUID A unique identifier of the meeting.
series_id string: UUID A unique identifier representing a meeting series. All follow-up meetings that belong to the same series share the same ID.
title string The title of the meeting.
meeting_description string Text describing the meeting's agenda or purpose.
summary string The summary of the meeting.
meeting_status enum: string
Possible values: open
minutes		 The current status of the meeting.
num_in_series number Index of the meeting within its series.
meeting_location string The location of the meeting.
starts_at timestamp: SQL The scheduled start time of the meeting.
duration number The total duration of the meeting.
video_conference_link string The URL link to join the video conference associated with the meeting.
meeting_created_by string The ID of the user that created the meeting.
meeting_updates_by string The ID of the user that last updated the meeting.
meeting_created_at timestamp: SQL The time the meeting was created.
meeting_updated_at timestamp: SQL The time the meeting was last updated.
meeting_deleted_at timestamp: SQL The time the meeting was deleted.
topic_id string: UUID A unique identifier of the meeting topic.
topic_order_index number The order index of the topic in the meeting.
topic_name string The title or description of the topic.
topic_deleted_at timestamp: SQL The time the topic was deleted.
item_id string: UUID A unique identifier of the action item.
item_order_index number The order index of the action item in the topic.
item_description string The description of the item.
item_status enum: string The status of the item.
cross_series_id string: UUID The series ID of the item. All follow-up items share the same series ID.
due_date timestamp: SQL The due date of the item.
item_created_by string The ID of the user that created the item.
item_updated_at timestamp: SQL The time at which the item was last updated.
item_deleted_at timestamp: SQL The time at which the item was deleted.
assignees string A list of assignees of the action item.

meeting_participants

Column name Data type Description
meeting_id string: UUID A unique identifier of the meeting.
series_id string: UUID A unique identifier representing a meeting series. All follow-up meetings that belong to the same series share the same ID.
title string The title of the meeting.
meeting_description string Text describing the meeting's agenda or purpose.
summary string The summary of the meeting.
meeting_status enum: string
Possible values: open
minutes		 The current status of the meeting.
num_in_series number Index of the meeting in the series.
meeting_location string The location of the meeting.
starts_at timestamp: SQL The start time of the meeting.
duration number The total duration of the meeting.
video_conference_link string The URL link to the video conference for the meeting.
meeting_created_by string The ID of the user that created the meeting.
meeting_updated_by string The ID of the user that last updated the meeting.
meeting_created_at timestamp: SQL The time the meeting was created.
meeting_updated_at timestamp: SQL The time the meeting was last updated.
meeting_deleted_at timestamp: SQL The time the meeting was deleted.
participant_id string: UUID A unique identifier of the participant.
participant_name string The name of the participant, derived from their Autodesk (Oxygen) ID and joined with the Admin tables; for example, "John Smith (Autodesk)".
non_member_participant_name string The name of the participant if they are not a member of the project, construed from the first_name, last_name, and company fields in the non_member_participants table. For example, "John Smith (Autodesk)".
participant_type enum: string
Possible values: organizer
invitee		 Indicates the type of the meeting participant.
participation_status enum: string
Possible values: present
missing		 Indicates the participation status of the meeting participant.
participant_deleted_at timestamp: SQL The time the participant was deleted.

Reviews

In addition to the Project Attributes listed above, the Reviews dataset includes the following datasets:

reviews

Column name Data type Description
review_id string: UUID A unique identifier of the review.
sequence_id string: UUID A user-friendly ID of a review sequence.
review_status enum: string
Possible values: initiating, open, closed, void, failed, closing, processing		 The current status of the review.
review_name string The name of the review.
workflow_name string The name of the workflow that the review is associated with.
memo string The note of the review.
created_at timestamp: SQL The time the review was created.
updated_at timestamp: SQL The time the review was last updated.
next_due_date timestamp: SQL The next due date of the review.
started_at timestamp: SQL he time the review was started.
finished_at timestamp: SQL The time the review was finished.
created_by string The name of the user that created the review.
docs_count number The number of reviewing documents associated with the review.
approved_count number Number of documents that have been approved in the review.
rejected_count number Number of documents that have been rejected in the review.
current_round_num number Current round number of the review.
current_step number Current step of the review.
total_steps number Total number of steps in the review.
review_step_name string The name of the review step display name as created in the workflow.
created_by string The name of the user that created the review.
creator_user_company string The company associated with the user (in the project) that created the review.
creator_user_roles string A list of roles assigned to the user (in the project) that created the review.
next_action_candidates_users string A list of candidate users in the next action.
next_action_candidates_roles string A list of candidate roles in the next action.
next_action_candidates_companies string A list of candidate companies in the next action.
next_action_candidates_all string A list of all candidate names (users, roles, and companies) in the next action.
next_action_claimed_by string A list of user names for the users claimed the next action.

reviews_comments

Column name Data type Description
comment_id string: UUID A unique identifier of the comment.
comment_created_at timestamp: SQL Time the comment was created.
comment_text string The content of the comment.
comment_by string The name of the user that created the comment.
comment_by_email string Email of the user that created the comment.
review_id string: UUID A unique identifier of the review that the comment belongs to.
sequence_id number A user-friendly ID of the review.
updated_at timestamp: SQL The time the comment was last updated.
review_status enum: string Possible values: initiating, open, closed, void, failed, closing, processing Status of the review.
review_name string The name of the review.
workflow_name string The name of the workflow.
current_step number The current step of the review.
total_steps number The total number of steps in the review.
next_action_candidates_all string: null A list of all candidate names (users, roles, and companies) in the next action.
created_by string The name of the user that created the review.

RFIs

In addition to the Project Attributes listed above, the RFIs dataset includes the following columns:

Column name Data type Description
rfi_id string: UUID Unique identifier of the RFI.
custom_identifier string Custom identifier for the RFI.
title string RFI title.
question string RFI question.
status enun: string Current status of the RFI.
due_date datetime Time the RFI is due.
official_response string Official response of the RFI.
official_response_status string Official response of the RFI.
responded_at datetime Time the RFI was responded to.
responded_by string Name of the user that responded to the RFI.
created_by string Name of the user that created the RFI.
created_at datetime Time the RFI was created.
updated_by string Name of the user that updated the RFI.
updated_at datetime Time the RFI was updated.
closed_by string Name of the user that closed the RFI.
closed_at datetime Time the RFI was closed.
suggested_answer string The suggested answer for the RFI.
manager string Name of the RFI manager.
answered_at datetime Last time the RFI answer attribute was updated.
answered_by string Name of the user that updated the RFI answer attribute.
cost_impact enum: string Cost impact of this RFI.
schedule_impact enum: string Schedule impact of this RFI.
priority enum: string Priority of the RFI.
external_id string Reference of the RFI.
category string Category to associate with this RFI.
discipline string Discipline to associate with this RFI.
location_path string Full location tree path.
ball_in_court string List of user names that the RFI is assigned to.
reviewers string List of names of the RFI reviewers.
co-reviewers string List of the RFI coreviewers.
opened_at timestamp: SQL Timestamp of the RFI or in review date.
comment_body string Content of the comment.
distr_list_user List of usernames of the watchers.
location_id string: UUID The associated Location object IDs.
location_path string Full location tree path.
response_content string Content of the response.

Sheets

In addition to the Project Attributes listed above, the Sheets dataset includes the following columns:

Note: The following dataset refers to Sheets in Autodesk Build, and does not include Sheets in Autodesk Takeoff.

sheets-build

Column name Data type Description
sheet_id string: UUID A unique identifier for a sheet.
sheet_lineage_id string: UUID A unique identifier representing the lineage of the sheet. All versions or revisions of the same sheet share the same sheet_lineage_id, allowing tracking of a sheet's version history within the system.
sheet_number string A unique identifier for the sheet used to organize and reference individual sheets within a set of construction or design drawings. It's referred to as "number" in the user interface and "name" in the dataset.
sheet_title string The title of the sheet, providing a descriptive name that summarizes the sheet's content or purpose.
sheet_tags string A list of all tags associated with the sheet. If no tags are assigned, the field returns "Untagged".
num_tags string The total count of distinct tags assigned to a sheet. Returns 0 if the sheet has no tags.
discipline string Represents the discipline associated with a sheet. Displays the discipline designator and name as shown in the UI. Returns "Unordered" if discipline_index = 1000, returns only the designator if the name is empty; otherwise, formatted as designator (name)
upload_file_published_at timestamp: SQL The timestamp indicating when the sheet was created, based on the publication time of the upload file.
upload_file_published_by string The name and company of the user who created the sheet by publishing the upload file. If the user account had been deleted, the field displays Name (Removed).
sheet_updated_at timestamp: SQL The timestamp of the most recent update to the sheet.
sheet_updated_by string The name and company of the user who last updated the sheet. If the user account had been deleted, the field displays Name (Removed).
version_set string The name of the version set to which the sheet belongs. If the sheet had been deleted, this field shows the version set name at the time of deletion (original_set_name).
issuance_date timestamp: SQL The issuance date of the version set.
version_set_created_at timestamp: SQL The timestamp when the version set was created. Records the exact date and time the version set was initially established.
version_set_created_by string The name and company of the user who created the version set. If the user account had been deleted, the field displays Name (Removed).
version_set_updated_at timestamp: SQL The timestamp of the most recent update to the version set.
version_set_updated_by string The name and company of the user who last update the version set. If the user account had been deleted, it displays Name (Removed).
is_current string Indicates whether the sheet is the most recent version. Returns Yes if it is the latest version, and No otherwise. Note: All deleted sheets have a value of No.
storage_size bigint The storage size of the sheet, measured in bytes.
num_versions bigint The number of versions associated with the sheet.
upload_file_name string The name of the uploaded file from which the sheet originates.
upload_id string: UUID A unique identifier of the uploaded file from which the sheet originates.
processing_state string Represents the current processing state of the sheet.
is_deleted string Indicates whether the sheet was deleted. Returns Yes if deleted and No otherwise.
deleted_at timestamp: SQL The timestamp indicating when the sheet was deleted. Records the exact date and time the sheet was removed from the system.
deleted_by string The name and company of the user who deleted the sheet. Displays Name (Removed) if the user was deleted.

Submittals

In addition to the Project Attributes listed above, the Submittals dataset includes the following columns:

Column name Data type Description
ball_in_court string User ID of the users that are ball in court for the item workflow.
created_at timestamp: SQL Time the submittal item was created.
created_by string Name of the user that created the submittal item.
description string Description of the submittal item.
due_date date: string Date and time for the submittal item to be done with current state.
identifier string Identifier of the submittal item, created automatically.
lead_time number Lead time of the submittal item.
manager string Name of the user, role, or company of the submittal's manager.
manager_due_date date: string Date indicating when the manager review is due.
number string Number of the submittal item.
package string Title of the package the item is related to, if any.
package ID string: UUID ID for the associated package.
Foreign Key:
Table: packages
Column:id
package_identifier number Identifier of the package the item is related to, if any.
priority enum: string Value of the priority_id.
published_by string Autodesk User ID of the user that published the item.
published_date timestamp: SQL Time the item was closed and distributed.
received_from_review timestamp: SQL Time the review finished.
received_from_submitter timestamp: SQL Time the submitter moved the item forward.
received_approval_date date: string Date the review was approved.
required_date date: string Item's required date.
required_on_job_date date: string Date the item is required on the job site.
responded_at timestamp: SQL Time the response was added.
responded_by string User ID of the user that responded.
response_comment string Response comment of the item (in addition to to response id)
response_id string ID of the response.
response_value string Value of the response_id.
responsible_contractor string Name of the user, role, or company of the responsible contractor.
responsbile_contractor_company string Company of the responsible contractor.
responsible_contractor_user string User name of the responsible contractor.
revision number Revision of the item.
sent_to_review timestamp: SQL Time the first review step started.
sent_to_review_by string Autodesk User ID of the user that submitted the item for review.
sent_to_submitter timestamp: SQL Indicates when the submitter received the item.
spec string Title (name) of the item.
spec_id string: UUID ID for the Spec Section.
spec_identifier string Identifier of the spec this section is related to.
spec_sub_section string Spec sub section.
state_id enum: string State of the item.
status string Value of the status_id.
subcontractor Autodesk User ID/ Role member group ID/ Company member group ID of the responsible contractor
submittal_id string: UUID Unique identifier of the submittal item.
submittal_by string Name of the user that submitted the item to the manager.
submitter_due_date date: string Indicates when the responsible contractor submission is due.
title string Name of the item.
type_id string: UUID ID of the item type.
type_value string Value of the item type_id.
updated_at timestamp: SQL Time the submittal was last updated.
updated_by string Name of the user that last updated the submittal.

Schedule

In addition to the Project Attributes listed above, the Schedule dataset includes the following datasets:

schedules

Column name Data type Description
schedule_id string: UUID Unique identifier for the schedule.
schedule_name string Name of the schedule.
schedule_type enum: string
Possible values: XER, XML, MPP, PP		 Type of schedule file.
schedule_version_number number Revision number of the schedule.
schedule_is_public boolean Indicates if the schedule is available to all project members or only to a restricted list.
schedule_created_by string User who created the schedule.
schedule_created_at string Time the schedule was created.
schedule_updated_by string User who last updated the schedule.
schedule_updated_at timestamp: SQL Time the schedule was last updated.

schedule-activities

Column name Data type Description
schedule_id string: UUID Unique identifier for the schedule.
schedule_name string Name of the schedule.
schedule_type enum: string
Possible values: XER, XML, MPP, PP		 Type of schedule file.
schedule_version_number number Revision number of the schedule.
schedule_is_public boolean Indicates if the schedule is available to all project members or only to a restricted list.
schedule_created_by string User who created the schedule.
schedule_created_at string Time the schedule was created.
schedule_updated_by string User who last updated the schedule.
schedule_updated_at timestamp: SQL Time the schedule was last updated.
activity_id string: UUID Unique identifier for the activity.
activity_unique_id number Activity identifier in the scheduling software.
activity_sequential_id string Sequential identifier of the activity.
activity_parent_unique_id number Parent activity identifier in the scheduling software.
activity_type enum: string
Possible values: MILESTONE, ACTIVITY		 Type of activity.
activity_name string Name of the activity.
activity_is_critical_path boolean Indicates if the activity is on the critical path.
activity_completion_percentage number Completion percentage of the activity.
activity_planned_start timestamp: SQL Planned start date of the activity.
activity_planned_finish timestamp: SQL Planned finish date of the activity.
activity_actual_start timestamp: SQL Actual start date of the activity.
activity_actual_finish timestamp: SQL Actual finish date of the activity.
activity_start timestamp: SQL Calculated start display date of the activity.
activity_finish timestamp: SQL Calculated finish display date of the activity.
activity_duration number Duration of the activity in days.
activity_actual_duration number Actual duration of the activity in days.
activity_remaining_duration number Remaining duration of the activity in days.
activity_free_slack_units string Units of the free slack for the activity.
activity_free_slack_duration number Free slack duration in the units in activity_free_slack_units.
activity_total_slack_units string Units of the total slack for the activity.
activity_total_slack_duration number Total slack duration in the units in activity_total_slack_units.
activity_is_wbs boolean Indicates if the activity is a WBS.
activity_wbs_path string WBS path of the activity, constructed from unique IDs.
activity_wbs_code string WBS code of the activity.
activity_created_at timestamp: SQL Time the activity was created.
activity_updated_at timestamp: SQL Time the activity was last updated.
activity_wbs_path_text string WBS path of the activity, constructed from names.
predecessor_sequential_id string Sequential identifier of the predecessor activity.
predecessor_name string Name of the predecessor activity.
successor_sequential_id string Sequential identifier of the successor activity.
successor_name string Name of the successor activity.

schedule-resources

Column name Data type Description
schedule_id string: UUID Unique identifier for the schedule.
schedule_name string Name of the schedule.
schedule_type enum: string
Possible values: XER, XML, MPP, PP		 Type of schedule file.
schedule_version_number number Revision number of the schedule.
schedule_is_public boolean Indicates if the schedule is available to all project members or only to a restricted list.
schedule_created_by string User who created the schedule.
schedule_created_at string Time the schedule was created.
schedule_updated_by string User who last updated the schedule.
schedule_updated_at timestamp: SQL Time the schedule was last updated.
activity_id string: UUID Unique identifier for the activity.
unique_id number Activity identifier in the scheduling software.
sequential_id string Sequential identifier of the activity.
parent_unique_id number Parent activity identifier in the scheduling software.
activity_type enum: string
Possible values: MILESTONE, ACTIVITY		 Type of activity.
activity_name string Name of the activity.
activity_is_critical_path boolean Indicates if the activity is on the critical path.
activity_completion_percentage number Completion percentage of the activity.
resource_id string: UUID Unique identifier for the resource.
resource_name string Name of the resource.
resource_type enum: string
Possible values: WORK, COST, MATERIAL		 Type of resource.
resource_email_address string
Max length: 1000		 Email address of the resource.
resource_created_at timestamp: SQL Time the resource was created.
resource_updated_at timestamp: SQL Time the resource was last updated.
Parent page: Insight Builder

Was this information helpful?