IDEA4RC FHIR Implementation Guide, published by IDEA4RC Project. This guide is not an authorized publication; it is the continuous build for version 0.1.0 built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/hl7-eu/idea4rc/ and changes regularly. See the Directory of published versions
IDEA4RC Detailed ERD Model
IDEA4RC Common data Model (ERD)
The following diagram provide a description of the IDEA4RC MODEL expressed as ERD
IDEA4RC DataModel Draft IDEA4RC DataModel Patient sex race birthYear countryOfResidence smoking cigarettesPackYearsSmokedDuringLife alcohol height/weight charlsonComorbidityIndex comorbidity myocardialInfarction congestiveHeartFailure peripheralVascularDisease cerebrovascularAccident dementia chronicPulmonaryDisease connectiveTissueDisease ulcer mildLiverDisease moderateToSevereLiverDisease diabetes diabetesWithEndOrganDamage hemiplegia moderateToSevereRenalDisease solidTumor metastaticSolidTumor leukemia lymphoma multipleMyeloma aids easternCooperativeOncologyGroupPerformanceStatusAtDiagnosis ecogPsLabel karnofsyIndexAtDiagnosis karnofsyIndexLabel noGeneticSyndrome olliersDisease maffuciSyndrome liFraumeniSyndrome mccuneAlbrightSyndrome multipleOsteochondromas neurofibromatosisType1 rothmundThomsonSyndrome wernerSyndrome retinoblastoma pagetDisease otherGeneticSyndrome previousMalignantCancerSite previousCancerTreatment HospitalData hospitalName HospitalPatientRecords patient hospital dateOfFirstContactWithTheHospital PatientFollowUp patient statusOfPatientAtLastFollowUp statusOfDiseaseAtLastFollowUp patientFollowUpDate newCancerDiagnosis dateOfNewCancerDiagnosis newCancerTopography lastContact CancerEpisode patient cancerStartDate EpisodeEvent cancerEpisode diseaseStatus definedAt dateOfEpisode Diagnosis cancerEpisode dateOfDiagnosis typeOfBiopsy biopsyDoneBy ageAtDiagnosis radiotherapyInducedSarcoma biopsyGrading histologyGroup site histologySubGroup subsite diagnosisCode tumorSize superficialDepth deepDepth biopsyMitoticCount mitoticIndex plasmaticEbvDnaAtBaseline hpvStatus crp-CReactiveProteinTested episodeEvent localised numberOfTumorNodules locoRegional isTransitMetastasisWithClinicalConfirmation isMultifocalTumor RegionalNodalMetastases softTissues distantLymphNode lung metastasisatbone liver pleura peritoneum brain otherViscera PathologicalStage diagnosis diagnosis imagingForPrimarySite ctForPrimarySite mriForPrimarySite usForPrimarySite otherImagingForPrimarySite imagingForNeck ctForNeck mriForNeck usForNeck otherImagingForNeck imagingForMetastasis ctForMetastasis mriForMetastasis usForMetastasis otherImagingForMetastasis pt pn pm extraNodalExtension sentinelNode pathologicalStaging localised numberOfTumorNodules locoRegional isTransitMetastasisWithClinicalConfirmation isMultifocalTumor regionalNodalMetastases softTissues distantLymphNode lung metastasisatbone liver pleura peritoneum brain otherViscera unknown ClinicalStage diagnosisReference stagingProceduresDoneBy imagingForPrimarySite ctForPrimarySite mriForPrimarySite usForPrimarySite otherImagingForPrimarySite imagingForNeck ctForNeck mriForNeck usForNeck otherImagingForNeck imagingForMetastasis ctForMetastasis mriForMetastasis usForMetastasis otherImagingForMetastasis ct cn cm extraNodalExtension clinicalStaging localised numberOfTumorNodules locoRegional isTransitMetastasisWithClinicalConfirmation isMultifocalTumor regionalNodalMetastases softTissues distantLymphNode lung metastasisatbone liver pleura peritoneum brain otherViscera unknown GeneticTestExpression diagnosisReference episodeEvent geneExpressionAnalysisPerformed dateOfGeneExpression geneMutationAnalysisPerformed dateOfGeneMutation testsForChromosomeTranslocationsPerformed dateOfTranslocation nextGenerationSequencingPerformed dateOfNgs polymeraseChaniReactionTestPerformed dateOfPcr immunohistochemistryPerformed dateOfImmunohistochemistry circulatingTumorDnaPerformed dateOfCtdna Surgery diagnosisReference episodeEvent surgeryType surgeryHospital dateOfSurgery surgeryIntention typeOfSurgicalApproachOnTumour marginsAfterSurgery tumorRupture extraNodalExtension surgicalSpecimenMitoticCount surgicalSpecimenGradingOnlyInUntreatedTumours reconstruction neckSurgery dateOfNeckSurgery lateralityOfTheDissection surgeryOnM dateOfSurgeryOnM siteOfSurgeryOnMetastasisSoftTissue siteOfSurgeryOnMetastasisDistantLymphNodes siteOfSurgeryOnMetastasisLung siteOfSurgeryOnMetastasisBone siteOfSurgeryOnMetastasisLiver siteOfSurgeryOnMetastasisPleura siteOfSurgeryOnMetastasisPeritoneum siteOfSurgeryOnMetastasisBrain siteOfSurgeryOnMetastasisOtherViscera siteOfSurgeryOnMetastasisUnknown surgicalComplications SystemicTreatment diagnosisReference episodeEvent systemictreatmentHospital typeOfSystemicTreatment intent setting chemotherapyInfo startDateSystemicTreatment endDateSystemicTreatment numberOfCyclesAdministrations regimen startDateRegimenChanged endDateRegimenChanged reasonForEndOfTreatment treatmentResponse Radiotherapy diagnosisReference episodeEvent radiotherapyHospital intent setting beamQuality otherSpecify treatmentTechnique totalDoseGy totalHighDose numberOfFractions adaptiveRt igrt reirradiation fieldOfReirradiation startDate endDate treatmentSitePrimaryOnly treatmentSiteNeckOnly treatmentSitePrimaryAndIpsilateralNeck treatmentSitePrimaryAndBilateralNeck treatmentSiteDistantMetastasis metastaticTreatmentSiteLung metastaticTreatmentSiteMediastinum metastaticTreatmentSiteBone metastaticTreatmentSiteSoftTissue metastaticTreatmentSiteLiver rtTreatmentCompletedAsPlanned? regionalDeepHyperthemia treatmentResponse IsolatedLimbPerfusion diagnosisReference episodeEvent isolatedLimbPerfusionHospital startDate endDate treatmentResponse DrugsForTreatments SystemicTreatment otherLocalTreatment isolatedLimbPerfusion drug OverallTreatmentResponse diagnosisReference episodeEvent overallTreatmentResponse overallTreatmentResponseDefinedDone RegionalDeepHyperthemia diagnosisReference episodeEvent regionaldeephyperthemiaDoneAtHospital startDate endDate treatmentResponse AdverseEvent treatmentReference adverseEventType adverseEventStartingDate adverseEventDuration The relations to AdverseEvent are a XOR 1 1..N 1 1..N 1 0..N 1..N 1 1 1..N 1 0..N 0..1 1 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..1 1 0..N 1 0..N 1 0..1 1 0..1 1 0..N 1 0..N 1 0..N 1 0..N 1 0..1 1 0..N 1 0..N 0..N 1 1 0..N 1 0..N 1 0..N Text color: Blue -> H&N, Sarc. Red -> H&N Green -> Sarc. - ---- Shapes: red -> Mandatory yellow -> Recommended green -> Optional - ---- Each variable (and entity if needed) is related to the datamodels, HN means Head and Neck S means Sarcoma