Page History
Contributors: Igor Engel, Thomas Ganslandt
Background
The §21 dataset is a German benchmarking dataset mandated by the law on hospital reimbursement (Paragraph 21: "Übermittlung und Nutzung von Daten - des Gesetzes über die Entgelte für voll- und teilstationäre Krankenhausleistungen" (Krankenhausentgeltgesetz - KHEntgG)). It is primarily used to derive the German inpatient billing system based on Diagnosis Related Groups (DRGs) and has to be provided by every German hospital on a yearly basis. It is thus supported by all hospital patient administration and billing systems established in Germany. Due to its standardization and high availability, the §21 dataset has been established as a source dataset for benchmarking projects and other regional and national collaborations. It is thus also an ideal candidate for a "quick win" i2b2 implementation, as its format is well-structured and documented and it can be produced easily by any German hospital, rapidly providing a functional prototype with local data.
| Note |
|---|
It should be noted, however, that the §21 dataset is primarily reimbursemenetreimbursement-oriented, which may limit its usefulness in the research area. |
The §21 dataset is based on a standard delimited ("CSV" = comma separated values) format with the following files and contents of interest, among others (full specification in German language)
...
After the initial import, the §21 dataset would be represented in i2b2 in a very low-level format still close to the source CSV files: all coded items would just be displayed with their codes (and not the related names), and items that relate to large, hierarchical terminologies (e.g. ICD diagnosis classification) would be presented as very long lists. In a final post-processing step, the relevant standard terminologies (in this case ICD10, OPS and G-DRG) as well as §21-specific codelists (e.g. for admission type, clinical service) are imported and merged with the dataset to provide a well-structured and human-readable hierarchical representation (see figure below).
Raw import | Import after terminology integration |
|---|---|
|
|
Importing §21 files with the IDRT Import & Mapping Tool
...
Name | Description |
|---|---|
Truncate i2b2 Project? | If you check this, the project will be truncated before the data is uploaded. |
Truncate Previous Queries? | This will truncate the previous queries tables. |
Set patient_count after import | This will fill the c_totalnum column. |
P21 Folder | Here you can select the folder that contains all P21 files you want to upload. |
P21 Version | Here you can select the corresponding version for your P21 dataset. |
Date Pattern | Select the date pattern used in the P21 Files. |
Save Settings? | This will save the settings for the next import. Note: The truncate checkboxes are never saved. |
...
