Data Model for DORA RoI

0010 - LEI of the entity char(20)
0020 - Name of the entity varchar(255) 0030 - Country of the entity char(2) 0040 - Type of entity varchar(255) 0050 - Hierarchy of the entity within the group (where applicable) varchar(255) 0060 - LEI of the direct parent undertaking of the financial entity char(20) 0070 - Date of last update date 0080 - Date of integration in the Register of information date 0090 - Date of deletion in the Register of information date 0110 - Value of total assets - of the financial entity money 0100 - Currency char(3) B.01.02 — List of financial entities within the scope of the register of information 0010 - Contractual arrangement reference number varchar(255) 0020 - Type of contractual arrangement varchar(255) 0030 - Overarching contractual arrangement reference number varchar(255) 0050 - Annual expense or estimated cost of the contractual arrangement for the past year money 0040 - Currency of the amount reported char(3) B.02.01 — Contractual Arrangements – General Information 0010 - Identification code of the third-party service provider varchar(255) 0020 - Type of code of the third-party service provider varchar(255) 0030 - Additional identification code of the third-party service provider int 0040 - Type of additional identification code of the third-party service provider varchar(255) 0050 - Legal name of the third-party service provider varchar(255) 0060 - Name of the ICT third-party service provider in Latin alphabet varchar(255) 0070 - Type of person of the third-party service provider varchar(50) 0080 - Country of the third-party service provider’s headquarters char(2) 0100 - Total annual expense or estimated cost of the third-party service provider money 0090 - Currency of the amount reported char(3) 0110 - Identification code of the third-party service provider’s ultimate parent undertaking varchar(255) 0120 - Type of code of the third-party service provider’s ultimate parent undertaking varchar(255) B.05.01 — ICT third-party service provider 0010 - Contractual arrangement reference number varchar(255) 0020 - Type of ICT services varchar(50) 0030 - Identification code of the third-party service provider varchar(255) 0040 - Type of code of the third-party service provider varchar(255) 0050 - Rank int 0060 - Identification code of the recipient of sub-contracted ICT services varchar(255) 0070 - Type of code of the recipient of sub-contracted ICT services varchar(255) B.05.02 — ICT service supply chains 0040 - LEI of the financial entity char(20) 0010 - Function identifier varchar(5) 0020 - Licenced activity varchar(255) 0030 - Function name varchar(255) 0050 - Criticality or importance assessment varchar(255) 0060 - Reasons for criticality or importance varchar(255) 0070 - Date of the last assessment of criticality or importance date 0080 - Recovery time objective of the function int 0090 - Recovery point objective of the function int 0100 - Impact of discontinuing the function varchar(20) B.06.01 — Functions identification 0010 - Contractual
arrangement reference number 0020 - Identification code of the third-party service provider 0030 - Type of code of the third-party service provider 0040 - Type of ICT services 0050 - Substitutability of the ICT third-party service provider 0060 - Reason if the ICT third-party service provider is considered not substitutabl... 0070 - Date of the last audit on the ICT third-party service provider 0080 - Existence of an exit plan 0090 - Possibility of reintegration of the contracted ICT service 0100 - Impact of discontinuing the ICT services 0110 - Are there alternative ICT third-party service providers identified? 0120 - Identification of alternative ICT TPP B.07.01 — Assessment of the ICT services 0010 - Contractual arrangement with ICT intra-group service provider varchar(255) 0020 - Linked contractual arrangement with ICT third-party service provider varchar(255) B.02.03 — List of intra-group contractual arrangements 0010 - Contractual arrangement reference number varchar(255) 0020 - LEI of the entity signing the contractual arrangement char(20) B.03.01 — Entities signing the Contractual Arrangements for receiving ICT service(s) or on behalf of the entities making use of the ICT service(s) 0010 - Contractual arrangement reference number varchar(255) 0020 - LEI of the financial entity char(20) 0030 - Is the entity making use of the ICT services a branch of a financial entity? binary 0040 - Identication code of the branch varchar(255) B.04.01 — Financial entities making use of the ICT services Type of ICT services identifier varchar(50) Type of ICT services name varchar(50) Type of ICT services description varchar(255) Type of ICT Services 0010 - Contractual arrangement reference number varchar(255) 0020 - Identification code of the third-party service provider varchar(255) 0030 - Type of code of the third-party service provider varchar(255) B.03.02 — Third-party service providers signing the Contractual Arrangements for providing ICT service(s) 0010 - Contractual arrangement reference number varchar(255) 0020 - LEI of the intra-group entity providing ICT service char(20) B.03.03 — Entities signing the Contractual Arrangements for providing ICT service(s) 0010 - Contractual arrangement reference number varchar(255) 0030 - Identification code of the third-party service provider varchar(255) 0040 - Type of code to identify the third-party service provider varchar(255) 0020 - LEI of the financial entity making use of the ICT service char(20) 0050 - Function identifier varchar(5) 0060 - Type of ICT services varchar(50) 0070 - Start date of the contractual arrangement date 0080 - End date of the contractual arrangement date 0090 - Reason of the termination or ending of the contractual arrangement varchar(255) 0100 - Notice period for the financial entity int 0110 - Notice period for the ICT third-party service provider int 0120 - Country of the governing law of the contractual arrangement char(2) 0130 - Country of provision of the ICT services char(2)
0140 - Storage of data bit 0150 - Location of the data at rest (storage) char(2) 0160 - Location of management of the data (processing) char(2) 0170 - Sensitiveness of the data stored by the ICT third-party service provider varchar(20) 0180 - Level of reliance on the ICT service supporting the critical or important function. varchar(20) B.02.02 — Contractual Arrangements – Specific information 0010 - LEI of the entity maintaining the register of information char(20) 0020 - Name of the entity varchar(255) 0030 - Country of the entity char(2) 0040 - Type of entity varchar(255) 0050 - Competent Authority nvarchar(255) 0060 - Date of the reporting date B.01.01 — Financial entity maintaining the register of information 0020 - LEI of the financial entity head office of the branch char(20) 0010 - Identication code of the branch varchar(255) 0030 - Name of the branch varchar(255) 0040 - Country of the branch char(2) B.01.03 — List of branches

