Technical Specification

Document properties

  • Type of Publication: Technical Specification - File Layout
  • Last Updated: October, 2017
  • Version: 3.0, Published October, 2017
  • For Data Submissions effective Q1, 2018

1. Introduction

OSFI has specified a return for the Basel Capital Adequacy Reporting (BCAR) data call. This return must be submitted to OSFI through the new Tri-Agency Database System called RRS (Regulatory Reporting System). The data definitions for the return are found in [1] & [2] and this document highlights the technical file layout and format for that file. Note that the technical specification document should serve as the primary guideline whenever it is not completely ‘in-synch’ with the data definitions document [1].

1.1 Bibliography

[1] OSFI, “BCAR External_Template.xls”, Microsoft Excel Spreadsheet, Unclassified OSFI Publication.

[2] OSFI, “BCAR Technical Specification – Dimensional Data Definition”, Microsoft Excel Spreadsheet, Unclassified OSFI Publication.

Note that the MS Word version of this document (available in RRS) and Dimensional Data Definition document [2] should be in the same folder for the links to work.

2. Basic Concepts and Terms

In this section, we explain a number of concepts and terms related to the way that Return data is organized within a Return data file. We begin with a description of how to read the new BCAR template then move to dimensions and measurement records. Then these concepts are related to record types, which specify the set of fixed length measurement records that you will provide in your Return data file. 

2.1 How to read the new BCAR templates

In the earlier versions of the BCAR External Template each cell had a unique designated datapoint address (DPA). This value was used to represent the single location or cell where a value was required. BCAR had 2 categories of DPA codes, 4 digit and 8 digit. The 4 digit DPAs represent line-items without any additional dimensionality. An example is DPA 1001 which exists on Schedule 1 and has a label of Tier 1 Ratio (%). The representation of these 4 digit DPAs is unchanged in the new definition of BCAR. Each 8 digit DPAs represents a combination of dimensions with a single measure. The concept of these 8 digit datapoints has been replaced with the concept of dimensions and measures. In the first example below we see how a datapoint is represented in an older version’s template.

This example is for Schedule 9 from 2016 Final Sample Return which is currently available on the OSFI website. Note that each cell has a unique datapoint.

Example 1 

In the new set of schedules and template the same datapoint would be represented as a cross section of dimension codes and a measure.

In this case the indicated cell would be a combination of the following dimensions and measure code.

Measure:

Gross Exposure (credit-equiv. amount for off B/S) before CRM (M13)

Fixed Dimensions: 

Approach Type (APPROACH_TYPE) = No Approach Type(299)    
Probability of Default Band (PD) =Not Applicable (1499)
Double Default Framework (DD) = No Double Default (301),
Equity Characteristics (EQUITY_TYPE) = Not Applicable (1099)
Default / Dilution Risk (Risk_Type) = Not Applicable (1199)

Variable Dimension Codes:

BCAR Exposure Classes (EXP_CL) = Total Retail residential mortgages (108)
Exposure Type (Exp_Type) = Drawn (501)
Risk Weight (Risk_Weight) = 0% (701)

Example 2 

Note: the datapoint used in this example is no longer required after Q4 2016.

3. Dimensions, Measures and Information Categories (Record Types)

3.1. Dimensions

A dimension is a list of business categories that are grouped under a single business concept. For example, we have the BCAR Exposure Classes dimension shown below. The 19 categories (or dimension values, as they are often called) are assigned, as we see in the table below.

BCAR Exposure Classes

Parent Code Dimension Code Dimension Name
100 101 Total Corporate (excl. SMEs treated as Corporate)
100 105 SMEs treated as Corporate
100 106 Sovereign
100 107 Bank
100 108 Total Retail residential mortgages
100 111 Total Other retail (excl. SBEs treated as Other retail)
100 114 SBEs treated as Other Retail
100 115 Equity
100 116 Trading Book
100 117 Securitization
101 102 Corporate (excl. SMEs treated as Corporate & Specialized Lending)
101 103 Specialized Lending HVCRE
101 104 Specialized Lending non-HVCRE
108 109 Retail residential mortgages (excl. HELOCs)
108 110 HELOCs
111 112 Other retail (excl. QRRE and SBEs treated as Other Retail)
111 113 Qualifying Revolving Retail
  100 Total - All Exposure Classes
  199 No Exposure Class

