CITnet Jira | |||||||
Displaying 60 issues at 1/Feb/21 20:56. |
Issue Type | Key | Component/s | Summary | Description | Priority | Status | Resolution |
---|---|---|---|---|---|---|---|
Improvement | SDMXNA-682 | SECTOR | Change in label for Sectors S123A and S123B |
I reviewed the final package for the 2020 annual release SDMX-MES National Accounts DSDs and I have only one question on the labels of two sectors in CL_SECTOR.
Indeed, in the final package, the labels of sectors S123A and S1123B are the following: S123A: Stable Net Asset Value (NAV) MMFs S123B: Floating NAV MMFs In the written consultation we launched last year on the non-bank financial intermediation guidelines, a majority of G20 countries indicated that it would be better to replace “Stable” by “Constant” for S123A, and “Floating” by “Variable” for S123B. In this respect, would it be possible to modify the labels of sectors S123A and S123B as follows? S123A: Constant Net Asset Value (NAV) MMFs S123B: Variable NAV MMFs As only the OECD is currently using these two sectors in data collections, I do not think there is any issue to make this correction. |
Minor | Resolved | Fixed |
New Feature | SDMXNA-673 | NA-CodeLists | ECB fast track request for additional codes in STO |
ECB requests a fast-track release of the NA DSD. We need to include few new code values in the STO codelist.
The new codes to request in the NA DSD update for STO are: RDEP – Depreciation rate (PIM) RRET – Retirement rate (PIM) RREV – Revaluation rate (PIM) RTOT – Total rate (PIM) [RTOT = RDEP + RRET + RREV] Many thanks. |
Minor | Resolved | Fixed |
Improvement | SDMXNA-671 | New code for Area Code List |
Dear Colleagues,
Due to OECD enlargement we would need to add new code in Area Code List: P6 - OECD countries (fixed composition-37 members) AT + AU + BE + CA + CH + CL + CO + CZ + DE + DK + EE + ES + FI + FR + GB + GR + LU + HU + IE + IL+ IS + IT + JP + KR + LT+LV+ MX + NL + NO + NZ + PL + PT + SE + SI + SK + TR + US (37 countries). Thank you, Olaf |
Minor | Resolved | Fixed | |
Bug | SDMXNA-668 | SEEA-only | Discrepancy between SEEA Matrix and DSDs - UNIT_MULT |
In the SEEA DSD Matrix, UNIT_MULT is marked as being represented by an Integer. The actual SEEA DSDs are however using the CL_UNIT_MULT cross-domain code list, which contains all integers from -15 to 15.
It would be important to align the Matrix with the actual DSDs. Since the norm for the other SDMX-MES DSDs is to use the CL_UNIT_MULT code list, the DSDs are right and that the matrix needs to be corrected by indicating that the concept UNIT_MULT is represented by CL_UNIT_MULT. |
Minor | Resolved | Fixed |
Bug | SDMXNA-667 | SEEA-only | Mention of NACE instead of ISIC labels in CL_INTERACTORS |
Three codes in CL_INTERACTORS that have an explicit reference to NACE in the label or description:
* Code “_T”: the description reads “This aggregate includes all activities (All NACE and households activities, non-residents and not allocated)” * Code “ATU”: the label reads “All NACE activities” * Code “ATU_HH”: the label reads “All NACE and households activities” The description of the CL_INTERACTORS code list mentions both NACE and ISIC (_“Covers NACE/ISIC, households and Total”)._ UNSD would have a strong preference to replace all mentions of "NACE" with "ISIC", since this is a global DSD and ISIC is the international classification. However, if this would complicate country reporting too much, and NACE would also need to be mentioned, then UNSD would prefer ISIC to be listed first, i.e. "ISIC/NACE". |
Minor | Resolved | Fixed |
Sub-task | SDMXNA-666 | FDI-only | SDMXNA-651 Modify constraint on CL_SECTOR in FDI DSD |
In the Registry for the FDI DSD, we will need to add an additional constraint for the new code ‘S1272A’, so this code cannot be used for reporting FDI using the FDI DSD. We already have such constraints for codes S1SP, S12SP, S1SSP and S1273. Those constraints were added in the FDI DSD following issue SDMXNA-559
Also, given the change in label for code S1273, we should remove the current constraint for this code as it is no longer SPE related. |
Major | Resolved | Fixed |
Improvement | SDMXNA-665 | UNIT | Domestic currency in CL_UNIT |
XDF: Domestic currency (incl. conversion to current currency made using a fixed parity or market exchange rate) | Minor | Resolved | Fixed |
Improvement | SDMXNA-664 | AREA | New Euro Area aggregate code for CL_AREA |
The code we would like to add is:
_U31 =_ Intra EU Extra Euro Area (EU member states and institutions not belonging to the Euro area) changing composition _excluding the reference area_ Currently we have the below codes and this one is in line with the current coding conventions, so we do not expect any objections. |
Minor | Resolved | Fixed |
Improvement | SDMXNA-658 | UNIT | New codes for PPS in CL_UNIT |
In CL_UNIT, we have different codes available for expressing values in purchasing power parities as a ratio. Specifically, we have codes for EU27 (prior to 2013, code B4 in the DSD) and for EU28 (until 2020, code B5 in the DSD).
* PE_R_B4 - Euro, converted using purchasing power parities; ratio to EU27 * PE_R_B4_POP - Euro, converted using purchasing power parities; ratio to EU27 per capita * PE_R_B5 - Euro, converted using purchasing power parities; ratio to EU28 * PE_R_B5_POP - Euro, converted using purchasing power parities; ratio to EU28 per capita We also have a code to show that data is expressed as PPS, code "PE - Euro, converted using purchasing power parities". This code however does not specify which aggregate is used to calibrate the PPS (so for which aggregate PPS = EUR). We propose two improvements: * Create new ratio codes for the new B6 aggregate: PE_R_B6 and PE_R_B6_POP * Specify from now on which aggregate is used to calibrate the PPS values by introducing new PE codes. We would therefore: ** Propose the introduction of "PE_B6 - Euro, converted using purchasing power parities (PPS = EUR for EU27)". ** For backwards-compatibility reasons, we would keep "PE" for PPS=EUR for EU28, but would adjust the label accordingly: "PE - Euro, converted using purchasing power parities (PPS = EUR for EU28)" |
Major | Resolved | Fixed |
Improvement | SDMXNA-657 | UNIT | New code for CL_UNIT |
We would like to add ‘XDC_R_B6GA’ in the DSD list for ‘UNIT_MEASURE’ (please see the exchange with the ECB attached).
The description would be (in line with existing descriptions): ‘Domestic currency (incl conversion to current currency made using a fixed parity); ratio to sector specific gross disposable income, adjusted for the change in net equity of households in pension funds reserves’ |
Major | Resolved | Fixed |
Improvement | SDMXNA-656 | SECTOR | CL_SECTOR: Change in sub-sectors for S125 |
Last year, we added the following new sector codes in the dimension *CL_SECTOR:*
** |S125B|Financial corporations engaged in lending| | |S125C|Security and derivative dealers| | |S125D|Specialised financial corporations| | |S125D1|Clearing houses, which are part of specialised financial corporations| | |S125E|Other OFIs|S125E = S125 – S125A – S125B – S125C – S125D| After a thorough analysis of the comments made by countries and international organisations as well as further research on the criteria to clearly distinguish between financial corporations engaged in lending (S125B) and specialised financial corporations (S125D), we came to the conclusion that _central clearing counterparts_ (S125D1) could not be part of the specialised financial corporations subsector as they do not qualify as providing a wider range of services (in addition to providing credit) targeting specific groups of clients. In this respect, _central clearing counterparts_ have now become a subsector of the Other OFIs (S125E) and its sector code has moved from S125D1 to S125E1. In addition, the name of the subsector S125E1 has changed into “Central clearing counterparties” to comply with official standards (ESA 2010 and 2008 SNA). In conclusion, the subsector breakdown for other financial intermediaries (OFIs) should be changed as follows: |S125B|Financial corporations engaged in lending| | | |S125C|Security and derivative dealers| | | |S125D|Specialised financial corporations| | | |S125E|Other OFIs| S125E = S125 – S125A – S125B – S125C – S125D| | |S125E1|Central clearing counterparties, which are part of other OFIs| | | We would very much appreciate if the dimension *CL_SECTOR* could be updated this year with these revised subsector codes for S125 Other financial intermediaries, except insurance corporations and pension funds, to be able to reflect these improvements and to facilitate the data collection for this information in the course of 2020. |
Major | Resolved | Fixed |
Task | SDMXNA-655 | Package | Preparation of 2020-05 package |
this ticket is used to collect the new packages for version 2020-05. The latest versions of matrix files and shared code list files should be taken from here for generating the final package. | Blocker | Resolved | Fixed |
Improvement | SDMXNA-654 | MATURITY | CL_MATURITY - New codes requested by ECB |
Request done by [~emsuranda]
|LY13|Long-term original maturity (over 1 year) with residual maturity over 1 year and up to 3 years| |LY15|Long-term original maturity (over 1 year) with residual maturity over 1 year and up to 5 years| |LY23|Long-term original maturity (over 1 year) with residual maturity over 2 years and up to 3 years| |LY34|Long-term original maturity (over 1 year) with residual maturity over 3 years and up to 4 years| |LY35|Long-term original maturity (over 1 year) with residual maturity over 3 years and up to 5 years| |LY45|Long-term original maturity (over 1 year) with residual maturity over 4 years and up to 5 years| |LY56|Long-term original maturity (over 1 year) with residual maturity over 5 years and up to 6 years| |LY67|Long-term original maturity (over 1 year) with residual maturity over 6 years and up to 7 years| |LY78|Long-term original maturity (over 1 year) with residual maturity over 7 years and up to 8 years| |LY89|Long-term original maturity (over 1 year) with residual maturity over 8 years and up to 9 years| |LY9A|Long-term original maturity (over 1 year) with residual maturity over 9 years and up to 10 years| |LYAF|Long-term original maturity (over 1 year) with residual maturity over 10 years and up to 15 years| |LYAI|Long-term original maturity (over 1 year) with residual maturity over 10 years and up to 30 years| |LYFG|Long-term original maturity (over 1 year) with residual maturity over 15 years and up to 20 years| |LYGH|Long-term original maturity (over 1 year) with residual maturity over 20 years and up to 25 years| |LYHI|Long-term original maturity (over 1 year) with residual maturity over 25 years and up to 30 years| |LYI_|Long-term original maturity (over 1 year) with residual maturity over 30 years| |TY13|All original maturities with residual maturity over 1 year and up to 3 years| |TY23|All original maturities with residual maturity over 2 years and up to 3 years| |TY34|All original maturities with residual maturity over 3 years and up to 4 years| |TY35|All original maturities with residual maturity over 3 years and up to 5 years| |TY45|All original maturities with residual maturity over 4 years and up to 5 years| |TY56|All original maturities with residual maturity over 5 years and up to 6 years| |TY67|All original maturities with residual maturity over 6 years and up to 7 years| |TY78|All original maturities with residual maturity over 7 years and up to 8 years| |TY89|All original maturities with residual maturity over 8 years and up to 9 years| |TY9A|All original maturities with residual maturity over 9 years and up to 10 years| |TYAF|All original maturities with residual maturity over 10 years and up to 15 years| |TYAI|All original maturities with residual maturity over 10 years and up to 30 years| |TYFG|All original maturities with residual maturity over 15 years and up to 20 years| |TYGH|All original maturities with residual maturity over 20 years and up to 25 years| |TYHI|All original maturities with residual maturity over 25 years and up to 30 years| |TYI_|All original maturities with residual maturity over 30 years| |Y13|Original maturity over 1 year and up to 3 years| |Y23|Original maturity over 2 years and up to 3 years| |Y34|Original maturity over 3 years and up to 4 years| |Y35|Original maturity over 3 years and up to 5 years| |Y45|Original maturity over 4 years and up to 5 years| |Y56|Original maturity over 5 years and up to 6 years| |Y67|Original maturity over 6 years and up to 7 years| |Y78|Original maturity over 7 years and up to 8 years| |Y89|Original maturity over 8 years and up to 9 years| |Y9A|Original maturity over 9 years and up to 10 years| |YAF|Original maturity over 10 years and up to 15 years| |YFG|Original maturity over 15 years and up to 20 years| |YGH|Original maturity over 20 years and up to 25 years| |YHI|Original maturity over 25 years and up to 30 years| |YI_|Original maturity over 30 years| |XY12|Unspecified original maturities with residual maturity over 1 year and up to 2 years| |Y2_|Original maturity over 2 years| |
Major | Resolved | Fixed |
Improvement | SDMXNA-653 | SECTOR | CL_SECTOR new codes requested by ECB |
Request done by [~emsuranda] (ECB)
|S12E|Electronic money institutions| |S122E|Credit institutions| |S11P|Post office giro| |
Major | Resolved | Fixed |
Improvement | SDMXNA-652 | UNIT | CL_UNIT - 2 new codes for SEEA MFA |
from [~diegoce]
two new units are needed for our dataflow of MFA to UN: * PE_R_KG (PPS per kg) * EUR_R_KG_L (EUR per kg Chain linked volumes) |
Major | Resolved | Fixed |
Improvement | SDMXNA-651 | SECTOR | CL_SECTOR - changes needed in subsector breakdowns |
This issue follows the isue [https://webgate.ec.europa.eu/CITnet/jira/browse/SDMXNA-557]
from [~nynestis] I would like to submit an additional issue for this year’s release package of the SDMX NA DSD Matrix. Last year, we added new sector codes in the dimension *CL_SECTOR* for new data series requested as part of the more advanced ambition G20 templates related to recommendation 8 on institutional sector accounts. These new sector codes relate to more granular subsectors of the financial corporations’ sector (S12) requested in the “shadow banking” template entitled “_Additional sectors and instruments to capture relevant developments in the financial world”_. Please see attached. In particular, we added the following subsectors for the captive financial institutions S127: |S1271|Trusts, estate and agency accounts| | |S1272|Brass plate companies| | |S1273|Special Purpose Entities or conduits| | |S1274|Other captive finance companies and money lenders|S1274 = S127 – S1271 – S1272 – S1273| At the last OECD annual meeting of the Working Party on Financial Statistics in November 2019, the OECD presented a document with draft definitions for these new subsectors and instruments, anticipating the inclusion of these new subsectors and instruments as voluntary items in the OECD collection templates in 2020. Because the breakdowns largely concern new subsectors and instruments that are not covered in the 2008 SNA, clear and comprehensive definitions are needed to assist countries in the compilation of relevant estimates. As a follow-up, the OECD launched a written consultation in December 2019 to obtain feedback on these draft definitions. We are currently in the process of revising the draft definitions to integrate comments and suggestions made by OECD and G20 countries as well as international organisations. This revised document will accompany the data request that will be sent out in June 2020. After reviewing all the comments, it is clear that small changes are needed regarding the subsector breakdown for the captive financial institutions. In response to various comments made, this should be changed as follows: |S1271|Trusts, estate and agency accounts| | |S1272|Corporate groups’ captive financial entities| | |S1272A|Of which: Foreign owned SPE-type captives| | |S1273|Other captive finance companies and money lenders|S1273 = S127 – S1271 – S1272| As you can see Brass plate companies, which was a separate subsector (S1272) in the initial classification, are now included in the corporate groups’ captive financial entities subsector and renamed as "foreign owned SPE-type captives", as it turned out that brass plate companies are only relevant for a small number countries and that there would be no need to present it as a generic separate subsector in the template. The name has changed as brass plate companies is more a transversal term, as these entities may also be classified under the sector S11. In this respect, the sector S1273 “SPEs and conduits” has been changed into “Corporate groups’ captive financial entities” (S1272), also including “foreign owned SPE-type captives” which have now become subsector S1272A. The change in the name of “SPEs and conduits” relates to the fact that “SPEs” is more a generic term applicable to units that might belong to various sectors than a subsector name. For that reason, it does not make sense to use this term in the name of a specific subsector. In conclusion, the sector S127 has now only 3 subsectors: S1271; S1272 and S1273, with an “of which” subsector S1272A for sector S1272. We would very much appreciate if the dimension *CL_SECTOR* could be updated this year with these revised subsector codes for S127 Captive Financial Institutions, to be able to reflect these improvements and to facilitate the data collection for this information in the course of 2020. If you have any question, please do not hesitate to contact me. Kind regards, Isabelle |
Major | Resolved | Fixed |
Improvement | SDMXNA-649 | FDI-only | CL_TYPE_ENTITY code _Z to add |
from [~nkotheem]
I would like to make the following update to the _CL_TYPE_ENTITY_ code list, which is specific to the FDI DSD and maintained by the OECD: * A new code should be added : _Z for ‘not applicable’ We sometimes use this code when disseminating FDI statistics in ‘simplified’ public datasets which do not contain the type of entity concept. In any case, I believe it is good practice to have this type of standard code within a code list. |
Major | Resolved | Fixed |
Improvement | SDMXNA-648 | AREA | CL_AREA - change of integrity rules because of Brexit |
Some codes that represent areas with changing compositions have an integrity rules in the description where the countries are explicitly listed.
In the context of Brexit,the description should be changed. Some examples include the EU current composition, (code ‘B00’), the OECD current composition (code ‘P0’) and all the other codes based on these (e.g. ‘Europe Excluding OECD countries’, code ‘E1X’). Most of the descriptions for these cases indicate the year in which a new code has been added / removed. This ticket proposes to review some descriptions following this practice, as it provides a more correct integrity rule and also clarifies that the code should indeed be interpreted as referring to the “current composition”. As a general practice, it is proposed to use the words “from” and “until” to indicate the times at which the composition changed, as is already the case in other integrity rules. We could also only indicate the year, as is already the case for changing composition. No need to go back until1957. We can start from 2004 to keep things simpler. We could also consider removing the integrity rule for G2. It is a bit misleading since it excludes the reference area. Currently we have: G2 EEA except the euro area and reference area BG + CZ + DK + GB + HR + HU + LT + LV + PL + RO + SE + IS + LI + NO + 4A According to the points above, here are the proposed integrity rules: B00: AT + BE + BG (from 2007)+ CY + CZ + DE + DK + EE + ES + FI + FR + GB + GR + HR (from 2013) + HU + IE + IT + LT + LU + LV + MT + NL + PL + PT + RO (from 2007)+ SE + SI + SK+UK(until 2020) + B09 G4: AD + AL + BA + BY + FO + GG + GI + IM + JE + MD + MK + RU + SM + TR + UA + VA + ME + RS + CH + NO + IS + LI + HR (until 2013) + BG (until 2007) + RO (until 2007) + UK (from 2020) G9: AD + AL + BA + BY + FO + GG + GI + IM + JE + MD + MK + RU + SM + TR + UA + VA + ME + RS + HR (until 2013) + BG (until 2007) + RO (until 2007) + UK (from 2020) G0: AT + BE + BG (from 2007)+ CY + CZ + DE + DK + EE + ES + FI + FR + GB + GR + HR (from 2013) + HU + IE + IT + LT + LU + LV + MT + NL + PL + PT + RO (from 2007)+ SE + SI + SK+UK(until 2020)+ IS + LI +NO + 4Y + B09 G2: No integrity rule |
Major | Resolved | Fixed |
Task | SDMXNA-646 | All-DSDs, OG-DSD | Annual release 2020 |
Critical | Resolved | Fixed | |
Improvement | SDMXNA-645 | ACTIVITY | Change labels in CL_ACTIVITY |
We would need to change the labels for the codes K643, N79, C16T18, GTI, K_L and BTSXO
• For K643 and N79, we should align the labels to the official NACE labels Proposal: K643 Trusts, funds and similar financial entities N79 Travel agency, tour operator and other reservation service and related activities • For the C16T18, GTI, K_L and BTSXO aggregates, the current labels do not precisely follow the NACE composition and this may lead to misunderstanding. Proposal: C16T18 Manufacture of wood and of products of wood and cork, except furniture; manufacture of articles of straw and plaiting materials; manufacture of paper and paper products; printing and reproduction of recorded media GTI Wholesale and retail trade; repair of motor vehicles and motorcycles; transportation and storage; accommodation and food service activities K_L Financial and insurance activities; real estate activities BTSXO Industry, construction and services (except public administration and defence; compulsory social security; activities of households as employers; undifferentiated goods- and services-producing activities of households for own use; activities of extraterritorial organisations and bodies) |
Minor | Resolved | Fixed |
Improvement | SDMXNA-644 | AREA | New codes in BOP DSD - CL_AREA |
We would like to request addition of new codes in the following code lists:
. Area code: G10, label: Other European countries (not EU nor EFTA) (from 2020), Integrity rule: AD + AL + BA + BY + FO + GG + GI + IM + JE + MD + MK + RU + SM + TR + UA + VA + ME + RS + GB |
Minor | Resolved | Fixed |
Improvement | SDMXNA-643 | INSTR_ASSET | New codes in BOP DSD - CL_INSTR_ASSET |
We would like to request addition of new codes in the following code lists:
Instrument and asseets classification code: NENDI, label: Net international investment position excluding non-defaultable instruments |
Minor | Resolved | Fixed |
Improvement | SDMXNA-642 | BOP-CodeLists | New codes in BOP DSD - CL_ACCOUNTS_ITEM |
We would like to request addition of new codes in the following code lists:
. International accounts item: code: S_X_CG, label: Services excluding Transport and Financial services |
Minor | Resolved | Fixed |
Improvement | SDMXNA-640 | NA-CodeLists | New codes for table identifier code list |
dear colleagues,
We have extended a bit our MUFA reporting for which we added 2 new table identifiers, but we were unfortunately not aware that this is controlled by a codelist in NA_SEC. As the new reporting is due early April we do not have much time left for amending the codelists via official process. Could we therefore please ask you to amend the internal version CL_NA_TABLEID with the the below new entries? In parallel we will also submit the official request to Eurostat to amend the codelist globally used. MUFA10 ECB MUFA Guideline, Table 1: Consolidated financial assets MUFA11 ECB MUFA Guideline, Table 2: Consolidated financial liabilities Thanks very much for looking into this with some priority (if possible under these circumstances ). Kind regards, Istvan |
Major | Resolved | Fixed |
Improvement | SDMXNA-638 | ORGANISATION | New code in organisation |
CL_ORGANISATION 4W0 EFSF (European Financial Stability Facility) |
Minor | Resolved | Fixed |
Bug | SDMXNA-637 | AREA, ORGANISATION | Correction of labels related to Brexit |
The B6 code in the SDMX DSDs still has the old date for Brexit. Could you please check with Eurostat if this can be updated, maybe as part of the next release in May? Or maybe just open a Jira ticket? It would have to be done for all codes linked to it.
Currently it is defined as “EU27 (fixed composition) as of 29 March 2019 (brexit)” |
Trivial | Resolved | Fixed |
Improvement | SDMXNA-636 | INSTR_ASSET | Correction of validation rule CL INSTR ASSET |
F51M should have a validation rule associated to it (CL_INSTR_ASSET)
F51M=F512+F519 |
Minor | Resolved | Fixed |
Bug | SDMXNA-620 | SEEA-only | Correction in the SEEA DSD guidelines (2) |
Where it says
"Most flows are from the economy to the environment and are coded ACCOUNTING_ENTRY=EC. Flows from the environment to the economy (such as oxygen for combustion, water for drinking) are coded ACCOUNTING_ENTRY=B. Net additions to stock are coded ACCOUNTING_ENTRY=D." It should say "Most flows are from the economy to the environment and are coded ACCOUNTING_ENTRY=EC. Balancing items in the input side are also coded ACCOUNTING_ENTRY=EC. Flows from the environment to the economy (such as oxygen for combustion, water for drinking) are coded ACCOUNTING_ENTRY=EN. Balancing items in the output side are also coded ACCOUNTING_ENTRY=EN. Net additions to stock are coded ACCOUNTING_ENTRY=D." |
Minor | Resolved | Fixed |
Bug | SDMXNA-619 | SEEA-only | Correction in the SEEA DSD guidelines (1) |
The BRIDGE_ITEM codes in the MATERIAL table for MFA contains some incomplete codes (The string in red is missing):
| MATERIAL|*Imports* *(Table B)*|*Exports* *(Table D)*| |MF.4.2.3.1 Fuel for land transport|_Z|RES_ABR{color:#FF0000}*_LTR*{color}|_Z|TER_NRES*{color:#FF0000}_LTR{color}*| |MF.4.2.3.2 Fuel for water transport|_Z|RES_ABR*{color:#FF0000}_WTR{color}*|_Z|TER_NRES*{color:#FF0000}_WTR{color}*| |MF.4.2.3.3 Fuel for air transport|_Z|RES_ABR*{color:#FF0000}_ATR{color}*|_Z|TER_NRES*{color:#FF0000}_ATR{color}*| |
Minor | Resolved | Fixed |
Improvement | SDMXNA-618 | BOP-Dataflows | Change in codification |
We would need to change reference sector from S1W to S1 in codification for Personal remittances (R1) in QBOP and AITS datasets:
Codification would be: QBOP: Q.N.#.%.S1.S1.T.C.R1._Z._Z._Z.$._T._X.N, Q.N.#.%.S11.S1.T.D.R1._Z._Z._Z.$._T._X.N AITS: A.N.#.%.S1.S1.T.C.R1._Z._Z._Z.$._T._X.N, A.N.#.%.S1.S1.T.D.R1._Z._Z._Z.$._T._X.N, A.N.#.%.S1.S1.T.B.R1._Z._Z._Z.$._T._X.N Thank you and best regards, Olaf |
Minor | Resolved | Fixed |
Improvement | SDMXNA-616 | ORGANISATION | Change in CL_ORGANISATION |
We would need to make a change in label for code BA4 in CL_ORGANISATION from 'Ministry of Finance for the Federation of Bosnia and Herzegovina' to 'Bosnia and Herzegovina Ministry of Finance and Treasury'
Thank you and best regards, Olaf |
Trivial | Resolved | Fixed |
Improvement | SDMXNA-615 | AREA, UNIT | CL_UNIT and CL_AREA code request |
* To the “CL UNIT” add new Belarusian rouble code (*BYN*). We want to mention that this code implemented to the ISO codelists and ECB’s sdmx unit codelist.
* Add to the “CL AREA” international organization –Eurasian economic commission. |
Minor | Resolved | Fixed |
Improvement | SDMXNA-614 | BOP-CodeLists | New code for CL_ACCOUNTS_ITEM |
A new code is needed for the IMF SPE template:
|SPX5|Miscellaneous services: Services excluding transport, financial services, charges for the use of intellectual property and other busines sservices|SPX5 = S - SC - SG - SH -SJ| |
Minor | Resolved | Fixed |
Improvement | SDMXNA-613 | BOP-CodeLists | Addition of code to CL_FUNCTIONAL_CAT |
A new functional category is required to simplify the collection of the supplemental i.i.p. position.
TXDR - All functional categories (total) excluding direct investment and reserve assets TXDR = T - D - R Kind regards, Iustin |
Minor | Resolved | Fixed |
New Feature | SDMXNA-608 | NA-CodeLists | OECD and Eurostat to agree on an approach for table identifier |
OECD highlighted that the core issue of the NA model is that only a single table ID is possible per time series. In cases where the whole cube in managed in the same database, there is no possibility to mark multiple reporting tables for a single series. National Bank of Belgium is affected by the issue for ESA reporting from Q1/2020. The current preference for implementation is option B, since it only means a minor change of the DSD, adding codes to the table identifier code list. It will also mean to update related SDMX constraints owned by Eurostat to allow those new table identifiers. OECD will discuss bilaterally with Eurostat on a follow up of the issue in the context of the next annual release. Eurostat has done a mapping of series across tables, which can be valuable input to the list of required codes. A "softer" option B would be to be less explicit, using a general code for “multiple tables”.
Issue note: https://webgate.ec.europa.eu/CITnet/confluence/download/attachments/899871407/2019-12-16%20-%20NA_MAIN%20Table%20identifier%20Issue%20Note.docx?version=1&modificationDate=1575625909354&api=v2 |
Major | Resolved | Fixed |
Bug | SDMXNA-603 | AREA | Correction of labels for D1,D2,D3,D4,D5,D6 |
In BOP DSD v.1.10 incorrect labels for codes D1,D2,D3,D4,D5 were introduced. The label is the same for five codes and is Extra-EU 28 (fixed composition) excluding CA, RU, CH, TR, US, F2, E4, B2, as of 1 July 2013.
The correct labels should be: D1 - Extra EU 12 (fixed composition) D2 - Extra-EU 15 (fixed composition) D3 - Extra-EU 25 (fixed composition) D4 - Extra-EU 27 (fixed composition) D5 - Extra-EU 28 (fixed composition) Additionally, due to postponement of Brexit label for code D6 should be changed from Extra-EU 27 (fixed composition) excluding GB, as of 29 March 2019 to Extra-EU 27 (fixed composition) (including United Kingdom). Thank you and best regards, Olaf |
Trivial | Resolved | Fixed |
Improvement | SDMXNA-601 | ACTIVITY | New activity code |
we would need the following new NACE code to be added in the CL_ACTIVITY:
ATN_RTU - All activities except activities of public administration, defence, education, human health and social work Identity rule: ATN_RTU= A+B+C+D+E+F+G+H+I+J+K+L+M+N+R+S+T+U In case the request cannot be added in the fast track changes now, please add it for the next release in April/May 2020. |
Minor | Resolved | Fixed |
Bug | SDMXNA-600 | SEEA-only | Inconsistency between the Matrix and the DSD SEEAMFA |
The Matrix for SEEA domain references the dimension INTERACTORS in the DSD SEEAMFA but this dimension is missing in the DSD in the Registry
This issue is linked to the ticket SDMXNA-460 There is no impact on the current data collection because a constant is assigned to this dimension and it is also absent in the corresponding questionnaire used by Eurostat. The way to fix this issue has to be discussed: - remove the dimension in the matrix - add the dimension in the DSD and review all the corresponding questionnaires |
Minor | Resolved | Fixed |
Improvement | SDMXNA-599 | AREA | Addition of new codes to CL_AREA |
We would need to add new codes to the list of international organizations in CL_AREA:
- 4W - EFSF (European Financial Stability Facility) Accordingly the following integrity rule needs to be updated: 4Y=4A+4F+4S+4W - 6Z1 - The Global Fund to Fight AIDS, Tuberculosis and Malaria. Thank you and best regards, Olaf |
Minor | Resolved | Fixed |
Improvement | SDMXNA-595 | NA-CodeLists, SEEA_STO | New code for CL_NA_STO |
We would need to create a new code in the CL_NA_STO code list for the "Final domestic demand". We suggest to add the following:
Code Description Comments (Explanation) P3_P51G Final domestic demand P3_P51G=P3+P51G Btw, to be clear about the definitions, we also suggest to add the accounting identities to two other existing transactions: Code Description Comments (Explanation) P3T5 Domestic demand P3T5=P3+P5 P3T6 Total demand P3T6=P3+P5+P6 For your consideration, Best regards Rachida |
Minor | Resolved | Fixed |
Improvement | SDMXNA-594 | AREA | Change of label of code 6J |
Due to restructuring of the International Telecommunications Satellite Organisation we need to change label of code 6J in Area code list from INTELSAT (International Telecommunications Satellite Organisation) to ITSO (International Telecommunications Satellite Organisation). | Minor | Resolved | Fixed |
Improvement | SDMXNA-593 | SEEA-only | New code CL_MATERIAL for SEEA |
The code list CL_MATERIAL needs to be extended with a code MEMO_MF72 ("Waste disposal to controlled landfills (memo item)").
Note MEMO_MF72 = MEMO_MF721 (Disposal of municipal waste to controlled landfills (memo item) ) + MEMO_MF722 (Disposal of industrial waste to controlled landfills (memo item) ) |
Major | Resolved | Fixed |
Improvement | SDMXNA-592 | SEEA-only | New code in CL_BRIDGE_ITEM for SEEA |
The SEEA global DSD for energy accounts contains the concept BRIDGE_ITEMS referring to the code list CL_BRIDGE_ITEM. One of the codes in this list is ADJ_SD, standing for “Adjustments and statistical discrepancy”.
The bridge items in the energy accounts table have been extended with a new code: a sub-item (_of which…_) of ADJ_SD “Adjustments and statistical discrepancy”.T his sub-item is only relevant for SEEA energy accounts. We propose the creation of a new codes as subcategory of ADJ_SD “Adjustments and statistical discrepancy”: Code list: CL_BRIDGE_ITEM. - Proposed code/label: ADJ_SD_DUXGIC / "Adjustments and statistical discrepancy amongst which flows included in domestic use by resident units while excluded in gross inland consumption” |
Major | Resolved | Fixed |
Improvement | SDMXNA-591 | SEEA_STO | New codes in CL_SEEA_STO for SEEA |
The code list CL_STO includes the codes P2 (Intermediate consumption) and P3 (Final consumption expenditure). These codes are currently used in Energy accounts dataflows as proxies for “Transformation use of energy” and “Final Energy Use” respectively.
Transformation use of energy consists of transforming energy products to create other energy products, e.g. crude oil into gasoline, whereas final energy use consists of using energy products to product energy. However these flows are not identical to P2 and P3 in national accounts, for instance burning gasoline to produce energy (to move cars) may be done by businesses for P2 or by families for P3. In order to avoid the use of proxies not fully matching the code concept and the represented variable, we propose the creation of two new codes as subcategories of “Total Use”: Code list: CL_STO - Proposed code/label: TUTU / "Use of energy residuals by the environment during transformation of the energy products (Losses of energy products during transformation)” - Proposed code/label: TUEU / "Use of energy residuals by the environment during end use of the energy products (Losses of energy products during end use)" Notice TU (total use) = TUTU + TUEU |
Major | Resolved | Fixed |
Improvement | SDMXNA-590 | ACCOUNT_ENTRY, SEEA-only | New codes CL_ACCOUNT_ENTRY for SEEA (2 of 2) |
The code list CL_ACCOUNT_ENTRY includes a code D for "Debit" to represent the total (economic) outcoming transactions. The CL_ACCOUNT_ENTRY for MES was extended to include not only economic flows but also flows between the economy and the environment. Regrettably the existing code "D" is insufficient to encompass both types of flows, i.e. on the one hand between economic units and on the other hands between the economy and the environment.
In addition, two subcategories of "Debit" are needed, in particular for energy accounts. The use table for enegy accounts is subdivided in two tables: "Transformation use of energy flows" and "End use of energy flows. Accordingly three new codes are proposed: - Code list: CL_ACCOUNT_ENTRY. - Proposed code/label: D_EN / "Debit (Environment + Economy)" - Proposed code/label: DT_EN / "Transformation use (Environment + Economy)" - Proposed code/label: DE_EN / "End use (Environment + Economy)" A new code is also needed for Credit. A separate ticket was created. Notice Credit does not need the subdivision proposed for Debit because the supply table for energy flows is not subdivided in sub tables. |
Major | Resolved | Fixed |
Improvement | SDMXNA-589 | ACCOUNT_ENTRY, SEEA-only | New codes CL_ACCOUNT_ENTRY for SEEA (1 of 2) |
The code list CL_ACCOUNT_ENTRY includes a code C for "Credit" to represent the total (economic) incoming transactions. The CL_ACCOUNT_ENTRY for MES was extended to include not only economic flows but also flows between the economy and the environment. Regrettably the existing code "C" is insufficient to encompass both types of flows, i.e. on the one hand between economic units and on the other hands between the economy and the environment.
For this reason we propose the creation of the new code C_EN for "Credit (Environment + Economy)": - Code list: CL_ACCOUNT_ENTRY. - Proposed code/label: C_EN / "Credit (Environment + Economy)" The same situation exists for Debit. A separate ticket is created for this purpose. |
Major | Resolved | Fixed |
Improvement | SDMXNA-588 | AREA | New area codes |
We would need to add new codes to Area code list:
R53 - OPEC (Organization of Petroleum Exporting Countries) (from 2019) Integrity rule: R53 = AE + AO + CG + DZ + EC + GA + GQ + IQ + IR + KW + LY + NG + SA + VE 5Z45 - International Council for the Exploration of the Sea (ICES) Thank you and best regards, Olaf |
Major | Resolved | Fixed |
Improvement | SDMXNA-586 | SEEA-only | CONF_STATUS and OBS_STATUS_1 optional in Environmentatal Accounts DSDS |
CONF_STATUS and OBS_STATUS_1 should not be mandatory in none of the DSDs in environmental accounts | Major | Resolved | Rejected |
Improvement | SDMXNA-585 | AREA | Update in the validation rule for 4A |
The SRB (Single Resolution Board) - 4M is an EU organization but the validation rule for 4A does not reflect this.
4A=4B+4C+4D+4E+4G+4H+4I+4J+4R+4T+4U+4V to become 4A=4B+4C+4D+4E+4G+4H+4I+4J+{color:#FF0000}4M+{color}4R+4T+4U+4V |
Minor | Resolved | Fixed |
Improvement | SDMXNA-584 | SEEA-only | Missing code for SEEA in CL_MATERIAL |
During the definition of the code lists CL_MATERIAL, the following code needed for MFA (Material Flow Account) was forgotten
* MEMO_MF72: Waste disposal to controlled landfills (memo item) |
Major | Resolved | Duplicate |
Improvement | SDMXNA-583 | SEEA-only | Missing _Z code in CL_BRIDGE_ITEM |
The code _Z is needed for Material Flow Accounts | Major | Resolved | Fixed |
Improvement | SDMXNA-582 | NA-CodeLists | Missing codes for SEEA in CL_NA_STO |
A few codes introduced for Environmental Accounting in the code list CL_NA_STO are missing in the 06/2019 delivery:
|BBI|Balancing items (input - output) (environmental accounts)| |BDMC|Domestic material consumption (environmental accounts)| |BDMI|Direct material inputs (environmental accounts)| |BRMC|Raw material consumption – material footprint (environmental accounts)| |BRMI|Raw material input (environmental accounts)| |MDE|Domestic extraction (environmental accounts)| |MDPO|Domestic processed output (environmental accounts)| |KNAS|Net additions to stock (environmental accounts)| |PPTB|Physical trade balance (environmental accounts)| They might have been lost during the review process. The suggestion is to include these codes in the next release of the CL_NA_STO code list. |
Major | Resolved | Rejected |
Improvement | SDMXNA-581 | TRANSFORMATION, UNIT | add 4 new codes in CL_TRANSFORMATION and CL_UNIT |
|CL_UNIT|All currencies except: EUR, domestic currency|*X10*|
|CL_UNIT|Index of notional stocks|*IX_R_LE*| |CL_TRANSFORMATION|Growth rate, over 1 year, based on 3-month average|*GYA3*| |CL_TRANSFORMATION|Growth rate, over 1 year, based on 12-month average|*GYA12*| |
Major | Resolved | Fixed |
Bug | SDMXNA-517 | IDC-SIG-GDP | Proposal to add STO items B2G and B3G separately in Pilot 1 |
Dear colleagues,
We would like to propose a change/addition to Pilot 1. Currently the template includes the item B2A3G: Operating surplus and mixed income, gross. However, we collect these items separately when available, so we would propose adding the two independent items B2G: Operating surplus, gross; and B3G: Mixed income, gross as an alternative. We are flexible as to the timeline for implementing this change as we will likely not be providing an official datafile until around September. Thank you and best regards, Pedro Farinas | Statistics Assistant, National Accounts Economic Statistics Branch, Statistics Division | Department of Economic and Social Affairs United Nations | Room DC2-1513-E | farinas@un.org | Tel: +1 (212) 963 2288 | |
Major | Resolved | No Action |
Improvement | SDMXNA-423 | ORGANISATION | New codes in CL_ORGANISATION |
the Federal Planning Bureau will send additional voluntary SUT tables for the year 2014 to Eurostat in SDMX-XML format.
In the NASU files, we find the following list of ‘Compiling organisations’ for Belgium: BE1 Institut National de Statistiques de Belgique BE2 Banque Nationale de Belgique (Belgium) BE3 Federal Public Service Budget (Belgium) The Federal Planning Bureau is not available in this list. Can the FPB be added to this list as BE4 (to be used as ‘Sender id’ in the xml-file)? |
Minor | Resolved | Fixed |
Bug | SDMXNA-370 | NA-CodeLists | Wrong entries for German regions in ESTAT:CL_REGIONAL:1.1 |
The sub-regions DEC* have wrong codes in the code list CL_REGIONAL 1.1 used in the DSDs NA_REG 1.1 through 1.5. The issue is fixed in CL_REGIONAL 2.0 used in NA_REG 2.0 and newer.
We need to review if a fix for version 1.x would be needed. |
Minor | Resolved | No Action |
Task | SDMXNA-362 | INSTR_ASSET | Change in rule of code FR411 (CL_INSTRUMENT) |
Reported by a national central banks:
Code Description Comments (Integrity Rule) FR411 Reserve assets other than gold, SDRs, IMF reserve position, currency, deposits, securities, financial derivatives and loans (to non-banks) FR411=F5+F6+F8 However, should the integrity rule be FR411=F6+F8 instead of FR411=F5+F6+F8, since the description includes the information that reserve assets other than securities? where: F5 Equity and investment fund shares/units F6 Insurance, pension and standardized guarantee schemes F8 Other accounts receivable/payable So the question is: why Equities were included? Should the description of FR411 refer to debt securities only or is the rule wrong? |
Minor | Resolved | Fixed |
Bug | SDMXNA-336 | Excel | Missing formulas for footnotes in Excel template for table 25 |
see attached communication with INE Spain: miriam.lopez.bahut@ine.es | Minor | Resolved | No Action |
Bug | SDMXNA-335 | Excel | Wrong visualisation or parameter link in Excel template for ESA table 11 |
see attached communication with INE Spain: miriam.lopez.bahut@ine.es | Minor | Resolved | No Action |
Task | SDMXNA-184 | TG | Jira guidelines |
Eurostat to create some guidelines on the usage of Jira | Major | Resolved | Fixed |
Generated at Mon Feb 01 20:56:17 CET 2021 by GRAMAGLIA Luca using Jira 8.5.3#805003-sha1:b4933e02eaff29a49114274fe59e1f99d9d963d7. |