EBA Regular Use#
Table Column Type Length PrimaryK
ey
ForeignKe y
Nullable
0010 - LEI of the entity maintaining the register of information char 20 Yes No No 0020 - Name of the entity varchar 255 No 0030 - Country of the entity char 2 No 0040 - Type of entity varchar 255 No 0050 - Competent Authority varchar 255 No 0060 - Date of the reporting date 0 No 0010 - LEI of the entity char 20 Yes No No 0020 - Name of the entity varchar 255 No 0030 - Country of the entity char 2 No 0040 - Type of entity varchar 255 No 0050 - Hierarchy of the entity within the group (where applicable) varchar 255 No 0060 - LEI of the direct parent undertaking of the financial entity char 20 No Yes Yes 0070 - Date of last update date 0 No 0080 - Date of integration in the Register of information date 0 No 0090 - Date of deletion in the Register of information date 0 No 0100 - Currency char 3 No No Yes 0110 - Value of total assets - of the financial entity money 0 No No Yes 0010 - Identication code of the branch varchar 255 Yes No No 0020 - LEI of the financial entity head office of the branch char 20 Yes Yes No 0030 - Name of the branch varchar 255 No 0040 - Country of the branch char 2 No 0010 - Contractual arrangement reference number varchar 255 Yes No No 0020 - Type of contractual arrangement varchar 255 No 0030 - Overarching contractual arrangement reference number varchar 255 No Yes Yes 0040 - Currency of the amount reported char 3 No 0050 - Annual expense or estimated cost of the contractual arrangement for the past year money 0 No 0010 - Contractual arrangement reference number varchar 255 Yes Yes No 0020 - LEI of the financial entity making use of the ICT service char 20 Yes Yes No 0030 - Identification code of the third-party service provider varchar 255 Yes Yes No 0040 - Type of code to identify the third￾party service provider varchar 255 No No Yes 0050 - Function identifier varchar 255 Yes Yes No 0060 - Type of ICT services varchar 255 Yes No No 0070 - Start date of the contractual arrangement date 0 No 0080 - End date of the contractual arrangement date 0 No 0090 - Reason of the termination or ending of the contractual arrangement varchar 255 No No Yes 0100 - Notice period for the financial entity int 0 No No Yes 0110 - Notice period for the ICT third-party service provider int 0 No No Yes 0120 - Country of the governing law of the contractual arrangement char 2 No No Yes 0130 - Country of provision of the ICT services char 2 Yes No No 0140 - Storage of data bit 0 No 0150 - Location of the data at rest (storage) char 2 Yes No No B.01.01 — Financial entity maintaining the register of information B.01.02 — List of financial entities within the scope of the register of information B.01.03 — List of branches B.02.01 — Contractual Arrangements – General Information B.02.02 — Contractual Arrangements – Specific Information

