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:
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 is made up of the following:
| 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 is made up of the following:
| 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 is made up of the following:
| 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. |
Reviews
reviews
In addition to the Project Attributes listed above, the Reviews dataset is made up of the following:
| Column name | Data type | Description |
|---|---|---|
| review_id | string: UUID | Unique identifier of the review. |
| sequence_id | string: UUID | 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 | Name of the review. |
| workflow_name | string | Name of the workflow that the review is associated with. |
| memo | string | Note of the review. |
| created_at | timestamp: SQL | Time the review was created. |
| updated_at | timestamp: SQL | Time the review was last updated. |
| next_due_date | timestamp: SQL | Next due date of the review. |
| started_at | timestamp: SQL | Time the review was started. |
| finished_at | timestamp: SQL | Time the review was finished. |
| created_by | string | Name of the user that created the review. |
| docs_count | number | 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 | Name of the review step display name as created in the workflow. |
| created_by | string | Name of the user that created the review. |
| creator_user_company | string | Company assosciated with the user (in the project) that created the review. |
| creator_user_roles | string | List of roles assigned to the user (in the project) that created the review. |
| next_action_candidates_users | string | List of candidate users in the next action. |
| next_action_candidates_roles | string | List of candidate roles in the next action. |
| next_action_candidates_companies | string | List of candidate companies in the next action. |
| next_action_candidates_all | string | List of all candidate names (users, roles, and companies) in the next action. |
| next_action_claimed_by | string | List of user names for the users claimed the next action. |
reviews_comments
| Column name | Data type | Description |
|---|---|---|
| comment_id | string: UUID | Unique identifier of the comment. |
| comment_created_at | timestamp: SQL | Time the comment was created. |
| comment_text | string | Content of the comment. |
| comment_by | string | Name of the user that created the comment. |
| comment_by_email | string | Email of the user that created the comment. |
| review_id | string: UUID | Unique identifier of the review that the comment belongs to. |
| sequence_id | number | User-friendly ID of the review. |
| updated_at | timestamp: SQL | 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 | Name of the review. |
| workflow_name | string | Name of the worfklow. |
| current_step | number | Current step of the review. |
| total_steps | number | Total number of steps in the review. |
| next_action_candidates_all | string: null | List of all candidate names (users, roles, and companies) in the next action. |
| created_by | string | Name of the user that created the review. |
RFIs
In addition to the Project Attributes listed above, the RFI dataset is made up of the following:
| 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. |
Submittals
In addition to Project Attributes listed above, the Submittals dataset is made up of the following:
| 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. |
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 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 | Time weather data was fetched. |
| precipitation_accumulation | number | Total precipitation for the day (inches). |
forms-with-questions (only for native forms)
In addition to Project Attributes listed above, the forms-with-questions dataset is made up of the following:
| 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 | Name of the template. |
| template_type | string | Template type of the form. |
| status | string | Status of the form. |
| assigned_to | string | Person the form is assigned to. |
| number | number | A user-facing report number. |
| form_date | date | Date set on the form. |
| notes | string | User filled notes. |
| description | string | User filled description. |
| created_by | string | Person who created the form. |
| created_at | timestamp | Time the form created. |
| updated_at | timestamp | Time the form was last updated. |
| location_path | string | Full location free path. |
| last_reopened_by | string | Person that last reopened the form. |
| last_submitter_signed | boolean | Signed or not. |
| due_date | timestamp | Time the form is due. |
| last_submitted_at | timestamp | Time the form was submitted. |
| assignee_type | string | Type of an assignee. |
| section_index | number | Index of a form section. |
| section_name | string | Name of the form section. |
| section_assignee | string | Section assignee. |
| question_index | number | Index of the form question. |
| question | string | Description of the form question. |
| answer | string | Form question answer. |
| answer_id | string: UUID | A unique ID of the answer. |
| answer_rank | number | Rank of the answer. |
| answer_type | string Possible values: - array_val, - choice_val, date_val, - number_val, - svg_val, -text_val, -toggle_val |
Type of an answer. |
| signature_name | string | 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 is made up of the following:
| Column name | Data type | Description |
|---|---|---|
| native_form_id | string: UUID | Unique identfier of the native form that the value belongs to. |
| form_id | string: UUID | A unique ID of the form. |
| form_name | string | Name of the form. |
| status | string | Status of the form. |
| template_name | string | Name of the form template. |
| form_date | date | Date set on the form. |
| status | string | Status of the form. |
| template_name | string | Name of the form template. |
| form_date | date | Date specified on the form. |
| number | number | User facing form number. |
| discipline | string | Discipline for work log item. |
| company | string | Company for work log item. |
| role | string | Role for work log item. |
| number_of_workers | number | Number of workers for the work log item. |
| number_regular_hours | number | Number of regular hours for work log item. |
| number_of_hours | number | Number of overtime hours for work log item. |
| total_regular_hours | number | Total regular hours (number of workers * number of regular hours.) |
| total_of_hours | number | Total overtime hours (number of workers * number of overtime hours.) |
| work_performed | string | Description of performed work. |
Schedule
In addition to the Project Attributes listed above, the Schedule dataset is made up of the following:
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. |