Data Model - SE:dip




UML



Table




Parameter NameParameter Type

Code System / Value Set or Pattern

Multiplicity

Comments

Questions

JSON Object/Attribute Mapping

"application/json"

Mapping

ExomAG / HGQN Data Model


1







2

Patient






patient
3IDID-StringPseudonym ID1

patient.id
4Gender

Coding:

Code

Administrative Gender:

CodeDisplay
maleMännlich
femaleWeiblich
otherDivers
unknownUnbekannt
1

patient.genderCase.sex
5BirthdateYearMonthyyyy-MM1

Age (in years|months) will be computed by the application for display


patient.birthDateCase.dateOfBirth
6Date Of DeathDate
0...1



7Municipality CodeString
1



8Site

Coding:

Code

DNPM Site-ID

(Submitter)


0...1

Will be set by DNPM:DIP system upon import of a data set


patient.managingSite
9






10PatientReference[Patient]
1



11

TODO








12









13









14

Episode Of Care


Behandlungs-Episode/-Fall




case
15IDID-String
1

case.idCase.internalCaseID
16Custodian / Managing Org.ID-StringOrganization ID1



17Transfer TANID-StringTransfer TAN "Modellvorhaben" (TVN)1



18PeriodPeriod (Start and (optional) end date)Datum des ersten Kontakts/Überweisung an das ZSE1



19







20

Diagnosis






diagnosis
21IDID-String
1

diagnosis.id
22PatientReference[Patient]
1

diagnosis.patient
23Onset Age

Quantity:

value + unit

time unit: Months or Years0...1

diagnosis.onsetAgeCase.ageIn{Months|Years}
24(Genetic) Verification StatusCoding
CodeDisplay
unsolved

Keine genetische Diagnosestellung

unclearGenetische Verdachtsdiagnose
solvedGenetische Diagnose gesichert
partially-solved

Klinischer Phänotyp nur partiell gelöst






25Disease Category / Type

Coding:

Code + System (+ Version?)

Orphanet Rare Disease Ontology (ORDO)

or

ICD-10-GM

or

OMIM

1...N
OMIM: Licensing to clarifydiagnosis.categoriesCase.diseaseCategory
26







27

Hospitalization








28PeriodPeriod (Start and (optional) end date)
0...1



29DurationDuration [Days]
1



30







31

HPO-Term






Object entry in Array hpoTerms
32IDID-String
1

hpoTerms[n].id
33PatientReference[Patient]
1

hpoTerms[n].patient
34Onset DateYearMonth
1



35Status HistoryStatus
0...N



36Value

Coding:

Code

Human Phenotype Ontology1

hpoTerms[n].valueCase.hpoTerms (respective value)
37

Status








38StatusCoding
CodeDisplay
improvedVerbessert
worsenedVerschlechtert
resolvedWeggefallen





39DateDate





40







41

Observation: GMFCS








42IDID-String
1



43PatientReference[Patient]
1



44DateDate
1



45Value

Coding:

Code

Gross Motor Function Classification System

CodeDisplay
ILevel I
IILevel II
IIILevel III
IVLevel IV
VLevel V
1



46







47

Lab








48IDID-String
1
Do we really need to model this in DNPM:DIP? What value does this information add?
Lab.labID
49NameString
1

Lab.label
50

NGS Report






Object entry in Array ngsReports
51IDID-String
1

ngsReports[n].id
52Sequencing LabReference[Lab]
1
Do we really need to model this in DNPM:DIP? What value does this information add?ngsReports[n].performingLabCase.sequencingLabID
53DateDate
0...1

ngsReports[n].recordedOnBase.befunddatum
54Type

Coding:

Code

CodeDisplay
panelPanel
exomeExome
genome-short-readGenome short-read
genome-long-readGenome long-read
1

ngsReports[n].sequencingTypeCase.testConducted
55Family Controls

Coding: Code

Family control level/depth

CodeDisplay
singlesingle
duoduo
triotrio
>3>3
1

