schedule Schema Description
Documentation Updated: 2023-12-04activities
Schedule activities belonging to the latest schedule revision| ordinal_position | column_name | data_type | constraints | notes |
|---|---|---|---|---|
| 1 | id | string: UUID | The activity ID | |
| 2 | schedule_id | string: UUID | The schedules ID for the activity Foreign Key: Table: schedules Column: id | |
| 3 | bim360_account_id | string: UUID | BIM 360 HQ Account ID. | |
| 4 | bim360_project_id | string: UUID | BIM 360 HQ Project ID. | |
| 5 | unique_id | number | The activity unique id in the User's scheduling software | |
| 6 | sequential_id | number | The sequential ID of the activity | |
| 7 | file_activity_id | string | The activity ID field in the Schedule file | |
| 8 | parent_unique_id | number | The parent activity unique id in the User's scheduling software | |
| 9 | type | enum: string | Possible Values:
| detailed column 7 description |
| 10 | name | string: null | The activity name | |
| 11 | is_critical_path | boolean | Is the activity in the schedule's critical path | |
| 12 | completion_percentage | number | The activity completion percentage | |
| 13 | planned_start | timestamp: SQL | When the activity was planned to start | |
| 14 | planned_finish | timestamp: SQL | When the activity was planned to finish | |
| 15 | actual_start | timestamp: SQL | When the activity actually started | |
| 16 | actual_finish | timestamp: SQL | When the activity actually finished | |
| 17 | start | timestamp: SQL | A calculated field to determine the start display date of the activity | |
| 18 | finish | timestamp: SQL | A calculated field to determine the finish display date of the activity | |
| 19 | duration | number | The duration of the activity in days | |
| 20 | actual_duration | number | The actual duration of the activity in days | |
| 21 | remaining_duration | number | The remaining duration of the activity in days | |
| 22 | free_slack_units | string | Units of the free (remaining) slack of the activity | |
| 23 | free_slack_duration | number | The free (remaining) slack of the activity in the units in column free_slack_units | |
| 24 | total_slack_units | string | Units of the total slack of the activity | |
| 25 | total_slack_duration | number | The total slack of the activity in the units in column total_slack_units | |
| 26 | is_wbs | boolean | Is the activity a WBS | |
| 27 | wbs_path | string: null | The WBS Path of the activity, constracted from unique ids, string array // [1,2,3,4] -> "[1,2,3,4]" | |
| 28 | wbs_code | string: null | The WBS code of the activity | |
| 29 | created_at | timestamp: SQL | Creation time of the activity | |
| 30 | updated_at | timestamp: SQL | Update time of the activity | |
| 31 | wbs_path_text | string: null | The WBS Path of the activity, constracted from names, string array |
activity_codes
Activity codes (Custom attributes) assignments to Activities belonging to the latest schedule revision| ordinal_position | column_name | data_type | constraints | notes |
|---|---|---|---|---|
| 1 | id | string: UUID | The activity code ID (Activity code assignment ID) | |
| 2 | schedule_id | string: UUID | The schedule id of the activity code Foreign Key: Table: schedules Column: id | |
| 3 | bim360_account_id | string: UUID | BIM 360 HQ Account ID. | |
| 4 | bim360_project_id | string: UUID | BIM 360 HQ Project ID. | |
| 5 | activity_unique_id | number | The activity unique id in the User's scheduling software | |
| 6 | name | string | The name of the activity code | |
| 7 | value | string | The value code of the activity code assignment | |
| 8 | value_description | string: null | The value free text of the activity code assignment | |
| 9 | created_at | timestamp: SQL | Creation time of the activity code | |
| 10 | updated_at | timestamp: SQL | Update time of the activity code |
comments
Schedule update requests status changes| ordinal_position | column_name | data_type | constraints | notes |
|---|---|---|---|---|
| 1 | id | string: UUID | The comment ID | |
| 2 | schedule_id | string: UUID | The update request id for the status change request Foreign Key: Table: schedules Column: id | |
| 3 | bim360_account_id | string: UUID | BIM 360 HQ Account ID. | |
| 4 | bim360_project_id | string: UUID | BIM 360 HQ Project ID. | |
| 5 | activity_unique_id | number | The activity unique id in the User's scheduling software | |
| 6 | body | string | Max length: 10000 | The comment text |
| 7 | created_by | string | User who created the comment | |
| 8 | created_at | timestamp: SQL | Creation time of the comment |
dependencies
Activity dependencies (links) belonging to the latest schedule revision| ordinal_position | column_name | data_type | constraints | notes |
|---|---|---|---|---|
| 1 | id | string: UUID | The dependency ID | |
| 2 | schedule_id | string: UUID | The schedules ID for the revision Foreign Key: Table: schedules Column: id | |
| 3 | bim360_account_id | string: UUID | BIM 360 HQ Account ID. | |
| 4 | bim360_project_id | string: UUID | BIM 360 HQ Project ID. | |
| 5 | source_unique_id | number | The source activity unique id of the dependency | |
| 6 | target_unique_id | number | The target activity unique id of the dependency | |
| 7 | type | enum: string | ENUM VALUES: FINISH_FINISH, FINISH_START, START_FINISH, START_START | The type of dependency link |
| 8 | created_at | timestamp: SQL | Creation time of the dependency | |
| 9 | updated_at | timestamp: SQL | Update time of the dependency |
resources
Resource (Assignees) assignments to Activities belonging to the latest schedule revision| ordinal_position | column_name | data_type | constraints | notes |
|---|---|---|---|---|
| 1 | id | string: UUID | The resource ID (Resource assignment ID) | |
| 2 | schedule_id | string: UUID | The schedule id of the activity code Foreign Key: Table: schedules Column: id | |
| 3 | resource_unique_id | number | The resource unique id in the User's scheduling software | |
| 4 | bim360_account_id | string: UUID | BIM 360 HQ Account ID. | |
| 5 | bim360_project_id | string: UUID | BIM 360 HQ Project ID. | |
| 6 | activity_unique_id | number | The activity unique id in the User's scheduling software | |
| 7 | name | string | The name of the resource | |
| 8 | type | enum: string | ENUM VALUES: WORK, COST, MATERIAL | The type of resource |
| 9 | email_address | string | Max length: 1000 | The email address of the resource |
| 10 | created_at | timestamp: SQL | Creation time of the resource | |
| 11 | updated_at | timestamp: SQL | Update time of the resource |
schedules
Schedules in ACC Build| ordinal_position | column_name | data_type | constraints | notes |
|---|---|---|---|---|
| 1 | id | string: UUID | The schedule ID | |
| 2 | bim360_account_id | string: UUID | BIM 360 HQ Account ID. | |
| 3 | bim360_project_id | string: UUID | BIM 360 HQ Project ID. | |
| 4 | name | string | The schedule name | |
| 5 | type | enum: string | Possible Values:
| Schedule file type |
| 6 | version_number | number | The revision number of the schedule | |
| 7 | is_public | boolean | Is the schedule available to all project members or to a restricted list of users | |
| 8 | created_by | string | User who created the Schedule | |
| 9 | updated_by | string | User who updated the Schedule | |
| 10 | created_at | timestamp: SQL | Creation time of the schedule | |
| 11 | updated_at | timestamp: SQL | Update time of the schedule |