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.