7 Regulatory Data Extracts

This chapter provides information on creating and executing Data Extract Definitions to export the Regulatory Reporting Data into .csv files. It allows you to export data for a specific report, or cells and schedules. You can also export the data from a Derived Entity.

Create an Export Definition

To create an Export Definition, perform the following steps:

1. After logging into the OFSAAI Applications Page, navigate to Regulatory Reporting for Office of Superintendent of Financial Institutes Canada, and select Regulatory Data Extract.

Figure 53: Regulatory Data Export Page

This illustration shows the navigation to the Regulatory Data Export page starting with Regulatory Reporting for OSFI, select Regulatory Data Extracts .

2. Click Create. The New Model Definition Page is displayed.

Figure 54: New Model Definition Page

This illustration shows the creation of New Model Definition consisting of name, Description and Export Type fields.

3. Select or enter the required values for each field as follows.

Table 6: Model Export Definition Fields and Descriptions


Field Name	Description or Instruction
Name	Enter the name of the New Model Definition.
Description	Enter the New Model Definition Description.
Export Type	Select the Export Type of the model from the dropdown list.
Report	This field is displayed only when the Export Type is either Schedule or Reporting Lines. Select the appropriate report from the drop-down list.
Search	Search for a specific object from the available list.

4. Select the required objects from the list by marking the checkbox.

5. Click Save to complete the Export Definition creation.
On successful creation of the Export Definition, the Regulatory Data Export Definitions Summary Page is displayed.

Edit and View an Export Definition

To edit and view an Export Definition, perform the following steps:

Figure 55: Edit and View Export Definition Page

This illustration shows the edit page for export definition page

1. Click on the Export Definition that you wish to edit or view from the Export Definitions Summary Page.

The Edit or View Export Definition Page is displayed.

2. You can update the existing information if required and click Save to save the changes in the Export Definition or click Cancel to cancel if there is no modification in the Export Definition.

Delete an Export Definition

To delete an Export Definition, perform the following steps:

Figure 56: Delete Export Definition Page

This illustration shows the deletion of Export Definition.

1. Select a Model Export Definition from the Export Definitions Summary Page.

2. Click Delete to delete the Export Definition.

Executing the Regulatory Data Export Definition through Process Modelling Framework

After the Export Definition has been created, a process must be created in the Run Pipeline and must be executed through the Process Modelling Framework.