DMP data flow tour

Data transfers and creating reports for Disease Management Programs

We would like to take you on a trip through the data jungle of the German health care system. Let us show you how your data becomes part of a report. Below, the data flow is explained step by step.


Start tour
Medical Netcare - Management in health care

Part 1: medical documentation (MD)

DMP participants are meant to visit their diabetologist four times a year. The main events and parameters are discussed between physician and patient, recorded and sent to one of the 6 data authorities for testing and pseudonymisation.

md01-datenerfassung-bis-zur-datenstelle_fl

Data acquisition in a physician's practice

md02-pseudonymisierung_fl

Pseudonymisation and forwarding

md03-datenempfang-mnc_fl

Data processing by MNC

Medical Netcare - Management in health care

Part 2: data on patient characteristics (PM)

Data on patient characteristics is generated and transferred by the statutory health insurance companies. For each participant, information regarding their enrollment in a DMP, gender and age are transmitted.

kd01-kassen-erzeugen-pm-daten_fl

Generating the data on patient chracteristics

kd02-kassendatenuebermittlung-zu-mnc_fl

Data transfer to Medical Netcare

kd03-datenempfang-mnc_fl

Data processing by Medical Netcare

Medical Netcare - Management in health care

Part 3: Data for consolidating pseudonyms to a master record (MK)

The data for consolidating pseudonyms to a master record is generated and transmitted by the health insurance funds. The data consolidation program was established in order to pseudonymise all patients in a standardised way and is based on this data. Data on medical parameters and patient characteristics can deviate from the proper main pseudonym. For all records of one patient to bear the same pseudonym, pseudonyms are translated by the procedure depicted here into the main pseudonym.

mk01-kassen-erzeugen-mk-listen_fl

Generating translation lists

mk02-mk-datenuebermittlung-an-mnc_fl

Data transfer to Medical Netcare

mk03-datenempfang-mnc_fl

Data processing by Medical Netcare

Medical Netcare - Management in health care

Part 4: Data assigning membership of a distinct health insurance fund (IK)

The institution codes (IK) used in the medical documentation can differ from the main institution code of a fund due to administrative reasons. In order to state a participant's membership of a distinct health insurance fund, these differing codes have to be translated. This is the only way to reunite medical documentations with patient characteristics. Institution codes are generated and transmitted by the health insurance funds.

ik01-kassen-erzeugen-ik-listen_fl

Generating the institution code translation table

kd02-kassendatenuebermittlung-zu-mnc_fl

Data transfer to Medical Netcare

ik03-ik-listen-einlesen_fl

Data processing by Medical Netcare

VV01 Kassenzuordnung mittels IK-Liste_eng_fl

Translation of institution codes

The new data is not yet containing the final health insurance fund's assignment. The included institution codes have to be translated first. By translating using the institution code translation tables, data is assigned to the correct health insurance fund.

Translating is processed for each of the three other data types: patient characteristics, medical documentations and consolidation data.

In case of modifications in the translation tables, all records in stock are to be translated by means of these new tables. For example, this case occurs when two health insurance funds fuse. The institution codes of the fusioning funds are joined via new translation tables. This way, such modifications are implemented rather quickly.


Generating master records
vv02-pseudonymuebersetzung-mit-mk-liste_fl

Generating master records - translating pseudonyms

The translation lists by the health insurance funds are provided twice a year. Each time they arrive at Medical Netcare, the whole stock in translation rules is replaced and rebuilt. This means, on the one hand, that the translation is to be operated on the whole data in stock – on the other hand, a health insurance fund can report tranlations late or correct them providing missing data to connect medical documentations to the respective patient characteristics in retrospect.

The translation is operated on the patient characteristics provided by the health insurance funds as well as on the medical documentation.

When the translation is processed, the data fusion is complete for the moment. Now, MNC checks for loose ends (medical documentation without matching patient characteristic record or vice versa) and reports these to further enhance data quality. Within a time limit of 4 weeks, MNC accepts corrections or additional data. Afterwards, the data processing is finished.


Development of a medical case
VV03 Darstellung als Verlauf_eng_fl

Progress documentation

In their translated form, all data of a patient can be merged sensibly. The data of each DMP participant is a progress documentation by now.

The diagram on the left depicts a patient's progress with respect to the data. In order to further procede the data, a few more steps and algorithms are necessary. The current evaluation demands analyses on the basis of half-years as well as years. Due to regular consultations , there are normally two medical documentations per half-year (and accordingly four in a year). For example, each patient has two blood pressure values and two HbA1c values in a half-year. Data has to be further concentrated to suit the systematic evaluation with just one value per observation time.


data condensation
Medical Netcare - Management in health care

Operationalisations to condense data

Within DMP evaluation, yearly as well as half-yearly presentations are chosen for the evalution of data. If there is more than one medical documentation per patient and evaluation point, documentations have to be condensed.

MNC developed operationalisations prescribing for each medical parameter how to calculate or determine them. In defining these operationalisations, we took care to understand the meaning of each value and condense them accordingly. These are a few representative rules:

First or last value
  • the value from the first or the last documentation in an evaluational (half-)year is adopted
Major or minor value
  • the major or minor value out of all available documentations is adopted
Worst case or best case
  • the value transporting the worst or the best statement is adopted
Arithmetic means or sum
  • the arithmetic means or a sum is built on the basis of all available documentations
Medical Netcare - Management in health care

Report production

The requested evaluations for DMP are only possible with the data preparation being processed.

Every 3 years,

new reports are produced per indication.

These additional regulations are taken into account for the production of reports:

1. The year of the first publication of an to the DMP-A-RL is the last year to be included in the first report following the new systematic. Afterwards, sentence 3 applies.

2. The report has to be handed in no later than 18 months after the year of the first publication of the annex ended. Afterwards, sentence 3 applies.

3. The interval between indication-specific evaluation reports is three years.

contact options contact form restart tour Home get our newsletter
Do NOT follow this link or you will be banned from the site!
Wir benutzen Cookies um die Nutzerfreundlichkeit der Webseite zu verbessen. Durch Ihren Besuch stimmen Sie dem zu.