EDITOR is a web application developed by European DataWarehouse (EDW) for the seamless analysis and upload of structured data for underlying assets and transaction-level information in compliance with the UK Securitisation Regulatory Framework.
It allows reporting entities to pre-screen and analyse loan-level data (LLD) files and upload them directly to its Securitisation Repository Platform, registered under the Financial Conduct Authority (FCA).
EDITOR
YOUR SECURITISATION REPOSITORY PLATFORM
INTEGRATED UPLOADS FOR FCA COMPLIANCE
PUBLISH HIGH QUALITY LOAN-LEVEL DATA
As a pre-screening tool, EDITOR contains more than 4,000 rules and checks that allow for a quick overview of the potential inconsistencies in the submitted LLD files.
EDITOR’s data quality improvement process includes both mandatory checks as defined by FCA, as well as optional EDW checks aimed at increasing the quality and useability of the submitted data.
- Schema checks: verification of file structure and of the format of the data submitted
- FCA validation rules: rules that lead to a submission rejection if not validated
- FCA additional rules: additional rules that need to be executed by the Securitisation Repository but do not lead to a submission rejection
- Data Quality Plus: rules developed by EDW to improve the quality of FCA submissions
- Data Quality Score: a subset of Data Quality Plus rules used to calculate the EDW ”DQS” score
Results for each validation check are displayed in a “Pass/Fail” logic with only the number of loans which fail a particular data quality check being shown. This is reflected in the FCA Score (formerly DQS1). Additional data quality issues are reflected in the EDW Data Quality Score (formerly DQS2). Results are indications of potential data quality issues that need to be further investigated.
EDITOR FEATURES
- Pre-screen and analyse data files
- Directly upload data files to the securitisation repository
- Conduct rule analysis in all regulatory asset classes (RMBS, CRP, Auto, Consumer, Leasing)
- Centralised rule repository with automatic updates
- ‘My Portfolio’ tool to create a personal portfolio and add specific deals based on Securitisation IDs, ISINs, or EDCodes
- Access EDW’s Extended (FCA + Rating Agency) Templates
- Compare stratifications and rule results from previous submissions
- View data completeness and quality scores during upload and correct issues before submission
- Upload multiple files simultaneously
- Perform schema checks
- Create private deals
- Easily convert CSV files to XML format and submit with one click
SIMPLIFY DATA SUBMISSIONS AND SAVE TIME WITH THE INTEGRATED CSV2XML CONVERTER
The preparation of data in an XML format can be challenging, but EDW‘s CSV2XML Converter allows for the upload of data files in CSV format, which are then converted to XML and submitted in one click. The Converter also displays the reporting entity’s upcoming submission deadlines, the status of previous submissions, and an option to download the related feedback report.