Modelling Schema
Schema Revision History
Schema Changes 6.16.0 - 6.17.0
There were no changes to the schema in this version.
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 |
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 |
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 |
Schema Changes 6.12.0 - 6.13.0
| Table | Column | Change |
|---|
| RAM_Separation_Group | exclusive | Column now optional |
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 |
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 |
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 |
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 |
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 |
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 |
Schema Changes 6.5.0 - 6.6.0
| Table | Column | Change |
|---|
| RAM_Operation | once_only | Column added |
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 |
Schema Changes 6.3.0 - 6.4.0
There were no changes to the schema in this version.
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 |
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 |
Schema Changes 6.0.0 - 6.1.0
| Table | Column | Change |
|---|
| RAM_Unavailability_Category | interrupt | Column added |
Schema Changes 5.9.0 - 6.0.0
There were no changes to the schema in this version.
Subsections