Digital Operational Resilience and ICT Third-Party Risk Analytics Set (EU)
Overview
FINICT999 models digital operational resilience across EU financial entities and their ICT third parties from governance and service mapping through concentration, incidents, vulnerability, change, continuity, TLPT, audit, remediation and financial outcomes. Pre-DORA rows are resilience baselines, the transition period records readiness without claiming statutory compliance, and rows from the DORA application date follow applicable-state semantics. Official regulatory, economic, threat and ERA5 weather sources calibrate deterministic synthetic drivers only. Historical driver and periodic rows are synthetic calibrations, current-period rows are synthetic estimates, and forward-looking driver and periodic rows are synthetic forecasts. Forward-dated operational rows represent planned or scheduled activity. All modelled organisation, person, provider and product identities, plus all operational records, are synthetic by construction; organisation domains and emails use .example, and selected hardware assets map to governed transparent hardware imagery.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| dora_calendar_days | 4,383 |
| dora_methodology_sources | 46 |
| dora_regulatory_instruments | 24 |
| dora_jurisdictions | 37 |
| dora_external_drivers_monthly | 15,552 |
| dora_financial_entities | 80 |
| dora_legal_entities | 220 |
| dora_regulatory_scopes | 660 |
| dora_business_services | 900 |
| dora_facilities | 620 |
| dora_ict_providers | 650 |
| dora_technology_products | 480 |
| dora_ict_assets | 12,000 |
| dora_technology_dependencies | 28,000 |
| dora_people | 4,800 |
| dora_person_roles | 7,500 |
| dora_asset_media | 48 |
| dora_asset_config_history | 144,000 |
| dora_contractual_arrangements | 4,500 |
| dora_contract_services | 13,500 |
| dora_contract_data_locations | 7,500 |
| dora_subcontract_links | 14,000 |
| dora_register_snapshots | 2,200 |
| dora_register_entries | 50,600 |
| dora_exit_strategies | 4,500 |
| dora_concentration_monthly | 237,647 |
| dora_service_levels | 18,000 |
| dora_risk_assessments | 42,000 |
| dora_risk_scenarios | 84,000 |
| dora_control_catalogue | 240 |
| dora_control_assignments | 36,000 |
| dora_control_tests | 144,000 |
| dora_access_entitlements | 90,000 |
| dora_access_reviews | 180,000 |
| dora_workforce_training | 72,000 |
| dora_incidents | 18,000 |
| dora_incident_impacts | 36,000 |
| dora_incident_reports | 260 |
| dora_recurring_incident_links | 3,000 |
| dora_incident_timeline | 90,000 |
| dora_vulnerabilities | 30,000 |
| dora_asset_vulnerabilities | 72,000 |
| dora_patches | 18,000 |
| dora_patch_deployments | 90,000 |
| dora_change_requests | 50,000 |
| dora_releases | 40,000 |
| dora_continuity_plans | 3,600 |
| dora_continuity_tests | 12,000 |
| dora_recovery_results | 36,000 |
| dora_tlpt_engagements | 100 |
| dora_tlpt_phases | 700 |
| dora_tlpt_findings | 2,000 |
| dora_audits | 5,000 |
| dora_audit_findings | 15,000 |
| dora_remediation_actions | 30,000 |
| dora_finop_periodic | 55,147 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
Schema
Every table ships with typed columns, referential integrity, and documentation.
| Column | Type | Description |
|---|---|---|
| date_id | varchar(24) | Stable calendar-day key in YYYYMMDD form. |
| calendar_date | date | ISO calendar date represented by this daily time-spine row. |
| calendar_year | integer | Calendar year containing the represented date. |
| month_number | varchar(8) | Calendar month number within the year. |
| month_name | varchar(16) | English calendar month name. |
| quarter_number | varchar(8) | Calendar quarter number within the year. |
| iso_week_number | varchar(8) | ISO week number containing the represented date. |
+8 more columns in dora_calendar_days. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| source_id | varchar(32) | Stable primary key for one methodology source record. |
| source_code | varchar(32) | Stable machine-readable code for the methodology source. |
| publisher_name | varchar(72) | Name of the authority or institution publishing the source. |
| source_title | varchar(104) | Official title of the methodology source. |
| source_url | varchar(184) | Canonical public URL for the methodology source. |
| jurisdiction_id | varchar(8) | Foreign key to dora_jurisdictions.jurisdiction_id for the jurisdiction linked to this row. |
| source_type | varchar(32) | Classification of the methodology source, such as legislation, guidance or statistics. |
+10 more columns in dora_methodology_sources. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| instrument_id | varchar(32) | Stable primary key for one regulatory instrument record. |
| source_id | varchar(32) | Foreign key to dora_methodology_sources.source_id for the source linked to this row. |
| jurisdiction_id | varchar(8) | Foreign key to dora_jurisdictions.jurisdiction_id for the jurisdiction linked to this row. |
| instrument_code | varchar(24) | Machine-readable code for the instrument. |
| instrument_name | varchar(88) | Readable name of the instrument. |
| issuing_authority | varchar(72) | Issuing authority recorded for this regulatory instrument record. |
| legal_level | varchar(32) | Legal hierarchy of the instrument, such as legislation, a technical standard or supervisory guidance. |
+15 more columns in dora_regulatory_instruments. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| jurisdiction_id | varchar(16) | Stable primary key for one jurisdiction record. |
| jurisdiction_code | varchar(8) | Machine-readable code for the jurisdiction. |
| jurisdiction_name | varchar(24) | Readable name of the jurisdiction. |
| region_group | varchar(24) | Region group recorded for this jurisdiction record. |
| currency_code | varchar(8) | ISO currency code for the related monetary amount. |
| time_zone_name | varchar(24) | Readable name of the time zone. |
| competent_authority | varchar(56) | Competent authority recorded for this jurisdiction record. |
+5 more columns in dora_jurisdictions. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| driver_observation_id | varchar(40) | Stable primary key for one jurisdiction, month and external-driver observation. |
| month_start_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the month start date linked to this row. |
| jurisdiction_id | varchar(16) | Foreign key to dora_jurisdictions.jurisdiction_id for the jurisdiction linked to this row. |
| driver_code | varchar(24) | Machine-readable code for the driver. |
| driver_name | varchar(56) | Readable name of the driver. |
| driver_category | varchar(16) | Driver category recorded for this external drivers monthly record. |
| unit_name | varchar(24) | Readable measurement unit for the recorded value. |
+10 more columns in dora_external_drivers_monthly. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| financial_entity_id | varchar(24) | Stable primary key for one synthetic financial group or standalone institution. |
| group_code | varchar(24) | Machine-readable code for the group. |
| group_name | varchar(40) | Readable name of the group. |
| headquarter_jurisdiction_id | varchar(16) | Foreign key to dora_jurisdictions.jurisdiction_id for the headquarter jurisdiction linked to this row. |
| entity_type_code | varchar(8) | Machine-readable code for the entity type. |
| entity_type_name | varchar(64) | Readable name of the entity type. |
| sector_code | varchar(32) | Machine-readable code for the sector. |
+10 more columns in dora_financial_entities. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| legal_entity_id | varchar(24) | Stable primary key for one licensed legal entity. |
| financial_entity_id | varchar(24) | Foreign key to dora_financial_entities.financial_entity_id for the financial entity linked to this row. |
| jurisdiction_id | varchar(16) | Foreign key to dora_jurisdictions.jurisdiction_id for the jurisdiction linked to this row. |
| legal_entity_code | varchar(24) | Machine-readable code for the legal entity. |
| legal_entity_name | varchar(48) | Readable name of the legal entity. |
| synthetic_lei | varchar(32) | Checksum-valid synthetic Legal Entity Identifier reserved for test and analytical use. |
| identifier_type_code | varchar(8) | Machine-readable legal identifier type aligned with the applicable register rules. |
+16 more columns in dora_legal_entities. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| scope_id | varchar(48) | Stable primary key for one regulatory scope record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| instrument_id | varchar(32) | Foreign key to dora_regulatory_instruments.instrument_id for the instrument linked to this row. |
| scope_status | varchar(40) | Lifecycle or decision status of the scope. |
| scope_basis_code | varchar(24) | Machine-readable code for the scope basis. |
| scope_basis_name | varchar(64) | Readable name of the scope basis. |
| regulatory_phase_code | varchar(32) | Machine-readable phase distinguishing pre-DORA baseline, transition preparation and application. |
+8 more columns in dora_regulatory_scopes. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| service_id | varchar(32) | Stable primary key for one business service record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_code | varchar(24) | Machine-readable code for the service. |
| service_name | varchar(64) | Readable name of the service. |
| service_type_code | varchar(32) | Machine-readable code for the service type. |
| service_type_name | varchar(32) | Readable name of the service type. |
| criticality_code | varchar(16) | Machine-readable code for the criticality. |
+12 more columns in dora_business_services. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| facility_id | varchar(24) | Stable primary key for one facility. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| jurisdiction_id | varchar(16) | Foreign key to dora_jurisdictions.jurisdiction_id for the jurisdiction linked to this row. |
| facility_code | varchar(24) | Machine-readable code for the facility. |
| facility_name | varchar(56) | Readable name of the facility. |
| facility_type_code | varchar(8) | Machine-readable code for the facility type. |
| facility_type_name | varchar(32) | Readable name of the facility type. |
+10 more columns in dora_facilities. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| provider_id | varchar(24) | Stable primary key for one ict provider record. |
| parent_provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the parent provider linked to this row. |
| headquarter_jurisdiction_id | varchar(16) | Foreign key to dora_jurisdictions.jurisdiction_id for the headquarter jurisdiction linked to this row. |
| provider_code | varchar(24) | Machine-readable code for the provider. |
| provider_name | varchar(64) | Readable name of the provider. |
| provider_type_code | varchar(8) | Machine-readable code for the provider type. |
| provider_type_name | varchar(56) | Readable name of the provider type. |
+13 more columns in dora_ict_providers. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| product_id | varchar(32) | Stable primary key for one technology product record. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| product_code | varchar(32) | Machine-readable code for the product. |
| product_name | varchar(72) | Readable name of the product. |
| product_category_code | varchar(16) | Machine-readable code for the product category. |
| product_category_name | varchar(56) | Readable name of the product category. |
| deployment_model_code | varchar(16) | Machine-readable code for the deployment model. |
+9 more columns in dora_technology_products. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| asset_id | varchar(32) | Stable primary key for one ict asset record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| facility_id | varchar(24) | Foreign key to dora_facilities.facility_id for the facility linked to this row. |
| product_id | varchar(32) | Foreign key to dora_technology_products.product_id for the product linked to this row. |
| asset_code | varchar(32) | Machine-readable code for the asset. |
| asset_name | varchar(88) | Readable name of the asset. |
| asset_type_code | varchar(16) | Machine-readable code for the asset type. |
+14 more columns in dora_ict_assets. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| dependency_id | varchar(48) | Stable primary key for one directed service-to-technology dependency. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| upstream_asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the upstream asset linked to this row. |
| downstream_asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the downstream asset linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| dependency_type_code | varchar(16) | Machine-readable code for the dependency type. |
| dependency_type_name | varchar(40) | Readable name of the dependency type. |
+8 more columns in dora_technology_dependencies. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| person_id | varchar(32) | Stable primary key for one synthetic person. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| facility_id | varchar(24) | Foreign key to dora_facilities.facility_id for the facility linked to this row. |
| person_code | varchar(32) | Machine-readable code for the person. |
| full_name | varchar(32) | Generated full name of the employee, contractor or provider contact. |
| job_title | varchar(48) | Generated job title describing the person's organisational function. |
+10 more columns in dora_people. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| role_assignment_id | varchar(32) | Stable primary key for one person role record. |
| person_id | varchar(32) | Foreign key to dora_people.person_id for the person linked to this row. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| role_code | varchar(8) | Machine-readable code for the role. |
| role_name | varchar(48) | Readable name of the role. |
| responsibility_type_code | varchar(16) | Machine-readable code for the responsibility type. |
+5 more columns in dora_person_roles. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| media_asset_id | varchar(24) | Stable primary key for one asset media record. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| product_id | varchar(32) | Foreign key to dora_technology_products.product_id for the product linked to this row. |
| image_file | varchar(40) | Relative path of the governed hardware image asset. |
| image_format | varchar(16) | Raster image file format used by the governed media asset. |
| image_width_px | integer | Image canvas width in pixels. |
| image_height_px | integer | Image canvas height in pixels. |
+9 more columns in dora_asset_media. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| configuration_snapshot_id | varchar(40) | Stable primary key for one effective-dated asset configuration snapshot. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| snapshot_timestamp | varchar(32) | Timestamp at which the configuration snapshot was captured. |
| configuration_version | varchar(16) | Version identifier for the configuration. |
| operating_system_version | varchar(32) | Version identifier for the operating system. |
| firmware_version | varchar(16) | Version identifier for the firmware. |
| database_version | varchar(24) | Version identifier for the database. |
+10 more columns in dora_asset_config_history. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| arrangement_id | varchar(32) | Stable primary key for one contractual arrangement record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| instrument_id | varchar(32) | Foreign key to dora_regulatory_instruments.instrument_id for the instrument linked to this row. |
| arrangement_code | varchar(32) | Machine-readable code for the arrangement. |
| contract_title | varchar(88) | Readable title assigned to the contract. |
| arrangement_type_code | varchar(8) | Machine-readable code for the arrangement type. |
+16 more columns in dora_contractual_arrangements. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| contract_service_id | varchar(40) | Stable primary key for one contract service record. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| product_id | varchar(32) | Foreign key to dora_technology_products.product_id for the product linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| service_description | varchar(144) | Readable description of the service. |
| service_type_code | varchar(32) | Machine-readable code for the service type. |
+8 more columns in dora_contract_services. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| location_record_id | varchar(32) | Stable primary key for one contract data location record. |
| contract_service_id | varchar(40) | Foreign key to dora_contract_services.contract_service_id for the contract service linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| jurisdiction_id | varchar(16) | Foreign key to dora_jurisdictions.jurisdiction_id for the jurisdiction linked to this row. |
| location_type_code | varchar(16) | Machine-readable code for the location type. |
| location_type_name | varchar(40) | Readable name of the location type. |
| processing_activity_code | varchar(24) | Machine-readable code for the processing activity. |
+6 more columns in dora_contract_data_locations. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| subcontract_link_id | varchar(32) | Stable primary key for one subcontract link record. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
| contract_service_id | varchar(40) | Foreign key to dora_contract_services.contract_service_id for the contract service linked to this row. |
| prime_provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the prime provider linked to this row. |
| parent_provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the parent provider linked to this row. |
| subcontractor_provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the subcontractor provider linked to this row. |
| chain_level | integer | One-based depth of the subcontractor within the contractual delivery chain. |
+10 more columns in dora_subcontract_links. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| register_snapshot_id | varchar(32) | Stable primary key for one register snapshot record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| instrument_id | varchar(24) | Foreign key to dora_regulatory_instruments.instrument_id for the instrument linked to this row. |
| reporting_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the reporting date linked to this row. |
| snapshot_code | varchar(32) | Machine-readable code for the snapshot. |
| register_version | varchar(48) | Version identifier for the register. |
| consolidation_level_code | varchar(24) | Machine-readable code for the consolidation level. |
+6 more columns in dora_register_snapshots. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| register_entry_id | varchar(32) | Stable primary key for one template row within a register-of-information snapshot. |
| roi_template_code | varchar(16) | Register-of-information template code represented by the entry. |
| template_row_key | varchar(16) | Stable row key within the selected register-of-information template. |
| linked_entry_id | varchar(32) | Self-referencing entry key used for corrected register template cross-references. |
| register_snapshot_id | varchar(32) | Foreign key to dora_register_snapshots.register_snapshot_id for the register snapshot linked to this row. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
| contract_service_id | varchar(40) | Foreign key to dora_contract_services.contract_service_id for the contract service linked to this row. |
+13 more columns in dora_register_entries. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| exit_strategy_id | varchar(40) | Stable primary key for one effective-dated contract-service exit strategy. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
| contract_service_id | varchar(40) | Foreign key to dora_contract_services.contract_service_id for the contract service linked to this row. |
| alternate_provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the alternate provider linked to this row. |
| strategy_code | varchar(24) | Machine-readable code for the strategy. |
| strategy_version | numeric(4,1) | Version identifier for the strategy. |
| effective_from_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the effective from date linked to this row. |
+10 more columns in dora_exit_strategies. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| concentration_metric_id | varchar(32) | Stable primary key for one entity, month, provider and service-type concentration measure. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| month_start_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the month start date linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| service_type_code | varchar(32) | Machine-readable code for the service type. |
| service_type_name | varchar(32) | Readable name of the service type. |
| total_ict_spend_eur | numeric(12,2) | Modeled total ICT spend in euros for the legal entity and month. |
+8 more columns in dora_concentration_monthly. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| service_level_id | varchar(48) | Stable primary key for one service level record. |
| contract_service_id | varchar(40) | Foreign key to dora_contract_services.contract_service_id for the contract service linked to this row. |
| metric_code | varchar(24) | Machine-readable code for the metric. |
| metric_name | varchar(40) | Readable name of the metric. |
| unit_name | varchar(16) | Readable measurement unit for the recorded value. |
| target_value | numeric(6,1) | Contracted target for the service-level metric. |
| lower_threshold | numeric(5,1) | Lower decision threshold for the measured metric. |
+7 more columns in dora_service_levels. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| risk_assessment_id | varchar(40) | Stable primary key for one risk assessment record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
| assessment_code | varchar(40) | Machine-readable code for the assessment. |
+17 more columns in dora_risk_assessments. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| scenario_id | varchar(40) | Stable primary key for one risk scenario record. |
| risk_assessment_id | varchar(40) | Foreign key to dora_risk_assessments.risk_assessment_id for the risk assessment linked to this row. |
| scenario_code | varchar(40) | Machine-readable code for the scenario. |
| scenario_name | varchar(136) | Readable name of the scenario. |
| scenario_category_code | varchar(32) | Machine-readable code for the scenario category. |
| scenario_category_name | varchar(48) | Readable name of the scenario category. |
| threat_actor_code | varchar(40) | Machine-readable code for the threat actor. |
+12 more columns in dora_risk_scenarios. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| control_id | varchar(40) | Stable primary key for one control catalogue record. |
| instrument_id | varchar(32) | Foreign key to dora_regulatory_instruments.instrument_id for the instrument linked to this row. |
| control_code | varchar(40) | Machine-readable code for the control. |
| control_name | varchar(88) | Readable name of the control. |
| control_domain_code | varchar(8) | Machine-readable code for the control domain. |
| control_domain_name | varchar(48) | Readable name of the control domain. |
| control_objective | varchar(104) | Control objective recorded for this control catalogue record. |
+10 more columns in dora_control_catalogue. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| assignment_id | varchar(40) | Stable primary key for one control assignment record. |
| control_id | varchar(40) | Foreign key to dora_control_catalogue.control_id for the control linked to this row. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
+7 more columns in dora_control_assignments. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| control_test_id | varchar(40) | Stable primary key for one control test record. |
| assignment_id | varchar(40) | Foreign key to dora_control_assignments.assignment_id for the assignment linked to this row. |
| tester_person_id | varchar(32) | Foreign key to dora_people.person_id for the tester person linked to this row. |
| test_code | varchar(40) | Machine-readable code for the test. |
| test_type_code | varchar(32) | Machine-readable code for the test type. |
| test_type_name | varchar(48) | Readable name of the test type. |
| test_start_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the test start date linked to this row. |
+11 more columns in dora_control_tests. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| entitlement_id | varchar(40) | Stable primary key for one access entitlement record. |
| person_id | varchar(32) | Foreign key to dora_people.person_id for the person linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| role_assignment_id | varchar(32) | Foreign key to dora_person_roles.role_assignment_id for the role assignment linked to this row. |
| entitlement_code | varchar(32) | Machine-readable code for the entitlement. |
| account_reference | varchar(24) | Stable business reference for the account. |
+10 more columns in dora_access_entitlements. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| review_id | varchar(56) | Stable primary key for one access review record. |
| entitlement_id | varchar(40) | Foreign key to dora_access_entitlements.entitlement_id for the entitlement linked to this row. |
| reviewer_person_id | varchar(32) | Foreign key to dora_people.person_id for the reviewer person linked to this row. |
| campaign_code | varchar(24) | Machine-readable code for the campaign. |
| review_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the review date linked to this row. |
| review_decision_code | varchar(24) | Machine-readable code for the review decision. |
| review_decision_name | varchar(40) | Readable name of the review decision. |
+5 more columns in dora_access_reviews. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| training_record_id | varchar(40) | Stable primary key for one workforce training record. |
| person_id | varchar(32) | Foreign key to dora_people.person_id for the person linked to this row. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| course_code | varchar(32) | Machine-readable code for the course. |
| course_name | varchar(64) | Readable name of the course. |
| training_domain_code | varchar(32) | Machine-readable code for the training domain. |
| assignment_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the assignment date linked to this row. |
+8 more columns in dora_workforce_training. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| incident_id | varchar(40) | Stable primary key for one incident record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| primary_asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the primary asset linked to this row. |
| primary_provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the primary provider linked to this row. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
| root_incident_id | varchar(40) | Foreign key to dora_incidents.incident_id for the root incident linked to this row. |
+18 more columns in dora_incidents. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| impact_id | varchar(32) | Stable primary key for one incident impact record. |
| incident_id | varchar(40) | Foreign key to dora_incidents.incident_id for the incident linked to this row. |
| jurisdiction_id | varchar(16) | Foreign key to dora_jurisdictions.jurisdiction_id for the jurisdiction linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| impact_type_code | varchar(32) | Machine-readable code for the impact type. |
| impact_type_name | varchar(40) | Readable name of the impact type. |
| impact_start_timestamp | varchar(32) | Timestamp at which the measured incident impact began. |
+13 more columns in dora_incident_impacts. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| report_id | varchar(32) | Stable primary key for one incident report record. |
| incident_id | varchar(40) | Foreign key to dora_incidents.incident_id for the incident linked to this row. |
| instrument_id | varchar(32) | Foreign key to dora_regulatory_instruments.instrument_id for the instrument linked to this row. |
| reporting_authority_code | varchar(16) | Machine-readable code for the reporting authority. |
| report_stage_code | varchar(16) | Machine-readable code for the report stage. |
| report_stage_name | varchar(32) | Readable name of the report stage. |
| report_version | integer | Version identifier for the report. |
+10 more columns in dora_incident_reports. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| recurrence_link_id | varchar(32) | Stable primary key for one recurring incident link record. |
| predecessor_incident_id | varchar(40) | Foreign key to dora_incidents.incident_id for the predecessor incident linked to this row. |
| recurring_incident_id | varchar(40) | Foreign key to dora_incidents.incident_id for the recurring incident linked to this row. |
| recurrence_basis_code | varchar(32) | Machine-readable code for the recurrence basis. |
| recurrence_basis_name | varchar(88) | Readable name of the recurrence basis. |
| linked_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the linked date linked to this row. |
| similarity_score_pct | numeric(6,2) | Similarity score expressed as a percentage. |
+4 more columns in dora_recurring_incident_links. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| timeline_event_id | varchar(40) | Stable primary key for one timestamped incident timeline event. |
| incident_id | varchar(40) | Foreign key to dora_incidents.incident_id for the incident linked to this row. |
| event_timestamp | varchar(32) | Timestamp at which the timeline event occurred. |
| event_sequence | integer | One-based chronological order of the event within the incident timeline. |
| event_type_code | varchar(16) | Machine-readable code for the event type. |
| event_type_name | varchar(48) | Readable name of the event type. |
| actor_person_id | varchar(32) | Foreign key to dora_people.person_id for the actor person linked to this row. |
+8 more columns in dora_incident_timeline. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| vulnerability_id | varchar(40) | Stable primary key for one modelled vulnerability disclosure. |
| source_id | varchar(32) | Foreign key to dora_methodology_sources.source_id for the source linked to this row. |
| vulnerability_code | varchar(24) | Machine-readable code for the vulnerability. |
| vulnerability_title | varchar(120) | Readable title assigned to the vulnerability. |
| vulnerability_description | varchar(224) | Readable description of the vulnerability. |
| weakness_code | varchar(16) | Machine-readable code for the weakness. |
| weakness_name | varchar(56) | Readable name of the weakness. |
+9 more columns in dora_vulnerabilities. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| asset_vulnerability_id | varchar(32) | Stable primary key for one asset-to-vulnerability exposure finding. |
| vulnerability_id | varchar(40) | Foreign key to dora_vulnerabilities.vulnerability_id for the vulnerability linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| product_id | varchar(32) | Foreign key to dora_technology_products.product_id for the product linked to this row. |
| detection_timestamp | varchar(32) | Timestamp recording when the detection event occurred. |
| detection_method_code | varchar(24) | Machine-readable code for the detection method. |
| detection_method_name | varchar(48) | Readable name of the detection method. |
+8 more columns in dora_asset_vulnerabilities. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| patch_id | varchar(32) | Stable primary key for one provider patch or mitigation. |
| product_id | varchar(32) | Foreign key to dora_technology_products.product_id for the product linked to this row. |
| vulnerability_id | varchar(40) | Foreign key to dora_vulnerabilities.vulnerability_id for the vulnerability linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| patch_code | varchar(32) | Machine-readable code for the patch. |
| patch_name | varchar(112) | Readable name of the patch. |
| release_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the release date linked to this row. |
+8 more columns in dora_patches. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| deployment_id | varchar(32) | Stable primary key for one patch deployment record. |
| patch_id | varchar(32) | Foreign key to dora_patches.patch_id for the patch linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| change_request_id | varchar(40) | Foreign key to dora_change_requests.change_request_id for the change request linked to this row. |
| deployment_code | varchar(24) | Machine-readable code for the deployment. |
| planned_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the planned date linked to this row. |
| actual_start_timestamp | varchar(32) | Actual start timestamp for the activity. |
+9 more columns in dora_patch_deployments. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| change_request_id | varchar(40) | Stable primary key for one change request record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| requester_person_id | varchar(32) | Foreign key to dora_people.person_id for the requester person linked to this row. |
| approver_person_id | varchar(32) | Foreign key to dora_people.person_id for the approver person linked to this row. |
| change_code | varchar(24) | Machine-readable code for the change. |
+13 more columns in dora_change_requests. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| release_id | varchar(32) | Stable primary key for one release record. |
| change_request_id | varchar(40) | Foreign key to dora_change_requests.change_request_id for the change request linked to this row. |
| product_id | varchar(32) | Foreign key to dora_technology_products.product_id for the product linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| release_code | varchar(32) | Machine-readable code for the release. |
| release_name | varchar(96) | Readable name of the release. |
| release_version | varchar(16) | Version identifier for the release. |
+11 more columns in dora_releases. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| continuity_plan_id | varchar(48) | Stable primary key for one continuity plan record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| owner_person_id | varchar(32) | Foreign key to dora_people.person_id for the owner person linked to this row. |
| plan_code | varchar(40) | Machine-readable code for the plan. |
| plan_name | varchar(104) | Readable name of the plan. |
| plan_type_code | varchar(24) | Machine-readable code for the plan type. |
+12 more columns in dora_continuity_plans. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| continuity_test_id | varchar(40) | Stable primary key for one continuity test record. |
| continuity_plan_id | varchar(48) | Foreign key to dora_continuity_plans.continuity_plan_id for the continuity plan linked to this row. |
| test_code | varchar(32) | Machine-readable code for the test. |
| test_type_code | varchar(16) | Machine-readable code for the test type. |
| test_type_name | varchar(48) | Readable name of the test type. |
| scenario_id | varchar(40) | Foreign key to dora_risk_scenarios.scenario_id for the scenario linked to this row. |
| test_start_timestamp | varchar(32) | Timestamp at which the continuity exercise began. |
+12 more columns in dora_continuity_tests. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| recovery_result_id | varchar(32) | Stable primary key for one recovery result record. |
| continuity_test_id | varchar(40) | Foreign key to dora_continuity_tests.continuity_test_id for the continuity test linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| facility_id | varchar(24) | Foreign key to dora_facilities.facility_id for the facility linked to this row. |
| recovery_step_code | varchar(24) | Machine-readable code for the recovery step. |
| recovery_step_name | varchar(40) | Readable name of the recovery step. |
+9 more columns in dora_recovery_results. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| tlpt_engagement_id | varchar(32) | Stable primary key for one tlpt engagement record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| instrument_id | varchar(24) | Foreign key to dora_regulatory_instruments.instrument_id for the instrument linked to this row. |
| lead_authority_code | varchar(16) | Machine-readable code for the lead authority. |
| engagement_code | varchar(24) | Machine-readable code for the engagement. |
| engagement_name | varchar(88) | Readable name of the engagement. |
| scope_start_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the scope start date linked to this row. |
+10 more columns in dora_tlpt_engagements. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| tlpt_phase_id | varchar(32) | Stable primary key for one tlpt phase record. |
| tlpt_engagement_id | varchar(32) | Foreign key to dora_tlpt_engagements.tlpt_engagement_id for the tlpt engagement linked to this row. |
| phase_code | varchar(32) | Machine-readable code for the phase. |
| phase_name | varchar(56) | Readable name of the phase. |
| phase_sequence | integer | Execution sequence assigned to the phase. |
| planned_start_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the planned start date linked to this row. |
| planned_end_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the planned end date linked to this row. |
+7 more columns in dora_tlpt_phases. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| tlpt_finding_id | varchar(32) | Stable primary key for one tlpt finding record. |
| tlpt_engagement_id | varchar(32) | Foreign key to dora_tlpt_engagements.tlpt_engagement_id for the tlpt engagement linked to this row. |
| tlpt_phase_id | varchar(32) | Foreign key to dora_tlpt_phases.tlpt_phase_id for the tlpt phase linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| finding_code | varchar(24) | Machine-readable code for the finding. |
| finding_title | varchar(96) | Readable title assigned to the finding. |
+10 more columns in dora_tlpt_findings. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| audit_id | varchar(40) | Stable primary key for one audit record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| arrangement_id | varchar(32) | Foreign key to dora_contractual_arrangements.arrangement_id for the arrangement linked to this row. |
| instrument_id | varchar(32) | Foreign key to dora_regulatory_instruments.instrument_id for the instrument linked to this row. |
| lead_auditor_person_id | varchar(32) | Foreign key to dora_people.person_id for the lead auditor person linked to this row. |
| audit_code | varchar(40) | Machine-readable code for the audit. |
+9 more columns in dora_audits. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| audit_finding_id | varchar(32) | Stable primary key for one audit finding record. |
| audit_id | varchar(40) | Foreign key to dora_audits.audit_id for the audit linked to this row. |
| control_id | varchar(40) | Foreign key to dora_control_catalogue.control_id for the control linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| asset_id | varchar(32) | Foreign key to dora_ict_assets.asset_id for the asset linked to this row. |
| finding_code | varchar(24) | Machine-readable code for the finding. |
| finding_title | varchar(120) | Readable title assigned to the finding. |
+9 more columns in dora_audit_findings. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| remediation_action_id | varchar(32) | Stable primary key for one remediation action record. |
| source_type_code | varchar(32) | Machine-readable code for the source type. |
| source_type_name | varchar(48) | Readable name of the source type. |
| incident_id | varchar(8) | Foreign key to dora_incidents.incident_id for the incident linked to this row. |
| tlpt_finding_id | varchar(32) | Foreign key to dora_tlpt_findings.tlpt_finding_id for the tlpt finding linked to this row. |
| audit_finding_id | varchar(32) | Foreign key to dora_audit_findings.audit_finding_id for the audit finding linked to this row. |
| asset_vulnerability_id | varchar(32) | Foreign key to dora_asset_vulnerabilities.asset_vulnerability_id for the asset vulnerability linked to this row. |
+14 more columns in dora_remediation_actions. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| metric_record_id | varchar(40) | Stable primary key for one entity, service, provider and reporting-period metric record. |
| legal_entity_id | varchar(24) | Foreign key to dora_legal_entities.legal_entity_id for the legal entity linked to this row. |
| service_id | varchar(32) | Foreign key to dora_business_services.service_id for the service linked to this row. |
| provider_id | varchar(24) | Foreign key to dora_ict_providers.provider_id for the provider linked to this row. |
| period_start_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the period start date linked to this row. |
| period_end_date_id | varchar(24) | Foreign key to dora_calendar_days.date_id for the period end date linked to this row. |
| period_granularity_code | varchar(16) | Machine-readable code for the period granularity. |
+21 more columns in dora_finop_periodic. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| incident_code | incident_title | incident_type_name | detected_timestamp | started_timestamp | recovered_timestamp | severity_code | classification_status | major_incident_flag | root_cause_name | source_status |
|---|---|---|---|---|---|---|---|---|---|---|
| ICT-25-CRD-8JY8YC4EJ | Falbridge Customer identity and access internal system failure | Internal system failure | 2025-12-30T02:04:00Z | 2025-12-30T02:00:00Z | 2025-12-30T05:10:00Z | MEDIUM | NON_MAJOR_DORA | false | Recurring configuration and resilience gap | HISTORICAL |
| ICT-26-CRD-M80R1HYB7 | Farnmere Electronic order execution external ict service outage | External ICT service outage | 2026-05-06T09:16:00Z | 2026-05-06T09:11:00Z | 2026-05-06T12:22:00Z | MEDIUM | NON_MAJOR_DORA | false | Recurring configuration and resilience gap | HISTORICAL |
| ICT-25-CRD-ZJQSANPPC | Eldermark Securities custody administration malicious cyber intrusion | Malicious cyber intrusion | 2025-05-21T16:28:00Z | 2025-05-21T16:22:00Z | 2025-05-21T19:34:00Z | MEDIUM | NON_MAJOR_DORA | false | Recurring configuration and resilience gap | HISTORICAL |
Version History
| v1.0.0 | 2026-09-01 | Initial enterprise release covering digital operational resilience governance, ICT third-party dependencies, the register of information, risk and control operations, incidents, vulnerability and change, continuity, TLPT, audit, remediation, financial outcomes and governed hardware media. |
Related Datasets
Anti Money Laundering Transaction Monitoring Set (GB)
FinanceFINAML997 is a deterministic synthetic UK corporate banking warehouse: five thousand customer entities, eight thousand accounts, twenty-two thousand counterparties and six hundred thousand payments over twelve months, carrying confirmed laundering patterns and the incumbent monitoring estate that competes with them.
Consumer Credit Risk and Lending Decisioning Set (GB)
FinanceFINCRD995 is a deterministic synthetic UK consumer lender: 46,000 applicants, 65,000 applications and 15,000 agreements across the real Bank Rate cycle, and the counterfactual outcome for every applicant it turned down.
Insurance Underwriting and Claims Analytics Set (GB)
FinanceFININS998 is a deterministic synthetic UK general insurance warehouse: twenty-eight thousand policyholders, ninety-three thousand policy years across fourteen product lines, seventeen thousand claims and a counter-fraud estate, with ground-truth fraud labels that carry the honest value alongside the claimed one.