Current entity data detailing individual TIVs

Sets out the high-level premium and expense costs in both prior and current years. The sum of premiums and expenses in prior and current columns will be allocated to individual entities ie. the premiums allocated by the model will sum to equal the current column of this table.

sov

Format

A data frame with 739 rows and 24 columns:

entity_id

String: Unique identifier of the entity

loss_run_id

String: Identifier to match losses to entities.

bu, region, country, state, division, location, department

String: Attributes describing the entity. bu = Business unit.

tiv

Numeric: The Total Insured Value assessed per entity

aop_coverage, cat_eq_coverage, cat_wind_coverage, cat_flood_coverage, terrorism_coverage

Boolean: Indicating whether entity takes such coverage

aop_sprinkler_tier

String: Referencing exactly one of the tiers present in aop_sprinkler_tier, reflecting the tier of sprinkler system installed by the entity.

aop_combustible

String: Referencing exactly one of the tiers present in combustible_rels, reflecting the level of combustibility of the entity.

aop_tiv_size_bucket

String: Derivative field reflecting the relative size of TIV. Not used in default setup of the model, although can be conveniently used by custom rates (see rates)

cat_wind_hurricane

String: Referencing...

aop_id

String: A geographical ID used by rates

cat_eq_id, cat_wind_id, cat_flood_id

String: An ID representing the threat of earthquake-, wind-, or flood-related catastrophic damage used by rates

terrorism_id

String: A geographical ID used by rates

Details

The table contains at least one entry with a description matching "all_risk" and another matching "terrorism" - both of which should related to a "premium" cost type.