Appendix: Schema Changes¶
Archive Schema Changes 6.16.0 - 6.17.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.15.0 - 6.16.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.14.0 - 6.15.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Activity_Fact | arc_activity_name_key | Data type changed |
| ARC_Activity_Fact | arc_activity_type_key | Data type changed |
| ARC_Activity_Fact | arc_attribute_value_key1 | Data type changed |
| ARC_Activity_Fact | arc_attribute_value_key2 | Data type changed |
| ARC_Activity_Fact | arc_attribute_value_key3 | Data type changed |
| ARC_Activity_Fact | arc_attribute_value_key4 | Data type changed |
| ARC_Activity_Fact | arc_calendar_key | Data type changed |
| ARC_Activity_Fact | arc_contract_key | Data type changed |
| ARC_Activity_Fact | arc_customer_key | Data type changed |
| ARC_Activity_Fact | arc_location_key_end | Data type changed |
| ARC_Activity_Fact | arc_location_key_start | Data type changed |
| ARC_Activity_Fact | arc_region_group_key | Data type changed |
| ARC_Activity_Fact | arc_resource_key | Data type changed |
| ARC_Activity_Fact | arc_resource_type_key | Data type changed |
| ARC_Activity_Fact | arc_skill_group_key | Data type changed |
| ARC_Activity_Name | key | Data type changed |
| ARC_Activity_Name_Key | key | Data type changed |
| ARC_Activity_Type | key | Data type changed |
| ARC_Activity_Type_Key | key | Data type changed |
| ARC_Allocation_Fact | arc_activity_name_key | Data type changed |
| ARC_Allocation_Fact | arc_activity_type_key | Data type changed |
| ARC_Allocation_Fact | arc_attention_key | Data type changed |
| ARC_Allocation_Fact | arc_attribute_value_key1 | Data type changed |
| ARC_Allocation_Fact | arc_attribute_value_key2 | Data type changed |
| ARC_Allocation_Fact | arc_attribute_value_key3 | Data type changed |
| ARC_Allocation_Fact | arc_attribute_value_key4 | Data type changed |
| ARC_Allocation_Fact | arc_contract_key | Data type changed |
| ARC_Allocation_Fact | arc_customer_key | Data type changed |
| ARC_Allocation_Fact | arc_location_key_end | Data type changed |
| ARC_Allocation_Fact | arc_location_key_start | Data type changed |
| ARC_Allocation_Fact | arc_region_group_key | Data type changed |
| ARC_Allocation_Fact | arc_resource_key | Data type changed |
| ARC_Allocation_Fact | arc_resource_type_key | Data type changed |
| ARC_Allocation_Fact | arc_skill_group_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_activity_name_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_activity_type_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_attention_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_attribute_value_key1 | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_attribute_value_key2 | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_attribute_value_key3 | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_attribute_value_key4 | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_contract_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_customer_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_location_key_end | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_location_key_start | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_region_group_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_resource_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_resource_type_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_skill_group_key | Data type changed |
| ARC_Allocation_Snapshot_Fact | arc_snapshot_detail_key | Data type changed |
| ARC_Area | key | Data type changed |
| ARC_Area_Key | key | Data type changed |
| ARC_Attention | key | Data type changed |
| ARC_Attention_Key | key | Data type changed |
| ARC_Attribute_Value | key | Data type changed |
| ARC_Attribute_Value_Key | key | Data type changed |
| ARC_Audit | change_id | Data type changed |
| ARC_Audit | enacting_app_instance_id | Maximum string length increased to 128 |
| ARC_Audit | id | Data type changed |
| ARC_Audit | plan_id | Data type changed |
| ARC_Audit | requesting_app_instance_id | Maximum string length increased to 128 |
| ARC_Calendar | key | Data type changed |
| ARC_Calendar_Key | key | Data type changed |
| ARC_Contract | key | Data type changed |
| ARC_Contract_Key | key | Data type changed |
| ARC_Customer | key | Data type changed |
| ARC_Customer_Key | key | Data type changed |
| ARC_Fuel_Type | key | Data type changed |
| ARC_Fuel_Type_Key | key | Data type changed |
| ARC_Location | key | Data type changed |
| ARC_Location | location_type_description | Maximum string length increased to 2000 |
| ARC_Location_Key | key | Data type changed |
| ARC_Plan_Fact | plan_id | Data type changed |
| ARC_Plan_Snapshot_Fact | arc_snapshot_detail_key | Data type changed |
| ARC_Region | key | Data type changed |
| ARC_Region_Group | arc_region_key_single | Data type changed |
| ARC_Region_Group | key | Data type changed |
| ARC_Region_Group_Item | arc_region_group_key | Data type changed |
| ARC_Region_Group_Item | arc_region_key | Data type changed |
| ARC_Region_Group_Key | key | Data type changed |
| ARC_Region_Hierarchy | arc_region_key_child | Data type changed |
| ARC_Region_Hierarchy | arc_region_key_parent | Data type changed |
| ARC_Region_Key | key | Data type changed |
| ARC_Request | audit_id | Data type changed |
| ARC_Request | cancelling_app_instance_id | Maximum string length increased to 128 |
| ARC_Request | id | Data type changed |
| ARC_Request | requesting_app_instance_id | Maximum string length increased to 128 |
| ARC_Request | snapshot_id | Data type changed |
| ARC_Request_Clear_Data | arc_request_id | Data type changed |
| ARC_Request_Clear_Resource | arc_request_id | Data type changed |
| ARC_Resource | arc_attribute_value_key1 | Data type changed |
| ARC_Resource | arc_attribute_value_key2 | Data type changed |
| ARC_Resource | arc_attribute_value_key3 | Data type changed |
| ARC_Resource | arc_attribute_value_key4 | Data type changed |
| ARC_Resource | arc_region_group_key | Data type changed |
| ARC_Resource | arc_resource_type_key | Data type changed |
| ARC_Resource | arc_skill_group_key | Data type changed |
| ARC_Resource | key | Data type changed |
| ARC_Resource_Fact | arc_attribute_value_key1 | Data type changed |
| ARC_Resource_Fact | arc_attribute_value_key2 | Data type changed |
| ARC_Resource_Fact | arc_attribute_value_key3 | Data type changed |
| ARC_Resource_Fact | arc_attribute_value_key4 | Data type changed |
| ARC_Resource_Fact | arc_region_group_key | Data type changed |
| ARC_Resource_Fact | arc_resource_key | Data type changed |
| ARC_Resource_Fact | arc_resource_type_key | Data type changed |
| ARC_Resource_Fact | arc_skill_group_key | Data type changed |
| ARC_Resource_Key | key | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_attribute_value_key1 | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_attribute_value_key2 | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_attribute_value_key3 | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_attribute_value_key4 | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_region_group_key | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_resource_key | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_resource_type_key | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_skill_group_key | Data type changed |
| ARC_Resource_Snapshot_Fact | arc_snapshot_detail_key | Data type changed |
| ARC_Resource_Type | key | Data type changed |
| ARC_Resource_Type_Key | key | Data type changed |
| ARC_Skill | key | Data type changed |
| ARC_Skill | skill_type_description | Maximum string length increased to 2000 |
| ARC_Skill_Group | arc_skill_key_single | Data type changed |
| ARC_Skill_Group | key | Data type changed |
| ARC_Skill_Group_Item | arc_skill_group_key | Data type changed |
| ARC_Skill_Group_Item | arc_skill_key | Data type changed |
| ARC_Skill_Group_Key | key | Data type changed |
| ARC_Skill_Hierarchy | arc_skill_key_child | Data type changed |
| ARC_Skill_Hierarchy | arc_skill_key_parent | Data type changed |
| ARC_Skill_Key | key | Data type changed |
| ARC_Snapshot | id | Data type changed |
| ARC_Snapshot | last_change_id | Data type changed |
| ARC_Snapshot | last_load_id | Data type changed |
| ARC_Snapshot | last_plan_change_id | Data type changed |
| ARC_Snapshot | last_plan_complete_id | Data type changed |
| ARC_Snapshot_Detail | arc_snapshot_id | Data type changed |
| ARC_Snapshot_Detail | input_reference_internal_id | Data type changed |
| ARC_Snapshot_Detail | input_reference_internal_id_load | Data type changed |
| ARC_Snapshot_Detail | key | Data type changed |
| ARC_Snapshot_Detail | plan_id | Data type changed |
| ARC_Snapshot_Info | snapshot_id | Data type changed |
| ARC_Travel_Fact | arc_activity_name_key_next | Data type changed |
| ARC_Travel_Fact | arc_activity_name_key_previous | Data type changed |
| ARC_Travel_Fact | arc_area_key_end | Data type changed |
| ARC_Travel_Fact | arc_area_key_start | Data type changed |
| ARC_Travel_Fact | arc_location_key_end | Data type changed |
| ARC_Travel_Fact | arc_location_key_start | Data type changed |
| ARC_Travel_Fact | arc_region_group_key_end | Data type changed |
| ARC_Travel_Fact | arc_region_group_key_start | Data type changed |
| ARC_Travel_Fact | arc_resource_key | Data type changed |
| ARC_Travel_Fact | arc_vehicle_key | Data type changed |
| ARC_Travel_Fact | arc_vehicle_model_key | Data type changed |
| ARC_Travel_Fact | id | Data type changed |
| ARC_Update | id | Data type changed |
| ARC_Vehicle | arc_vehicle_model_key | Data type changed |
| ARC_Vehicle | key | Data type changed |
| ARC_Vehicle_Class | key | Data type changed |
| ARC_Vehicle_Class_Key | key | Data type changed |
| ARC_Vehicle_Key | key | Data type changed |
| ARC_Vehicle_Model | arc_fuel_type_key | Data type changed |
| ARC_Vehicle_Model | arc_vehicle_class_key | Data type changed |
| ARC_Vehicle_Model | arc_vehicle_ownership_type_key | Data type changed |
| ARC_Vehicle_Model | key | Data type changed |
| ARC_Vehicle_Model_Key | key | Data type changed |
| ARC_Vehicle_Ownership_Type | key | Data type changed |
| ARC_Vehicle_Ownership_Type_Key | key | Data type changed |
Archive Schema Changes 6.13.0 - 6.14.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.12.0 - 6.13.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.11.0 - 6.12.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Activity_Fact | arc_snapshot_detail_key | Column removed |
| ARC_Activity_Fact | last_updated | Column added |
| ARC_Allocation_Fact | Table added | |
| ARC_Allocation_Snapshot_Fact | arc_dataset_key | Column no longer included in primary key |
| ARC_Attribute_Value | last_updated | Column added |
| ARC_Dataset | last_updated | Column added |
| ARC_Plan_Fact | Table added | |
| ARC_Plan_Snapshot_Fact | arc_dataset_key | Column added |
| ARC_Region_Group | last_updated | Column added |
| ARC_Resource_Fact | Table added | |
| ARC_Resource_Snapshot_Fact | arc_dataset_key | Column no longer included in primary key |
| ARC_Skill_Group | last_updated | Column added |
| ARC_Snapshot_Timetable | enable_continuous_reporting | Column added |
| ARC_Travel_Fact | arc_activity_name_key_next | Column added |
| ARC_Travel_Fact | arc_activity_name_key_previous | Column added |
| ARC_Travel_Fact | arc_snapshot_detail_key | Column removed |
| ARC_Travel_Fact | last_updated | Column added |
| ARC_Travel_Fact | visit_id_next | Column added |
| ARC_Travel_Fact | visit_id_previous | Column added |
| ARC_Vehicle | arc_vehicle_model_key | Column now optional |
| ARC_Vehicle_Model | arc_fuel_type_key | Column now optional |
| ARC_Vehicle_Model | arc_vehicle_class_key | Column now optional |
Archive Schema Changes 6.10.0 - 6.11.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Audit | enacting_app_instance_id | Maximum string length increased to 80 |
| ARC_Audit | requesting_app_instance_id | Maximum string length increased to 80 |
| ARC_Request | cancelling_app_instance_id | Maximum string length increased to 80 |
| ARC_Request | requesting_app_instance_id | Maximum string length increased to 80 |
Archive Schema Changes 6.9.0 - 6.10.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Data_Update | object_pk1 | Maximum string length increased to 256 |
| ARC_Data_Update | object_pk2 | Maximum string length increased to 256 |
| ARC_Data_Update | object_pk3 | Maximum string length increased to 256 |
| ARC_Data_Update | object_pk4 | Maximum string length increased to 256 |
| ARC_Data_Update | object_pk5 | Maximum string length increased to 256 |
| ARC_Fuel_Type | Table added | |
| ARC_Fuel_Type_Key | Table added | |
| ARC_Time_Zone | iana_id | Column added |
| ARC_Time_Zone | windows_id | Column added |
| ARC_Travel_Fact | arc_vehicle_key | Column added |
| ARC_Travel_Fact | arc_vehicle_model_key | Column added |
| ARC_Vehicle | Table added | |
| ARC_Vehicle_Class | Table added | |
| ARC_Vehicle_Class_Key | Table added | |
| ARC_Vehicle_Key | Table added | |
| ARC_Vehicle_Model | Table added | |
| ARC_Vehicle_Model_Key | Table added | |
| ARC_Vehicle_Ownership_Type | Table added | |
| ARC_Vehicle_Ownership_Type_Key | Table added |
Archive Schema Changes 6.8.0 - 6.9.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Activity_Duration_Estimate | location_id | Column added |
| ARC_Activity_Duration_Estimate | spatial_key | Column added |
| ARC_Activity_Fact | input_duration_minutes | Column added |
| ARC_Activity_State | completed_label | Maximum string length increased to 500 |
| ARC_Activity_State | hit_sla_label | Maximum string length increased to 500 |
| ARC_Activity_State | is_scheduled_label | Maximum string length increased to 500 |
| ARC_Allocation_Detail | fixed_resource_label | Maximum string length increased to 500 |
| ARC_Allocation_Detail | fixed_time_label | Maximum string length increased to 500 |
| ARC_Allocation_Detail | same_location_label | Maximum string length increased to 500 |
| ARC_Allocation_Detail | source_label | Maximum string length increased to 500 |
| ARC_Location | spatial_key | Column added |
Archive Schema Changes 6.7.0 - 6.8.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.6.0 - 6.7.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Audit | result_id | Column added |
| ARC_Audit | update_successful | Column added |
Archive Schema Changes 6.5.0 - 6.6.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Location | latitude | Column added |
| ARC_Location | longitude | Column added |
Archive Schema Changes 6.4.0 - 6.5.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.3.0 - 6.4.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.2.0 - 6.3.0¶
There were no changes to the schema in this version.
Archive Schema Changes 6.1.0 - 6.2.0¶
| Table | Column | Change |
|---|---|---|
| ARC_Request | audit_id | Column added |
Archive Schema Changes 6.0.0 - 6.1.0¶
There were no changes to the schema in this version.
Archive Schema Changes 5.9.0 - 6.0.0¶
There were no changes to the schema in this version.