Instructions – Property & Casualty Insurer Appointed Actuary’s Report (AAR) Supplementary Tables

Each property & casualty (P&C) insurer should submit a workbook containing supplemental data (Supplementary Tables) in addition to the Appointed Actuary’s Report (AAR). The Supplementary Tables must contain specific data elements presented in specific formats. This workbook is a template for the Supplementary Tables.

This workbook includes following tabs:

• cover
• list of supplementary tables
• data dictionary
• supplementary tables (Table 1-14)
• drop down menu
• data validation

General Instructions

Prepare the Supplementary Tables in accordance with the general instructions provided in this section. Instructions and guidance specific to the individual workbook tabs are provided in the following sections:

Filing

The Supplementary Tables (this workbook) should be submitted as a structured return in the Regulatory Reporting System (RRS) no later than 60 days after the end of the insurer’s fiscal year.

Basis

Information entered in this workbook should be

• determined as of the insurer’s fiscal year-end unless instructed otherwise
• prepared on a consolidated basis
• expressed amounts in thousands of Canadian dollars unless instructed otherwise
• determined for insurance contract liabilities measured under IFRS 17

Workbook modifications

The workbook should not be modified in any way including

• adding or deleting columns
• renaming, adding, or deleting tabs
• changing the format of cells

Granularity

Insurers should allocate values where they are requested at a more granular level than the level of aggregation at which the insurer has determined the amount. Where the insurer has allocated an amount, describe the allocation approach in the comment box of the cover page.

Data entry

• Blue cells are for manual entry.
• Green cells indicate the use of a drop down menu.
• Gray cells are automatically calculated.
• White cells have fixed text.

Please note that all colored cells are made accessible in the Excel spreadsheet through tooltips and locked cells.

Refer to the “data dictionary” tab for further description of what is expected in each column including drop down menu, column type and data type.

Cells should not be left “blank” unless there is no input for the cell. “0” should be entered if the amount is zero.

Insurers may only enter the values provided in drop down menus where they have been provided. Values other than those provided in drop down menus may not be entered.

Machine readable data entry

This workbook has been updated to support ingestion of the data into OSFI’s databases. Data entry in this workbook follows certain general principles.

Each tab in the workbook collects data on a certain topic (for example, table 2 collects reference curve information). Refer to the tab “list of supplementary tables” for a complete overview of the tables.

Within each tab, each distinct data value (referenced as value) is entered in a separate row (for example, each peer review information required is entered in a separate row in table 14).

Each value may be described by a value_category and one or more descriptors depending on the tab and the nature of the data collected.

In some tabs, values are described by descriptors in addition to the value_category. For example, insurers provide ultimate undiscounted estimate at prior year end in table 10 and 12 (value) broken down by

• aggregation basis (gross, net or ceded)
• aggregation type (accident year, underwriting or policy year)
• actuarial lines of business

The values for each of these additional descriptors should be entered or chosen from a set of allowable entries (drop down menu).

Please see the data dictionary, drop down menu, and data validation for additional information on permitted values and limitations on the values that may be entered.

Data quality

Insurers should conduct a quality check of the Supplementary Tables prior to submission. In particular, insurers should ensure:

• values are selected exclusively from the options provided in drop down menus in all green cells.
• values are expressed in thousands for dollar amounts or percentages as instructed.
• information is consistent throughout the workbook.
• values are consistent with the validation rules presented in the “Data Validation” tab.

We may ask insurers to refile Supplementary Tables to correct errors including the failure to follow these instructions.

Table 1 - Portfolio Reporting

List each unique link between a portfolio and an actuarial line of business on its own row. Specifically:

• a portfolio associated with multiple actuarial lines of business will appear on multiple rows (once per actuarial line of business).
• an actuarial line of business associated with multiple portfolios will also appear on multiple rows (once per portfolio).

Table 2 - Reference Discount Curve

The total discount rate should equal the risk-free rate plus the applicable illiquidity premium. Risk-free rates and total discount rates may be expressed as forward rates or spot rates provided the two are consistent. Describe the basis for the discount rates in the comment box of the cover page.