EBA Regular Use#
0160 - Location of management of the data (processing) char 2 Yes No No 0170 - Sensitiveness of the data stored by the ICT third-party service provider varchar 255 No No Yes 0180 - Level of reliance on the ICT service supporting the critical or important function. varchar 255 No No Yes 0010 - Contractual arrangement with ICT intra-group service provider varchar 255 Yes Yes No 0020 - Linked contractual arrangement with ICT third-party service provider varchar 255 Yes Yes No 0010 - Contractual arrangement reference number varchar 255 Yes Yes No 0020 - LEI of the entity signing the contractual arrangement char 20 Yes Yes No 0010 - Contractual arrangement reference number varchar 255 Yes Yes No 0020 - Identification code of the third-party service provider varchar 255 Yes Yes No 0030 - Type of code of the third-party service provider varchar 255 No No Yes 0010 - Contractual arrangement reference number varchar 255 Yes Yes No 0020 - LEI of the intra-group entity providing ICT service char 20 Yes Yes No 0010 - Contractual arrangement reference number varchar 255 Yes Yes No 0020 - LEI of the financial entity char 20 Yes Yes No 0030 - Is the entity making use of the ICT services a branch of a financial entity? binary 0 No 0040 - Identification code of the branch varchar 255 Yes No No 0010 - Identification code of the third-party service provider varchar 255 Yes No No 0020 - Type of code of the third-party service provider varchar 255 No 0030 - Additional identification code of the third-party service provider int 0 No No Yes 0040 - Type of additional identification code of the third-party service provider varchar 255 No No Yes 0050 - Legal name of the third-party service provider varchar 255 No 0060 - Name of the ICT third-party service provider in Latin alphabet varchar 255 No No Yes 0070 - Type of person of the third-party service provider varchar 255 No 0080 - Country of the third-party service provider’s headquarters char 2 No 0090 - Currency of the amount reported char 3 No No Yes 0100 - Total annual expense or estimated cost of the third-party service provider money 0 No No Yes 0110 - Identification code of the third-party service provider’s ultimate parent undertaking varchar 255 No Yes No 0120 - Type of code of the third-party service provider’s ultimate parent undertaking varchar 255 No No Yes 0010 - Contractual arrangement reference number varchar 255 Yes Yes No 0020 - Type of ICT services varchar 255 Yes No No 0030 - Identification code of the third-party service provider varchar 255 Yes Yes No 0040 - Type of code of the third-party service provider varchar 255 No No Yes 0050 - Rank int 0 Yes No No 0060 - Identification code of the recipient of sub-contracted ICT services varchar 255 Yes Yes No 0070 - Type of code of the recipient of sub￾contracted ICT services varchar 255 No No Yes B.03.01 — Entities signing the Contractual Arrangements for receiving ICT service(s) or on behalf of the entities making use of the ICT service(s) B.03.02 —
Third-party service providers signing the Contractual Arrangements for providing ICT service(s) B.03.03 — Entities signing the Contractual Arrangements for providing ICT service(s) B.04.01 — Financial entities making use of the ICT services B.05.01 — ICT third-party service provider B.05.02 — ICT service supply chains B.02.03 — List of intra-group contractual arrangements

EBA Regular Use#
0010 - Function identifier varchar 255 Yes No No 0020 - Licenced activity varchar 255 No 0030 - Function name varchar 255 No 0040 - LEI of the financial entity char 20 Yes Yes No 0050 - Criticality or importance assessment varchar 255 No 0060 - Reasons for criticality or importance varchar 255 No 0070 - Date of the last assessment of criticality or importance date 0 No 0080 - Recovery time objective of the function int 0 No 0090 - Recovery point objective of the function int 0 No 0100 - Impact of discontinuing the function varchar 255 No 0010 - Contractual arrangement reference number varchar 255 Yes Yes No 0020 - Identification code of the third-party service provider varchar 255 Yes Yes No 0030 - Type of code of the third-party service provider varchar 255 No No Yes 0040 - Type of ICT services varchar 255 Yes No No 0050 - Substitutability of the ICT third-party service provider varchar 255 No 0060 - Reason if the ICT third-party service provider is considered not substitutable or difficult to be substitutable varchar 255 No No Yes 0070 - Date of the last audit on the ICT third￾party service provider date 0 No 0080 - Existence of an exit plan bit 0 No 0090 - Possibility of reintegration of the contracted ICT service varchar 255 No 0100 - Impact of discontinuing the ICT services varchar 255 No 0110 - Are there alternative ICT third-party service providers identified? bit 0 No 0120 - Identification of alternative ICT TPP varchar 255 No No Yes B.06.01 — Functions identification B.07.01 — Assessment of the ICT services