familyControlsCase.singleDuoTrio
56Sequencing InfoObject: Sequencing Info
1

ngsReports[n].metaInfoCase.wetlabMetaInfo
57AutozygosityObservation: Autozygosity
0...1

ngsReports[n].autozygosity
58VariantsObservation: Variant
0...N

ngsReports[n].variants
59

Sequencing Info








60PlatformCoding
CodeDisplay
illuIllumina
ontONT
10xg10X Genomics
pacb

PacBio

mgiMGI
ugUltima Genomics
otherOther
1



61KitString
1



62

Observation: Autozygosity








63IDID-String
1

ngsReports[n].autozygosity.id
64PatientReference[Patient]
1

ngsReports[n].autozygosity.patient
65Value

Float

Range: 0 - 11
DEFINITION ???ngsReports[n].autozygosity.valueCase.autozygosity
66

Observation: Variant (Base class)








67IDID-String
1

ngsReports[n].variants[m].id
68PatientReference[Patient]
1

ngsReports[n].variants[m].id
69Gene(s)

Coding: Code

HGNC:ID0...NSystem will resolve the gene symbol from HGNC gene set for use as display
ngsReports[n].variants[m].genes
70LocalizationCoding


CodeDisplay
coding-regionCoding Region
splicing-regionSplicing Region
regulatory-regionRegulatory Region
intronicIntronic
intergenicIntergenic

0...N





71gDNA ChangeCoding: Code



ngsReports[n].variants[m].gDNAChange
72cDNA ChangeCoding: Code



ngsReports[n].variants[m].cDNAChange
73Protein changeCoding: Code



ngsReports[n].variants[m].proteinChange
74ACMG Class
CodeDisplay
1Benign
2Likely benign
3Uncertain significance
4Likely pathogenic
5Pathogenic
0...1

ngsReports[n].variants[m].acmgClass
75ACMG CriteriaObject: ACMG Criterion
0...N

ngsReports[n].variants[m].acmgCriteria
76ZygosityCoding: Code
CodeDisplay
heterozygousHeterozygous
homozygousHomozygous
comp-hetCompound heterozygous
hemiHemizygous
homoplasmicHomoplasmic
heteroplasmicHeteroplasmic
0...1

ngsReports[n].variants[m].zygosity
77Segregation AnalysisCoding: Code
CodeDisplay
not-performednot performed
de-novode-novo
from-fatherTransmitted from father
from-motherTransmitted from mother
0...1

ngsReports[n].variants[m].segregationAnalysis
78Mode of inheritanceCoding: Code
CodeDisplay
dominantDominant
recessiveRecessive
X-linkedX-linked
mitochondrialMitochondrial
unclearUnclear
0...1

ngsReports[n].variants[m].modeOfInheritance
79Significance for case
CodeDisplay
primaryVariant in context of patient's disease
incidentalIncidental finding
candidateCandidate variant
0...1

ngsReports[n].variants[m].significance
80ClinVar IDExternal ID [ClinVar]ClinVar variant ID0...1



81PublicationsReference[Publication]PubMed ID (or DOI?)0...N



82

Object: ACMG Criterion








83ValueCoding: Code

ACMG Criteria

CodeDisplay
PVS1
PS1
PS2
PS3
PS4
PM1
PM2
PM3
PM4
PM5
PM6
PP1
PP2
PP3
PP4
PP5
BA1
BS1
BS2
BS3
BS4
BP1
BP2
BP3
BP4
BP5
BP6
BP7
1



84ModifierCoding: Code
CodeDisplay
pvsvery strong pathogenic
psstrong pathogenic
pmmedium pathogenic
ppsupporting pathogenic
bastand-alone benign
bsstrong benign
bpsupporting benign
bmmedium benign
0...1



85







86

Structural Variant (SV): Variant






Object entry in Array ngsReports[n].variants
87ISCN DescriptionCoding: CodeISCN Description0...1

