Releases: Simplitium/OED
OED v1.1.1d
OED has been moved to Oasis GitHub page as per README file. Therefore files from Simplitium's GitHub have been deleted.
OED v1.1.1
DB updates:
Updated script 3 to pick up whether perils are grouped
Added PayOutType Reference table
Removed unaccepable value (=3) from LimitType reference table
Added 3 additional detailed Forestry occupancy codes (Spruce, Birch, Pine)
Added 'XK' for Kosavo Country code
Updated IsLimitAtDamage data type to bit.
OED spec updates:
- Added acceptable / valid value ranges (column H in 'OED Input Fields' tab) where applicable for OED fields.
- Corrected data type for ReinstatementCharge
- Added additional PayOutType accepted values in 'Financial Code Values' tab
- Updated CondName and all DedCode and LimitCode fields to be optional.
- Added 3 additional detailed Forestry occupancy codes (Spruce, Birch, Pine)
- Added 'XK' for Kosavo country code.
- Updated IsLimitAtDamage data type to boolean.
OED v1.1.0
DB updates:
• Split StepFunctions table into StepFunctions and Steps
• Added additional fields in Steps table: PayutType, TriggerType, PayoutEnd, PayoutLimit, ExtraExpenseFactor, ExtraExpenseLimit, DebrisRemovalFactor
• Renamed several fields in Steps table: StartTrigger to TriggerStart, EndTrigger to TriggerEnd and Payout to PayoutStart
• Add a new LimitType = 3 in the xLimitType reference table
• Updated description for 1056 occupancy code
OED spec updates:
- Updated all step policy fields that contained "Content" to "Contents" in order to be consistent with the rest of OED specification.
- PayOutBuilding, PayOutContents, PayOutBuildingContents has been updated with "Start", i.e. PayOutBuildingStart, PayOutContentsStart, PayOutBuildingContentsStart, in order to accommodate for ramp step policies.
- Updated Trigger Start and End field names to be consistent with the naming for payouts (e.g. StartTriggerBuilding is now TriggerBuildingStart).
- Description fields made clearer for step policy fields.
- Added additional 11 fields to accommodate step policies: ExtraExpenseFactor, ExtraExpenseLimit, PayOutLimitBuilding, PayOutLimitContents, PayOutLimitBuildingContents, PayOutType, DebrisRemovalFactor, PayOutBuildingEnd, PayOutContentsEnd, PayOutBuildingContentsEnd, TriggerType.
- Added LimitType = 3 (% of Limit) for step policies (i.e. PayOutType field).
- Corrected typos for RiskLevel categories.
- Updated description for 1056 occupancy code to express clearer what Terraced houses represent.
- Updated 'OED DB data types' tab to reflect the changes in the step policies (StepFunctions and Steps tables).
- Updated conditionally required fields in 'OED CR Field Appendix' for step policies.
OED v1.0.4
DB updates:
updated xPerilCodes table to add column 'Grouped' - to indicate if the peril is grouped
added Notes columns to xCoverages, xDedtype & xGeogScheme tables
Currency fields changed to variable length in all tables (up to 3 characters)
CondPriority moved to Conditions table
added additional, more granular construction codes for motor
removed duplicated category for Roof cover (17 = Light Metal Panel)
BuildingID data type updated to alphanumeric (up to 20 characters) to have a better alignment between AIR and OED and to future proof this to be a unique building identifier (per country or globally)
OED input updates:
- Added GeogSchemes values for CatRisk Solutions models.
- Added two new GeogSchemes for Australia
- Added AreaCode/AreaName for Australia
- Added a comment that OtherTIV should be populated for motor TIVs (along with appropriate motor construction code)
- Removed duplicated category for Roof cover (17 = Light Metal Panel)
- Updated descriptions for 1105, 1108 occupancy codes
- Clarified that LayerLimit, LayerAttachment are always treated as amount
- BuildingID data type updated to alphanumeric (up to 20 characters) to have a better alignment between AIR and OED and to future proof this to be a unique building identifier (per country or globally)
- CondPriority moved to Acc file and backend restructured accordingly
- Added additional, more granular construction codes for motor, including some additional information in "Notes" tab.
- Updated all date formats to be in ISO 8601 standard (YYYY-MM-DD)
- Increased a number of step policy steps, as there could be more than 7 steps.
- Added HAZUS and GEC explanations in the Notes tab for automobiles.
OED v1.0.3
Corrections to some occupancy descriptions
Original occupancy and construction code data types updated to varchar(100)
OED v1.0.2
Changes to provide more information about input field requirements - including logic about conditionally required fields.
Changes to OED DB structure to reduce storage.
OED v1.0.1
Changes to correct typos and provide more information about input field requirements - including which input fields can be blank.
Some minor changes to DB tables to increase flexibility
1.0.0
First release of OED.