Solvency II Reporting Quality

SOLVENCY_IIfree

Validate regulatory reporting data for EU insurance — LEI, ISIN, CIC codes, SCR ratios, and asset classification.

12 rules 1589 downloads4.1 avg (157)

solvency-iieiopaqrtleiisinregulatoryeu-insurance

4.1(157 ratings)

Test this pack with your data

Download the template, fill in your data, and see quality results instantly.

Test This Pack

Download & Install

Choose your tool — get a ready-to-run file

Run this on your data? Upload your CSV — we'll auto-map the columns, validate, and report the bad rows.Test my data

Or use the CLI

$ npx dqhub install solvency-ii-reporting --format soda --table YOUR_TABLE

About this pack

Data quality rules for Solvency II quantitative reporting templates (QRTs). Covers: - Legal Entity Identifier (LEI) format validation - ISIN and CUSIP security identifiers - CIC (Complementary Identification Code) for asset classification - SCR/MCR ratio threshold monitoring - Currency code validation (ISO 4217) - Country code validation (ISO 3166) Based on EIOPA published validation rules and QRT field specifications.

Sources & References

GLEIF — Global LEI System

Legal entities must be identified by a valid 20-character LEI conforming to ISO 17442

Solvency II — EIOPA Solvency II Reporting Templates

LEI is required for entity identification in QRT templates S.06.02 and S.08.01

ISO — ISO 6166 - International Securities Identification Numbering System

Securities must be identified by a valid 12-character ISIN conforming to the ISO 6166 format

Solvency II — EIOPA QRT S.06.02

ISIN is the preferred identification code for assets reported in Solvency II asset templates

Solvency II — EIOPA Solvency II CIC Table (Annex VI of Delegated Regulation)

Assets reported in QRT templates S.06.02 and S.06.03 must include a valid 4-character CIC code

Solvency II — Directive 2009/138/EC, Article 101

Insurance undertakings must maintain eligible own funds covering the SCR; ratio below 100% triggers supervisory ladder of intervention

CUSIP Global Services — CUSIP Number Standard

Securities identifiers must conform to the 9-character CUSIP format for accurate trade settlement and regulatory reporting

BCBS_239 — Principle 2

Data architecture and infrastructure must use standardized reference data

GDPR — Article 44-49

Cross-border transfer validation requires valid country identification

What's included

6format rules

2completeness rules

2range rules

1consistency rules

1uniqueness rules

Checks included (12)

Legal Entity Identifier (LEI) Format(lei)

Validates that Legal Entity Identifier (LEI) values conform to the ISO 17442 standard: 18 alphanumeric characters followed by 2 check digits. LEIs uniquely identify legal entities participating in financial transactions and are mandatory for Solvency II reporting, EMIR, and MiFID II compliance.

International Securities Identification Number (ISIN) Format(isin)

Validates that ISIN values conform to the ISO 6166 standard: a 2-letter country code prefix, followed by 9 alphanumeric characters (the national security identifier), and a single check digit. ISINs are used globally for securities identification in investment portfolio reporting and Solvency II QRT submissions.

Complementary Identification Code (CIC) Format(cic_code)

Validates that CIC (Complementary Identification Code) values conform to the EIOPA Solvency II standard: a 2-letter country code followed by a 2-digit asset category code. The CIC is used to classify investment assets in Solvency II Quantitative Reporting Templates (QRTs) and determines how assets are treated for capital requirements.

CUSIP Security Identifier Format(cusip)

Validates that CUSIP (Committee on Uniform Securities Identification Procedures) identifiers conform to the standard 9-character alphanumeric format. CUSIPs uniquely identify North American securities and are used extensively in insurance investment portfolio reporting and regulatory filings.

ISO Currency Code Validation(currency_code)

Validates that values are valid ISO 4217 currency codes (e.g., USD, EUR, GBP, JPY)

ISO Country Code Validation(country_code)

Validates that values are valid ISO 3166-1 alpha-2 country codes (e.g., US, GB, DE, FR)

Column Not Null

Asserts that a specified column contains no null values. This is the most fundamental completeness check — every row must have a value present in the target column.

Column Completeness Threshold

Asserts that a column meets a minimum completeness threshold, measured as the percentage of non-null values. Useful when some nulls are acceptable but the overall population rate must stay above a defined level (e.g., 95%).

Non-Negative Values

Validates that a numeric column contains no negative values. Common for quantities, counts, amounts, durations, and other measures that should never be negative.

Value In Range

Validates that all values in a numeric column fall within a specified minimum and maximum range (inclusive). Catches data entry errors, unit conversion issues, and out-of-bounds values.

Solvency Capital Requirement (SCR) Ratio Check(scr_ratio)

Validates that the SCR (Solvency Capital Requirement) ratio is positive and flags values below 100%. An SCR ratio below 100% indicates that an insurer does not hold sufficient eligible own funds to cover the SCR, triggering supervisory intervention under Solvency II. Negative ratios indicate data errors.

Column Unique

Validates that all non-null values in a specified column are unique. Useful for natural keys, email addresses, identifiers, and any column where duplicates indicate a data quality issue.