Skip to content

Releases: Simplitium/OED

OED v1.1.1d

18 May 14:29
a017145
Compare
Choose a tag to compare

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

09 Apr 14:36
423194d
Compare
Choose a tag to compare

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:

  1. Added acceptable / valid value ranges (column H in 'OED Input Fields' tab) where applicable for OED fields.
  2. Corrected data type for ReinstatementCharge
  3. Added additional PayOutType accepted values in 'Financial Code Values' tab
  4. Updated CondName and all DedCode and LimitCode fields to be optional.
  5. Added 3 additional detailed Forestry occupancy codes (Spruce, Birch, Pine)
  6. Added 'XK' for Kosavo country code.
  7. Updated IsLimitAtDamage data type to boolean.

OED v1.1.0

30 Dec 11:12
edb74c6
Compare
Choose a tag to compare

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:

  1. Updated all step policy fields that contained "Content" to "Contents" in order to be consistent with the rest of OED specification.
  2. PayOutBuilding, PayOutContents, PayOutBuildingContents has been updated with "Start", i.e. PayOutBuildingStart, PayOutContentsStart, PayOutBuildingContentsStart, in order to accommodate for ramp step policies.
  3. Updated Trigger Start and End field names to be consistent with the naming for payouts (e.g. StartTriggerBuilding is now TriggerBuildingStart).
  4. Description fields made clearer for step policy fields.
  5. Added additional 11 fields to accommodate step policies: ExtraExpenseFactor, ExtraExpenseLimit, PayOutLimitBuilding, PayOutLimitContents, PayOutLimitBuildingContents, PayOutType, DebrisRemovalFactor, PayOutBuildingEnd, PayOutContentsEnd, PayOutBuildingContentsEnd, TriggerType.
  6. Added LimitType = 3 (% of Limit) for step policies (i.e. PayOutType field).
  7. Corrected typos for RiskLevel categories.
  8. Updated description for 1056 occupancy code to express clearer what Terraced houses represent.
  9. Updated 'OED DB data types' tab to reflect the changes in the step policies (StepFunctions and Steps tables).
  10. Updated conditionally required fields in 'OED CR Field Appendix' for step policies.

OED v1.0.4

23 Oct 16:33
31aee90
Compare
Choose a tag to compare

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:

  1. Added GeogSchemes values for CatRisk Solutions models.
  2. Added two new GeogSchemes for Australia
  3. Added AreaCode/AreaName for Australia
  4. Added a comment that OtherTIV should be populated for motor TIVs (along with appropriate motor construction code)
  5. Removed duplicated category for Roof cover (17 = Light Metal Panel)
  6. Updated descriptions for 1105, 1108 occupancy codes
  7. Clarified that LayerLimit, LayerAttachment are always treated as amount
  8. 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)
  9. CondPriority moved to Acc file and backend restructured accordingly
  10. Added additional, more granular construction codes for motor, including some additional information in "Notes" tab.
  11. Updated all date formats to be in ISO 8601 standard (YYYY-MM-DD)
  12. Increased a number of step policy steps, as there could be more than 7 steps.
  13. Added HAZUS and GEC explanations in the Notes tab for automobiles.

OED v1.0.3

16 May 15:24
b47ea51
Compare
Choose a tag to compare

Corrections to some occupancy descriptions
Original occupancy and construction code data types updated to varchar(100)

OED v1.0.2

08 Jan 17:15
9113319
Compare
Choose a tag to compare

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

21 Dec 11:33
e92f5cc
Compare
Choose a tag to compare

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

09 Oct 08:47
94bee20
Compare
Choose a tag to compare

First release of OED.