The table shows dimension values. Each value has a key and label. In addition, a dimension can be hierarchical. BCAR Exposure Classes is a hierarchical dimension whereby several values roll-up under a higher level value. This is represented by the parent key column. Hierarchies are typically validated using aggregation rules. Rule types are described in the Global document. This document reference will be added later to the bibliography.

List of Dimensions

List of Enumerations

3.2. Measures

Measures are specific addresses or cells that represent a value that needs to be reported.

Typically a measure will be a unique cell in valid combination of dimension codes.

In this example from Schedule 9 in “BCAR External_Templates.xls” [1] the measure for the indicated cell is: Gross Exposure (credit-equiv. amount for off B/S) before CRM (M13)

Example 3 

List of Measures

3.3. Information Categories (Record Types)

OSFI is responsible for collecting and evaluating several general categories of information. Each information category is defined by a set of dimensions and measures.

Taking an example from Schedule 5 of BCAR which represents Standardized Approach – Credit Risk-Weighted Assets - For Banking Book – Total Corporate:

  • Data values for the set of measures, Notional Principle Amount (M12), Gross Exposure (credit-equiv. amount for off B/S) before CRM (M13), Net Exposure (credit-equiv. amount for off B/S) before CRM (M11), Redistribution of exposure for guarantees and credit derivatives (M14), Redistribution of net exposure for collateral (simple approach) (M15), Adjustment to net exposure for collateral (comprehensive approach) (M16), Net Exposure (after CRM) (M17), and Risk Weighted Assets (M7) will be collected for the dimensions: BCAR Exposure Classes (EXP_CL), Risk Weight (RISK_WEIGHT) and Exposure Type (EXP_TYPE).
  • This specific combination of measures and dimensions represents a unique Information Category or Record Type which, in this case, spans multiple schedules. This Record Type is identified with the code 005. Record Types are specified in greater detail in section 4 of this document.

In another example from Schedule 22B of BCAR which represents IRB Approach – Credit Risk-Weighted Assets – For Banking Book - Corporate:

  • Data values for the set of measures, Estimated PD (%) of Obligor (M3), Notional Principle Amount (M12), Gross Exposure (EAD) before CRM (M9), Adjustment to repo-style transaction exposure (M18), Adjusted EAD after CRM (Collateral reflected in EAD) (M1), Adjusted EAD after CRM (Collateral not reflected in EAD) (M2), Weighted Ave. LGD (collateral reflected in EAD) (M4), Weighted Ave. LGD (collateral not reflected in EAD) (M5), Double Default Framework -Weighted Ave. PD of Guarantor (%) (M8), Weighted Ave. Maturity (M6) and Risk Weighted Assets (M7) will be collected for the dimensions: BCAR Exposure Classes (EXP_CL), Exposure Type (EXP_TYPE), Approach Type (APPROACH_TYPE), Probability of Default Band (PD) and Double Default Framework (DD).
  • This specific combination of measures and dimensions represents a unique Information Category or Record Type which, in this case, spans multiple schedules too. This Record Type is identified with the code 010. Record Types are specified in greater detail in section 4 of this document.

3.4 Invalid Combinations (holes)

An invalid combination otherwise known as a hole is an instance where a value is not required. Currently this applies to BCAR returns only, although in the future it may apply other returns as well. A hole is identified by a grey cell as in this example.

Example 4 

Measure Holes – a measure hole is like the example provided above , it is a single cell where a value is not required.

Dimensional Holes – A Dimensional Hole is a series of measure holes that may or may not appear on the table. It is often represented by its absence. In the example below record Type 005 is defined as having multiple Exposure Types (EXP_TYPE) yet only three are displayed for data entry:

Exposure Types (EXP_TYPE) = Drawn (501)
Exposure Types (EXP_TYPE) = Undrawn commitment (502)
Exposure Types (EXP_TYPE) = Other off-balance sheet (505).

There are several exposure types that are not required in this schedule:

Exposure Type (EXP_TYPE) = Repo-Style Transaction (503)

Since there are no values required across the full range of all the measures for this Exposure Type it is not even displayed on the schedule. Had it been displayed all its values would have been greyed out. This is a dimensional hole.

Note that Exposure Type (EXP_TYPE) = Repo-Style Transaction (503) is absent from Schedule 9 – Record Type 005 although it is on the list of allowed values.

Example 5 

List of Invalid Combinations (Holes)

Beneath each record type grid is a link that opens an Excel sheet, “BCAR Technical Specification – Dimensional Data Definition.xls”, [2] that displays the list of measure and dimensional holes.

As highlighted in the example below, document “BCAR Technical Specification – Dimensional Data Definition.xls” [2] lists all the possible cross sections of dimension and measure for each record type.

Where the value is 0 that combination is not required to be reported or in other word is a hole. The value 1 indicates that it is a valid combination and a value can be reported.

When multiple dimension codes are displayed then the accompanying value refers to the full range of those dimension codes. This is what is referred to as a dimensional hole

Example 1 – Measure Hole

  • BCAR Exposure Classes (EXP_CL ) = Specialized Lending HVCRE (103)
  • Exposure Type ( EXP_TYPE ) = Total Exposure Type (500)
  • Risk Weight (RISK_WEIGHT ) = Total Risk Weight (700)
  • Measure: Notional Principal Amount (M12)

Example 2 Dimensional Hole

  • BCAR Exposure Classes (EXP_CL ) = Specialized Lending HVCRE (103)
  • Exposure Type ( EXP_TYPE ) = Drawn (501)
  • Exposure Type ( EXP_TYPE ) = Undrawn commitment (502)
  • Exposure Type ( EXP_TYPE ) = OTC Derivatives(504)
  • Exposure Type ( EXP_TYPE ) = Other off-balance sheet (505)
  • Risk Weight (RISK_WEIGHT ) = 70% Slotting non-HVCRE Strong (707)
  • Risk Weight (Risk_Weight ) = 90% Slotting non-HVCRE Good (709)
  • Risk Weight (Risk_Weight ) = 90% Slotting non-HVCRE Good (709)
  • Risk Weight (Risk_Weight ) = 115% Slotting Non-HVCRE Satisfactory(713)

Measure: all measures

Example 6 

4. Extract File Requirements

The following sections describe the BCAR Return extract file layout required by RRS.

4.1. File Type and Naming Convention

The data file will have the naming convention of FI_BA_MMYYYY.DAT, where FI represents the Institution ID (provided by OSFI), BA is a fixed string representing the two characters identifying the code for this return, MM represents the month and YYYY represents the year of the reporting date of information.

The data file will be a variable length text file – the length of the line will depend on the specific Record Type –and end with a carriage return (CR) and line feed (LF) as record delimiters.

4.2. File Structure

The first row of the extract file must be a header record (“000”). Apart from the header, all the other records may be in any order. These records represent the values collected for each Record Type.

4.3. Record Types

Each line of your Return data file is for a specific Record Type. Valid Record Types that will be reported are shown in the table below. RRS must be able to identify the type of record in order to parse it into its constituent fields. To facilitate this process, every record begins with a three-character “Record Type” identifier. The specific record structure for each Record Type is specified later in this document.

Record Type ID Record Type Description
005 For the following schedules 5, 7 - 13
010 For the following schedules 22 - 28, 30 - 34
015 For schedule 29
025 For schedule 36
030 For the following schedules 22 - 25, 30 - 34
035 For the following schedules 22 - 25, 30 - 34
040 For schedule 9
045 For schedule 9
050 For schedule 46
998 For the following schedules 1 - 4, 12 (section B and C),14, 35, 37 - 45

4.4. Dimension Types

The Dimensions and their key value ranges required by this Return are shown below. Links for each dimension will provide the list of key values.

Dimension ID Dimension Name Remarks
APPROACH_TYPE Approach Type For IRB exposures, IRB credit risk approach type : IRB Retail (202) and IRB Wholesale (204)
EXP_CL BCAR Exposure Classes For both IRB and Standardized, credit risk exposure class : Corporate (101), Bank (107), Mortgage (108 or 109), etc.
RISK_TYPE Default / Dilution Risk For the retail IRB memo item for purchased receivables : Default Risk (1101) and Dilution Risk (1102)
DD Double Default Framework For wholesale IRB exposure classes : Not using double default (301) and using double default (302)
EQUITY_TYPE Equity Characteristics For the IRB equity schedule, records if capital gains are expected and if shares are publicly traded
EXP_TYPE Exposure Type For both IRB and Standardized, credit risk exposure type: Drawn (501) Undrawn (502), OTC Derivatives (504), etc.
PD Probability of Default Band For IRB exposures, numbered PD bands, ranging from PD Band 1 (1401) to Default 100% (1426)
RISK_WEIGHT Risk Weight For standardized approach exposures, credit risk weights: 0% (701), 20% (703), 75% (708) etc.
COUNTRY Country Code For the Counter-cyclical buffer, two letter ISO country codes : Canada (CA), Germany (DE), USA (US), UK (GB), etc.

