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.
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)
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)
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.
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.
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
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.
-
Section 1.1 - Replaced 3 excel spreadsheets with one single spreadsheet ‘BCAR Technical Specification – dimensional data definition’
-
Section 3 and 4 –
- Added hyperlinks to list dimensions, measures, enumerations and invalid combinations (holes)
- Changed Schedule 9 example (screen shots) using the most current version of BCAR template
-
Section 4.3 –
- Added new record type 050 for Schedule 46
- Added reference of Schedule 12 section B and C to record type 998
-
Section 4.4 – Added Dimension Type ‘Country’
-
Section 4.5 –
- Added brief descriptions for each record type
- Updated record structure for record type (010) to add 3 new measures
- Added record structure for new record type 050 (Schedule 46)
- Corrected Start position of M12, M9, M7, M19 in record type 015
- Corrected Start position of M11 in record type 045
- Removed field ‘Return File Layout Version’ from header record 000
- 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.
- Section 4.5 –
- Eight new measures added for Record Type (005)
- Ten new measures added for Record Type (010)