IDEA4RC FHIR Implementation Guide
1.0.0 - release 150

IDEA4RC FHIR Implementation Guide - Downloaded Version 1.0.0 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