Appendix: Schema Changes
Schema Changes 6.16.0 - 6.17.0
Scheduling Schema Changes 6.16.0 - 6.17.0
| Table | Column | Change |
|---|
| Activity | sla_template_id | Column added |
| Activity_Pool_Category | | Table added |
| Activity_Pool_Wrapper | | Table added |
| Activity_Type | sla_template_id | Column added |
| Availability_Set | availability_cost | Column added |
| Availability_Set | availability_visit_cost | Column added |
| Availability_Set_Item | availability_cost | Column added |
| Availability_Set_Item | availability_visit_cost | Column added |
| Resource_Type | parallel_index_categorisation | Column added |
| Resource_Wrapper | | Table added |
| Resources | parallel_index_categorisation | Column added |
| SLA_Template | | Table added |
| SLA_Template_Item | | Table added |
| Target_Focus | sequence | Column added |
| Target_Focus | target_focus_group_id | Column added |
| Target_Focus_Group | | Table added |
Modelling Schema Changes 6.16.0 - 6.17.0
There were no changes to the schema in this version.
Archive Schema Changes 6.16.0 - 6.17.0
There were no changes to the schema in this version.
System Schema Changes 6.16.0 - 6.17.0
There are no changes to the system schema in this version.
Schema Changes 6.15.0 - 6.16.0
Scheduling Schema Changes 6.15.0 - 6.16.0
| Table | Column | Change |
|---|
| Activity_Availability_Set | | Table added |
| Activity_Category | | Table added |
| Activity_Pool_Avail_Set | | Table added |
| Activity_Type_Avail_Set | | Table added |
| Activity_Type_Category | | Table added |
| Availability_Set | | Table added |
| Availability_Set_Item | | Table added |
| Broadcast_Data | | Table added |
| Categorisation | | Table added |
| Category | | Table added |
| Category_Custom_Metric | | Table added |
| Custom_Metric | categorisation_id | Column added |
| Location_Availability_Set | | Table added |
| Location_Type_Avail_Set | | Table added |
| Resource_Category | | Table added |
| Resource_Type_Category | | Table added |
| Rule_Parameter_Override | | Table added |
| Suggested_Split_Res_Order | | Table added |
Modelling Schema Changes 6.15.0 - 6.16.0
| Table | Column | Change |
|---|
| RAM_Activity_Type_Category | | Table added |
| RAM_Categorisation | | Table added |
| RAM_Category | | Table added |
| RAM_Category_Custom_Metric | | Table added |
| RAM_Custom_Metric | ram_categorisation_id | Column added |
| RAM_Resource_Category | | Table added |
| RAM_Resource_Type_Category | | Table added |
Archive Schema Changes 6.15.0 - 6.16.0
There were no changes to the schema in this version.
System Schema Changes 6.15.0 - 6.16.0
There are also changes to the system schema in this version.
Schema Changes 6.14.0 - 6.15.0
Scheduling Schema Changes 6.14.0 - 6.15.0
| Table | Column | Change |
|---|
| Activity | icon_id | Column added |
| Activity | remote_fulfillment | Column added |
| Activity_Pool | parent_activity_pool_id | Column added |
| Activity_Pool_Link | | Table added |
| Activity_Type | remote_fulfillment | Column added |
| Aggregate_Member | plan_id | Data type changed |
| Aggregated_Activity | plan_id | Data type changed |
| Allocation | fulfilled_remotely | Column added |
| Allocation | plan_id | Data type changed |
| Allocation_Data | plan_id | Data type changed |
| Allocation_Hint | | Table added |
| Allocation_Operation | plan_id | Data type changed |
| Allocation_Part | part_change_time | Column added |
| Allocation_Part | plan_id | Data type changed |
| Appointment_History | id | Data type changed |
| Appointment_History | input_reference_internal_id | Data type changed |
| Appointment_History | load_internal_id | Data type changed |
| Appointment_History | plan_id | Data type changed |
| Appointment_Offer | plan_id | Data type changed |
| Appointment_Summary | plan_id | Data type changed |
| Broadcast_History | application_instance_id | Maximum string length increased to 128 |
| Broadcast_History | id | Data type changed |
| Broadcast_History | input_reference_internal_id | Data type changed |
| Broadcast_History | plan_id | Data type changed |
| Broadcast_History | response | Data type changed |
| Dataset_Status | application_instance_id | Maximum string length increased to 128 |
| Dataset_Status | input_reference_internal_id | Data type changed |
| Explanation_Message_Param | plan_id | Data type changed |
| Explanation_Outcome | plan_id | Data type changed |
| Explanation_Outcome_Alloc | plan_id | Data type changed |
| Explanation_Outcome_Message | plan_id | Data type changed |
| Explanation_Request | plan_id | Data type changed |
| Explanation_Response | plan_id | Data type changed |
| Explanation_Response | requested_plan_id | Data type changed |
| Input_Load_Status | internal_id | Data type changed |
| Input_Reference | application_instance_id | Maximum string length increased to 128 |
| Input_Reference | enacting_app_instance_id | Maximum string length increased to 128 |
| Input_Reference | internal_id_parent_dataset | Data type changed |
| Input_Reference | load_id | Column added |
| Isochrone_Point | plan_id | Data type changed |
| Load_Info | last_change_internal_id | Data type changed |
| Load_Info | last_load_internal_id | Data type changed |
| Load_Info | load_input_reference_id | Column added |
| Load_Info | max_internal_id | Data type changed |
| Object_Deletion | cascade | Column added |
| Plan | application_instance_id | Maximum string length increased to 128 |
| Plan | id | Data type changed |
| Plan | input_reference_internal_id | Data type changed |
| Plan | last_plan_id | Data type changed |
| Plan | load_input_ref_internal_id | Column added |
| Plan_Area | plan_id | Data type changed |
| Plan_Break | plan_id | Data type changed |
| Plan_Deletion | plan_id | Data type changed |
| Plan_Depot_Transfer | plan_id | Data type changed |
| Plan_Direction | plan_id | Data type changed |
| Plan_Info | last_complete_plan_id | Data type changed |
| Plan_Info | last_internal_id | Data type changed |
| Plan_Info | last_plan_id | Data type changed |
| Plan_Info | max_plan_id | Data type changed |
| Plan_Load_Status | internal_id | Data type changed |
| Plan_Load_Status | plan_id | Data type changed |
| Plan_Point | plan_id | Data type changed |
| Plan_Polygon | plan_id | Data type changed |
| Plan_Resource | plan_id | Data type changed |
| Plan_Route | plan_id | Data type changed |
| Plan_Split_Resource_Order | plan_id | Data type changed |
| Plan_Travel | plan_id | Data type changed |
| Plan_Travel_Part_Usage | plan_id | Data type changed |
| Resource_Movement | plan_id | Data type changed |
| Schedule_Data_Usage | id | Data type changed |
| Schedule_Exception | plan_id | Data type changed |
| Schedule_Exception_Data | plan_id | Data type changed |
| Secured_Data | input_reference_internal_id | Data type changed |
| Secured_Data | plan_id | Data type changed |
| Split_Resource_Order_Hint | | Table added |
| Suggested_Change | plan_id | Data type changed |
| Suggested_Dispatch | plan_id | Data type changed |
| Travel_Detail | plan_id | Data type changed |
Modelling Schema Changes 6.14.0 - 6.15.0
| Table | Column | Change |
|---|
| RAM_Activity_Type | remote_fulfillment | Column added |
| RAM_Data_Request | id | Data type changed |
| RAM_Data_Request | ram_update_id | Data type changed |
| RAM_Demand | | Table removed |
| RAM_Demand_Data | | Table removed |
| RAM_Demand_Element | | Table removed |
| RAM_Demand_Element_Type | | Table removed |
| RAM_Exception | ram_response_id | Data type changed |
| RAM_Investigation | | Table removed |
| RAM_Investigation_Demand | | Table removed |
| RAM_Investigation_Resourcing | | Table removed |
| RAM_Investigation_Result | | Table removed |
| RAM_Investigation_Result_Data | | Table removed |
| RAM_Investigation_Result_Parameter | | Table removed |
| RAM_Investigation_Result_Resource_Change | | Table removed |
| RAM_Investigation_Result_Statistic | | Table removed |
| RAM_Investigation_Result_Target | | Table removed |
| RAM_Request | id | Data type changed |
| RAM_Request | ram_investigation_result_id | Column removed |
| RAM_Resourcing | | Table removed |
| RAM_Resourcing_Data | | Table removed |
| RAM_Resourcing_Element | | Table removed |
| RAM_Resourcing_Element_Type | | Table removed |
| RAM_Response | id | Data type changed |
| RAM_Response | ram_request_id | Data type changed |
| RAM_Rota | last_retrieved_update_id | Data type changed |
| RAM_Update | enacting_app_instance_id | Maximum string length increased to 128 |
| RAM_Update | id | Data type changed |
| RAM_Update | requesting_app_instance_id | Maximum string length increased to 128 |
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 |
System Schema Changes 6.14.0 - 6.15.0
There are also changes to the system schema in this version.
Schema Changes 6.13.0 - 6.14.0
Scheduling Schema Changes 6.13.0 - 6.14.0
| Table | Column | Change |
|---|
| Activity | split_model_id | Column added |
| Activity_Group | allow_ordered_across_shifts | Column added |
| Activity_Type | split_model_id | Column added |
| Expl_Split_Resource_Order | | Table added |
| Explanation_Message_Param | parameter_type | Column added |
| Explanation_Request_Change | base_duration | Column added |
| Explanation_Request_Change | fixed_date_time | Column added |
| Explanation_Request_Change | override_duration | Column added |
| Explanation_Request_Change | shift_start_time | Column now optional |
| Plan_Split_Resource_Order | | Table added |
| Split_Model | | Table added |
| Split_Resource_Order | | Table added |
Modelling Schema Changes 6.13.0 - 6.14.0
| Table | Column | Change |
|---|
| RAM_Activity_Type | ram_split_model_id | Column added |
| RAM_Resource | memo | Maximum string length increased to 4000 |
| RAM_Rota_Item | modified | Column added |
| RAM_Split_Model | | Table added |
Archive Schema Changes 6.13.0 - 6.14.0
There were no changes to the schema in this version.
System Schema Changes 6.13.0 - 6.14.0
There are also changes to the system schema in this version.
Schema Changes 6.12.0 - 6.13.0
Scheduling Schema Changes 6.12.0 - 6.13.0
| Table | Column | Change |
|---|
| Activity | memo | Column added |
| Activity_Pool | | Table added |
| Activity_Pool_Item | | Table added |
| Availability | activity_pool_id | Column added |
| Availability_Pattern | activity_pool_id | Column added |
| Resource_Preference | activity_pool_id | Column added |
| Resources | memo | Maximum string length increased to 4000 |
| Schedule_Exception_Data | activation_datetime | Column added |
| Schedule_Exception_Data | value | Column now optional |
| Separation_Group | exclusive | Column now optional |
Modelling Schema Changes 6.12.0 - 6.13.0
| Table | Column | Change |
|---|
| RAM_Separation_Group | exclusive | Column now optional |
Archive Schema Changes 6.12.0 - 6.13.0
There were no changes to the schema in this version.
System Schema Changes 6.12.0 - 6.13.0
There are also changes to the system schema in this version.
Schema Changes 6.11.0 - 6.12.0
Scheduling Schema Changes 6.11.0 - 6.12.0
| Table | Column | Change |
|---|
| Activity_Group | activity_group_sla_model_id | Column added |
| Activity_Group | end_time_calculation_method | Column added |
| Activity_Group_SLA | | Table added |
| Activity_Group_SLA_Model | | Table added |
| Activity_Part | unlimited_supply | Column added |
| Activity_Type | on_location_duration_factor | Column added |
| Activity_Type_Part | unlimited_supply | Column added |
| Allocation | parallel_index | Column added |
| Allocation_Part | vehicle_id | Column added |
| Appointment_Request | appointment_base_datetime | Column added |
| Appointment_Request | distance_threshold_km | Column added |
| Appointment_Template | distance_threshold_km | Column added |
| Appt_Request_Slot_Usage | | Table added |
| Appt_Template_Slot_Usage | | Table added |
| Explanation_Request | activity_id | Column now optional |
| Explanation_Request | end_datetime_range | Column added |
| Explanation_Request | explanation_type | Column added |
| Explanation_Request | position | Column added |
| Explanation_Request | resource_id | Column added |
| Explanation_Request | start_datetime_range | Column added |
| Explanation_Request_Change | | Table added |
| Explanation_Response | activity_id | Column now optional |
| Explanation_Response | explanation_type | Column added |
| External_Change_Req_Resource | | Table added |
| External_Change_Request | | Table added |
| External_Change_Request_Item | | Table added |
| External_Change_Select | | Table added |
| External_Change_Select_Item | | Table added |
| External_Change_Type | | Table added |
| Part | is_vehicle_part | Column added |
| Part_Stock | vehicle_id | Column added |
| Plan_Resource | max_parallel_allocations | Column added |
| Plan_Travel_Part_Usage | | Table added |
| Resource_Pool | resource_pool_set_id | Column now optional |
| Resource_Pool_Item | shift_id | Column added |
| Resource_Pool_Set_Item | | Table added |
| Separation_Group | exclusive | Column added |
| Shift | rule_collection_id | Column added |
| Slot_Usage_Rule | maximum_slot_utilisation | Column added |
| Slot_Usage_Rule | minimum_slot_free_time | Column added |
| Slot_Usage_Rule_Set | resource_pool_set_id | Column added |
| Vehicle | vehicle_model_id | Column now optional |
| Vehicle_Capacity | | Table added |
| Vehicle_Model | fuel_type_id | Column now optional |
| Vehicle_Model | vehicle_class_id | Column now optional |
| Vehicle_Model_Capacity | | Table added |
| Vehicle_Model_Part_Usage | | Table added |
| Vehicle_Part_Usage | | Table added |
| Visit_Part | vehicle_id | Column added |
Modelling Schema Changes 6.11.0 - 6.12.0
| Table | Column | Change |
|---|
| RAM_Activity_Type | on_location_duration_factor | Column added |
| RAM_Activity_Type_Part | unlimited_supply | Column added |
| RAM_Appointment_Template | distance_threshold_km | Column added |
| RAM_Appt_Template_Slot_Usage | | Table added |
| RAM_Part | is_vehicle_part | Column added |
| RAM_Part_Stock | ram_vehicle_id | Column added |
| RAM_Resource_Pool_Set_Item | | Table added |
| RAM_Rota_Item | ram_rule_collection_id | Column added |
| RAM_Rota_Item_Resource_Pool | | Table added |
| RAM_Separation_Group | exclusive | Column added |
| RAM_Shift_Template | ram_rule_collection_id | Column added |
| RAM_Shift_Template_Item | ram_rule_collection_id | Column added |
| RAM_Shift_Template_Item_Pool | | Table added |
| RAM_Slot_Usage_Rule | maximum_slot_utilisation | Column added |
| RAM_Slot_Usage_Rule | minimum_slot_free_time | Column added |
| RAM_Slot_Usage_Rule_Set | ram_resource_pool_set_id | Column added |
| RAM_Vehicle | ram_vehicle_model_id | Column now optional |
| RAM_Vehicle_Capacity | | Table added |
| RAM_Vehicle_Model | ram_fuel_type_id | Column now optional |
| RAM_Vehicle_Model | ram_vehicle_class_id | Column now optional |
| RAM_Vehicle_Model_Capacity | | Table added |
| RAM_Vehicle_Model_Part_Usage | | Table added |
| RAM_Vehicle_Part_Usage | | Table added |
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 |
System Schema Changes 6.11.0 - 6.12.0
There are also changes to the system schema in this version.
Schema Changes 6.10.0 - 6.11.0
Scheduling Schema Changes 6.10.0 - 6.11.0
| Table | Column | Change |
|---|
| Activity | display_context_id | Column added |
| Activity_Type | display_context_id | Column added |
| Broadcast_History | application_instance_id | Maximum string length increased to 80 |
| Custom_URL | navigable_target_name | Column added |
| Dataset | display_context_id | Column added |
| Input_Reference | enacting_app_instance_id | Maximum string length increased to 80 |
| Plan | application_instance_id | Maximum string length increased to 80 |
| Resource_Type | display_context_id | Column added |
| Resources | display_context_id | Column added |
Modelling Schema Changes 6.10.0 - 6.11.0
| Table | Column | Change |
|---|
| RAM_Activity_Type | display_context_id | Column added |
| RAM_Dataset | display_context_id | Column added |
| RAM_Resource | display_context_id | Column added |
| RAM_Resource_Type | display_context_id | Column added |
| RAM_Update | enacting_app_instance_id | Maximum string length increased to 80 |
| RAM_Update | requesting_app_instance_id | Maximum string length increased to 80 |
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 |
System Schema Changes 6.10.0 - 6.11.0
There are also changes to the system schema in this version.
Schema Changes 6.9.0 - 6.10.0
Scheduling Schema Changes 6.9.0 - 6.10.0
| Table | Column | Change |
|---|
| Activity | do_in_locality_incentive | Column added |
| Activity_Group | max_delay_start_proportion | Column added |
| Activity_Group | min_delay_start_proportion | Column added |
| Activity_Status | duration_override | Column added |
| Activity_Type | do_in_locality_incentive | Column added |
| Allocation | duration_overhead | Column added |
| Appointment_History | | Table added |
| Broadcast_History | send_time_taken | Column added |
| Distance_Penalty | | Table added |
| Distance_Penalty_Type | | Table added |
| Explanation_Message_Param | | Table added |
| Explanation_Outcome | | Table added |
| Explanation_Outcome_Alloc | | Table added |
| Explanation_Outcome_Message | | Table added |
| Explanation_Request | | Table added |
| Explanation_Response | | Table added |
| Explanation_Result_Type | | Table added |
| Fuel_Type | | Table added |
| Input_Reference | object_deletion_count | Column added |
| Input_Reference | row_count | Column added |
| Object_Deletion | object_pk1 | Maximum string length increased to 100 |
| Part | resource_pool_set_id | Column added |
| Part_Stock | resource_pool_id | Column added |
| Plan_Route | vehicle_id | Column added |
| Resource_Skill | in_use_cost | Column added |
| Resource_Skill | in_use_multiplier | Column added |
| Resource_Skill | not_in_use_cost | Column added |
| Resource_Skill | not_in_use_multiplier | Column added |
| Resource_Skill_Availability | in_use_cost | Column added |
| Resource_Skill_Availability | in_use_multiplier | Column added |
| Resource_Skill_Availability | not_in_use_cost | Column added |
| Resource_Skill_Availability | not_in_use_multiplier | Column added |
| Resource_Type | vehicle_id | Column added |
| Resource_Type_Skill | in_use_cost | Column added |
| Resource_Type_Skill | in_use_multiplier | Column added |
| Resource_Type_Skill | not_in_use_cost | Column added |
| Resource_Type_Skill | not_in_use_multiplier | Column added |
| Resources | vehicle_id | Column added |
| Schedule_Data_Usage | dataset_id | Column added |
| Separation_Model_Item | duration_overhead | Column added |
| Shift | vehicle_id | Column added |
| Skill | in_use_cost | Column added |
| Skill | in_use_multiplier | Column added |
| Skill | not_in_use_cost | Column added |
| Skill | not_in_use_multiplier | Column added |
| Travel_Cost_Model | max_journey_distance_km | Column added |
| Travel_Cost_Model | max_shift_travel_distance_km | Column added |
| Travel_Penalty | additional_journey_time | Column added |
| Vehicle | | Table added |
| Vehicle_Class | | Table added |
| Vehicle_Model | | Table added |
| Vehicle_Ownership_Type | | Table added |
Modelling Schema Changes 6.9.0 - 6.10.0
| Table | Column | Change |
|---|
| RAM_Activity_Type | do_in_locality_incentive | Column added |
| RAM_Data_Update | object_pk1 | Maximum string length increased to 256 |
| RAM_Data_Update | object_pk2 | Maximum string length increased to 256 |
| RAM_Data_Update | object_pk3 | Maximum string length increased to 256 |
| RAM_Data_Update | object_pk4 | Maximum string length increased to 256 |
| RAM_Distance_Penalty | | Table added |
| RAM_Distance_Penalty_Type | | Table added |
| RAM_Fuel_Type | | Table added |
| RAM_Object_Group | ram_location_id | Column added |
| RAM_Part | ram_resource_pool_set_id | Column added |
| RAM_Part_Stock | ram_resource_pool_id | Column added |
| RAM_Resource | ram_vehicle_id | Column added |
| RAM_Resource_Pool | | Table added |
| RAM_Resource_Pool_Res_Type | | Table added |
| RAM_Resource_Pool_Resource | | Table added |
| RAM_Resource_Pool_Set | | Table added |
| RAM_Resource_Skill | in_use_cost | Column added |
| RAM_Resource_Skill | in_use_multiplier | Column added |
| RAM_Resource_Skill | not_in_use_cost | Column added |
| RAM_Resource_Skill | not_in_use_multiplier | Column added |
| RAM_Resource_Skill_Availability | in_use_cost | Column added |
| RAM_Resource_Skill_Availability | in_use_multiplier | Column added |
| RAM_Resource_Skill_Availability | not_in_use_cost | Column added |
| RAM_Resource_Skill_Availability | not_in_use_multiplier | Column added |
| RAM_Resource_Type | ram_vehicle_id | Column added |
| RAM_Resource_Type_Skill | in_use_cost | Column added |
| RAM_Resource_Type_Skill | in_use_multiplier | Column added |
| RAM_Resource_Type_Skill | not_in_use_cost | Column added |
| RAM_Resource_Type_Skill | not_in_use_multiplier | Column added |
| RAM_Rota_Item | ram_vehicle_id | Column added |
| RAM_Separation_Model_Item | duration_overhead | Column added |
| RAM_Shift_Template_Item | shift_cut_off | Column added |
| RAM_Skill | in_use_cost | Column added |
| RAM_Skill | in_use_multiplier | Column added |
| RAM_Skill | not_in_use_cost | Column added |
| RAM_Skill | not_in_use_multiplier | Column added |
| RAM_Travel_Cost_Model | max_journey_distance_km | Column added |
| RAM_Travel_Cost_Model | max_shift_travel_distance_km | Column added |
| RAM_Travel_Penalty | additional_journey_time | Column added |
| RAM_Vehicle | | Table added |
| RAM_Vehicle_Class | | Table added |
| RAM_Vehicle_Model | | Table added |
| RAM_Vehicle_Ownership_Type | | Table added |
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 |
System Schema Changes 6.9.0 - 6.10.0
There are also changes to the system schema in this version.
Schema Changes 6.8.0 - 6.9.0
Scheduling Schema Changes 6.8.0 - 6.9.0
| Table | Column | Change |
|---|
| Position | | Table added |
| Resource_Type | shift_cut_off | Column added |
| Resources | shift_cut_off | Column added |
| Rule | activity_type_id | Column added |
| Rule_Parameter | parameter_id | Maximum string length increased to 40 |
| Rule_Type_Parameter | parameter_id | Maximum string length increased to 40 |
| Shift | shift_cut_off | Column added |
| Team_Resource | position_id | Column added |
Modelling Schema Changes 6.8.0 - 6.9.0
| Table | Column | Change |
|---|
| RAM_Requirement_Position | ram_position_id | Column now mandatory |
| RAM_Requirement_Position | ram_requirement_id | Column now mandatory |
| RAM_Requirement_Position_Level | ram_alert_level_id | Column now mandatory |
| RAM_Resource | shift_cut_off | Column added |
| RAM_Resource_Type | shift_cut_off | Column added |
| RAM_Rota_Item | shift_cut_off | Column added |
| RAM_Rule | ram_activity_type_id | Column added |
| RAM_Rule_Parameter | parameter_id | Maximum string length increased to 40 |
| RAM_Rule_Type_Parameter | parameter_id | Maximum string length increased to 40 |
| RAM_Shift_Template | cost_km | Column added |
| RAM_Shift_Template | cost_ph | Column added |
| RAM_Shift_Template | cost_phot | Column added |
| RAM_Shift_Template | max_travel | Column added |
| RAM_Shift_Template | ram_travel_cost_model_id | Column added |
| RAM_Shift_Template | shift_cut_off | Column added |
| RAM_Shift_Template | travel_from | Column added |
| RAM_Shift_Template | travel_to | Column added |
| RAM_Shift_Template_Item | cost_km | Column added |
| RAM_Shift_Template_Item | cost_ph | Column added |
| RAM_Shift_Template_Item | cost_phot | Column added |
| RAM_Shift_Template_Item | max_travel | Column added |
| RAM_Shift_Template_Item | ram_travel_cost_model_id | Column added |
| RAM_Shift_Template_Item | shift_cost | Column added |
| RAM_Shift_Template_Item | travel_from | Column added |
| RAM_Shift_Template_Item | travel_to | Column 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 |
System Schema Changes 6.8.0 - 6.9.0
There are no changes to the system schema in this version.
Schema Changes 6.7.0 - 6.8.0
Scheduling Schema Changes 6.7.0 - 6.8.0
| Table | Column | Change |
|---|
| Plan | dataset_type | Column added |
| Resource_Preference | availability_id | Column added |
| Resource_Preference | availability_pattern_id | Column added |
| Resource_Preference | override_priority | Column added |
| Resource_Region | override_priority | Column added |
| Resource_Region_Availability | | Table added |
| Resource_Skill_Availability | override_priority | Column added |
| Resources | icon_id | Column added |
| Slot_Usage_Rule_Set | filter_by_activity_type | Column added |
| Slot_Usage_Rule_Set | filter_exclude_break_time | Column added |
| Slot_Usage_Rule_Set | filter_exclude_higher_priority | Column added |
| Slot_Usage_Rule_Set | filter_exclude_lower_priority | Column added |
| Slot_Usage_Rule_Set | filter_ignore_break_time | Column added |
| Slot_Usage_Rule_Set | filter_ignore_private_time | Column added |
Modelling Schema Changes 6.7.0 - 6.8.0
| Table | Column | Change |
|---|
| RAM_Resource | ram_icon_id | Column added |
| RAM_Resource_Division | override_priority | Column added |
| RAM_Resource_Division_Avail | | Table added |
| RAM_Resource_Preference | override_priority | Column added |
| RAM_Resource_Preference | ram_time_pattern_id | Column added |
| RAM_Resource_Skill_Availability | override_priority | Column added |
| RAM_Resource_Skill_Availability | proficiency | Column added |
| RAM_Rota_Requirement_Alert | ram_role_id | Column added |
| RAM_Rota_Requirement_Match | ram_role_id | Column now optional |
| RAM_Shift_Template | ram_location_id_end | Column added |
| RAM_Shift_Template | ram_location_id_start | Column added |
| RAM_Shift_Template_Item | ram_location_id_end | Column added |
| RAM_Shift_Template_Item | ram_location_id_start | Column added |
| RAM_Slot_Usage_Rule_Set | filter_by_activity_type | Column added |
| RAM_Slot_Usage_Rule_Set | filter_exclude_break_time | Column added |
| RAM_Slot_Usage_Rule_Set | filter_exclude_higher_priority | Column added |
| RAM_Slot_Usage_Rule_Set | filter_exclude_lower_priority | Column added |
| RAM_Slot_Usage_Rule_Set | filter_ignore_break_time | Column added |
| RAM_Slot_Usage_Rule_Set | filter_ignore_private_time | Column added |
Archive Schema Changes 6.7.0 - 6.8.0
There were no changes to the schema in this version.
System Schema Changes 6.7.0 - 6.8.0
There are also changes to the system schema in this version.
Schema Changes 6.6.0 - 6.7.0
Scheduling Schema Changes 6.6.0 - 6.7.0
| Table | Column | Change |
|---|
| Activity_Custom_Metric | | Table added |
| Activity_Type | icon_id | Column added |
| Activity_Type_Custom_Metric | | Table added |
| Appointment_Offer | prospective_allocation_start | Column added |
| Appointment_Offer | prospective_resource_id | Column added |
| Appointment_Template_Item | slot_usage_window_end | Column added |
| Appointment_Template_Item | slot_usage_window_start | Column added |
| Broadcast_History | | Table added |
| Custom_Metric | | Table added |
| Icon | | Table added |
| Icon_Type | | Table added |
| Input_Reference | dataset_id_parent_dataset | Column added |
| Issue | | Table removed |
| Issue_Dataset_Threshold | | Table removed |
| Issue_Response | | Table removed |
| Issue_Response_Type | | Table removed |
| Issue_Threshold | | Table removed |
| Resource_Class | | Table added |
| Resource_Type | icon_id | Column added |
| Resource_Type | resource_class_id | Column added |
| Resource_Type | shift_visit_cost | Column added |
| Resources | resource_class_id | Column added |
| Resources | shift_visit_cost | Column added |
| Separation_Model_Item | shift_separation | Column added |
| Shift | shift_visit_cost | Column added |
| Team_Resource | | Table added |
Modelling Schema Changes 6.6.0 - 6.7.0
| Table | Column | Change |
|---|
| RAM_Act_Type_Custom_Metric | | Table added |
| RAM_Activity_Type | ram_icon_id | Column added |
| RAM_Appointment_Template_Item | slot_usage_window_end | Column added |
| RAM_Appointment_Template_Item | slot_usage_window_start | Column added |
| RAM_Custom_Metric | | Table added |
| RAM_Icon | | Table added |
| RAM_Icon_Type | | Table added |
| RAM_Resource_Type | ram_icon_id | Column added |
| RAM_Rota_Item | shift_visit_cost | Column added |
| RAM_Rota_Requirement_Alert | ram_position_id | Column added |
| RAM_Rota_Requirement_Match | ram_position_id | Column added |
| RAM_Separation_Model_Item | shift_separation | Column added |
| RAM_Shift_Template | shift_visit_cost | Column added |
Archive Schema Changes 6.6.0 - 6.7.0
| Table | Column | Change |
|---|
| ARC_Audit | result_id | Column added |
| ARC_Audit | update_successful | Column added |
System Schema Changes 6.6.0 - 6.7.0
There are also changes to the scheduling system schema in this version.
Schema Changes 6.5.0 - 6.6.0
Scheduling Schema Changes 6.5.0 - 6.6.0
| Table | Column | Change |
|---|
| Operation | once_only | Column added |
| Shift_Type | colour | Column added |
Modelling Schema Changes 6.5.0 - 6.6.0
| Table | Column | Change |
|---|
| RAM_Operation | once_only | Column added |
Archive Schema Changes 6.5.0 - 6.6.0
| Table | Column | Change |
|---|
| ARC_Location | latitude | Column added |
| ARC_Location | longitude | Column added |
System Schema Changes 6.5.0 - 6.6.0
There are also changes to the scheduling system schema in this version.
Schema Changes 6.4.0 - 6.5.0
Scheduling Schema Changes 6.4.0 - 6.5.0
| Table | Column | Change |
|---|
| Activity_Operation | | Table added |
| Activity_Operation_Usage | | Table added |
| Activity_Usage_Period | | Table added |
| Allocation_Operation | | Table added |
| Modelling_Pattern | usage_model_id | Column removed |
| Operation | | Table added |
| Operation_Hierarchy | | Table added |
| Operation_Ordering | | Table added |
| Operation_Skill | | Table added |
| Usage_Class | | Table added |
| Usage_Model | usage_calculation_method | Column added |
| Usage_Model_Item | | Table added |
| Usage_Model_SLA | | Table added |
| Usage_Model_Time_Item | | Table removed |
| Visit_Operation | | Table added |
Modelling Schema Changes 6.4.0 - 6.5.0
| Table | Column | Change |
|---|
| RAM_Act_Template_Operation | | Table added |
| RAM_Act_Template_Usage_Period | | Table added |
| RAM_Activity_Template | id | Maximum string length increased to 32 |
| RAM_Operation | | Table added |
| RAM_Operation_Hierarchy | | Table added |
| RAM_Operation_Ordering | | Table added |
| RAM_Operation_Skill | | Table added |
| RAM_Template_Operation_Usage | | Table added |
| RAM_Usage_Calculation_Type | | Table added |
| RAM_Usage_Class | | Table added |
| RAM_Usage_Model | | Table added |
| RAM_Usage_Model_Item | | Table added |
| RAM_Usage_Model_SLA | | Table added |
Archive Schema Changes 6.4.0 - 6.5.0
There were no changes to the schema in this version.
System Schema Changes 6.4.0 - 6.5.0
There are no changes to the scheduling system schema in this version.
Schema Changes 6.3.0 - 6.4.0
Scheduling Schema Changes 6.3.0 - 6.4.0
There were no changes to the schema in this version.
Modelling Schema Changes 6.3.0 - 6.4.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.
System Schema Changes 6.3.0 - 6.4.0
There are only index changes to the scheduling system schema in this version.
Schema Changes 6.2.0 - 6.3.0
Scheduling Schema Changes 6.2.0 - 6.3.0
| Table | Column | Change |
|---|
| Activity | last_visited_date_time | Column added |
| Activity_Part | refill_to_capacity | Column added |
| Activity_Type_Part | refill_to_capacity | Column added |
| Child_Schedule | | Table added |
| Dataset | process_type | Column added |
| Part | is_global | Column added |
Modelling Schema Changes 6.2.0 - 6.3.0
| Table | Column | Change |
|---|
| RAM_Activity_Template | last_visited | Column added |
| RAM_Activity_Template | ram_time_pattern_id | Column now optional |
| RAM_Activity_Type | separation_group_id | Column added |
| RAM_Activity_Type_Part | refill_to_capacity | Column added |
| RAM_Modelling_Pattern | leeway_before | Column added |
| RAM_Modelling_Pattern | leeway_percentage | Column added |
| RAM_Modelling_Pattern | leeway_percentage_before | Column added |
| RAM_Modelling_Pattern | step | Column now mandatory |
| RAM_Part | is_global | Column added |
| RAM_Resource | separation_model_id | Column added |
| RAM_Resource_Type | separation_model_id | Column added |
| RAM_Separation_Group | | Table added |
| RAM_Separation_Model | | Table added |
| RAM_Separation_Model_Item | | Table added |
Archive Schema Changes 6.2.0 - 6.3.0
There were no changes to the schema in this version.
System Schema Changes 6.2.0 - 6.3.0
There are no changes to the scheduling system schema in this version.
Schema Changes 6.1.0 - 6.2.0
Scheduling Schema Changes 6.1.0 - 6.2.0
| Table | Column | Change |
|---|
| Appointment_Request | blocking | Column added |
| Appointment_Template | blocking | Column added |
Modelling Schema Changes 6.1.0 - 6.2.0
| Table | Column | Change |
|---|
| RAM_Appointment_Template | blocking | Column added |
| RAM_Exception | ram_rule_type_id | Column added |
Archive Schema Changes 6.1.0 - 6.2.0
| Table | Column | Change |
|---|
| ARC_Request | audit_id | Column added |
System Schema Changes 6.1.0 - 6.2.0
There are also changes to the scheduling system schema in this version.
Schema Changes 6.0.0 - 6.1.0
Scheduling Schema Changes 6.0.0 - 6.1.0
There were no changes to the schema in this version.
Modelling Schema Changes 6.0.0 - 6.1.0
| Table | Column | Change |
|---|
| RAM_Unavailability_Category | interrupt | Column added |
Archive Schema Changes 6.0.0 - 6.1.0
There were no changes to the schema in this version.
System Schema Changes 6.0.0 - 6.1.0
There are also changes to the scheduling system schema in this version.
Schema Changes 5.9.0 - 6.0.0
Scheduling Schema Changes 5.9.0 - 6.0.0
| Table | Column | Change |
|---|
| Input_Reference | input_datetime | Column now optional |
| Issue | organisation_id | Column now mandatory |
| Issue_Threshold | organisation_id | Column added |
| Plan_Route | snap_time | Column added |
| Schedule_Data_Usage | | Table added |
Modelling Schema Changes 5.9.0 - 6.0.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.