Statistical processing
Contact info
Welfare and Health, Social StatisticsBirgitte Lundstrøm
+45 24 21 39 65
Get as PDF
Data for the statistics on assistive products are collected quarterly from the municipalities via automatic reports from the professional systems or via a web-based reporting solution. The collected data goes through an error-finding procedure, where the municipalities receive aggregated data, which they must approve. When the data has been validated by the municipalities and finally approved, Statistics Denmark processes the collected data and removes invalid data.
Source data
Lending of assistive products is primarily registered in the municipalities' aid depots. Data on the granted products are reported by the trading municipality, i.e. the municipality that has searched the individual citizen for the product. In this connection, it should be noted that some municipalities have entered into an administrative collaboration, where a municipality, in addition to reporting on its own behalf, also reports on behalf of one or more municipalities.
Frequency of data collection
Data are collected quarterly.
Data collection
Data are mainly reported directly from the administrative systems used by the municipalities through system-to-system solutions. The automatic reporting is developed and maintained by the municipalities' tech suppliers. Alternatively, data can be reported manually via an online reporting service provided by Statistics Denmark. In the web-based reporting solution, the municipalities maintain their data alongside their regular administration of the services, typically because the municipal professional system cannot report directly to Statistics Denmark.
Data validation
Statistics Denmark sends approval reports to the municipalities once a year, where they must approve summary statements of the distribution and submission of assistive products. Together with the approval reports, a report for validation of the distribution of the legal sections is sent. See the legal sections in the section Classification system. If the municipalities cannot approve the data, they are asked to correct any errors and resend the data. After this, the municipality will again be asked to approve the new summary data on distribution and submission as well as the distribution of the legal sections.. If the municipality does not respond to inquiries from Statistics Denmark, it is followed up with two written reminders and one telephone reminder. For municipalities that do not respond to inquiries from Statistics Denmark, Statistics Denmark can ask the Ministry of Social Affairs, Housing and Senior Citizens to contact the municipality with a view to further dialogue on approval of data. Statistics Denmark works to ensure that all municipalities report data on assistive products distributed by the legal sections. Statistics Denmark has contacted all municipalities and asked them to report the legal sections and attach a section to each assistive product. Statistics Denmark will develop and continuously implement validation on the legal sections used to grant the assistive products.
Data compilation
Statistics Denmark receives data regarding assistive products from each municipality from the system suppliers or an alternative reporting system made available to the municipalities by Statistics Denmark.
Data is collected with full load in each quarter. Statistics Denmark sends two written reminders and one telephone reminder. For municipalities that do not respond to Statistics Denmark's inquiry, Statistics Denmark can ask the Ministry of Social Affairs, Housing and Senior Citizens to contact the municipality with a view to further dialogue about reporting data.
Once the data has been received, the data is compiled into a single data set, which forms the basis for the statistics.
In connection with the municipalities changing system suppliers, data supplied from the old and new system must be processed and compiled into a single report for the municipality.
The statistics cover the period from 1st of July 2022 onwards. This means that all assistive products that are loaned out as of 1st of July 2022, as well as assistive products that are delivered and/or returned as of 1st of July 2022 and onwards, will be included in the statistics. Other data that are not active in this period are deleted from data.
Each assistive product is registered with a social security number. All social security numbers are validated on the basis of Statistics Denmark's population register, and invalid social security numbers are removed from data. In some cases, assistive products are delivered to institutions where they can be used by several citizens. These assistive products are registered with a fictitious social security number and are removed from data if possible.
Each assistive product is associated with a reporting municipality and a paying municipality. A number of municipalities have inter-municipal collaborations, which means that a group of municipalities is part of a collaboration on custodial solutions for assistive products. One municipality will be responsible for the reporting of assistive products on behalf of the other municipalities that are part of the collaboration. In these cases, the paying municipality will not always be correct, but will be registered with the municipality responsible for the report. Based on Statistics Denmark's population register, the citizen's municipality code is registered based on the citizen's municipality of residence at the time of delivery. In a few cases, there is no municipality of residence at the time of delivery. Here, the municipality code is set to the reporting municipality's municipality code.
Some assistive product are registered as being active even though the citizen is dead. In these cases the death of the citizen is registered as the returning date. Some assistive products are registered with a returning date that is much later than the death of the citizen. If a returning date is registered but the returning date is more than 31 days after the death of the citizen, the death of the citizen is registered as the returning date. Assistive products with a returning date registered before the delivery and deliveries that are registered after the death of the citizen are removed from data. After these corrections of data some assistive products are no longer active at the 1st of July 2022 and they are removed from data.
After correcting the delivery date some assistive products are still registered as active even though they are delivered many years ago. It is not assessed that assistive products are still active after many years of use. Assistive products that are delivered more than 20 years back in time are removed from data.
The municipalities have to attach a legal section to each assistive product. This should be reported in the variable 'lov_navn' using specific codes but is not always done. The municipalities can use the variable 'lov_tekst' to write a free text and attach a legal section to the assistive product. If a free text is attached to lov_tekst and the free text is included in the mandatory legal sections, the legal section is attached to the variable lov_navn_opret using the specific codes.
Age and sex is calculated using the birth date and is calculated at the end of the year. For citizens that have died prior to end of the year, the age is calculated using the death of the citizen.
Adjustment
No corrections of data are made, other than the ones described in the section Data Validation and Data Compilation.