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
Draft IDEA4RC DataModel Patient Sex Race BirthYear CountryOfResidence Smoking CigarettesOrCigarsSmokedPerDay Alcohol BMI CharlsonComorbidityIndex Comorbidity MyocardialInfarction CongestiveHeartFailure PeripheralVascularDisease CerebrovascularAccidentExceptHemiplegia Dementia ChronicPulmonaryDisease ConnectiveTissueDisease Ulcer MildLiverDisease ModerateToSevereLiverDisease DiabetesWithoutComplications DiabetesWithEndOrganDamage Hemiplegia ModerateToSevereRenalDisease SolidTumorNonMetastatic MetastaticSolidTumor Leukemia Lymphoma MultipleMyeloma Aids ecogPS ecogPS KarnofsyIndexAtDiagnosis KarnofsyIndexLabel NoGeneticSyndromeWho2020 OlliersDisease MaffuciSyndrome liFraumeniSyndrome mcCuneAlbrightSyndrome MultipleOsteochondromas NeurofibromatosisType1 rothmundThomsonSyndrome WernerSyndrome Retinoblastoma PagetDisease OtherGeneticSyndromeWho2020 OccurrenceOfOtherCancer PreviousCancerTreatment HospitalData hospitalName HospitalPatientRecords patient hospitalData dateOfFirstContactWithTheHospital PatientFollowUp Patient statusAtLastFollowUp PatientFollowUpDate NewCancerDiagnosis DateOfNewCancerDiagnosis NewCancerTopography LastContact CancerEpisode Patient dateOfDiagnosis TypeOfBiopsy BiopsyDoneBy AgeAtDiagnosis RadiotherapyInducedSarcoma Grading HistologySquamous HistologyAdenocarcinoma HistologyNeuroendocrine HistologyOdontogenicCarcinoma HistologySNUC HistologySubgroupAdipocyticTumours histologySubgroupFmtTumours histologySubgroupSocalledFibrohistiocyticTumours VascularTumours pericyticPerivascularTumours SmoothMuscleTumours SkeletalMuscleTumours chondroOsseousTumours PeripheralNerveSheathTumours TumoursOfUncertainDifferentiation undifSmallRCelSarcBonAndSofTis estAndRelatedTumours MiscellaniousMesenchimalTumors MixedEpithelialAndMesenchymalTumours NasalCavityAndParanasalSinusesSubsite NasopharynxSubsite HypopharynxSubsite OropharynxSubsite LarynxSubsite OralCavitySubsite LipSubsite UpperAndLowerLimbsSubsite TrunkWallSubsite IntraAbdominalSubsite IntraThoracicSubsite GenitoUrinarySubsite HeadAndNeckSubsite BreastSubsite OtherSubsite TumorSize Depth BiopsyMitoticCount PlasmaticEbvDnaAtBaseline HpvStatus crpCReactiveProteinTested EpisodeEvent cancerEpisode EventType DefinedAt DateOfEpisode HnStage episodeEvent Ct Cn Cm Pt Pn Pm rEne StagingClassification SoftTissue DistantLymphNode Lung Bone Liver Pleura Peritoneum Brain OtherViscera Unknown SarcomaStage episodeEvent Localised locoRegional RegionalNodalMetastases SoftTissue DistantLymphNode Lung Bone Liver Pleura Peritoneum Brain OtherViscera Unknown PathologicalReportInfo episodeEvent DegreeOfCytologicAtypia PatternOfGrowth MitoticActivity InfiltrationOfSurroundingMyometrium TypeOfNecrosis expressionOfErPr VascularIntrusionOrInvasion P16AndP53Expression GeneticTestExpression episodeEvent GeneExpressionAnalysisPerformed DateOfGeneExpression GeneMutationAnalysisPerformed DateOfGeneMutation TestsForChromosomeTranslocationsPerformed DateOfTraslocation ngsPerformed DateOfNgs pcrTestPerformed DateOfPcr ImmunohistochemistryPerformed DateOfImmunohistochemistry ctDnaPerformed DateOfCtdna Surgery episodeEvent SurgeryType SurgeryHospital DateOfSurgery SurgeryIntention TypeOfSurgicalApproachOnTumour MarginsAfterSurgery TumorRupture SurgicalSpecimenMitoticCount SurgicalSpecimenGradingOnlyInUntreatedTumours IsolatedLimbPerfusion Reconstruction NeckSurgery DateOfNeckSurgey LateralityOfTheDissection SurgeryOnM DateOfSurgeryOnM siteOfSurgeryOnMetastasisSoftTissue siteOfSurgeryOnMetastasisDistantLymphNodes siteOfSurgeryOnMetastasisLung siteOfSurgeryOnMetastasisBone siteOfSurgeryOnMetastasisLiver siteOfSurgeryOnMetastasisPleura siteOfSurgeryOnMetastasisPeritoneum siteOfSurgeryOnMetastasisBrain siteOfSurgeryOnMetastasisOtherViscera siteOfSurgeryOnMetastasisUnknown surgicalComplications SystemicTreatment episodeEvent TypeOfSystemicTreatment Intent Setting ChemotherapyInfo StartDateSystemicTreatment EndDateSystemicTreatment numberOfCyclesAdministrations StartDateRegimenChanged EndDateRegimenChanged ReasonForEndOfTreatment treatmentResponse Radiotherapy episodeEvent Radiotherapy Intent Setting BeamQuality otherSpecify TreatmentTechnique totalDoseGy NumberOfFractions AdaptiveRt igrt StartDate EndDate PrimaryOnly NeckOnly PrimaryAndIpsilateralNeck PrimaryAndBilateralNeck DistantMetastasis Lung Mediastinum Bone SoftTissue Liver TreatmentCompletedAsPlanned? RegionalDeepHyperthemia Rdh_Startdate Rdh_Enddate ClinicalTreatmentResponse OtherLocalTreatment episodeEvent episodeEvent StartDate EndDate IsolatedlimbperfusionReference treatmentResponse IsolatedLimbPerfusion episodeEvent episodeEvent StartDate EndDate treatmentResponse DrugsForTreatments drugTreatment Drug TreatmentResponse episodeEvent treatmentResponse treatmentResponseDefinedDone AdverseEvent episodeEvent adverseEventType AdverseEventStartingDate AdverseEventDuration The relations to AdverseEvent are a XOR s 1 1..N 1 1..N 1 0..N 1 0..N 1 1..N 1 0..1 1 0..1 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 1 0..N 0..N 1 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