4.5. Record Structures

This section described the record structure for each Record Type.

The record structure is defined using a table with 6 fields. Each field is described below:

Field ID
This is the RRS identifier for the dimension or measure.

Field Name
This is the Name of the dimension or measure.

Notes
This provides additional information on how the field should be populated. In some cases this will be a fixed value and in others there will be a range of allowed values that should be used.

Start
This is the fixed character position in the data file record where the value must start.

Length
This is the length of the reported value. The reported value must be right justified. Where the reported value does not fill the entire available length, the characters on the left must be padded with blank or zero characters. Where there is no value to report the entire length must be padded with blank characters.

Dimension
This field indicates whether the field is a dimension or a measure. Y indicates a dimension.
It should be noted, that no line numbers have been specified for any of the record type definitions. This is a change from how current dimensional record structures are defined as RRS has no use for this information. However, no errors will be thrown if the line number is provided at the end of each record.

Header Record (000)

The header record is a quality control mechanism that uniquely identifies each file sent to OSFI (i.e. who sent the file, the reporting date, the file name, etc). The information contained in the header field is checked against the file name and the actual details of the file to ensure that the file received by OSFI has not been corrupted.

The record structure layout of the header record is detailed below:

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “000” Fixed string “000” 1 3 -
EXP_CL BCAR Exposure Classes Fixed string “199” 4 3 Y
RISK_WEIGHT Risk Weight Fixed String “799” 7 3 Y
EXP_TYPE Exposure Type Fixed String “599” 10 3 Y
APPROACH_TYPE Approach Type Fixed String “299” 13 3 Y
PD Probability of Default Band Fixed String “1499” 16 4 Y
DD Double Default Framework Fixed String “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed String “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed String “1199” 27 4 Y
  Institution ID Right-padded with spaces 31 4 N
  Reporting Date of Information Format: YYYYMMDD 35 8 N
  Return Name Fixed String, “BA”, Right-padded with spaces 43 7 N

Record Type (005) Schedules 5 and 7 to 13

