Date YYYYMMDD
Date YYYYMMDD
Record 020 - Declared Aggregation Year
Key 'ACC_YEAR' = Label 'Accident Year'
Key 'UW_YEAR' = Label 'U/W Year'
Record 010 - Declared Actuary's Category and Aggregation by Exhibit
Key '01' = Label '1st actuary's category for the specified Exhibit Category'
Key '02' = Label '2nd actuary's category for the specified Exhibit Category'
Key '03' = Label '3rd actuary's category for the specified Exhibit Category'
Key '04' = Label '4th actuary's category for the specified Exhibit Category'
Key '05' = Label '5th actuary's category for the specified Exhibit Category'
Key '06' = Label '6th actuary's category for the specified Exhibit Category'
Key '07' = Label '7th actuary's category for the specified Exhibit Category'
Key '08' = Label '8th actuary's category for the specified Exhibit Category'
Key '09' = Label '9th actuary's category for the specified Exhibit Category'
Key '10' = Label '10th actuary's category for the specified Exhibit Category'
Key '11' = Label '11th actuary's category for the specified Exhibit Category'
Key '12' = Label '12th actuary's category for the specified Exhibit Category'
Key '13' = Label '13th actuary's category for the specified Exhibit Category'
Key '14' = Label '14th actuary's category for the specified Exhibit Category'
Key '15' = Label '15th actuary's category for the specified Exhibit Category'
Key '16' = Label '16th actuary's category for the specified Exhibit Category'
Key '17' = Label '17th actuary's category for the specified Exhibit Category'
Key '18' = Label '18th actuary's category for the specified Exhibit Category'
Key '19' = Label '19th actuary's category for the specified Exhibit Category'
Key '20' = Label '20th actuary's category for the specified Exhibit Category'
Key '21' = Label '21st actuary's category for the specified Exhibit Category'
Key '22' = Label '22th actuary's category for the specified Exhibit Category'
Key '23' = Label '23th actuary's category for the specified Exhibit Category'
Key '24' = Label '24th actuary's category for the specified Exhibit Category'
Key '25' = Label '25th actuary's category for the specified Exhibit Category'
Key '26' = Label '26th actuary's category for the specified Exhibit Category'
Key '27' = Label '27th actuary's category for the specified Exhibit Category'
Key '28' = Label '28th actuary's category for the specified Exhibit Category'
Key '29' = Label '29th actuary's category for the specified Exhibit Category'
Key '30' = Label '30th actuary's category for the specified Exhibit Category'
Key '31' = Label '31st actuary's category for the specified Exhibit Category'
Key '32' = Label '32th actuary's category for the specified Exhibit Category'
Key '33' = Label '33th actuary's category for the specified Exhibit Category'
Key '34' = Label '34th actuary's category for the specified Exhibit Category'
Key '35' = Label '35th actuary's category for the specified Exhibit Category'
Key '36' = Label '36th actuary's category for the specified Exhibit Category'
Key '37' = Label '37th actuary's category for the specified Exhibit Category'
Key '38' = Label '38th actuary's category for the specified Exhibit Category'
Key '39' = Label '39th actuary's category for the specified Exhibit Category'
Key '40' = Label '40th actuary's category for the specified Exhibit Category'
Key '41' = Label '41st actuary's category for the specified Exhibit Category'
Key '42' = Label '42th actuary's category for the specified Exhibit Category'
Key '43' = Label '43th actuary's category for the specified Exhibit Category'
Key '44' = Label '44th actuary's category for the specified Exhibit Category'
Key '45' = Label '45th actuary's category for the specified Exhibit Category'
Key '46' = Label '46th actuary's category for the specified Exhibit Category'
Key '47' = Label '47th actuary's category for the specified Exhibit Category'
Key '48' = Label '48th actuary's category for the specified Exhibit Category'
Key '49' = Label '49th actuary's category for the specified Exhibit Category'
Key '50' = Label '50th actuary's category for the specified Exhibit Category'
Key '51' = Label '51st actuary's category for the specified Exhibit Category'
Key '52' = Label '52th actuary's category for the specified Exhibit Category'
Key '53' = Label '53th actuary's category for the specified Exhibit Category'
Key '54' = Label '54th actuary's category for the specified Exhibit Category'
Key '55' = Label '55th actuary's category for the specified Exhibit Category'
Key '56' = Label '56th actuary's category for the specified Exhibit Category'
Key '57' = Label '57th actuary's category for the specified Exhibit Category'
Key '58' = Label '58th actuary's category for the specified Exhibit Category'
Key '59' = Label '59th actuary's category for the specified Exhibit Category'
Key '60' = Label '60th actuary's category for the specified Exhibit Category'
Key '61' = Label '61st actuary's category for the specified Exhibit Category'
Key '62' = Label '62th actuary's category for the specified Exhibit Category'
Key '63' = Label '63th actuary's category for the specified Exhibit Category'
Key '64' = Label '64th actuary's category for the specified Exhibit Category'
Key '65' = Label '65th actuary's category for the specified Exhibit Category'
Key '66' = Label '66th actuary's category for the specified Exhibit Category'
Key '67' = Label '67th actuary's category for the specified Exhibit Category'
Key '68' = Label '68th actuary's category for the specified Exhibit Category'
Key '69' = Label '69th actuary's category for the specified Exhibit Category'
Key '70' = Label '70th actuary's category for the specified Exhibit Category'
Key '71' = Label '71st actuary's category for the specified Exhibit Category'
Key '72' = Label '72th actuary's category for the specified Exhibit Category'
Key '73' = Label '73th actuary's category for the specified Exhibit Category'
Key '74' = Label '74th actuary's category for the specified Exhibit Category'
Key '75' = Label '75th actuary's category for the specified Exhibit Category'
Key '76' = Label '76th actuary's category for the specified Exhibit Category'
Key '77' = Label '77th actuary's category for the specified Exhibit Category'
Key '78' = Label '78th actuary's category for the specified Exhibit Category'
Key '79' = Label '79th actuary's category for the specified Exhibit Category'
Key '80' = Label '80th actuary's category for the specified Exhibit Category'
Key '81' = Label '81st actuary's category for the specified Exhibit Category'
Key '82' = Label '82th actuary's category for the specified Exhibit Category'
Key '83' = Label '83th actuary's category for the specified Exhibit Category'
Key '84' = Label '84th actuary's category for the specified Exhibit Category'
Key '85' = Label '85th actuary's category for the specified Exhibit Category'
Key '86' = Label '86th actuary's category for the specified Exhibit Category'
Key '87' = Label '87th actuary's category for the specified Exhibit Category'
Key '88' = Label '88th actuary's category for the specified Exhibit Category'
Key '89' = Label '89th actuary's category for the specified Exhibit Category'
Key '90' = Label '90th actuary's category for the specified Exhibit Category'
Key '91' = Label '91st actuary's category for the specified Exhibit Category'
Key '92' = Label '92th actuary's category for the specified Exhibit Category'
Key '93' = Label '93th actuary's category for the specified Exhibit Category'
Key '94' = Label '94th actuary's category for the specified Exhibit Category'
Key '95' = Label '95th actuary's category for the specified Exhibit Category'
Key '96' = Label '96th actuary's category for the specified Exhibit Category'
Key '97' = Label '97th actuary's category for the specified Exhibit Category'
Key '98' = Label '98th actuary's category for the specified Exhibit Category'
Key '99' = Label 'Total'
AGGREGATION_YEAR
Key '01' = Label 'Current Year - 10 and prior'
Key '02' = Label 'Current Year - 9'
Key '03' = Label 'Current Year - 8'
Key '04' = Label 'Current Year - 7'
Key '05' = Label 'Current Year - 6'
Key '06' = Label 'Current Year - 5'
Key '07' = Label 'Current Year - 4'
Key '08' = Label 'Current Year - 3'
Key '09' = Label 'Current Year - 2'
Key '10' = Label 'Current Year - 1'
Key '11' = Label 'Current Year'
Key '99' = Label 'Total'
Key '01' = Label '1st Portfolio'
Key '02' = Label '2nd Portfolio'
Key '03' = Label '3rd Portfolio'
Key '04' = Label '4th Portfolio'
Key '05' = Label '5th Portfolio'
Key '06' = Label '6th Portfolio'
Key '07' = Label '7th Portfolio'
Key '08' = Label '8th Portfolio'
Key '09' = Label '9th Portfolio'
Key '10' = Label '10th Portfolio'
Key '11' = Label '11th Portfolio'
Key '12' = Label '12th Portfolio'
Key '13' = Label '13th Portfolio'
Key '14' = Label '14th Portfolio'
Key '15' = Label '15th Portfolio'
Key '16' = Label '16th Portfolio'
Key '17' = Label '17th Portfolio'
Key '18' = Label '18th Portfolio'
Key '19' = Label '19th Portfolio'
Key '20' = Label '20th Portfolio'
Key '21' = Label '21st Portfolio'
Key '22' = Label '22nd Portfolio'
Key '23' = Label '23rd Portfolio'
Key '24' = Label '24th Portfolio'
Key '25' = Label '25th Portfolio'
Key '26' = Label '26th Portfolio'
Key '27' = Label '27th Portfolio'
Key '28' = Label '28th Portfolio'
Key '29' = Label '29th Portfolio'
Key '30' = Label '30th Portfolio'
Key '31' = Label '31st Portfolio'
Key '32' = Label '32nd Portfolio'
Key '33' = Label '33rd Portfolio'
Key '34' = Label '34th Portfolio'
Key '35' = Label '35th Portfolio'
Key '36' = Label '36th Portfolio'
Key '37' = Label '37th Portfolio'
Key '38' = Label '38th Portfolio'
Key '39' = Label '39th Portfolio'
Key '40' = Label '40th Portfolio'
Key '41' = Label '41st Portfolio'
Key '42' = Label '42nd Portfolio'
Key '43' = Label '43rd Portfolio'
Key '44' = Label '44th Portfolio'
Key '45' = Label '45th Portfolio'
Key '46' = Label '46th Portfolio'
Key '47' = Label '47th Portfolio'
Key '48' = Label '48th Portfolio'
Key '49' = Label '49th Portfolio'
Key '50' = Label '50th Portfolio'
Key '51' = Label '51st Portfolio'
Key '52' = Label '52nd Portfolio'
Key '53' = Label '53rd Portfolio'
Key '54' = Label '54th Portfolio'
Key '55' = Label '55th Portfolio'
Key '56' = Label '56th Portfolio'
Key '57' = Label '57th Portfolio'
Key '58' = Label '58th Portfolio'
Key '59' = Label '59th Portfolio'
Key '60' = Label '60th Portfolio'
Key '61' = Label '61st Portfolio'
Key '62' = Label '62nd Portfolio'
Key '63' = Label '63rd Portfolio'
Key '64' = Label '64th Portfolio'
Key '65' = Label '65th Portfolio'
Key '66' = Label '66th Portfolio'
Key '67' = Label '67th Portfolio'
Key '68' = Label '68th Portfolio'
Key '69' = Label '69th Portfolio'
Key '70' = Label '70th Portfolio'
Key '71' = Label '71st Portfolio'
Key '72' = Label '72nd Portfolio'
Key '73' = Label '73rd Portfolio'
Key '74' = Label '74th Portfolio'
Key '75' = Label '75th Portfolio'
Key '76' = Label '76th Portfolio'
Key '77' = Label '77th Portfolio'
Key '78' = Label '78th Portfolio'
Key '79' = Label '79th Portfolio'
Key '80' = Label '80th Portfolio'
Key '81' = Label '81st Portfolio'
Key '82' = Label '82nd Portfolio'
Key '83' = Label '83rd Portfolio'
Key '84' = Label '84th Portfolio'
Key '85' = Label '85th Portfolio'
Key '86' = Label '86th Portfolio'
Key '87' = Label '87th Portfolio'
Key '88' = Label '88th Portfolio'
Key '89' = Label '89th Portfolio'
Key '90' = Label '90th Portfolio'
Key '91' = Label '91st Portfolio'
Key '92' = Label '92nd Portfolio'
Key '93' = Label '93rd Portfolio'
Key '94' = Label '94th Portfolio'
Key '95' = Label '95th Portfolio'
Key '96' = Label '96th Portfolio'
Key '97' = Label '97th Portfolio'
Key '98' = Label '98th Portfolio'
Key '99' = Label 'Total'
Key '01' = Label 'Liquidity Category 1'
Key '02' = Label 'Liquidity Category 2'
Key '03' = Label 'Liquidity Category 3'
Key '04' = Label 'Liquidity Category 4'
Key '05' = Label 'Liquidity Category 5'
Key '99' = Label 'Total'
REPORTING_BASIS
Key 'GROSS' = Label 'Gross'
Key 'CEDED' = Label 'Ceded'
EXHIBIT_CATEGORY_LONG 4 digits
Key '1039' = Label 'Insurer-Property-Personal (Gross)'
Key '1050' = Label 'Insurer-Property-Commercial (Gross)'
Key '1070' = Label 'Insurer-Aircraft (Gross)'
Key '1080' = Label 'Insurer-Automobile-Liability-Private Passenger (Gross)'
Key '1090' = Label 'Insurer-Automobile-Personal Accident-Private Passenger (Gross)'
Key '1100' = Label 'Insurer-Automobile-Other-Private Passenger (Gross)'
Key '1130' = Label 'Insurer-Automobile-Liability-Other than Private Passenger (Gross)'
Key '1140' = Label 'Insurer-Automobile-Personal Accident-Other than Private Passenger (Gross)'
Key '1150' = Label 'Insurer-Automobile-Other-Other than Private Passenger (Gross)'
Key '1270' = Label 'Insurer-Boiler and machinery (Gross)'
Key '1290' = Label 'Insurer-Credit (Gross)'
Key '1300' = Label 'Insurer-Credit Protection (Gross)'
Key '1310' = Label 'Insurer-Fidelity (Gross)'
Key '1320' = Label 'Insurer-Hail (Gross)'
Key '1330' = Label 'Insurer-Legal expense (Gross)'
Key '1340' = Label 'Insurer-Liability-Comprehensive General Liability (with products) (Gross)'
Key '1350' = Label 'Insurer-Liability-Comprehensive General Liability (without products) (Gross)'
Key '1360' = Label 'Insurer-Liability-Cyber Liability (Gross)'
Key '1370' = Label 'Insurer-Liability-Directors and Officers Liability (Gross)'
Key '1380' = Label 'Insurer-Liability-Excess Liability (Gross)'
Key '1390' = Label 'Insurer-Liability-Professional Liability (Gross)'
Key '1400' = Label 'Insurer-Liability-Umbrella Liability (Gross)'
Key '1410' = Label 'Insurer-Liability-Pollution Liability (Gross)'
Key '1420' = Label 'Insurer-Liability-All Other (Gross)'
Key '1440' = Label 'Insurer-Mortgage (Gross)'
Key '1450' = Label 'Insurer-Other Approved Products (Gross)'
Key '1460' = Label 'Insurer-Surety-Contract Surety (Gross)'
Key '1470' = Label 'Insurer-Surety-All Other Surety (Gross)'
Key '1490' = Label 'Insurer-Title (Gross)'
Key '1500' = Label 'Insurer-Marine (Gross)'
Key '1510' = Label 'Insurer-Accident and sickness (Gross)'
Key '3039' = Label 'Reinsurer-Proportional Reinsurance-Property-Personal (Gross)'
Key '3050' = Label 'Reinsurer-Proportional Reinsurance-Property-Commercial (Gross)'
Key '3070' = Label 'Reinsurer-Proportional Reinsurance-Aircraft (Gross)'
Key '3080' = Label 'Reinsurer-Proportional Reinsurance-AutomobileLiability-Private Passenger (Gross)'
Key '3090' = Label 'Reinsurer-Proportional Reinsurance-AutomobilePersonal Accident-Private Passenger (Gross)'
Key '3100' = Label 'Reinsurer-Proportional Reinsurance-AutomobileOther-Private Passenger (Gross)'
Key '3130' = Label 'Reinsurer-Proportional Reinsurance-AutomobileLiability-Other than Private Passenger (Gross)'
Key '3140' = Label 'Reinsurer-Proportional Reinsurance-AutomobilePersonal Accident-Other than Private Passenger (Gross)'
Key '3150' = Label 'Reinsurer-Proportional Reinsurance-AutomobileOther-Other than Private Passenger (Gross)'
Key '3270' = Label 'Reinsurer-Proportional Reinsurance-Boiler and machinery (Gross)'
Key '3290' = Label 'Reinsurer-Proportional Reinsurance-Credit (Gross)'
Key '3300' = Label 'Reinsurer-Proportional Reinsurance-Credit Protection (Gross)'
Key '3310' = Label 'Reinsurer-Proportional Reinsurance-Fidelity (Gross)'
Key '3320' = Label 'Reinsurer-Proportional Reinsurance-Hail (Gross)'
Key '3330' = Label 'Reinsurer-Proportional Reinsurance-Legal expense (Gross)'
Key '3340' = Label 'Reinsurer-Proportional Reinsurance-Liability-Comprehensive General Liability (with products) (Gross)'
Key '3350' = Label 'Reinsurer-Proportional Reinsurance-Liability-Comprehensive General Liability (without products) (Gross)'
Key '3360' = Label 'Reinsurer-Proportional Reinsurance-Liability-Cyber Liability (Gross)'
Key '3370' = Label 'Reinsurer-Proportional Reinsurance-Liability-Directors and Officers Liability (Gross)'
Key '3380' = Label 'Reinsurer-Proportional Reinsurance-Liability-Excess Liability (Gross)'
Key '3390' = Label 'Reinsurer-Proportional Reinsurance-Liability-Professional Liability (Gross)'
Key '3400' = Label 'Reinsurer-Proportional Reinsurance-Liability-Umbrella Liability (Gross)'
Key '3410' = Label 'Reinsurer-Proportional Reinsurance-Liability-Pollution Liability (Gross)'
Key '3420' = Label 'Reinsurer-Proportional Reinsurance-Liability-All Other (Gross)'
Key '3440' = Label 'Reinsurer-Proportional Reinsurance-Mortgage (Gross)'
Key '3450' = Label 'Reinsurer-Proportional Reinsurance-Other Approved Products (Gross)'
Key '3460' = Label 'Reinsurer-Proportional Reinsurance-Surety-Contract Surety (Gross)'
Key '3470' = Label 'Reinsurer-Proportional Reinsurance-Surety-All Other Surety (Gross)'
Key '3490' = Label 'Reinsurer-Proportional Reinsurance-Title (Gross)'
Key '3500' = Label 'Reinsurer-Proportional Reinsurance-Marine (Gross)'
Key '3510' = Label 'Reinsurer-Proportional Reinsurance-Accident and sickness (Gross)'
Key '6039' = Label 'Reinsurer-Excess Reinsurance-Property-Personal (Gross)'
Key '6050' = Label 'Reinsurer-Excess Reinsurance-Property-Commercial (Gross)'
Key '6070' = Label 'Reinsurer-Excess Reinsurance-Aircraft (Gross)'
Key '6080' = Label 'Reinsurer-Excess Reinsurance-AutomobileLiability-Private Passenger (Gross)'
Key '6090' = Label 'Reinsurer-Excess Reinsurance-AutomobilePersonal Accident-Private Passenger (Gross)'
Key '6100' = Label 'Reinsurer-Excess Reinsurance-AutomobileOther-Private Passenger (Gross)'
Key '6130' = Label 'Reinsurer-Excess Reinsurance-AutomobileLiability-Other than Private Passenger (Gross)'
Key '6140' = Label 'Reinsurer-Excess Reinsurance-AutomobilePersonal Accident-Other than Private Passenger (Gross)'
Key '6150' = Label 'Reinsurer-Excess Reinsurance-AutomobileOther-Other than Private Passenger (Gross)'
Key '6270' = Label 'Reinsurer-Excess Reinsurance-Boiler and machinery (Gross)'
Key '6290' = Label 'Reinsurer-Excess Reinsurance-Credit (Gross)'
Key '6300' = Label 'Reinsurer-Excess Reinsurance-Credit Protection (Gross)'
Key '6310' = Label 'Reinsurer-Excess Reinsurance-Fidelity (Gross)'
Key '6320' = Label 'Reinsurer-Excess Reinsurance-Hail (Gross)'
Key '6330' = Label 'Reinsurer-Excess Reinsurance-Legal expense (Gross)'
Key '6340' = Label 'Reinsurer-Excess Reinsurance-Liability-Comprehensive General Liability (with products) (Gross)'
Key '6350' = Label 'Reinsurer-Excess Reinsurance-Liability-Comprehensive General Liability (without products) (Gross)'
Key '6360' = Label 'Reinsurer-Excess Reinsurance-Liability-Cyber Liability (Gross)'
Key '6370' = Label 'Reinsurer-Excess Reinsurance-Liability-Directors and Officers Liability (Gross)'
Key '6380' = Label 'Reinsurer-Excess Reinsurance-Liability-Excess Liability (Gross)'
Key '6390' = Label 'Reinsurer-Excess Reinsurance-Liability-Professional Liability (Gross)'
Key '6400' = Label 'Reinsurer-Excess Reinsurance-Liability-Umbrella Liability (Gross)'
Key '6410' = Label 'Reinsurer-Excess Reinsurance-Liability-Pollution Liability (Gross)'
Key '6420' = Label 'Reinsurer-Excess Reinsurance-Liability-All Other (Gross)'
Key '6440' = Label 'Reinsurer-Excess Reinsurance-Mortgage (Gross)'
Key '6450' = Label 'Reinsurer-Excess Reinsurance-Other Approved Products (Gross)'
Key '6460' = Label 'Reinsurer-Excess Reinsurance-Surety-Contract Surety (Gross)'
Key '6470' = Label 'Reinsurer-Excess Reinsurance-Surety-All Other Surety (Gross)'
Key '6490' = Label 'Reinsurer-Excess Reinsurance-Title (Gross)'
Key '6500' = Label 'Reinsurer-Excess Reinsurance-Marine (Gross)'
Key '6510' = Label 'Reinsurer-Excess Reinsurance-Accident and sickness (Gross)'
Key '9989' = Label 'Total (Ceded)'
Key '9999' = Label 'Total (Gross)'
Institution ID
Identification de l'entreprise
Portfolio Declared
PORTFOLIO_CODE
Portfolio_Name
Declared Actuary's Category and Aggregation by Exhibit
EXHIBIT_CATEGORY_CODE
ACTUARY_CATEGORY_CODE
Actuary_Category_Name
Declared Aggregation Year
AGGREGATION_YEAR_CODE
Aggregation_Year_Name
Unpaid Claims and Loss Ratio Analysis Exhibit
PORTFOLIO_CODE
EXHIBIT_CATEGORY_CODE
ACTUARY_CATEGORY_CODE
AGGREGATION_TYPE_CODE
AGGREGATION_YEAR_CODE
REPORTING_BASIS_CODE
LIQUIDITY_CATEGORY_FOR_DISCOUNT_RATE_CODE
m1 - Paid Losses - Current Year
m2 - Paid Losses - Cumulative
m3 - Liabilities for Incurred Claims - Bornhuetter-Ferguson Initial Expected Loss Ratio Assumptions
m4 - Liabilities for Incurred Claims - Estimate of Future Cash Flows - Case Reserves
m5 - Liabilities for Incurred Claims - Estimate of Future Cash Flows - IBNR
m6 - Liabilities for Incurred Claims - Estimate of Future Cash Flows - Total
m7 - Liabilities for Incurred Claims - Estimate of Present Value of Future Cash Flows - Total
m8 - Liabilties for Incurred Claims - Risk Adjustment (RA) - RA ($'000)
m9 - Liabilties for Incurred Claims - Risk Adjustment (RA) - RA (%)
m10 - Liabilities for Incurred Claims - Fulfilment Cash Flows
m11 - Loss Ratio Analysis - Insurance Revenue/Earned Premiums
m12 - Loss Ratio Analysis - Undiscounted Loss Ratio (%)
m13 - Claim Counts - Open as at Year-end
m14 - Claim Counts - Reported to Date
m15 - As at Prior Year-end - Total Estimate of Future Cash Flows
m16 - As at Prior Year-end - Reported Claim Counts to Date
APV Reserves including ULAE, FA and Other
PORTFOLIO_CODE
EXHIBIT_CATEGORY_CODE
ACTUARY_CATEGORY_CODE
AGGREGATION_TYPE_CODE
REPORTING_BASIS_CODE
LIQUIDITY_CATEGORY_FOR_DISCOUNT_RATE_CODE
m51 - ULAE - Total
m52 - "Facility Association" and "Plan"
m53 - Other Provisions
m54 - Grand Total