search

SORMAS-Foundation / SORMAS-Project

SORMAS (Surveillance, Outbreak Response Management and Analysis System) is an early warning and management system to fight the spread of infectious diseases.
https://sormas.org
GNU General Public License v3.0
293 stars 143 forks source link

Recovering certificate for DE - calculation of the peroids (28 days and 6 months after pos. PCR) #5394

Open marko-arn opened 3 years ago

marko-arn commented 3 years ago

Situation Description

Since last Friday in Germany the recovered cases are treated for 6 months after the infection like a persons with a negative rapid test or with vaccination.

Therefore they can obtain a confirmation from the health office. This certifcate confirms when they had the last positive PCR-Test and shows the relevant peroid according the the law (from 28 days after the test up to 6 months after the test)

We are currently printing the certificates for all recovered people in the past, but in future they get it through some workflow within Sormas. For that workflow a calculattion of the period is needed for the document generation (or in the database itself).

Feature Description

Introducing an automated calculation for the period of the selected PCR-Test in the document generation. Currently we use custom fields for this, but its not very user-friendly ot calculate it by hand.

grafik

Possible Alternatives

Leave it like it is.

Additional Information

marko-arn commented 3 years ago

@syntakker could this maybe solved by fields during the document generation?

syntakker commented 3 years ago

@Marko-ilmkreisunder under the hood of the document generation is xdocreport and the velocity engine, which is quite powerful. I would assume that it is possible to do custom date calculations either at this level or inside the docx template using features of MS Word.

However some of the preformatting - such as the rendering of dates - is done within SORMAS, this might interfere with such an approach.

If it is however a feature that is widely used and standardized, it might be worth discussing whether to introduce the necessary fields. @MateStrysewske ?

marko-arn commented 3 years ago

@syntakker I thought it might more faster to have the date calculated in the document engine then to implement a new field.

I checked it before if it calculated in the word template but word cannot calculate dates in mergefields. Its possible to add numbers to the days, but it's not changing the months. So e. G. adding 6 days to the 25.04. produces a 31.04..

kwa20 commented 3 years ago

@Marko-ilmkreis I see this request coming up here and there but I'm having a hard time thinking of ways to solve this by implementing fields in Sormas itself because they will be very unsustainable. What is the current approach or workflow with these documents?

marko-arn commented 3 years ago

@kwa20 If there are restrictions on public life, all recovered persons have the same rights as fully vaccinated or tested persons. This is regulated in the "COVID-19-Schutzmaßnahmen-Ausnahmenverordnung – SchAusnahmV".

A person is recovered "if the underlying testing has been done by laboratory diagnosis using nucleic acid detection (PCR, PoC-PCR, or other methods of nucleic acid amplification technology) and has been done at least 28 days and not more than 6 months ago."

Each recovered person receives from our health department at the end of the isolation a cancellation notice, as well as a proof of recovery according to §WER of the above regulation. So far, the above period is calculated manually.

marko-arn commented 3 years ago

@kwa20 according to the federal government's "COVID-19 Protective Measures Exemption Ordinance - SchAusnahmV" (https://www.bmjv.de/SharedDocs/Gesetzgebungsverfahren/Dokumente/Verordnungsentwurf_Corona-Impfung.pdf?__blob=publicationFile&v=7), recovered persons are equal to fully vaccinated and tested persons.

According to this regulation, a recovered person is an asymptomatic person who is in possession of a certificate of recovery issued to him or her.

This certificate of recovery is proof of the presence of a previous infection with the SARS-CoV-2 coronavirus ... if the underlying test was performed by laboratory diagnostics using nucleic acid detection (PCR, PoC-PCR or other methods of nucleic acid amplification technology) and was done at least 28 days and not more than 6 months ago.

The certificate of recovery is specified accordingly in the Thuringian Regulation in §2 Para. 2 No. 13b (https://www.tmasgff.de/fileadmin/user_upload/Gesundheit/COVID-19/Verordnung/Lesefassung_ThuerSARS-CoV-2-IfS-MassnVO_01.06.2021.pdf) and is a medical or official certificate. This should be the same or similar in all federal states.

Since the health authorities usually arrange the tests, the data are available in Sormas.

In our district, each person who has recovered receives a notice of cancellation of isolation. The second page of the notice is designed as proof of recovery (https://www.ilm-kreis.de/media/custom/2778_2033_1.PDF?1620896031). However, until now, the periods of 28 days to 6 months after testing must be calculated manually, which is very time-consuming and prone to error.