The standardized approach to calculating credit risk-weighted assets is outlined in Chapter 3 of the guideline. All data for exposures reported under the standardized approach are captured here with the exception of reverse mortgage data from schedule 9 which is captured under record types 040 and 045 and standardized securitization data which is captured under Conventional DPAs (record type 998). The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “005” Fixed string “005” 1 3 -
EXP_CL BCAR Exposure Classes Allowed Values 4 3 Y
RISK_WEIGHT Risk Weight Allowed Values 7 3 Y
EXP_TYPE Exposure Type Allowed Values 10 3 Y
APPROACH_TYPE Approach Type Fixed string “299” 13 3 Y
PD Probability of Default Band Fixed string “1499” 16 4 Y
DD Double Default Framework Fixed string “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed string “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed string “1199” 27 4 Y
M7 Risk Weighted Assets Left-padded with 0’s 31 15 N
M11 Net Exposure (credit-equiv. amount for off B/S) Left-padded with 0’s 46 15 N
M12 Notional Principal Amount Left-padded with 0’s 61 15 N
M13 Gross Exposure (credit-equiv. amount for off B/S) before CRM Left-padded with 0’s 76 15 N
M14 Redistribution of exposure for guarantees and credit derivatives Left-padded with 0’s 91 15 N
M15 Redistribution of net exposure for collateral (simple approach) Left-padded with 0’s 106 15 N
M16 Adjustment to net exposure for collateral (comprehensive approach Left-padded with 0’s 121 15 N
M17 Net Exposure (after CRM) Left-padded with 0’s 136 15 N
M25 Mortgages insured by Sovereign - Pre-CRM net exposure (credit-equiv. amount for off B/S) Left-padded with 0’s 151 15 N
M26 Mortgages insured by Sovereign - Redistribution of net exposure for guarantees, credit derivatives Left-padded with 0’s 166 15 N
M27 Mortgages insured by Sovereign - Post-CRM net exposure Left-padded with 0’s 181 15 N
M28 Mortgages insured by Sovereign - Risk-weighted Assets Left-padded with 0’s 196 15 N
M55 Mortgages insured by a corporate - Pre-CRM net exposure (credit-equiv. amount for off B/S) Left-padded with 0’s 211 15 N
M56 Mortgages insured by a corporate - Redistribution of net exposure for guarantees, credit derivatives Left-padded with 0’s 226 15 N
M57 Mortgages insured by a corporate - Post-CRM net exposure  Left-padded with 0’s 241 15 N
M58 Mortgages insured by a corporate - Risk-weighted Assets Left-padded with 0’s 256 15 N

List of Invalid Combinations (Holes)

Record type (010) Schedules 22 to 28 and 30 to 34

Record type 010 captures data for exposures reported under the general IRB approach described in Chapter 6 of the guideline, including information relating to any LGD adjustments to reflect guarantees. Exposures that do not follow the PD, EAD, LGD approach are captured under other record types, including an item on purchased receivables, an item on default/dilution risk, specialized lending, PD/LGD approach to equity, IRB equity and securitization, respectively captured under record types 030, 035, 015, 025, 998 and 998. The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “010 Fixed string “010” 1 3 -
EXP_CL BCAR Exposure Classes Allowed Values 4 3 Y
RISK_WEIGHT Risk Weight Fixed String “799” 7 3 Y
EXP_TYPE Exposure Type Allowed Values 10 3 Y
APPROACH_TYPE Approach Type Allowed Values 13 3 Y
PD Probability of Default Band Allowed Values 16 4 Y
DD Double Default Framework Allowed Values 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed string “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed string “1199” 27 4 Y
M1 Adjusted EAD after CRM (Collateral reflected in EAD) Left-padded with 0’s 31 15 N
M2 Adjusted EAD after CRM (Collateral not reflected in EAD) Left-padded with 0’s 46 15 N
M3 Estimated PD (%) of Obligor Left-padded with 0’s 61 15 N
M4 Weighted Ave. LGD (collateral reflected in EAD) Left-padded with 0’s 76 15 N
M5 Weighted Ave. LGD (collateral not reflected in EAD) Left-padded with 0’s 91 15 N
M6 Weighted Ave. Maturity Left-padded with 0’s 106 15 N
M7 Risk Weighted Assets Left-padded with 0’s 121 15 N
M8 Double Default Framework - Weighted Ave. PD of Guarantor (%) Left-padded with 0’s 136 15 N
M9 Gross Exposure (EAD) before CRM Left-padded with 0’s 151 15 N
M10 Increase & Decrease in Exposure for guar. & credit deriv. on retail, SME exposures Left-padded with 0’s 166 15 N
M12 Notional Principal Amount Left-padded with 0’s 181 15 N
M14 Redistribution of exposure for guarantees and credit derivatives Left-padded with 0’s 196 15 N
M18 Adjustment to repo-style transaction exposure Left-padded with 0’s 211 15 N
M19 Expected Loss Amount Left-padded with 0’s 226 15 N
M20 Weighted Average Firm Size Left-padded with 0’s 241 15 N
M30 Guaranteed exposures, to which LGD adjustment was applied Left-padded with 0’s 256 15 N
M31 Guarantees Using LGD Adjust. - Weighted Ave. LGD (%), before recognition of guarantees Left-padded with 0’s 271 15 N
M32 Guarantees Using LGD Adjust. - Weighted Ave. LGD (%), after recognition of guarantees Left-padded with 0’s 286 15 N
M33 Guarantees Using LGD Adjust. - Exposures having Corp. excl. SME Guarantors Left-padded with 0’s 301 15 N
M34 Guarantees Using LGD Adjust. - Weighted Ave. PD of Corp. excl. SME Guarantors (%) Left-padded with 0’s 316 15 N
M35 Guarantees Using LGD Adjust. - Exposures having SMEs treated as Corporate Guarantors Left-padded with 0’s 331 15 N
M36 Guarantees Using LGD Adjust. - Weighted Ave. PD of SMEs treated as Corporate Guarantors (%) Left-padded with 0’s 346 15 N
M37 Guarantees Using LGD Adjust. - Exposures having Sovereign Guarantors Left-padded with 0’s 361 15 N
M38 Guarantees Using LGD Adjust. - Weighted Ave. PD of Sovereign Guarantors (%) Left-padded with 0’s 376 15 N
M39 Guarantees Using LGD Adjust. - Exposures having Bank Guarantors Left-padded with 0’s 391 15 N
M40 Guarantees Using LGD Adjust. - Weighted Ave. PD of Bank Guarantors (%) Left-padded with 0’s 406 15 N
M41 Uninsured Exposure bound by LGD Floor Left-padded with 0’s 421 15 N
M42 Weighted Ave. LGD on Uninsured Exposures bound by LGD Floor, Before LGD Floor (%) Left-padded with 0’s 436 15 N
M43 Weighted Ave. LGD on Uninsured Exposures bound by LGD Floor, After LGD Floor (%) Left-padded with 0’s 451 15 N
M48 Insured mortgages - Exposure (at PD of original obligor (M48)) Left-padded with 0’s 466 15 N
M49 PD substitution for Insured mortgages - Redistribution of insured mortgage exposures Left-padded with 0’s 481 15 N
M59 PD substitution for Insured mortgages - After CRM Adjusted Exposure (EAD) Left-padded with 0’s 496 15 N
M50 Insured mortgages - Weighted Ave. LGD (adjusted for CRM after application of floor)(%) Left-padded with 0’s 511 15 N
M51 PD substitution for Insured mortgages - Weighted Ave. Maturity (years) Left-padded with 0’s 526 15 N
M52 Insured mortgages - Risk-weighted Assets Left-padded with 0’s 541 15 N
M53 Insured mortgages - Expected Loss Amount Left-padded with 0’s 556 15 N
M61 Insured mortgages - DLGD floor - Insured exposures bound by LGD floor Left-padded with 0’s 571 15 N
M62 Insured mortgages - DLGD floor - LGD on insured exposures bound by LGD floor, before LGD floor (%) Left-padded with 0’s 586 15 N
M63 Insured mortgages - DLGD floor - LGD on insured exposures bound by LGD floor, after LGD floor (%) Left-padded with 0’s 601 15 N

List of Invalid Combinations (Holes)

Record Type (015) Schedule 29

Specialized lending is a subclass of Corporate for which the reporting institution does not meet the requirements for estimating PDs and cannot use the risk-weight formulas. In these cases, it must use a Supervisory Slotting approach to calculate risk-weighted assets. The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “015 Fixed string “015” 1 3 -
EXP_CL BCAR Exposure Classes Allowed Values 4 3 Y
RISK_WEIGHT Risk Weight Allowed Values 7 3 Y
EXP_TYPE Exposure Type Allowed Values 10 3 Y
APPROACH_TYPE Approach Type Fixed string “299” 13 3 Y
PD Probability of Default Band Fixed string “1499” 16 4 Y
DD Double Default Framework Fixed string “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed string “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed string “1199” 27 4 Y
M12 Notional Principal Amount Left-padded with 0’s 31 15 N
M9 Gross Exposure (EAD) before CRM Left-padded with 0’s 46 15 N
M7 Risk Weighted Assets Left-padded with 0’s 61 15 N
M19 Expected Loss Amount Left-padded with 0’s 76 15 N

List of Invalid Combinations (Holes)

Record Type (025) Schedule 36

The PD/LGD approach for equity exposures is only available for non-tier 1 perpetual preferred shares without a redeemable feature and perpetual preferred shares with a redeemable feature at the issuer’s option. The methodology for calculating risk-weighted assets under the PD/LGD approach is described in section 6.5.1(ii).  The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “025” Fixed string “025” 1 3 -
EXP_CL BCAR Exposure Classes Fixed string “199” 4 3 Y
RISK_WEIGHT Risk Weight Fixed string “799” 7 3 Y
EXP_TYPE Exposure Type Fixed string “599” 10 3 Y
APPROACH_TYPE Approach Type Fixed string “299” 13 3 Y
PD Probability of Default Band Allowed Values 16 4 Y
DD Double Default Framework Fixed string “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Allowed Values 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed string “1199” 27 4 Y
M3 Estimated PD (%) of Obligor Left-padded with 0’s 31 15 N
M19 Expected Loss Amount Left-padded with 0’s 46 15 N
M21 Exposure Left-padded with 0’s 61 15 N
M22 Weighted Average Scaling Factor Left-padded with 0’s 76 15 N
M23 PD/LGD for IRB Equity - Risk Weighted Assets (Pre-floor) Left-padded with 0’s 91 15 N
M24 PD/LGD for IRB Equity - Risk Weighted Assets (Post-floor) Left-padded with 0’s 106 15 N

List of Invalid Combinations (Holes)

Record Type (030) Schedules 22 to 25 and 30 to 34

Within the corporate and retail exposure classes, eligible purchased receivables are given unique treatment, whereby risk-weighted assets are calculated separately for default and for dilution risk. Additional data relating to purchased receivables under this treatment are captured under ‘Purchased Receivable EL and RWA’ (Record type 035). The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “030” Fixed string “030” 1 3 -
EXP_CL BCAR Exposure Classes Allowed Values 4 3 Y
RISK_WEIGHT Risk Weight Fixed string “799” 7 3 Y
EXP_TYPE Exposure Type Allowed Values 10 3 Y
APPROACH_TYPE Approach Type Allowed Values 13 3 Y
PD Probability of Default Band Fixed string “1499” 16 4 Y
DD Double Default Framework Fixed string “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed string “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed string “1199” 27 4 Y
M12 Notional Principal Amount Left-padded with 0’s 31 15 N
M9 Gross Exposure (EAD) before CRM Left-padded with 0’s 46 15 N
M2 Adjusted EAD after CRM (Collateral not reflected in EAD) Left-padded with 0’s 61 15 N
M5 Weighted Ave. LGD (collateral not reflected in EAD) Left-padded with 0’s 76 15 N
M6 Weighted Ave. Maturity of Credit Protection Left-padded with 0’s 91 15 N
M20 Weighted Average Firm Size Left-padded with 0’s 106 15 N

List of Invalid Combinations (Holes)

Record Type (035) Schedules 22 to 25 and 30 to 34

Measures relating to eligible purchased receivables qualifying for special treatment are captured in this record type as well as in Purchased Receivables (record type 030). The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “035” Fixed string “035” 1 3 -
EXP_CL BCAR Exposure Classes Allowed Values 4 3 Y
RISK_WEIGHT Risk Weight Fixed string “799” 7 3 Y
EXP_TYPE Exposure Type Allowed Values 10 3 Y
APPROACH_TYPE Approach Type Allowed Values 13 3 Y
PD Probability of Default Band Fixed string “1499” 16 4 Y
DD Double Default Framework Fixed string “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed string “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Allowed Values 27 4 Y
M7 Risk Weighted Assets Left-padded with 0’s 31 15 N
M19 Expected Loss Amount Left-padded with 0’s 46 15 N

List of Invalid Combinations (Holes)

Record Type (040) Schedule 9

Reverse mortgages are given special capital treatment set out in the Advisory on the Capital Treatment of Reverse Mortgages. In addition to the data captured here, reverse mortgages must also be included under the Standardized approach (record type 005), under Total Retail residential mortgages (exposure class 108). Additional data may also be captured under Reverse Mortgages Deducted from Capital (record type 045). The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “040” Fixed string “040” 1 3 -
EXP_CL BCAR Exposure Classes Fixed string “199” 4 3 Y
RISK_WEIGHT Risk Weight Allowed Values 7 3 Y
EXP_TYPE Exposure Type Allowed Values 10 3 Y
APPROACH_TYPE Approach Type Fixed string “299” 13 3 Y
PD Probability of Default Band Fixed string “1499” 16 4 Y
DD Double Default Framework Fixed string “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed string “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed string “1199” 27 4 Y
M7 Risk Weighted Assets Left-padded with 0’s 31 15 N
M11 Net Exposure (credit-equiv. amount for off B/S) before CRM Left-padded with 0’s 46 15 N
M12 Notional Principal Amount Left-padded with 0’s 61 15 N
M13 Gross Exposure (credit-equiv. amount for off B/S) before CRM Left-padded with 0’s 76 15 N
M14 Redistribution of exposure for guarantees and credit derivatives Left-padded with 0’s 91 15 N
M15 Redistribution of net exposure for collateral (simple approach) Left-padded with 0’s 106 15 N
M16 Adjustment to net exposure for collateral (comprehensive approach) Left-padded with 0’s 121 15 N
M17 Net Exposure (after CRM) Left-padded with 0’s 136 15 N

List of Invalid Combinations (Holes)

Record Type (045) Schedule 9

Reverse Mortgages to be deducted from capital as set out in the Advisory on the Capital Treatment of Reverse Mortgages are reported here as well as under deductions from capital and are additionally assigned a 0% risk weight.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “045” Fixed string “045” 1 3 -
EXP_CL BCAR Exposure Classes Fixed string “199” 4 3 Y
RISK_WEIGHT Risk Weight Fixed string “799” 7 3 Y
EXP_TYPE Exposure Type Allowed Values 10 3 Y
APPROACH_TYPE Approach Type Fixed string “299” 13 3 Y
PD Probability of Default Band Fixed string “1499” 16 4 Y
DD Double Default Framework Fixed string “301” 20 3 Y
EQUITY_TYPE Equity Characteristics Fixed string “1099” 23 4 Y
RISK_TYPE Default / Dilution Risk Fixed string “1199” 27 4 Y
M11 Net Exposure (credit-equiv. amount for off B/S) before CRM Left-padded with 0’s 31 15 N

List of Invalid Combinations (Holes)

Record Type (050) Schedule 46

Institutions with operations outside Canada will look at the geographic location of their private sector credit exposures and calculate their institution-specific countercyclical capital buffer requirement as a weighted average of the requirements that are being applied in jurisdictions to which they have credit exposures.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “050” Fixed string “050” 1 3 -
COUNTRY_CD County Code Allowed Values 4 2 Y
M44 RWA for Private Sector Credit Exposures Left-padded with 0’s 6 15 N
M45 Geographic Weight for jurisdiction Left-padded with 0’s 21 15 N
M46 CCyB add-on rate Left-padded with 0’s 36 15 N
M47 Weighted buffer add-on Left-padded with 0’s 51 15 N

List of Invalid Combinations (Holes)

Record Type (998) Conventional DPAs Schedules 1 to 4, 12 (Section B & C), 14, 35, 37 to 45

Data not captured under the other record types are captured here. A value must be provided for every DPA code where there is one available. The record structure layout for this information category is detailed as follows.

Field ID Field Name Notes Start Length Dimension
Record Type Fixed string “998” Fixed string “998” 1 3 -
DPA CODE 4 digit dpa code - 4 4 N
DPA Value Value associated with DPA Left-padded with 0’s 8 15 N

5. Change Control Log

Changes in version 2.0

These entries highlight changes made since the last release of this document.  This log has been written for the technical audience who is already familiar with the previous release of this document and needs to know what changes have been made to it. Readers should have Version 1.0 of this document on hand when reviewing this change log.

Those not already working with Version 1.0 of this Technical Specification Document do not need to use this change log.

  1. Section 1.1 - Replaced 3 excel spreadsheets with one single spreadsheet ‘BCAR Technical Specification – dimensional data definition’

  2. Section 3 and 4 –

    1. Added hyperlinks to list dimensions, measures, enumerations and invalid combinations (holes)
    2. Changed Schedule 9 example (screen shots) using the most current version of BCAR template  
  3. Section 4.3 –

    1. Added new record type 050 for Schedule 46
    2. Added reference of Schedule 12 section B and C to record type 998
  4. Section 4.4 – Added Dimension Type ‘Country’

  5. Section 4.5 –

    1. Added brief descriptions for each record type
    2. Updated record structure for record type (010) to add 3 new measures
    3. Added record structure for new record type 050 (Schedule 46)
    4. Corrected Start position of M12, M9, M7, M19 in record type 015
    5. Corrected Start position of M11 in record type 045
    6. Removed field ‘Return File Layout Version’ from header record 000
    7. Added reference of Schedule 12 section B and C to record type 998

Changes in version 3.0

These entries highlight changes made since the last release of this document.  This log has been written for the technical audience who is already familiar with the previous release of this document and needs to know what changes have been made to it. Readers should have Version 2.0 of this document on hand when reviewing this change log.

Those not already working with Version 2.0 of this Technical Specification Document do not need to use this change log.

  1. Section 4.5 –
    • Eight new measures added for Record Type (005)
    • Ten new measures added for Record Type (010)