IDEA4RC FHIR Implementation Guide
1.0.0 - release 150

This page is part of the IDEA4RC FHIR Implementation Guide (v1.0.0: QA Preview) based on FHIR (HL7® FHIR® Standard) R4. This is the current published version. For a full list of available versions, 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 DataModelDraftIDEA4RC DataModelPatientsexracebirthYearcountryOfResidencesmokingcigarettesPackYearsSmokedDuringLifealcoholheight/weightcharlsonComorbidityIndexcomorbiditymyocardialInfarctioncongestiveHeartFailureperipheralVascularDiseasecerebrovascularAccidentdementiachronicPulmonaryDiseaseconnectiveTissueDiseaseulcermildLiverDiseasemoderateToSevereLiverDiseasediabetesdiabetesWithEndOrganDamagehemiplegiamoderateToSevereRenalDiseasesolidTumormetastaticSolidTumorleukemialymphomamultipleMyelomaaidseasternCooperativeOncologyGroupPerformanceStatusAtDiagnosisecogPsLabelkarnofsyIndexAtDiagnosiskarnofsyIndexLabelnoGeneticSyndromeolliersDiseasemaffuciSyndromeliFraumeniSyndromemccuneAlbrightSyndromemultipleOsteochondromasneurofibromatosisType1rothmundThomsonSyndromewernerSyndromeretinoblastomapagetDiseaseotherGeneticSyndromepreviousMalignantCancerSitepreviousCancerTreatmentHospitalDatahospitalNameHospitalPatientRecordspatienthospitaldateOfFirstContactWithTheHospitalPatientFollowUppatientstatusOfPatientAtLastFollowUpstatusOfDiseaseAtLastFollowUppatientFollowUpDatenewCancerDiagnosisdateOfNewCancerDiagnosisnewCancerTopographylastContactCancerEpisodepatientcancerStartDateEpisodeEventcancerEpisodediseaseStatusdefinedAtdateOfEpisodeDiagnosiscancerEpisodedateOfDiagnosistypeOfBiopsybiopsyDoneByageAtDiagnosisradiotherapyInducedSarcomabiopsyGradinghistologyGroupsitehistologySubGroupsubsitediagnosisCodetumorSizesuperficialDepthdeepDepthbiopsyMitoticCountmitoticIndexplasmaticEbvDnaAtBaselinehpvStatuscrp-CReactiveProteinTestedepisodeEventlocalisednumberOfTumorNoduleslocoRegionalisTransitMetastasisWithClinicalConfirmationisMultifocalTumorRegionalNodalMetastasessoftTissuesdistantLymphNodelungmetastasisatboneliverpleuraperitoneumbrainotherVisceraPathologicalStagediagnosisdiagnosisimagingForPrimarySitectForPrimarySitemriForPrimarySiteusForPrimarySiteotherImagingForPrimarySiteimagingForNeckctForNeckmriForNeckusForNeckotherImagingForNeckimagingForMetastasisctForMetastasismriForMetastasisusForMetastasisotherImagingForMetastasisptpnpmextraNodalExtensionsentinelNodepathologicalStaginglocalisednumberOfTumorNoduleslocoRegionalisTransitMetastasisWithClinicalConfirmationisMultifocalTumorregionalNodalMetastasessoftTissuesdistantLymphNodelungmetastasisatboneliverpleuraperitoneumbrainotherVisceraunknownClinicalStagediagnosisReferencestagingProceduresDoneByimagingForPrimarySitectForPrimarySitemriForPrimarySiteusForPrimarySiteotherImagingForPrimarySiteimagingForNeckctForNeckmriForNeckusForNeckotherImagingForNeckimagingForMetastasisctForMetastasismriForMetastasisusForMetastasisotherImagingForMetastasisctcncmextraNodalExtensionclinicalStaginglocalisednumberOfTumorNoduleslocoRegionalisTransitMetastasisWithClinicalConfirmationisMultifocalTumorregionalNodalMetastasessoftTissuesdistantLymphNodelungmetastasisatboneliverpleuraperitoneumbrainotherVisceraunknownGeneticTestExpressiondiagnosisReferenceepisodeEventgeneExpressionAnalysisPerformeddateOfGeneExpressiongeneMutationAnalysisPerformeddateOfGeneMutationtestsForChromosomeTranslocationsPerformeddateOfTranslocationnextGenerationSequencingPerformeddateOfNgspolymeraseChaniReactionTestPerformeddateOfPcrimmunohistochemistryPerformeddateOfImmunohistochemistrycirculatingTumorDnaPerformeddateOfCtdnaSurgerydiagnosisReferenceepisodeEventsurgeryTypesurgeryHospitaldateOfSurgerysurgeryIntentiontypeOfSurgicalApproachOnTumourmarginsAfterSurgerytumorRuptureextraNodalExtensionsurgicalSpecimenMitoticCountsurgicalSpecimenGradingOnlyInUntreatedTumoursreconstructionneckSurgerydateOfNeckSurgerylateralityOfTheDissectionsurgeryOnMdateOfSurgeryOnMsiteOfSurgeryOnMetastasisSoftTissuesiteOfSurgeryOnMetastasisDistantLymphNodessiteOfSurgeryOnMetastasisLungsiteOfSurgeryOnMetastasisBonesiteOfSurgeryOnMetastasisLiversiteOfSurgeryOnMetastasisPleurasiteOfSurgeryOnMetastasisPeritoneumsiteOfSurgeryOnMetastasisBrainsiteOfSurgeryOnMetastasisOtherViscerasiteOfSurgeryOnMetastasisUnknownsurgicalComplicationsSystemicTreatmentdiagnosisReferenceepisodeEventsystemictreatmentHospitaltypeOfSystemicTreatmentintentsettingchemotherapyInfostartDateSystemicTreatmentendDateSystemicTreatmentnumberOfCyclesAdministrationsregimenstartDateRegimenChangedendDateRegimenChangedreasonForEndOfTreatmenttreatmentResponseRadiotherapydiagnosisReferenceepisodeEventradiotherapyHospitalintentsettingbeamQualityotherSpecifytreatmentTechniquetotalDoseGytotalHighDosenumberOfFractionsadaptiveRtigrtreirradiationfieldOfReirradiationstartDateendDatetreatmentSitePrimaryOnlytreatmentSiteNeckOnlytreatmentSitePrimaryAndIpsilateralNecktreatmentSitePrimaryAndBilateralNecktreatmentSiteDistantMetastasismetastaticTreatmentSiteLungmetastaticTreatmentSiteMediastinummetastaticTreatmentSiteBonemetastaticTreatmentSiteSoftTissuemetastaticTreatmentSiteLiverrtTreatmentCompletedAsPlanned?regionalDeepHyperthemiatreatmentResponseIsolatedLimbPerfusiondiagnosisReferenceepisodeEventisolatedLimbPerfusionHospitalstartDateendDatetreatmentResponseDrugsForTreatmentsSystemicTreatmentotherLocalTreatmentisolatedLimbPerfusiondrugOverallTreatmentResponsediagnosisReferenceepisodeEventoverallTreatmentResponseoverallTreatmentResponseDefinedDoneRegionalDeepHyperthemiadiagnosisReferenceepisodeEventregionaldeephyperthemiaDoneAtHospitalstartDateendDatetreatmentResponseAdverseEventtreatmentReferenceadverseEventTypeadverseEventStartingDateadverseEventDurationThe relations to AdverseEvent are a XOR11..N11..N10..N1..N111..N10..N0..1110..N10..N10..N10..N10..N10..N10..110..N10..N10..110..110..N10..N10..N10..N10..110..N10..N0..N110..N10..N10..NText color:Blue -> H&N, Sarc.Red -> H&NGreen -> Sarc.-----Shapes:red -> Mandatoryyellow -> Recommendedgreen -> Optional-----Each variable (and entity if needed) is related to the datamodels,HN means Head and NeckS means Sarcoma