Eesti Pank / Bank of Estonia

Frontpage » Statistical indicators » Financial sector statistics
Tühik

Technical requirements for submission of reports

Technical requirements for submission of reports are established by Eesti Pank Governor's Decree No.9 9.12.2011 "Requirements for submission of reports formatted as XML documents".

An example about the formatting of report messages

Description of the report message

Report message as a whole determined by the schema http://www.fi.ee/schemas/x_headers.xsd comprises of header and report parts and looks as follows:

<message>

<message_header>
...
</message_header>
<report>
...
</report>

</message>


Message Header

Element

XML-element

Mandatory

Type

Message header

message_header

Yes

 

Reporting entity's code

from

Yes

Integer

Message creation date

date

Yes

YYYY-MM-DDThh:mm:ss

Sender's name

sender

Yes

Tekst 8..30

Sender's e-mail

send_mail

Yes

e-mail address

Sender's telephone

send_phone

No

Text 5..20

Comment

comment

No

Text

Request a delivery receipt for a message

require_receipt

No

yes/no


Example:

<message_header>

<from>765</from>
<date>2010-10-10T11:20:23</date>
<sender>Jaan Kask</sender>
<send_mail>jaan.kask@maapank.ee</send_mail>
<send_phone>6666666</send_phone>
<require_receipt>yes</require_receipt>

</message_header>


Report

<report>

<report_header>
...
</report_header>
<row>
...
</row>
...               
<row>
...               
</row>

</report>


Report header

Element

XML-element

Mandatory

Type

Report header

report_header

Yes

 

Report code

typeid

Yes

Integer

Report date

timeid

Yes

YYYY-MM-DD

Report compiler's name

compiler

Yes

Text 8..30

Report compiler's e-mail

comp_mail

Yes

e-mail address

Report compiler's telephone

comp_phone

Yes

Text 5..20


Example:

<report_header>

<typeid>162</typeid>
<timeid>2010-09-30</timeid>
<compiler>Jelizaveta Ivanova</compiler>
<comp_mail>liza@maapank.ee</comp_mail>
<comp_phone>7777777</comp_phone>

</report_header>

Report row

Element

XML element

Mandatory

Type

Report row

row

Yes

 

Row 1 element

According to the report

Yes

According to the report

Row 2 element

According to the report

Yes

According to the report

...

...

...

 

Example:

<row>

<pangakaart_liik_1>11</pangakaart_liik_1>
<pangakaart_liik_2>9</pangakaart_liik_2>
<kasutussagedus>1</kasutussagedus>
<pangakaartide_arv>39739</pangakaartide_arv>

</row>

An example of an entire report message

<?xml version="1.0" encoding="ISO-8859-1"?>
<message xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="x_aruanne162.xsd">

<message_header>

<from>765</from>
<date>2010-10-10T11:20:23</date>
<sender>Jaan Kask</sender>
<send_mail>jaan.kask@maapank.ee</send_mail>
<send_phone>6666666</send_phone>
<require_receipt>yes</require_receipt>

</message_header>

<report>

<report_header>

<typeid>162</typeid>
<timeid>2010-09-30</timeid>
<compiler>Jelizaveta Ivanova</compiler>
<comp_mail>liza@maapank.ee</comp_mail>
<comp_phone>7777777</comp_phone>

</report_header>

<row>

<pangakaart_liik_1>2</pangakaart_liik_1>
<pangakaart_liik_2>1</pangakaart_liik_2>
<kasutussagedus>2</kasutussagedus>
<pangakaartide_arv>1520</pangakaartide_arv>

</row>
<row>

<pangakaart_liik_1>1</pangakaart_liik_1>
<pangakaart_liik_2>1</pangakaart_liik_2>
<kasutussagedus>2</kasutussagedus>
<pangakaartide_arv>1231</pangakaartide_arv>

</row>
<row>

<pangakaart_liik_1>1</pangakaart_liik_1>
<pangakaart_liik_2>9</pangakaart_liik_2>
<kasutussagedus>2</kasutussagedus>
<pangakaartide_arv>567</pangakaartide_arv>

</row>

</report>

</message>


NB! Some important notices about report messages!

1. E-mail addresses indicated in messages should be active!

2. 2. The prohibited symbols   "<>&'.  should not appear in values of elements. For example, row -  <reitinguagentuur>S & P </reitinguagentuur> - is incorrect.

Respective symbols can be reported substituting them as follows:
" as &quot;
< as &lt;
> as &gt;
& as &amp;
' as &apos;

3. A first row of the XML-document which among other things indicates the coding of the symbols should be (in place of double quotes single quotes can be used):

<?xml version="1.0" encoding="ISO-8859-1"?>  või
<?xml version="1.0" encoding="UTF-8"?>  või
<?xml version="1.0" ?>

4. An element 'message' should be presented as :

<message xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="x_aruanneZZZZ.xsd">, kus ZZZZ tähistab aruande koodi.