Immunizations - Generate csv-file to import in DIM

[marko-arn]

Situation Description

As far as it is known yet, the Health Offices will be involved in the vaccinations against Corona from October 2021 onwards. This also includes the transmission of the necessary data to the RKI according to §7 para. 1 Corona Vaccination Ordinance):

Patient pseudonym, Month and year of birth, sex, Five-digit postcode and county of the person to be vaccinated, identification number and district of the vaccination centre Date of the vaccination, Start or completion of the vaccination series (initial or follow-up vaccination), Vaccine-specific documentation number (vaccine product or trade name), Batch number, Basis of prioritisation according to §§ 2 to 4.

The DIM (digital immunisation monitoring) provided by Bundesdruckerei is used for data transmission. This offers the possibility to enter the data anonymously, to connect via REST-API or to upload it as a csv file via import.

Since the connection via REST-API is not quite simple (certificate handling, etc.), Sormas should offer the possibility to export the data via csv in a suitable data format.

An example export is here(note: the fileformat csv ist not allowed for upload and was therefore changed to txt):

CSV-Beispieldateineu.csv.txt

Here is a hand-out with the data description:

2021-06-22_DIM_HandoutCSVUpload_Release_2.pdf

As an health office must have an own identification number for every vaccination center and team there is during the export of the data an entry field needed for entering these data.

There must also a filter for the vaccination date and the export must only include the immunisations for the selected period. E.g. if the person gets the second doze, the first dose must not exported.

@MateStrysewske @Jan-Boehme

[marko-arn]

@kwa20 @Candice-Louw FYI

[kwa20]

@Marko-ilmkreis Would you be able to elaborate a little on the additional variables?

• For vacc_center, we might be able to use the externalId of a facility. However, I fear that this might not be reliable enough and would actually require an additional field.
• For STIKO prioritization, I cannot identify a clear association of variables to the §§ in the legal text. Ideally, these fields would not only be used in germany but also available to any users. Do you maybe know more about this?

Here a first preliminary mapping: DIM_Mapping_210802.xlsx (based on the Handout)

@markusmann-vg @JaquM FYI

[marko-arn]

@kwa20 Unfortunately we are still not having access to DIM.

As far as I see from the §§ vacc_center must be the "Kennnummer und Landkreis des Impfzentrums oder des in § 3 Absatz 1 Satz 1 Nummer 4 genannten Leistungserbringers,". In the excample it is an alpha-numeric value, which is defined by the Bundesdruckerei (?). One health office can have more than one vacc center (e.g. we will have two). Best option would be to have a separate facility type for that only showing in the immunizations module.

For the STIKO priorizations I also don't see a definition in the law, but I also guess that they might changing them according to their immunization strategy.