ngsReports[n].variants[m].iscnDescription-
88







89

Small Variant: Variant




SNVs and small indels


90ChromosomeCoding: CodeCode: { chr1 - chr22, chrX, chrY, chrMT }1



91PositionInt

GRCh38 coordinates in VCF-style

1



92RefStringref sequence in VCF-style1



93AltStringalternative/observed sequence in VCF-style1



94







95

Copy Number Variant (CNV): Variant








96ChromosomeCoding: CodeCode: { chr1 - chr22, chrX, chrY, chrMT }1



97Start PositionIntGRCh38 coordinate1



98End PositionIntGRCh38 coordinate1



99TypeCoding: Code

CNV Type

CodeDisplay
gainGain
lossLoss
1



100







101

Care Plan








102IDID-String
1



103PatientReference[Patient]
1



104Recording DateDate
1



105Sequencing RequestedBoolean
0...1



106Therapy RecommendationsObject: Therapy Recommendation
0...N



107Study Enrollment RecommendationObject: Study Enrollment Recommendation
0...1



108

Recommendation (Base Class)








109IDID-String
1



110PatientReference[Patient]
1



111DateDate
1



112Supporting VariantsReference[Variant]
0...N



113NotesString
0...1



114

Therapy Recommendation








115Therapy Type/CategoryCoding

???

CodeDisplay
symptomatic-therapySymptomatische nicht-medikamentöse Therapie (Fördermaßnahmen)
symptomatic-medication-administrationSymptomatische medikamentöse Therapie (bspw. antispastische Medikation)
symptomatic-interventionSymptomatische interventionelle Therapie (Operationen, Injektionen)
causal-medication-administrationKausale Therapie (medikamentös)
causal-interventionKausale Therapie (interventionell)
1



116MedicationCodingATC ???0...N



117

Study Enrollment Recommendation








118StudiesReference[Study]Study Number(s)0...N



119

Clinical Management Recommendation








120TypeCoding

Ref. TNAMSE

CodeDisplay
disease-specific-ambulatory-careIndikatorerkrankungsspezifische Ambulanz
university-ambulatory-careAndere Hochschulambulanz
local-crdEigenes ZSE
other-crdAnderes ZSE
other-ambulatory-careAndere Ambulanz
gpHausarzt
specialistNiedergelassener Facharzt





121







122

Therapy Follow-up Documentation








123HistoryTherapy
1...N



124

Therapy






therapy
125IDID-String
1

therapy.id
126PatientReference[Patient]
1

therapy.patient
127Recorded OnDate
1



128PeriodPeriod
0...1



129Type/CategoryCodingsee. Therapy Recommendation Type/Category1



130MedicationCodingsee. Therapy Recommendation Medication0...N



131NotesString
0...N

therapy.notes
132







133







134

PatientRecord








135PatientPatient
1

patient
136DiagnosisDiagnosis
1

diagnosis
137CaseCase
1

case
138HPO-TermsObservation: HPO-Term
1...N

hpoTerms
139GMFCS Status HistoryObservation: GMFCS
0...N



140HospitalizationHospitalization
0...1



141Care PlansCare Plan
1...N



142NGS-ReportNGS-Report
0...N

ngsReports
143Therapy DocumentationTherapy
0...N

therapy

API Docs

Documentation of the DNPM:DIP node's "ETL API", i.e. for upload of RD Patient Record data, can be found at:

https://github.com/KohlbacherLab/dnpm-dip-api-gateway/tree/main/app/controllers#example-data-and-etl-api

This also includes an endpoint to get a JSON Schema of the representation of an RD Patient Record.

Demo System

A Demo System exposing the above REST API is available at: https://dnpm.bwhealthcloud.de

IMPORTANT: This System is meant for demonstration/testing purposes only – DO NOT use its validation endpoint with real data! The validation API will also be available in your local installation of the DNPM:DIP node, so you will eventually be able to validate your real data in a protected local operations setting.

Quick Links: