Reserving Master
Formula
Examples
For a full list of available parameters see Inputs.
This formula returns the live reserving master data associated with the Fidelies IG for the company. This is the formula you should if you require the latest data. This is the latest data, associated with latest quarter reporting per the IG. You should not use this formula for external reporting.
The analytics version of this formula returns the live reserving events data associated with the Fidelies IG for the company. At this point the time has been aggregated to the level of the class code, entity, MGA and broker.
-
The below formula returns reserving events data for RDF class code grouped up by entity, mga.
Inputs
Tip
The best practise for once you have used this formula is to create a table from the results and use this table within your analysis. This ensures that your data changes only when you want it to and you are not dependent on the table columns being in the same order each exercise.
1. Use the formula to get the data you need
2. Select all the data that the formula returns (including headings)
3. Go to Data >> Get Data >> From Other Sources >> From Table/Range
4. Right click on the 'Array' name and rename it to something sensible
5. Check to see if the first row has been promoted to headers, this is usually done automatically but
if not on the "Home" tab you can select "Use the first row as headers".
6. If you are seeing errors in the layer_id or program_id columns then you need to change the data type.
To do this go to the Applied Steps on the right hand side, choose 'Changed Type' and change
{'layer_id', Int.64.Type} to {'layer_id', type text} and {'program_id', Int.64.Type} to {'program_id', type text}.
7. Click Close & Load.
This will create a table in your worksheet. If the data changes you will need to refresh the table by going to
Data >> Refresh All or Data >> Queries & Connections >> right click on your table and refresh.
By default, data will not be split by entity, MGA or broker, but you can use the parameter values if these splits are required.
| PARAMETER | DESCRIPTION |
|---|---|
class_ids
|
The 3 letter class code. This can be a single cell, or multiple cells to return more than one class code. If left blank this will default to all available class codes.
TYPE:
|
show_entities
|
A boolean value to show data split by Entity. This can be either True or False. If left blank this will default to False and show data combined by Entity.
TYPE:
|
show_mgas
|
A boolean value to show data split by Fidelis / Pine Walk / Third Party MGAs. This can be either True or False. If left blank this will default to False and show data combined into all TFP.
TYPE:
|
show_years
|
Year. This can be a single cell, or multiple cells to return more than one year. If left blank this will default to the last 5 years.
TYPE:
|
Note
- To return all class ids you can leave
class_idsblank. show_entities,show_mgasare optional and default to False if left blank. It is possible to omit these from your formula if you do not need them split out in your data.
Outputs
| PARAMETER | DESCRIPTION |
|---|---|
entity
|
Alias: Entity The Entity (FUL, FIID, FIBL).
TYPE:
|
uw_year
|
Alias: Underwriting Year The Underwriting Year of the policy.
TYPE:
|
fx_set
|
Alias: FX Set The FX set used to convert the figures to USD.
TYPE:
|
reserving_asat
|
Alias: Reserving As At The reserving as-at period, e.g. 2025Q1.
TYPE:
|
reserving_version
|
Alias: Reserving Version The reserving version.
TYPE:
|
program_id
|
Alias: Program Id The Program Id.
TYPE:
|
is_latest
|
Alias: Is Latest Flag: 1 = row belongs to the latest reserving version, 0 = historical.
TYPE:
|
class_id
|
Alias: Class Id The 3 letter class code.
TYPE:
|
pillar
|
Alias: Pillar This pillar definition is consistent with the definition between the IG and TFP and should be used in most scenarios.
TYPE:
|
master_carrier_grouping
|
Alias: Master Carrier Grouping The capacity provider. This can be the IG, F3123, Consortium, Allianz.
TYPE:
|
business_segment
|
Alias: Business Segment This is the IG's mapping to business segment (INS / REIN).
TYPE:
|
mgup_split_pillar
|
Alias: MGUP Pillar This pillar definition is used in MGUP Production meetings. The main difference is the how RI classes are mapped from Speciality / Bespoke to Reinsurance and how some Reinsurance classes are mapped back to Specialty / Bespoke. Unless you want to tie up with MGUP pillar definitions, you should not use this pillar.
TYPE:
|
minor_class
|
Alias: Minor Class This is consistent with the IG definition of minor classes.
TYPE:
|
major_class
|
Alias: Major Class This is consistent with the IG definition of major classes.
TYPE:
|
mgup_split_light
|
Alias: MGUP Light Class This class definition is used in MGUP Production meetings, similar to Minor Class. It will split, e.g. P,C&E MGUP class into Construction, Non-Renewable, Renewables, Property and D&F.
TYPE:
|
mgup_split_master
|
Alias: MGUP Master Class This class definition is used in MGUP Production meetings, similar to Major Class.
TYPE:
|
mgup_split
|
Alias: MGUP Split This is the full list of MGUP master and MGUP light classes combined together separated by a hyphen.
TYPE:
|
mgup_reporting
|
Alias: MGUP Reporting Class This is the MGUP Master class broken down into the main reporting classes.
TYPE:
|
dom_simon_class
|
Alias: Dom Simon Class The Dom Simon class grouping used in reserving analysis, classes used for Project Dom Simon.
TYPE:
|
dom_simon_lob
|
Alias: Dom Simon LOB The Dom Simon line of business grouping used in reserving analysis, LOB grouping for Project Dom Simon.
TYPE:
|
broker_master_group
|
Alias: Broker Grouped This is a high level mapping of brokers. Brokers have been grouped together for reporting purposes from their lowest granularity. For example, all GC and Marsh broker names have been grouped together into GC Marsh. To see the mapping refer to ANT.ACT.Mappings.get_broker_mapping()
TYPE:
|
mga_code
|
Alias: MGA Code This is a high level mapping of MGAs / Third Party binders based on their Layer Id. If the value is To see the mapping refer to ANT.ACT.Mappings.get_mga_mapping()
TYPE:
|
gross_acq_earned_premium_usd
|
Alias: Gross Earned Acquisition Costs USD The gross earned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
gross_acq_unearned_premium_usd
|
Alias: Gross Unearned Acquisition Costs USD The gross unearned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
gross_acq_unwritten_premium_usd
|
Alias: Gross Unwritten Acquisition Costs USD The gross unwritten acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
gross_gn_earned_premium_usd
|
Alias: Gross Net Earned Premium USD The gross gross of reinsurance, net of acquisition costs earned premium in USD.
TYPE:
|
gross_gn_written_premium_usd
|
Alias: Gross Net Written Premium USD The gross gross of reinsurance, net of acquisition costs written premium in USD.
TYPE:
|
gross_gn_unearned_premium_usd
|
Alias: Gross Net Unearned Premium USD The gross gross of reinsurance, net of acquisition costs unearned premium in USD.
TYPE:
|
gross_gn_unwritten_premium_usd
|
Alias: Gross Net Unwritten Premium USD The gross gross of reinsurance, net of acquisition costs unwritten premium in USD.
TYPE:
|
gross_gg_earned_premium_usd
|
Alias: Gross Gross Earned Premium USD The gross gross of reinsurance, gross of acquisition costs earned premium in USD.
TYPE:
|
gross_gg_written_premium_usd
|
Alias: Gross Gross Written Premium USD The gross gross of reinsurance, gross of acquisition costs written premium in USD.
TYPE:
|
gross_gg_unearned_premium_usd
|
Alias: Gross Gross Unearned Premium USD The gross gross of reinsurance, gross of acquisition costs unearned premium in USD.
TYPE:
|
gross_gg_unwritten_premium_usd
|
Alias: Gross Gross Unwritten Premium USD The gross gross of reinsurance, gross of acquisition costs unwritten premium in USD.
TYPE:
|
gross_gg_ultimate_premium_usd
|
Alias: Gross Gross Ultimate Premium USD The gross gross of reinsurance, gross of acquisition costs ultimate premium in USD.
TYPE:
|
gross_gn_ultimate_premium_usd
|
Alias: Gross Net Ultimate Premium USD The gross gross of reinsurance, net of acquisition costs ultimate premium in USD.
TYPE:
|
gross_reinstatement_premium_usd
|
Alias: Gross Reinstatement Premium USD The gross reinstatement premium in USD (premium charged to reinstate cover after a loss).
TYPE:
|
gross_profit_commission_usd
|
Alias: Gross Profit Commission USD The gross profit commission in USD (profit-share commission on the treaty).
TYPE:
|
ceded_acq_earned_premium_usd
|
Alias: Ceded Earned Acquisition Costs USD The ceded earned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
ceded_acq_unearned_premium_usd
|
Alias: Ceded Unearned Acquisition Costs USD The ceded unearned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
ceded_acq_unwritten_premium_usd
|
Alias: Ceded Unwritten Acquisition Costs USD The ceded unwritten acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
ceded_gn_earned_premium_usd
|
Alias: Ceded Net Earned Premium USD The ceded gross of reinsurance, net of acquisition costs earned premium in USD.
TYPE:
|
ceded_gn_written_premium_usd
|
Alias: Ceded Net Written Premium USD The ceded gross of reinsurance, net of acquisition costs written premium in USD.
TYPE:
|
ceded_gn_unearned_premium_usd
|
Alias: Ceded Net Unearned Premium USD The ceded gross of reinsurance, net of acquisition costs unearned premium in USD.
TYPE:
|
ceded_gn_unwritten_premium_usd
|
Alias: Ceded Net Unwritten Premium USD The ceded gross of reinsurance, net of acquisition costs unwritten premium in USD.
TYPE:
|
ceded_gg_earned_premium_usd
|
Alias: Ceded Gross Earned Premium USD The ceded gross of reinsurance, gross of acquisition costs earned premium in USD.
TYPE:
|
ceded_gg_written_premium_usd
|
Alias: Ceded Gross Written Premium USD The ceded gross of reinsurance, gross of acquisition costs written premium in USD.
TYPE:
|
ceded_gg_unearned_premium_usd
|
Alias: Ceded Gross Unearned Premium USD The ceded gross of reinsurance, gross of acquisition costs unearned premium in USD.
TYPE:
|
ceded_gg_unwritten_premium_usd
|
Alias: Ceded Gross Unwritten Premium USD The ceded gross of reinsurance, gross of acquisition costs unwritten premium in USD.
TYPE:
|
ceded_gg_ultimate_premium_usd
|
Alias: Ceded Gross Ultimate Premium USD The ceded gross of reinsurance, gross of acquisition costs ultimate premium in USD.
TYPE:
|
ceded_gn_ultimate_premium_usd
|
Alias: Ceded Net Ultimate Premium USD The ceded gross of reinsurance, net of acquisition costs ultimate premium in USD.
TYPE:
|
ceded_reinstatement_premium_usd
|
Alias: Ceded Reinstatement Premium USD The ceded reinstatement premium in USD (premium charged to reinstate cover after a loss).
TYPE:
|
ceded_profit_commission_usd
|
Alias: Ceded Profit Commission USD The ceded profit commission in USD (profit-share commission on the treaty).
TYPE:
|
fac_acq_earned_premium_usd
|
Alias: Fac Acq Earned Premium USD The Facultative reinsurance share of earned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
fac_acq_unearned_premium_usd
|
Alias: Fac Acq Unearned Premium USD The Facultative reinsurance share of unearned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
fac_acq_unwritten_premium_usd
|
Alias: Fac Acq Unwritten Premium USD The Facultative reinsurance share of unwritten acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
fac_gn_earned_premium_usd
|
Alias: Fac GN Earned Premium USD The Facultative reinsurance share of gross of reinsurance, net of acquisition costs earned premium in USD.
TYPE:
|
fac_gn_written_premium_usd
|
Alias: Fac GN Written Premium USD The Facultative reinsurance share of gross of reinsurance, net of acquisition costs written premium in USD.
TYPE:
|
fac_gn_unearned_premium_usd
|
Alias: Fac GN Unearned Premium USD The Facultative reinsurance share of gross of reinsurance, net of acquisition costs unearned premium in USD.
TYPE:
|
fac_gn_unwritten_premium_usd
|
Alias: Fac GN Unwritten Premium USD The Facultative reinsurance share of gross of reinsurance, net of acquisition costs unwritten premium in USD.
TYPE:
|
fac_gg_earned_premium_usd
|
Alias: Fac GG Earned Premium USD The Facultative reinsurance share of gross of reinsurance, gross of acquisition costs earned premium in USD.
TYPE:
|
fac_gg_written_premium_usd
|
Alias: Fac GG Written Premium USD The Facultative reinsurance share of gross of reinsurance, gross of acquisition costs written premium in USD.
TYPE:
|
fac_gg_unearned_premium_usd
|
Alias: Fac GG Unearned Premium USD The Facultative reinsurance share of gross of reinsurance, gross of acquisition costs unearned premium in USD.
TYPE:
|
fac_gg_unwritten_premium_usd
|
Alias: Fac GG Unwritten Premium USD The Facultative reinsurance share of gross of reinsurance, gross of acquisition costs unwritten premium in USD.
TYPE:
|
fac_gg_ultimate_premium_usd
|
Alias: Fac GG Ultimate Premium USD The Facultative reinsurance share of gross of reinsurance, gross of acquisition costs ultimate premium in USD.
TYPE:
|
fac_gn_ultimate_premium_usd
|
Alias: Fac GN Ultimate Premium USD The Facultative reinsurance share of gross of reinsurance, net of acquisition costs ultimate premium in USD.
TYPE:
|
fac_reinstatement_premium_usd
|
Alias: Fac Reinstatement Premium USD The Facultative reinsurance share of reinstatement premium in USD (premium to reinstate cover after a loss).
TYPE:
|
fac_profit_commission_usd
|
Alias: Fac Profit Commission USD The Facultative reinsurance share of profit commission in USD (profit-share commission on the treaty).
TYPE:
|
xol_acq_earned_premium_usd
|
Alias: XOL Acq Earned Premium USD The Excess-of-Loss reinsurance share of earned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
xol_acq_unearned_premium_usd
|
Alias: XOL Acq Unearned Premium USD The Excess-of-Loss reinsurance share of unearned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
xol_acq_unwritten_premium_usd
|
Alias: XOL Acq Unwritten Premium USD The Excess-of-Loss reinsurance share of unwritten acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
xol_gn_earned_premium_usd
|
Alias: XOL GN Earned Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, net of acquisition costs earned premium in USD.
TYPE:
|
xol_gn_written_premium_usd
|
Alias: XOL GN Written Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, net of acquisition costs written premium in USD.
TYPE:
|
xol_gn_unearned_premium_usd
|
Alias: XOL GN Unearned Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, net of acquisition costs unearned premium in USD.
TYPE:
|
xol_gn_unwritten_premium_usd
|
Alias: XOL GN Unwritten Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, net of acquisition costs unwritten premium in USD.
TYPE:
|
xol_gg_earned_premium_usd
|
Alias: XOL GG Earned Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, gross of acquisition costs earned premium in USD.
TYPE:
|
xol_gg_written_premium_usd
|
Alias: XOL GG Written Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, gross of acquisition costs written premium in USD.
TYPE:
|
xol_gg_unearned_premium_usd
|
Alias: XOL GG Unearned Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, gross of acquisition costs unearned premium in USD.
TYPE:
|
xol_gg_unwritten_premium_usd
|
Alias: XOL GG Unwritten Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, gross of acquisition costs unwritten premium in USD.
TYPE:
|
xol_gg_ultimate_premium_usd
|
Alias: XOL GG Ultimate Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, gross of acquisition costs ultimate premium in USD.
TYPE:
|
xol_gn_ultimate_premium_usd
|
Alias: XOL GN Ultimate Premium USD The Excess-of-Loss reinsurance share of gross of reinsurance, net of acquisition costs ultimate premium in USD.
TYPE:
|
xol_reinstatement_premium_usd
|
Alias: XOL Reinstatement Premium USD The Excess-of-Loss reinsurance share of reinstatement premium in USD (premium to reinstate cover after a loss).
TYPE:
|
xol_profit_commission_usd
|
Alias: XOL Profit Commission USD The Excess-of-Loss reinsurance share of profit commission in USD (profit-share commission on the treaty).
TYPE:
|
qs_acq_earned_premium_usd
|
Alias: QS Acq Earned Premium USD The Quota Share reinsurance share of earned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
qs_acq_unearned_premium_usd
|
Alias: QS Acq Unearned Premium USD The Quota Share reinsurance share of unearned acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
qs_acq_unwritten_premium_usd
|
Alias: QS Acq Unwritten Premium USD The Quota Share reinsurance share of unwritten acquisition costs in USD (brokerage / commission on the corresponding premium base).
TYPE:
|
qs_gn_earned_premium_usd
|
Alias: QS GN Earned Premium USD The Quota Share reinsurance share of gross of reinsurance, net of acquisition costs earned premium in USD.
TYPE:
|
qs_gn_written_premium_usd
|
Alias: QS GN Written Premium USD The Quota Share reinsurance share of gross of reinsurance, net of acquisition costs written premium in USD.
TYPE:
|
qs_gn_unearned_premium_usd
|
Alias: QS GN Unearned Premium USD The Quota Share reinsurance share of gross of reinsurance, net of acquisition costs unearned premium in USD.
TYPE:
|
qs_gn_unwritten_premium_usd
|
Alias: QS GN Unwritten Premium USD The Quota Share reinsurance share of gross of reinsurance, net of acquisition costs unwritten premium in USD.
TYPE:
|
qs_gg_earned_premium_usd
|
Alias: QS GG Earned Premium USD The Quota Share reinsurance share of gross of reinsurance, gross of acquisition costs earned premium in USD.
TYPE:
|
qs_gg_written_premium_usd
|
Alias: QS GG Written Premium USD The Quota Share reinsurance share of gross of reinsurance, gross of acquisition costs written premium in USD.
TYPE:
|
qs_gg_unearned_premium_usd
|
Alias: QS GG Unearned Premium USD The Quota Share reinsurance share of gross of reinsurance, gross of acquisition costs unearned premium in USD.
TYPE:
|
qs_gg_unwritten_premium_usd
|
Alias: QS GG Unwritten Premium USD The Quota Share reinsurance share of gross of reinsurance, gross of acquisition costs unwritten premium in USD.
TYPE:
|
qs_gg_ultimate_premium_usd
|
Alias: QS GG Ultimate Premium USD The Quota Share reinsurance share of gross of reinsurance, gross of acquisition costs ultimate premium in USD.
TYPE:
|
qs_gn_ultimate_premium_usd
|
Alias: QS GN Ultimate Premium USD The Quota Share reinsurance share of gross of reinsurance, net of acquisition costs ultimate premium in USD.
TYPE:
|
qs_reinstatement_premium_usd
|
Alias: QS Reinstatement Premium USD The Quota Share reinsurance share of reinstatement premium in USD (premium to reinstate cover after a loss).
TYPE:
|
qs_profit_commission_usd
|
Alias: QS Profit Commission USD The Quota Share reinsurance share of profit commission in USD (profit-share commission on the treaty).
TYPE:
|
net_acq_earned_premium_usd
|
Alias: Net Earned Acquisition Costs USD The net earned acquisition costs in USD (brokerage / commission on the net premium base).
TYPE:
|
net_acq_unearned_premium_usd
|
Alias: Net Unearned Acquisition Costs USD The net unearned acquisition costs in USD (brokerage / commission on the net premium base).
TYPE:
|
net_acq_unwritten_premium_usd
|
Alias: Net Unwritten Acquisition Costs USD The net unwritten acquisition costs in USD (brokerage / commission on the net premium base).
TYPE:
|
net_nn_earned_premium_usd
|
Alias: Net Net Earned Premium USD The net of reinsurance, net of acquisition costs earned premium in USD (net of reinsurance measure).
TYPE:
|
net_nn_written_premium_usd
|
Alias: Net Net Written Premium USD The net of reinsurance, net of acquisition costs written premium in USD (net of reinsurance measure).
TYPE:
|
net_nn_unearned_premium_usd
|
Alias: Net Net Unearned Premium USD The net of reinsurance, net of acquisition costs unearned premium in USD (net of reinsurance measure).
TYPE:
|
net_nn_unwritten_premium_usd
|
Alias: Net Net Unwritten Premium USD The net of reinsurance, net of acquisition costs unwritten premium in USD (net of reinsurance measure).
TYPE:
|
net_ng_earned_premium_usd
|
Alias: Net Gross Earned Premium USD The net of reinsurance, gross of acquisition costs earned premium in USD (net of reinsurance measure).
TYPE:
|
net_ng_written_premium_usd
|
Alias: Net Gross Written Premium USD The net of reinsurance, gross of acquisition costs written premium in USD (net of reinsurance measure).
TYPE:
|
net_ng_unearned_premium_usd
|
Alias: Net Gross Unearned Premium USD The net of reinsurance, gross of acquisition costs unearned premium in USD (net of reinsurance measure).
TYPE:
|
net_ng_unwritten_premium_usd
|
Alias: Net Gross Unwritten Premium USD The net of reinsurance, gross of acquisition costs unwritten premium in USD (net of reinsurance measure).
TYPE:
|
net_ng_ultimate_premium_usd
|
Alias: Net Gross Ultimate Premium USD The net of reinsurance, gross of acquisition costs ultimate premium in USD (net of reinsurance measure).
TYPE:
|
net_nn_ultimate_premium_usd
|
Alias: Net Net Ultimate Premium USD The net of reinsurance, net of acquisition costs ultimate premium in USD (net of reinsurance measure).
TYPE:
|
net_reinstatement_premium_usd
|
Alias: Net Reinstatement Premium USD The net reinstatement premium in USD (premium to reinstate cover after a loss).
TYPE:
|
net_profit_commission_usd
|
Alias: Net Profit Commission USD The net profit commission in USD (profit-share commission on the treaty).
TYPE:
|
gross_paid_claims_usd
|
Alias: Gross Paid Claims USD The gross paid claims in USD.
TYPE:
|
gross_os_claims_usd
|
Alias: Gross Outstanding Claims USD The gross outstanding claims in USD.
TYPE:
|
gross_incurred_claims_usd
|
Alias: Gross Incurred Claims USD The gross incurred claims in USD.
TYPE:
|
gross_earned_claims_usd
|
Alias: Gross Earned Claims USD The gross earned claims in USD.
TYPE:
|
gross_ultimate_claims_usd
|
Alias: Gross Ultimate Claims USD The gross ultimate claims in USD.
TYPE:
|
gross_unearned_claims_usd
|
Alias: Gross Unearned Claims USD The gross unearned claims in USD.
TYPE:
|
gross_unwritten_claims_usd
|
Alias: Gross Unwritten Claims USD The gross unwritten claims in USD.
TYPE:
|
gross_specific_ibnr_usd
|
Alias: Gross Specific IBNR USD The gross specific (case-level) IBNR reserve in USD.
TYPE:
|
gross_general_ibnr_usd
|
Alias: Gross General IBNR USD The gross general (bulk) IBNR reserve in USD.
TYPE:
|
gross_total_specific_usd
|
Alias: Gross Total Specific Claims USD The gross total specific claims in USD.
TYPE:
|
ceded_paid_claims_usd
|
Alias: Ceded Paid Claims USD The ceded paid claims in USD.
TYPE:
|
ceded_os_claims_usd
|
Alias: Ceded Outstanding Claims USD The ceded outstanding claims in USD.
TYPE:
|
ceded_incurred_claims_usd
|
Alias: Ceded Incurred Claims USD The ceded incurred claims in USD.
TYPE:
|
ceded_earned_claims_usd
|
Alias: Ceded Earned Claims USD The ceded earned claims in USD.
TYPE:
|
ceded_ultimate_claims_usd
|
Alias: Ceded Ultimate Claims USD The ceded ultimate claims in USD.
TYPE:
|
ceded_unearned_claims_usd
|
Alias: Ceded Unearned Claims USD The ceded unearned claims in USD.
TYPE:
|
ceded_unwritten_claims_usd
|
Alias: Ceded Unwritten Claims USD The ceded unwritten claims in USD.
TYPE:
|
ceded_specific_ibnr_usd
|
Alias: Ceded Specific IBNR USD The ceded specific (case-level) IBNR reserve in USD.
TYPE:
|
ceded_general_ibnr_usd
|
Alias: Ceded General IBNR USD The ceded general (bulk) IBNR reserve in USD.
TYPE:
|
ceded_total_specific_usd
|
Alias: Ceded Total Specific Claims USD The ceded total specific claims in USD.
TYPE:
|
fac_paid_claims_usd
|
Alias: Fac Paid Claims USD The Facultative reinsurance share of paid claims in USD.
TYPE:
|
fac_os_claims_usd
|
Alias: Fac Outstanding Claims USD The Facultative reinsurance share of outstanding claims in USD.
TYPE:
|
fac_incurred_claims_usd
|
Alias: Fac Incurred Claims USD The Facultative reinsurance share of incurred claims in USD.
TYPE:
|
fac_earned_claims_usd
|
Alias: Fac Earned Claims USD The Facultative reinsurance share of earned claims in USD.
TYPE:
|
fac_ultimate_claims_usd
|
Alias: Fac Ultimate Claims USD The Facultative reinsurance share of ultimate claims in USD.
TYPE:
|
fac_unearned_claims_usd
|
Alias: Fac Unearned Claims USD The Facultative reinsurance share of unearned claims in USD.
TYPE:
|
fac_unwritten_claims_usd
|
Alias: Fac Unwritten Claims USD The Facultative reinsurance share of unwritten claims in USD.
TYPE:
|
fac_specific_ibnr_usd
|
Alias: Fac Specific IBNR USD The Facultative reinsurance share of specific (case-level) IBNR reserve in USD.
TYPE:
|
fac_general_ibnr_usd
|
Alias: Fac General IBNR USD The Facultative reinsurance share of general (bulk) IBNR reserve in USD.
TYPE:
|
fac_total_specific_usd
|
Alias: Fac Total Specific USD The Facultative reinsurance share of total specific claims in USD.
TYPE:
|
xol_paid_claims_usd
|
Alias: XOL Paid Claims USD The Excess-of-Loss reinsurance share of paid claims in USD.
TYPE:
|
xol_os_claims_usd
|
Alias: XOL Outstanding Claims USD The Excess-of-Loss reinsurance share of outstanding claims in USD.
TYPE:
|
xol_incurred_claims_usd
|
Alias: XOL Incurred Claims USD The Excess-of-Loss reinsurance share of incurred claims in USD.
TYPE:
|
xol_earned_claims_usd
|
Alias: XOL Earned Claims USD The Excess-of-Loss reinsurance share of earned claims in USD.
TYPE:
|
xol_ultimate_claims_usd
|
Alias: XOL Ultimate Claims USD The Excess-of-Loss reinsurance share of ultimate claims in USD.
TYPE:
|
xol_unearned_claims_usd
|
Alias: XOL Unearned Claims USD The Excess-of-Loss reinsurance share of unearned claims in USD.
TYPE:
|
xol_unwritten_claims_usd
|
Alias: XOL Unwritten Claims USD The Excess-of-Loss reinsurance share of unwritten claims in USD.
TYPE:
|
xol_specific_ibnr_usd
|
Alias: XOL Specific IBNR USD The Excess-of-Loss reinsurance share of specific (case-level) IBNR reserve in USD.
TYPE:
|
xol_general_ibnr_usd
|
Alias: XOL General IBNR USD The Excess-of-Loss reinsurance share of general (bulk) IBNR reserve in USD.
TYPE:
|
xol_total_specific_usd
|
Alias: XOL Total Specific USD The Excess-of-Loss reinsurance share of total specific claims in USD.
TYPE:
|
qs_paid_claims_usd
|
Alias: QS Paid Claims USD The Quota Share reinsurance share of paid claims in USD.
TYPE:
|
qs_os_claims_usd
|
Alias: QS Outstanding Claims USD The Quota Share reinsurance share of outstanding claims in USD.
TYPE:
|
qs_incurred_claims_usd
|
Alias: QS Incurred Claims USD The Quota Share reinsurance share of incurred claims in USD.
TYPE:
|
qs_earned_claims_usd
|
Alias: QS Earned Claims USD The Quota Share reinsurance share of earned claims in USD.
TYPE:
|
qs_ultimate_claims_usd
|
Alias: QS Ultimate Claims USD The Quota Share reinsurance share of ultimate claims in USD.
TYPE:
|
qs_unearned_claims_usd
|
Alias: QS Unearned Claims USD The Quota Share reinsurance share of unearned claims in USD.
TYPE:
|
qs_unwritten_claims_usd
|
Alias: QS Unwritten Claims USD The Quota Share reinsurance share of unwritten claims in USD.
TYPE:
|
qs_specific_ibnr_usd
|
Alias: QS Specific IBNR USD The Quota Share reinsurance share of specific (case-level) IBNR reserve in USD.
TYPE:
|
qs_general_ibnr_usd
|
Alias: QS General IBNR USD The Quota Share reinsurance share of general (bulk) IBNR reserve in USD.
TYPE:
|
qs_total_specific_usd
|
Alias: QS Total Specific USD The Quota Share reinsurance share of total specific claims in USD.
TYPE:
|
net_paid_claims_usd
|
Alias: Net Paid Claims USD The net paid claims in USD.
TYPE:
|
net_os_claims_usd
|
Alias: Net Outstanding Claims USD The net outstanding claims in USD.
TYPE:
|
net_incurred_claims_usd
|
Alias: Net Incurred Claims USD The net incurred claims in USD.
TYPE:
|
net_earned_claims_usd
|
Alias: Net Earned Claims USD The net earned claims in USD.
TYPE:
|
net_ultimate_claims_usd
|
Alias: Net Ultimate Claims USD The net ultimate claims in USD.
TYPE:
|
net_unearned_claims_usd
|
Alias: Net Unearned Claims USD The net unearned claims in USD.
TYPE:
|
net_unwritten_claims_usd
|
Alias: Net Unwritten Claims USD The net unwritten claims in USD.
TYPE:
|
net_specific_ibnr_usd
|
Alias: Net Specific IBNR USD The net specific (case-level) IBNR reserve in USD.
TYPE:
|
net_general_ibnr_usd
|
Alias: Net General IBNR USD The net general (bulk) IBNR reserve in USD.
TYPE:
|
net_total_specific_usd
|
Alias: Net Total Specific Claims USD The net total specific claims in USD.
TYPE:
|
gross_gg_ultimate_loss_ratio_numerator
|
Alias: Gross Gross Ultimate Loss Ratio Numerator The numerator component used to calculate the gross GG ultimate loss ratio.
TYPE:
|
gross_gg_ultimate_loss_ratio_denominator
|
Alias: Gross Gross Ultimate Loss Ratio Denominator The denominator component used to calculate the gross GG ultimate loss ratio.
TYPE:
|
gross_gn_ultimate_loss_ratio_numerator
|
Alias: Gross Net Ultimate Loss Ratio Numerator The numerator component used to calculate the gross GN ultimate loss ratio.
TYPE:
|
gross_gn_ultimate_loss_ratio_denominator
|
Alias: Gross Net Ultimate Loss Ratio Denominator The denominator component used to calculate the gross GN ultimate loss ratio.
TYPE:
|
ceded_gg_ultimate_loss_ratio_numerator
|
Alias: Ceded Gross Gross Ultimate Loss Ratio Numerator The numerator component used to calculate the ceded GG ultimate loss ratio.
TYPE:
|
ceded_gg_ultimate_loss_ratio_denominator
|
Alias: Ceded Gross Gross Ultimate Loss Ratio Denominator The denominator component used to calculate the ceded GG ultimate loss ratio.
TYPE:
|
ceded_gn_ultimate_loss_ratio_numerator
|
Alias: Ceded Gross Net Ultimate Loss Ratio Numerator The numerator component used to calculate the ceded GN ultimate loss ratio.
TYPE:
|
ceded_gn_ultimate_loss_ratio_denominator
|
Alias: Ceded Gross Net Ultimate Loss Ratio Denominator The denominator component used to calculate the ceded GN ultimate loss ratio.
TYPE:
|
net_ng_ultimate_loss_ratio_numerator
|
Alias: Net Gross Ultimate Loss Ratio Numerator The numerator component used to calculate the net NG ultimate loss ratio.
TYPE:
|
net_ng_ultimate_loss_ratio_denominator
|
Alias: Net Gross Ultimate Loss Ratio Denominator The denominator component used to calculate the net NG ultimate loss ratio.
TYPE:
|
net_nn_ultimate_loss_ratio_numerator
|
Alias: Net Net Ultimate Loss Ratio Numerator The numerator component used to calculate the net NN ultimate loss ratio.
TYPE:
|
net_nn_ultimate_loss_ratio_denominator
|
Alias: Net Net Ultimate Loss Ratio Denominator The denominator component used to calculate the net NN ultimate loss ratio.
TYPE:
|
gross_gg_earned_loss_ratio_numerator
|
Alias: Gross Gross Earned Loss Ratio Numerator The numerator component used to calculate the gross GG earned loss ratio.
TYPE:
|
gross_gg_earned_loss_ratio_denominator
|
Alias: Gross Gross Earned Loss Ratio Denominator The denominator component used to calculate the gross GG earned loss ratio.
TYPE:
|
gross_gn_earned_loss_ratio_numerator
|
Alias: Gross Net Earned Loss Ratio Numerator The numerator component used to calculate the gross GN earned loss ratio.
TYPE:
|
gross_gn_earned_loss_ratio_denominator
|
Alias: Gross Net Earned Loss Ratio Denominator The denominator component used to calculate the gross GN earned loss ratio.
TYPE:
|
ceded_gg_earned_loss_ratio_numerator
|
Alias: Ceded Gross Gross Earned Loss Ratio Numerator The numerator component used to calculate the ceded GG earned loss ratio.
TYPE:
|
ceded_gg_earned_loss_ratio_denominator
|
Alias: Ceded Gross Gross Earned Loss Ratio Denominator The denominator component used to calculate the ceded GG earned loss ratio.
TYPE:
|
ceded_gn_earned_loss_ratio_numerator
|
Alias: Ceded Gross Net Earned Loss Ratio Numerator The numerator component used to calculate the ceded GN earned loss ratio.
TYPE:
|
ceded_gn_earned_loss_ratio_denominator
|
Alias: Ceded Gross Net Earned Loss Ratio Denominator The denominator component used to calculate the ceded GN earned loss ratio.
TYPE:
|
net_ng_earned_loss_ratio_numerator
|
Alias: Net Gross Earned Loss Ratio Numerator The numerator component used to calculate the net NG earned loss ratio.
TYPE:
|
net_ng_earned_loss_ratio_denominator
|
Alias: Net Gross Earned Loss Ratio Denominator The denominator component used to calculate the net NG earned loss ratio.
TYPE:
|
net_nn_earned_loss_ratio_numerator
|
Alias: Net Net Earned Loss Ratio Numerator The numerator component used to calculate the net NN earned loss ratio.
TYPE:
|
net_nn_earned_loss_ratio_denominator
|
Alias: Net Net Earned Loss Ratio Denominator The denominator component used to calculate the net NN earned loss ratio.
TYPE:
|
gross_gg_incurred_loss_ratio_numerator
|
Alias: Gross Gross Incurred Loss Ratio Numerator The numerator component used to calculate the gross GG incurred loss ratio.
TYPE:
|
gross_gg_incurred_loss_ratio_denominator
|
Alias: Gross Gross Incurred Loss Ratio Denominator The denominator component used to calculate the gross GG incurred loss ratio.
TYPE:
|
gross_gn_incurred_loss_ratio_numerator
|
Alias: Gross Net Incurred Loss Ratio Numerator The numerator component used to calculate the gross GN incurred loss ratio.
TYPE:
|
gross_gn_incurred_loss_ratio_denominator
|
Alias: Gross Net Incurred Loss Ratio Denominator The denominator component used to calculate the gross GN incurred loss ratio.
TYPE:
|
ceded_gg_incurred_loss_ratio_numerator
|
Alias: Ceded Gross Gross Incurred Loss Ratio Numerator The numerator component used to calculate the ceded GG incurred loss ratio.
TYPE:
|
ceded_gg_incurred_loss_ratio_denominator
|
Alias: Ceded Gross Gross Incurred Loss Ratio Denominator The denominator component used to calculate the ceded GG incurred loss ratio.
TYPE:
|
ceded_gn_incurred_loss_ratio_numerator
|
Alias: Ceded Gross Net Incurred Loss Ratio Numerator The numerator component used to calculate the ceded GN incurred loss ratio.
TYPE:
|
ceded_gn_incurred_loss_ratio_denominator
|
Alias: Ceded Gross Net Incurred Loss Ratio Denominator The denominator component used to calculate the ceded GN incurred loss ratio.
TYPE:
|
net_ng_incurred_loss_ratio_numerator
|
Alias: Net Gross Incurred Loss Ratio Numerator The numerator component used to calculate the net NG incurred loss ratio.
TYPE:
|
net_ng_incurred_loss_ratio_denominator
|
Alias: Net Gross Incurred Loss Ratio Denominator The denominator component used to calculate the net NG incurred loss ratio.
TYPE:
|
net_nn_incurred_loss_ratio_numerator
|
Alias: Net Net Incurred Loss Ratio Numerator The numerator component used to calculate the net NN incurred loss ratio.
TYPE:
|
net_nn_incurred_loss_ratio_denominator
|
Alias: Net Net Incurred Loss Ratio Denominator The denominator component used to calculate the net NN incurred loss ratio.
TYPE:
|
gross_gg_ibnr_ratio_numerator
|
Alias: Gross Gross IBNR Ratio Numerator The numerator component used to calculate the gross GG IBNR ratio.
TYPE:
|
gross_gg_ibnr_ratio_denominator
|
Alias: Gross Gross IBNR Ratio Denominator The denominator component used to calculate the gross GG IBNR ratio.
TYPE:
|
ceded_gg_ibnr_ratio_numerator
|
Alias: Ceded Gross Gross IBNR Ratio Numerator The numerator component used to calculate the ceded GG IBNR ratio.
TYPE:
|
ceded_gg_ibnr_ratio_denominator
|
Alias: Ceded Gross Gross IBNR Ratio Denominator The denominator component used to calculate the ceded GG IBNR ratio.
TYPE:
|
net_ng_ibnr_ratio_numerator
|
Alias: Net Gross IBNR Ratio Numerator The numerator component used to calculate the net NG IBNR ratio.
TYPE:
|
net_ng_ibnr_ratio_denominator
|
Alias: Net Gross IBNR Ratio Denominator The denominator component used to calculate the net NG IBNR ratio.
TYPE:
|
gross_gn_ibnr_ratio_numerator
|
Alias: Gross Net IBNR Ratio Numerator The numerator component used to calculate the gross GN IBNR ratio.
TYPE:
|
gross_gn_ibnr_ratio_denominator
|
Alias: Gross Net IBNR Ratio Denominator The denominator component used to calculate the gross GN IBNR ratio.
TYPE:
|
ceded_gn_ibnr_ratio_numerator
|
Alias: Ceded Gross Net IBNR Ratio Numerator The numerator component used to calculate the ceded GN IBNR ratio.
TYPE:
|
ceded_gn_ibnr_ratio_denominator
|
Alias: Ceded Gross Net IBNR Ratio Denominator The denominator component used to calculate the ceded GN IBNR ratio.
TYPE:
|
net_nn_ibnr_ratio_numerator
|
Alias: Net Net IBNR Ratio Numerator The numerator component used to calculate the net NN IBNR ratio.
TYPE:
|
net_nn_ibnr_ratio_denominator
|
Alias: Net Net IBNR Ratio Denominator The denominator component used to calculate the net NN IBNR ratio.
TYPE:
|
gross_earned_pct_numerator
|
Alias: Gross Earned Pct Numerator The numerator component used to calculate the gross earned percentage.
TYPE:
|
gross_earned_pct_denominator
|
Alias: Gross Earned Pct Denominator The denominator component used to calculate the gross earned percentage.
TYPE:
|
net_earned_pct_numerator
|
Alias: Net Earned Pct Numerator The numerator component used to calculate the net earned percentage.
TYPE:
|
net_earned_pct_denominator
|
Alias: Net Earned Pct Denominator The denominator component used to calculate the net earned percentage.
TYPE:
|
ceded_earned_pct_numerator
|
Alias: Ceded Earned Pct Numerator The numerator component used to calculate the ceded earned percentage.
TYPE:
|
ceded_earned_pct_denominator
|
Alias: Ceded Earned Pct Denominator The denominator component used to calculate the ceded earned percentage.
TYPE:
|
gross_paid_claims_development_pct_numerator
|
Alias: Gross Paid Claims Development Pct Numerator The numerator component used to calculate the gross paid claims development percentage.
TYPE:
|
gross_paid_claims_development_pct_denominator
|
Alias: Gross Paid Claims Development Pct Denominator The denominator component used to calculate the gross paid claims development percentage.
TYPE:
|
ceded_paid_claims_development_pct_numerator
|
Alias: Ceded Paid Claims Development Pct Numerator The numerator component used to calculate the ceded paid claims development percentage.
TYPE:
|
ceded_paid_claims_development_pct_denominator
|
Alias: Ceded Paid Claims Development Pct Denominator The denominator component used to calculate the ceded paid claims development percentage.
TYPE:
|
net_paid_claims_development_pct_numerator
|
Alias: Net Paid Claims Development Pct Numerator The numerator component used to calculate the net paid claims development percentage.
TYPE:
|
net_paid_claims_development_pct_denominator
|
Alias: Net Paid Claims Development Pct Denominator The denominator component used to calculate the net paid claims development percentage.
TYPE:
|
gross_incurred_claims_development_pct_numerator
|
Alias: Gross Incurred Claims Development Pct Numerator The numerator component used to calculate the gross incurred claims development percentage.
TYPE:
|
gross_incurred_claims_development_pct_denominator
|
Alias: Gross Incurred Claims Development Pct Denominator The denominator component used to calculate the gross incurred claims development percentage.
TYPE:
|
ceded_incurred_claims_development_pct_numerator
|
Alias: Ceded Incurred Claims Development Pct Numerator The numerator component used to calculate the ceded incurred claims development percentage.
TYPE:
|
ceded_incurred_claims_development_pct_denominator
|
Alias: Ceded Incurred Claims Development Pct Denominator The denominator component used to calculate the ceded incurred claims development percentage.
TYPE:
|
net_incurred_claims_development_pct_numerator
|
Alias: Net Incurred Claims Development Pct Numerator The numerator component used to calculate the net incurred claims development percentage.
TYPE:
|
net_incurred_claims_development_pct_denominator
|
Alias: Net Incurred Claims Development Pct Denominator The denominator component used to calculate the net incurred claims development percentage.
TYPE:
|
gross_ultimate_acq_ratio_numerator
|
Alias: Gross Ultimate Acquisition Ratio Numerator The numerator component used to calculate the gross ultimate acquisition cost ratio.
TYPE:
|
gross_ultimate_acq_ratio_denominator
|
Alias: Gross Ultimate Acquisition Ratio Denominator The denominator component used to calculate the gross ultimate acquisition cost ratio.
TYPE:
|
ceded_ultimate_acq_ratio_numerator
|
Alias: Ceded Ultimate Acquisition Ratio Numerator The numerator component used to calculate the ceded ultimate acquisition cost ratio.
TYPE:
|
ceded_ultimate_acq_ratio_denominator
|
Alias: Ceded Ultimate Acquisition Ratio Denominator The denominator component used to calculate the ceded ultimate acquisition cost ratio.
TYPE:
|
net_ultimate_acq_ratio_numerator
|
Alias: Net Ultimate Acquisition Ratio Numerator The numerator component used to calculate the net ultimate acquisition cost ratio.
TYPE:
|
net_ultimate_acq_ratio_denominator
|
Alias: Net Ultimate Acquisition Ratio Denominator The denominator component used to calculate the net ultimate acquisition cost ratio.
TYPE:
|
gross_earned_acq_ratio_numerator
|
Alias: Gross Earned Acquisition Ratio Numerator The numerator component used to calculate the gross earned acquisition cost ratio.
TYPE:
|
gross_earned_acq_ratio_denominator
|
Alias: Gross Earned Acquisition Ratio Denominator The denominator component used to calculate the gross earned acquisition cost ratio.
TYPE:
|
ceded_earned_acq_ratio_numerator
|
Alias: Ceded Earned Acquisition Ratio Numerator The numerator component used to calculate the ceded earned acquisition cost ratio.
TYPE:
|
ceded_earned_acq_ratio_denominator
|
Alias: Ceded Earned Acquisition Ratio Denominator The denominator component used to calculate the ceded earned acquisition cost ratio.
TYPE:
|
net_earned_acq_ratio_numerator
|
Alias: Net Earned Acquisition Ratio Numerator The numerator component used to calculate the net earned acquisition cost ratio.
TYPE:
|
net_earned_acq_ratio_denominator
|
Alias: Net Earned Acquisition Ratio Denominator The denominator component used to calculate the net earned acquisition cost ratio.
TYPE:
|
gross_premium_development_pct_numerator
|
Alias: Gross Premium Development Pct Numerator The numerator component used to calculate the gross premium development percentage.
TYPE:
|
gross_premium_development_pct_denominator
|
Alias: Gross Premium Development Pct Denominator The denominator component used to calculate the gross premium development percentage.
TYPE:
|
ceded_premium_development_pct_numerator
|
Alias: Ceded Premium Development Pct Numerator The numerator component used to calculate the ceded premium development percentage.
TYPE:
|
ceded_premium_development_pct_denominator
|
Alias: Ceded Premium Development Pct Denominator The denominator component used to calculate the ceded premium development percentage.
TYPE:
|
net_premium_development_pct_numerator
|
Alias: Net Premium Development Pct Numerator The numerator component used to calculate the net premium development percentage.
TYPE:
|
net_premium_development_pct_denominator
|
Alias: Net Premium Development Pct Denominator The denominator component used to calculate the net premium development percentage.
TYPE:
|
gross_earned_claims_reserve_usd
|
Alias: Gross Earned Claims Reserve USD The gross earned claims reserve in USD (the earned portion of the held claims reserve).
TYPE:
|
net_earned_claims_reserve_usd
|
Alias: Net Earned Claims Reserve USD The net earned claims reserve in USD (the earned portion of the held claims reserve).
TYPE:
|
ceded_earned_claims_reserve_usd
|
Alias: Ceded Earned Claims Reserve USD The ceded earned claims reserve in USD (the earned portion of the held claims reserve).
TYPE:
|