Common Data Models Harmonization
1.0.0 - STU 1 Publication
Common Data Models Harmonization
1.0.0 - STU 1 Publication
This page is part of the Common Data Models Harmonization FHIR IG (v1.0.0: STU 1) based on FHIR R4. This is the current published version. For a full list of available versions, see the Directory of published versions 
This section contains the mappings between the various CDMs, BRIDG and the FHIR Resources/profiles. In each mapping the CDM data element is mapped to the appropriate BRIDG data element and the FHIR Data Element. The column FHIR Resource/Profile/Extension identifies the specific profile and/or extension if one exists. If the profiles do not exist then they are mapped to the resource. New profiles and extensions will be added where necessary as the pilot implementations provide feedback.
The mappings use the US Core profiles, value sets and code systems where they exist and overlap with CDMH.
The mappings of the various CDMs to BRIDG data model which was used as the intermediary model in the CDMH project are documented in the following spreadsheet. BRIDG was chosen as the intermediary model as it was required for submitting data to FDA.
The table below outlines the mappings between PCORnet CDM version 4 and FHIR Resources/profiles and extensions.
| PCORnet Data Element | FHIR Data Element | FHIR Resource/Profile/Extension | BRIDG Mapping |
| Table : DEMOGRAPHICS | Patient | Person | |
| patid | Patient.id | CdmhPatient | Person : Subject.identifier(ID).identifier |
| birth_date | Patient.birthDate | CdmhPatient | Person.birthDate |
| birth_time | Patient.extension: patient-birthTime | CdmhPatient | Person.birthDate |
| sex | Patient.extension: us-core-birthsex | CdmhPatient | Person.sexGenotypeCode |
| sexual_orientation | Patient.extension: cdmh-patient-sexualOrientation | CdmhPatient | Person.sexualOrientationCode |
| gender_identity | Patient.extension: patient-genderIdentity | CdmhPatient | Person.genderIdentityCode |
| hispanic | Patient.extension: cdmh-pcornet-ethnicity | CdmhPatient | Person.ethnicGroupCode |
| race | Patient.extension: cdmh-pcornet-race | CdmhPatient | Person.raceCode |
| biobank_flag | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pat_pref_language_spoken | Patient.communication.language | CdmhPatient | Not mapped for CDMH project |
| Table : ENCOUNTER | Encounter | PerformedEncounter WHERE PerformedEncounter : DefinedSubjectActivityGroup.categoryCode = "Encounter" | |
| encounterid | Encounter.id | CdmhEncounter | PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| patid | Encounter.subject.id | CdmhEncounter | PerformedEncounter : Subject.identifier(ID).identifier |
| admit_date | Encounter.period.start | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| admit_time | Encounter.period.start | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| discharge_date | Encounter.period.end | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).high |
| discharge_time | Encounter.period.end | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).high |
| providerid | Encounter.participant.individual.id | CdmhEncounter, us-core-practitioner | PerformedEncounter : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| facility_location | Encounter.location.location.address | CdmhEncounter, CdmhLocation | PerformedEncounter : Place.physicalAddress(AD).item(ADXP).value WHERE PerformedActivity : Place.physicalAddress(AD).item(ADXP).partType = 'ZIP' |
| enc_type | Encounter.class | CdmhEncounter | PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| facilityid | Encounter.location.location.id | CdmhEncounter, CdmhLocation | PerformedEncounter : Place : ServiceDeliveryLocation : Organization : HealthcareFacility.identifier(DSET[ID]).item(ID).identifier |
| discharge_disposition | Encounter.hospitalization.dischargeDisposition | CdmhEncounter | PerformedEncounter : departs for : Place.typeCode |
| discharge_status | Encounter.hospitalization.extension: cdmh-pcornet-discharge-status | CdmhEncounter,CdmhLocation | PerformedEncounter : PerformedObservation : PerformedObservationResult.value(ANY = CD) WHERE PerformedObservation : DefinedObservation.nameCode = "SubjectStatusAtDischarge" |
| drg | Encounter.extension: cdmh-pcornet-drg-group | CdmhEncounter | PerformedEncounter.classificationCode(CD).code |
| drg_type | Encounter.extension : cdmh-pcornet-drg-version | CdmhEncounter | PerformedEncounter.classificationCode(CD).codeSystem |
| admitting_source | Encounter.hospitalization.extension: cdmh-pcornet-admitting-source-facility-type | CdmhEncounter, CdmhLocation | PerformedEncounter : arrives from : Place.typeCode |
| payer_type_primary | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| payer_type_secondary | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| facility_type | Encounter.location.location.type | CdmhEncounter, CdmhLocation | PerformedEncounter : Place : ServiceDeliveryLocation : Organization : HealthcareFacility |
| Table : ENROLLMENT | CdmhResearchStudy | PerformedAdministrativeActivity WHERE PerformedAdministrativeActivity : DefinedSubjectActivityGroup.categoryCode = "ObservationPeriod" | |
| patid | ResearchStudy.enrollment.member.entity.id | CdmhResearchStudy, CdmhGroup | PerformedAdministrativeActivity : Subject.identifier(ID).identifier |
| enr_start_date | ResearchStudy.enrollment.member.period | CdmhResearchStudy, CdmhGroup | PerformedAdministrativeActivity.dateRange(IVL[TS.DATETIME]).low |
| enr_end_date | ResearchStudy.enrollment.member.period | CdmhResearchStudy, CdmhGroup | PerformedAdministrativeActivity.dateRange(IVL[TS.DATETIME]).high |
| chart | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| enr_basis | ResearchStudy.enrollment.characteristic | CdmhResearchStudy, CdmhGroup | PerformedAdministrativeActivity.informationSourceTypeCode |
| Table : DIAGNOSIS | Encounter | PerformedDiagnosis | |
| diagnosisid | Encounter.diagnosis.condition.id | CdmhEncounter | PerformedDiagnosis : PerformedObservation.identifier(DSET[ID]).item(ID).identifier |
| patid | Encounter.subject.id | CdmhEncounter | PerformedDiagnosis : PerformedObservation : Subject.identifier.item(ID).identifier |
| encounterid | Encounter.id | CdmhEncounter | PerformedDiagnosis : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier.item(ID).identifier |
| enc_type | Encounter.class | CdmhEncounter | PerformedDiagnosis : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| admit_date | Encounter.period.start | CdmhEncounter | PerformedDiagnosis : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| providerid | Encounter.participant.individual.id | CdmhEncounter, us-core-practitioner | PerformedDiagnosis : PerformedObservation : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| dx | Encounter.diagnosis.condition.code (value) | CdmhEncounter | PerformedDiagnosis.value(ANY=CD).code |
| dx_type | Encounter.diagnosis.condition.code (system) | CdmhEncounter | PerformedDiagnosis.value(ANY=CD).codeSystem |
| dx_source | Encounter.diagnosis.use | CdmhEncounter | PerformedDiagnosis : PerformedObservation.timePointCode |
| dx_origin | Encounter.diagnosis.extension: cdmh-pcornet-diagnosis-origin | CdmhEncounter | PerformedDiagnosis : PerformedObservation.informationSourceTypeCode |
| pdx | Encounter.diagnosis.rank | CdmhEncounter | PerformedDiagnosis.priorityAtDischargeCode |
| dx_poa | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| Table : PROCEDURE | Procedure | PerformedProcedure | |
| procedureid | Procedure.id | CdmhProcedure | PerformedProcedure.identifier(DSET[ID]).item(ID).identifier |
| patid | Procedure.subject | CdmhProcedure | PerformedProcedure > Subject.identifier(ID).identifier |
| encounterid | Procedure.encounter | CdmhProcedure, CdmhEncounter | PerformedProcedure : PerformedCompositionRelationship : PerformedEncounter.identifier.item(ID).identifier |
| enc_type | Procedure.encounter.class | CdmhProcedure, CdmhEncounter | PerformedProcedure : PerformedCompositionRelationship : PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| admit_date | Procedure.encounter.period | CdmhProcedure, CdmhEncounter | PerformedProcedure : PerformedCompositionRelationship : PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| providerid | Procedure.encounter.participant.individual.id | CdmhProcedure,CdmhEncounter,us-core-practitioner | PerformedProcedure : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| px_date | Procedure.performedDateTime | CdmhProcedure | PerformedProcedure.dateRange(IVL[TS.DATETIME]).high |
| px | Procedure.code (value) | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode |
| px_type | Procedure.code (system) | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode(CD).codeSystemName |
| px_source | Procedure.code.extension: cdmh-pcornet-px-source | CdmhProcedure | PerformedProcedure.informationSourceTypeCode |
| ppx | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| Table : VITAL | Observation | PerformedClinicalResult WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.categoryCode = "Vital Signs" | |
| vitalid | Observation.id | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.identifier(DSET[ID]).item(ID).identifier |
| patid | Observation.subject | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : Subject.identifier(ID).identifier |
| encounterid | Observation.encounter | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| measure_date | Observation.effectiveDateTime | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).low |
| measure_time | Observation.effectiveDateTime | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).low |
| vital_source | Observation.code.extension: cdmh-pcornet-vital-source | CdmhVitalSigns | observation |
| ht | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.methodCode |
| wt | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Weight" |
| systolic | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult.typeCode = "Systolic" AND PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Blood Pressure" |
| diastolic | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult.typeCode = "Diastolic" AND PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Blood Pressure" |
| original_bmi | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "BMI" |
| bp_position | Observation.extension: cdmh-pcornet-body-position | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.bodyPositionCode |
| smoking | Observation.code,Observation.value[x] | us-core-smokingstatus | PerformedClinicalResult.value(ANY=CD).value WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Smoking" |
| tobacco | Observation.code,Observation.value[x] | us-core-observationresults | PerformedClinicalResult.value(ANY=CD).value WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Tobacco use" |
| tobacco_type | Observation.code,Observation.value[x] | us-core-observationresults | PerformedClinicalResult.typeCode WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Tobacco use" |
| Table : DISPENSING | MedicationDispense | PerformedStudyAgentTransfer WHERE PerformedStudyAgentTransfer : DefinedStudyAgentTransfer.nameCode = "Dispensing" | |
| dispensingid | MedicationDispense.id | CdmhMedicationDispense | PerformedStudyAgentTransfer.identifier(DSET[ID]).item(ID).identifier |
| patid | MedicationDispense.subject | CdmhMedicationDispense | PerformedStudyAgentTransfer : Subject.identifier(ID).identifier |
| prescribingid | MedicationDispense.authorizingPrescription.requester | CdmhMedicationDispense,CdmhMedicationRequest,us-core-practitioner | PerformedStudyAgentTransfer : {is the component of} : PerformedCompositionRelationship : {is the parent of} : PerformedSubstanceAdministration.identifier |
| dispense_date | MedicationDispense.whenHandedOver | CdmhMedicationDispense | PerformedStudyAgentTransfer.dateRange(IVL[TS_DATETIME]).high |
| ndc | MedicationDispense.medicationCodeableConcept | CdmhMedicationDispense | PerformedStudyAgentTransfer : Drug.code |
| dispense_sup | MedicationDispense.daysSupply | CdmhMedicationDispense | PerformedStudyAgentTransfer.daysSupply |
| dispense_amt | MedicationDispense.quantity | CdmhMedicationDispense | PerformedStudyAgentTransfer.quantity |
| dispense_dose_disp | MedicationDispense.dosageInstruction.doseAndRate.doseQuantity | CdmhMedicationDispense | Not mapped for CDMH project |
| dispense_dose_disp_unit | MedicationDispense.dosageInstruction.doseAndRate.doseQuantity | CdmhMedicationDispense | Not mapped for CDMH project |
| dispense_route | MedicationDispense.dosageInstruction.route | CdmhMedicationDispense | Not mapped for CDMH project |
| Table : LAB_RESULT_CM | Observation | PerformedClinicalResult | |
| lab_result_cm_id | Observation.id | CdmhLabResults | PerformedClinicalResult : PerformedObservation.identifier(DSET[ID]).item(ID).identifier |
| patid | Observation.subject | CdmhLabResults | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection : Subject.identifier(ID).identifier |
| encounterid | Observation.encounter | CdmhLabResultss | PerformedClinicalResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| lab_name | Observation.performer(organization).name | CdmhLabResults, CdmhOrganization | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).originalText |
| specimen_source | Observation.specimen.bodySite | CdmhLabResults,Specimen | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection.methodCode |
| lab_loinc | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).code |
| priority | Observation.Extension (Proposed Name: priority : Coding) | CdmhLabResults | PerformedClinicalResult : PerformedObservation.urgencyCode |
| result_loc | Observation.performer(organization).type | CdmhLabResults, CdmhOrganization | PerformedClinicalResult : PerformedObservation : Place.typeCode |
| lab_px | Observation.partOf (Procedure) | CdmhLabResults, us-core-procedure | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item(CD).code |
| lab_px_type | Observation.partOf (Procedure) | CdmhLabResults, us-core-procedure | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item(CD).codeSystem |
| lab_order_date | Observation.basedOn(ServiceRequest).occurenceDateTime | CdmhLabResults, ServiceRequest | PerformedClinicalResult : PerformedObservation.orderDate |
| specimen_date | Observation.specimen.collection.collectedDateTime | CdmhLabResults,Specimen | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection.dateRange(IVL[TS.DATETIME]).low |
| specimen_time | Observation.specimen.collection.collectedDateTime | CdmhLabResults,Specimen | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection.dateRange(IVL[TS.DATETIME]).low |
| result_date | Observation.issued | CdmhLabResults | PerformedClincalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).high |
| result_time | Observation.issued | CdmhLabResults | PerformedClincalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).high |
| result_qual | Observation.value[x] | CdmhLabResults | PerformedClinicalResult.value(ANY=CD).code WHERE value(ANY=CD).codeSystem = "LOINC" |
| result_num | Observation.value[x] | CdmhLabResults | IF Unit AND Modifier are present, PerformedClinicalResult.value(ANY=URG[PQ]) ELSE IF Unit present, PerformedClinicalResult.value(ANY=PQ).value, ELSE IF Modifier present, PerformedClinicalResult.value(ANY=URG[REAL]), ELSE PerformedClinicalResult.value(ANY=REAL).value |
| result_modifier | Observation.value[x] | CdmhLabResults | PerformedClinicalResult.value AND PerformedClinicalResult : PerformedClinicalResult.value |
| result_unit | Observation.value[x] | CdmhLabResults | PerformedClinicalResult.value(ANY=PQ).unit |
| norm_range_low | Observation.referenceRange.low | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).low |
| norm_modifier_low | Observation.referenceRange.modifierExtension | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).low |
| norm_range_high | Observation.referenceRange.high | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).high |
| norm_modifier_high | Observation.referenceRange.modifierExtension | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).high |
| abn_ind | Observation.interpretation | CdmhLabResults | PerformedClinicalResult.normalRangeComparisonCode |
| result_snomed | Observation.value[x](CodeableConcept) | CdmhLabResults | Not mapped for CDMH project |
| raw_lab_name | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| raw_result | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| Table : CONDITION | Condition | PerformedMedicalConditionResult | |
| conditionid | Condition.id | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation.identifier |
| patid | Condition.subject | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation : Subject.identifier.item(ID).identifier |
| encounterid | Condition.encounter | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier.item(ID).identifier |
| report_date | Condition.recordedDate | CdmhCondition | PerformedMedicalConditionResult.reportedDate |
| resolve_date | Condition.abatementDateTime | CdmhCondition | PerformedMedicalConditionResult.occurrenceDateRange(IVL[TS.DATETIME]).high |
| onset_date | Condition.onsetDateTime | CdmhCondition | PerformedMedicalConditionResult.occurrenceDateRange(IVL[TS.DATETIME]).low |
| condition_status | Condition.clinicalStatus | CdmhCondition | PerformedMedicalConditionResult.conditionStatusCode |
| condition | Condition.code | CdmhCondition | PerformedMedicalConditionResult.value(CD).code |
| condition_type | Condition.code | CdmhCondition | PerformedMedicalConditionResult.value(CD).codeSystem |
| condition_source | Condition.extension: cdmh-pcornet-condition-source | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation.informationSourceTypeCode |
| Table : PRO_CM | QuestionnaireResponse | PerformedObservationResult WHERE PerformedObservationResult : PerformedObservation : DefinedObservation.categoryCode = "Patient-Reported Outcome Item" | |
| pro_cm_id | QuestionnaireResponse.id | QuestionnaireResponse | PerformedObservationResult : PerformedObservation.identifier(DSET[ID]).item(ID).identifier |
| patid | QuestionnaireResponse.subject | QuestionnaireResponse | PerformedObservationResult : PerformedObservation : Subject.identifier(ID).identifier |
| encounterid | QuestionnaireResponse.encounter | QuestionnaireResponse | PerformedObservationResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| pro_type | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_item | QuestionnaireResponse.item.linkId, QuestionnaireResponse.questionnaire.item | QuestionnaireResponse | PerformedObservationResult : PerformedObservation : DefinedActivity.nameCode(CD).code |
| pro_item_loinc | QuestionnaireResponse.questionnaire.item.code | QuestionnaireResponse, Questionnaire | PerformedObservationResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item(CD).code WHERE translation.item.codeSystem = "LOINC" |
| pro_date | QuestionnaireResponse.authored | QuestionnaireResponse | PerformedObservationResult.createdDate |
| pro_time | QuestionnaireResponse.authored | QuestionnaireResponse | PerformedObservationResult.createdDate |
| pro_response | QuestionnaireResponse.item.answer | QuestionnaireResponse | PerformedObservationResult.value |
| pro_response_text | QuestionnaireResponse.item.answer | QuestionnaireResponse | PerformedObservationResult.value |
| pro_response_num | QuestionnaireResponse.item.answer | QuestionnaireResponse | PerformedObservationResult.value |
| pro_method | QuestionnaireResponse.Extension (Proposed Name: administration-method : CodeableConcept) | QuestionnaireResponse | PerformedObservationResult : PerformedObservation.methodCode |
| pro_mode | QuestionnaireResponse.source | QuestionnaireResponse | PerformedObservationResult : PerformedObservation : PerformedObservation : PerformedObservationResult.value(CD) WHERE PerformedObservationResult : PerformedObservation : PerformedObservation : DefinedObservation.nameCode(CD) = "ResponseMode" |
| pro_cat | QuestionnaireResponse.Extension (Proposed Name: administration-method : CodeableConcept) | QuestionnaireResponse | PerformedObservationResult : PerformedObservation.methodCode |
| pro_item_version | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_name | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_seq | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_score | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_theta | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_scaled_tscore | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_standard_error | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_count_error | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_loinc | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_version | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_item_fullname | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_item_text | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| pro_measure_fullname | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| Table : PRESCRIBING | MedicationRequest | PerformedSubstanceAdministration | |
| prescribingid | MedicationRequest.id | CdmhMedicationRequest | PerformedSubstanceAdministration.identifier(DSET[ID]).item(ID).identifier |
| patid | MedicationRequest.subject | CdmhMedicationRequest | PerformedSubstanceAdministration : Subject.identifier(ID).identifier |
| encounterid | MedicationRequest.encounter | CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| rx_providerid | MedicationRequest.requester | CdmhMedicationRequest, us-core-practitioner | PerformedSubstanceAdministration : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| rx_order_date | MedicationRequest.authoredOn | CdmhMedicationRequest | PerformedSubstanceAdministration.orderDate |
| rx_order_time | MedicationRequest.authoredOn | CdmhMedicationRequest | PerformedSubstanceAdministration.orderDate |
| rx_start_date | MedicationRequest.dispenseRequest.validityPeriod | CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.dateRange(IVL[TS.DATETIME]).low |
| rx_end_date | MedicationRequest.dispenseRequest.validityPeriod | CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.dateRange(IVL[TS.DATETIME]).high |
| rx_quantity | MedicationRequest.dispenseRequest.quantity | CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.quantity(PQ).value |
| rx_quantity_unit | MedicationRequest.dosageInstruction.doseAndRate.dose[x] | CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.quantity(PQ).unit |
| rx_refills | MedicationRequest.dispenseRequest.numberOfRepeatsAllowed | CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.orderedNumberOfRepeats |
| rx_days_supply | MedicationRequest.dispenseRequest.expectedSupplyDuration | CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.daysSupply |
| rx_frequency | MedicationRequest.dosageInstruction.timing | CdmhMedicationRequest | PerformedSubstanceAdministration.doseFrequencyCode |
| rx_basis | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| rxnorm_cui | MedicationRequest.medicationCodeableConcept | CdmhMedicationRequest | PerformedSubstanceAdministration : Drug.code(CD).code |
| rx_dose_ordered | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| rx_dose_ordered_unit | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| rx_route | Not mapped for CDMH project | Not mapped for CDMH project | Not mapped for CDMH project |
| Table : DEATH | AdverseEvent | AdverseEvent WHERE AdverseEvent : PerformedObservation : DefinedObservation.nameCode = "Death Information" | |
| patid | AdverseEvent.subject | CdmhAdverseEvent | AdverseEvent : PerformedObservation : Subject.identifier(ID).identifier |
| death_date | AdverseEvent.date | CdmhAdverseEvent | AdverseEvent |
| death_date_impute | AdverseEvent.recordedDate | CdmhAdverseEvent | AdverseEvent.occurrenceDateRange(IVL[TS.DATETIME]).low |
| death_source | AdverseEvent.extension: cdmh-pcornet-death-source | CdmhAdverseEvent | AdverseEvent : PerformedObservation.informationSourceTypeCode |
| death_match_confidence | AdverseEvent.extension: cdmh-pcornet-death-match-confidence | CdmhAdverseEvent | AdverseEvent.uncertaintyCode |
| Table : DEATH_CAUSE | AdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult WHERE PerformedObservationResult : PerformedObservation : DefinedObservation.nameCode = "Cause of Death Information" | |
| patid | AdverseEvent.subject | CdmhAdverseEvent | AdverseEvent > CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult : PerformedObservation : Subject.identifier(ID).identifier |
| death_cause | AdverseEvent.suspectedEntity.causality.extension: cdmh-pcornet-death-cause | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult.value(CD) |
| death_cause_code | AdverseEvent.suspectedEntity.causality.extension: cdmh-pcornet-death-cause-code | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult.value(ANY=CD).codeSystem |
| death_cause_type | AdverseEvent.suspectedEntity.causality.extension: cdmh-pcornet-death-cause-type | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : EvaluatedResultRelationship.probabilityCode |
| death_cause_source | AdverseEvent.suspectedEntity.causality.extension: cdmh-pcornet-death-cause-source | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult : PerformedObservation.informationSourceTypeCode |
| death_cause_confidence | AdverseEvent.suspectedEntity.causality.extension: cdmh-pcornet-death-cause-confidence | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult.uncertaintyCode |
The table below outlines the mappings between OMOP and FHIR Resources/profiles and extensions.
| OMOP Data Element | FHIR Data Element | FHIR Resource/Profile/Extension | BRIDG Mapping |
| Table : Person | Patient | Person | |
| person_id | Patient.identifier2 | CdmhPatient | Person : Subject.identifier(ID).identifier |
| person_source_value | Patient.identifier2 | CdmhPatient | Person : Subject.identifier(ID).identifier |
| provider_id | Patient.generalPractitioner.identifier2 | CdmhPatient, us-core-practitioner | Person : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| care_site_id | Patient.managingOrganization.identifier2 | CdmhPatient, CdmhOrganization | Person : HealthcareFacility.identifier(DSET[ID]).item(ID).identifier |
| gender_concept_id3 | Patient.gender1 | CdmhPatient | Person.sexGenotypeCode |
| gender_source_value | Patient.gender1 | CdmhPatient | Person.sexGenotypeCode |
| year_of_birth | Patient.birthDate | CdmhPatient | Person.birthDate |
| month_of_birth | Patient.birthDate | CdmhPatient | Person.birthDate |
| day_of_birth | Patient.birthDate | CdmhPatient | Person.birthDate |
| birth_datetime | Patient.extension : patient-birthTime | CdmhPatient | Person.birthDate |
| race_concept_id3 | Patient.extension: us-core-race1 | CdmhPatient | Person.raceCode |
| ethnicity_concept_id3 | Patient.extension: us-core-ethnicity1 | CdmhPatient | Person.ethnicGroupCode |
| location_id | Patient.address | CdmhPatient | Person.postalAddress |
| Table : VISIT_OCCURRENCE | Encounter | PerformedEncounter WHERE PerformedEncounter > DefinedSubjectActivityGroup.categoryCode = "Encounter" | |
| visit_occurence_id | Encounter.identifier2 | CdmhEncounter | PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| visit_source_value | Encounter.identifier2 | CdmhEncounter | PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| care_site_id | Encounter.location.location.managingOrganization.identifier2 | CdmhEncounter, CdmhLocation | PerformedEncounter : Place : ServiceDeliveryLocation : Organization : HealthcareFacility.identifier(DSET[ID]).item(ID).identifier |
| admitting_from_concept_id3 | Encounter.hospitalization.extension : cdmh-pcornet-admitting-source-facility-type1 | CdmhEncounter, CdmhLocation | PerformedEncounter : arrives from : Place.typeCode |
| admitting_from_source_value, admitting_from_source_concept_id | Encounter.hospitalization.extension : cdmh-pcornet-admitting-source-facility-type1 | CdmhEncounter, CdmhLocation | PerformedEncounter : arrives from : Place.typeCode |
| discharge_to_concept_id3 | Encounter.hospitalization.extension : cdmh-pcornet-discharge-status1 | CdmhEncounter,CdmhLocation | PerformedEncounter : departs for : Place.typeCode |
| discharge_to_source_value | Encounter.hospitalization.extension : cdmh-pcornet-discharge-status1 | CdmhEncounter,CdmhLocation | PerformedEncounter : departs for : Place.typeCode |
| preceding_visit_occurence | Encounter.partOf | CdmhEncounter | PerformedEncounter : PerformedEncounter |
| person_id | Encounter.subject.identifier2 | CdmhEncounter | PerformedEncounter : Subject.identifier(ID).identifier |
| visit_concept_id3 | Encounter.type1 | CdmhEncounter | PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| visit_source_value | Encounter.type1 | CdmhEncounter | PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| visit_start_date | Encounter.period | CdmhEncounter | Encounter |
| visit_start_datetime | Encounter.period | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| visit_end_date | Encounter.period | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).high |
| visit_end_datetime | Encounter.period | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).high |
| visit_type_concept_id3 | Encounter.diagnosis.extension : cdmh-pcornet-diagnosis-origin1 | CdmhEncounter | PerformedEncounter.informationSourceTypeCode |
| visit_type_source_value | Encounter.diagnosis.extension : cdmh-pcornet-diagnosis-origin1 | CdmhEncounter | PerformedEncounter.informationSourceTypeCode |
| provider_id | Encounter.performer.identifier2 | CdmhEncounter | PerformedEncounter : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| Table : CARE_SITE | Organization | HealthcareFacility | |
| care_site_id | Organization.identifier2 | CdmhOrganization | HealthcareFacility.identifier(DSET[ID]).item(ID).identifier |
| care_site_name | Organization.name | CdmhOrganization | HealthcareFacility : Organization.name |
| place_of_service_concept_id | Organization.type | Organization | HealthcareFacility : Organization.typeCode |
| location_id | Organization.address | CdmhOrganization | HealthcareFacility.postalAddress |
| Table : CONDITION_OCCURRENCE | Condition | PerformedMedicalConditionResult | |
| condition_occurrence_id | Condition.identifier2 | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation.identifier |
| condition_occurrence_source_value | Condition.identifier2 | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation.identifier |
| provider_id | Condition.asserter.identifier2 | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| visit_occurrence_id | Condition.encounter.identifier2 | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier.item(ID).identifier |
| condition_status_concept_id3 | Condition.category1 | CdmhCondition | PerformedMedicalConditionResult.conditionStatusCode |
| person_id | Condition.subject.identifier2 | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation : Subject.identifier.item(ID).identifier |
| condition_concept_id3 | Condition.code1 | CdmhCondition | PerformedMedicalConditionResult.value(CD).code |
| condition_source_value | Condition.code1 | CdmhCondition | PerformedMedicalConditionResult.value(CD).code |
| condition_start_date | Condition.onset[x] | CdmhCondition | PerformedMedicalConditionResult.occurrenceDateRange(IVL[TS.DATETIME]).low |
| condition_start_datetime | Condition.onset[x] | CdmhCondition | PerformedMedicalConditionResult.occurrenceDateRange(IVL[TS.DATETIME]).low |
| condition_end_date | Condition.abatement[x] | CdmhCondition | PerformedMedicationConditionResult.occurrenceDateRange(IVL[TS.DATETIME]).high |
| condition_end_datetime | Condition.abatement[x] | CdmhCondition | PerformedMedicationConditionResult.occurrenceDateRange(IVL[TS.DATETIME]).high |
| condition_type_concept_id3 | Condition.code.extension : cdmh-pcornet-condition-source1 | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation.informationSourceTypeCode |
| condition_type_source_value | Condition.code.extension : cdmh-pcornet-condition-source1 | CdmhCondition | PerformedMedicalConditionResult : PerformedObservation.informationSourceTypeCode |
| stop_reason | Condition.note if recorded | CdmhCondition | PerformedMedicalConditionResult.conditionStatusChangeReason |
| Table : DEATH | AdverseEvent | AdverseEvent WHERE AdverseEvent : PerformedObservation : DefinedObservation.nameCode = "Death Information" | |
| person_id | AdverseEvent.subject.identifier2 | CdmhAdverseEvent | AdverseEvent : PerformedObservation : Subject.identifier(ID).identifier |
| death_date | AdverseEvent.date | CdmhAdverseEvent | AdverseEvent.occurrenceDateRange(IVL[TS.DATETIME]).low |
| death_datetime | AdverseEvent.date | CdmhAdverseEvent | AdverseEvent.occurrenceDateRange(IVL[TS.DATETIME]).low |
| death_type_concept_id | AdverseEvent.suspectedEntity.causality.extension : cdmh-pcornet-death-cause-source1 | CdmhAdverseEvent | AdverseEvent : PerformedObservation.informationSourceTypeCode |
| cause_concept_id3 | AdverseEvent.suspectedEntity.causality.extension : cdmh-pcornet-death-cause, cdmh-pcornet-death-cause-code1 | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult.value(CD) |
| Table : DEVICE_EXPOSURE | Procedure | PerformedSubstanceAdministration | |
| device_exposure_id3 | Procedure.focalDevice.udiCarrier2 | CdmhProcedure, us-core-implantable-device | PerformedSubstanceAdministration.identifier |
| provider_id | Procedure.performer.actor2 | CdmhProcedure, us-core-practitioner | PerformedSubstanceAdministration : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| visit_occurrence_id | Procedure.encounter.identifier2 | CdmhProcedure | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| person_id | Procedure.subject.identifier2 | CdmhProcedure | PerformedSubstanceAdministration : Subject.identifier |
| device_exposure_start_date | Procedure.performedPeriod.low | CdmhProcedure | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).low |
| device_exposure_start_datetime | Procedure.performedPeriod.low | CdmhProcedure | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).low |
| device_exposure_end_date | Procedure.performedPeriod.high | CdmhProcedure | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).high |
| device_exposure_end_datetime | Procedure.performedPeriod.high | CdmhProcedure | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).high |
| device_type_concept_id | Procedure.focalDevice.manipulated.type, Procedure.usedReference.type | CdmhProcedure, us-core-implantable-device | PerformedSubstanceAdministration.informationSourceTypeCode |
| unique_device_id | Procedure.focalDevice.manipulated.udiCarrier,Procedure.usedReference.udiCarrier | CdmhProcedure, us-core-implantable-device | PerformedSubstanceAdministration : Device.identifier |
| Table :DRUG_EXPOSURE | MedicationStatement, MedicationRequest | PerformedSubstanceAdministration | |
| drug_exposure_id | MedicationStatement.identifier2 | CdmhMedicationStatement | PerformedSubstanceAdministration.identifier(DSET[ID]).item(ID).identifier |
| stop_reason | MedicationStatement.statusReason | CdmhMedicationStatement | PerformedSubstanceAdministration.changeReason |
| refills | MedicationStatement.basedOn(MedicationRequest).dispenseRequest.numberOfRepeatsAllowed | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.orderedNumberOfRepeats |
| quantity | MedicationStatement.basedOn(MedicationRequest).dispenseRequest.quantity | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration.productDose(PQ).value |
| days_supply | MedicationStatement.basedOn(MedicationRequest).dispenseRequest.expectedSupplyDuration | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedStudyAgentTransfer.daysSupply |
| lot_number | MedicationStatement.medication.batch.lotNumber | CdmhMedicationStatement, us-core-medication | PerformedSubstanceAdministration : Drug.lotNumberText |
| sig | MedicationStatement.basedOn(MedicationRequest).dosageInstruction.text | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration.productDoseDescription |
| route_concept_id | MedicationStatement.basedOn(MedicationRequest).dosageInstruction.route1 | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration.routeOfAdministrationCode |
| provider_id | MedicationStatement.basedOn(MedicationRequest).requester.identifier2 | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration : Performer > HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| visit_occurrence_id | MedicationStatement.context.identifier | CdmhMedicationStatement, CdmhEncounter | PerformedSubstanceAdministration : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| drug_source_value | MedicationStatement.medication | CdmhMedicationStatement | PerformedSubstanceAdministration : Drug.code(CD).originalText |
| person_id | MedicationStatement.subject.identifier | CdmhMedicationStatement | PerformedSubstanceAdministration : Subject.identifier(ID).identifier |
| drug_concept_id3 | MedicationStatement.medicationCodeableConcept1 | CdmhMedicationStatement | PerformedSubstanceAdministration : Drug.code(CD).code |
| drug_exposure_start_date | MedicationStatement.effectivePeriod.low | CdmhMedicationStatement | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).low |
| drug_exposure_start_datetime | MedicationStatement.effectivePeriod.low | CdmhMedicationStatement | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).low |
| drug_exposure_end_date | MedicationStatement.effectivePeriod.high | CdmhMedicationStatement | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).high |
| drug_exposure_end_datetime | MedicationStatement.effectivePeriod.high | CdmhMedicationStatement | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).high |
| verbatim_end_date | MedicationStatement.basedOn(MedicationRequest).validityPeriod.high | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration.dateRange(IVL[TS.DATETIME]).high |
| Table : LOCATION | Location | Linked to specific BRIDG tables as needed | |
| location_id | Location.identifier | CdmhLocation | Linked to specific BRIDG tables as needed |
| address_1 | Location.address.line | CdmhLocation | Linked to specific BRIDG tables as needed |
| address_2 | Location.address.line | CdmhLocation | Linked to specific BRIDG tables as needed |
| city | Location.address.city | CdmhLocation | Linked to specific BRIDG tables as needed |
| state | Location.address.state | CdmhLocation | Linked to specific BRIDG tables as needed |
| zip | Location.address.postalCode | CdmhLocation | Linked to specific BRIDG tables as needed |
| country | Location.address.country | CdmhLocation | Linked to specific BRIDG tables as needed |
| Table :MEASUREMENT | Observation | PerformedClinicalResult | |
| measurement_id | Observation.identifier2 | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.identifier(DSET[ID]).item(ID).identifier |
| unit_concept_id | Observation.valueQuantity.units1 | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).unit |
| range_low | Observation.referenceRange.low | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult > ReferenceResult.value(ANY=IVL[PQ]).low |
| range_high | Observation.referenceRange.high | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult > ReferenceResult.value(ANY=IVL[PQ]).high |
| provider_id | Observation.performer.identifier2 | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| visit_occurrence_id | Observation.encounter2 | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| measurement_source_value | Observation.code1 | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item |
| person_id | Observation.subject.identifier2 | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection : Subject.identifier(ID).identifier |
| measurement_concept_id3 | Observation.code1 | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).code |
| measurement_date | Observation.effectiveDateTime | CdmhLabResults,CdmhVitalSigns | PerformedClincalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).high |
| measurement_datetime | Observation.effectiveDateTime | CdmhLabResults,CdmhVitalSigns | PerformedClincalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).high |
| value_as_number | Observation.valueInt | CdmhLabResults,CdmhVitalSigns | IF Unit AND Modifier are present, PerformedClinicalResult.value(ANY=URG[PQ]) ELSE IF Unit present, PerformedClinicalResult.value(ANY=PQ).value, ELSE IF Modifier present, PerformedClinicalResult.value(ANY=URG[REAL]), ELSE PerformedClinicalResult.value(ANY=REAL).value |
| value_as_concept_id | Observation.valueCodeableConcept | CdmhLabResults,CdmhVitalSigns | PerformedClinicalResult.value(ANY=CD).code |
| Table :OBSERVATION_PERIOD (Not Required to be mapped for CDMH) | |||
| Table : OBSERVATION | Observation | PerformedClinicalResult WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.categoryCode = "Clinical Observation" | |
| observation_id | Observation.identifier2 | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult : PerformedObservation.identifier |
| unit_concept_id | Observation.valueQuantity.unit1 | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult.value(ANY=PQ).unit |
| provider_id | Observation.performer.identifier2 | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult : PerformedObservation : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| visit_occurrence_id | Observation.encounter.identifier2 | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| person_id | Observation.subject.identifier2 | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult : PerformedObservation : Subject.identifier(ID).identifier |
| observation_concept_id | Observation.code2 | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode |
| observation_date | Observation.effectiveDateTime | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult : PerformedActivity.dateRange(IVL[TS.DATETIME]).high |
| observation_datetime | Observation.effectiveDateTime | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult : PerformedActivity.dateRange(IVL[TS.DATETIME]).high |
| value_as_number | Observation.valueInt | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult.value(ANY=REAL) OR PerformedClinicalResult.value(ANY=PQ).value |
| value_as_string | Observation.valueString | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult.value(ANY=ST) |
| value_as_concept_id | Observation.valueCodeableConcept | CdmhLabResults,CdmhVitalSigns,us-core-smokingstatus | PerformedClinicalResult.value(ANY=CD) |
| Table : PROCEDURE_OCCURRENCE | Procedure | PerformedProcedure | |
| procedure_occurrence_id | Procedure.identifier2 | CdmhProcedure | PerformedProcedure.identifier(DSET[ID]).item(ID).identifier |
| visit_occurrence_id | Procedure.encounter.identifier2 | CdmhProcedure | Procedure |
| person_id | Procedure.subject.identifier2 | CdmhProcedure | PerformedProcedure : PerformedCompositionRelationship : PerformedEncounter.identifier.item(ID).identifier |
| procedure_concept_id3 | Procedure.code1 | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode |
| procedure_date | Procedure.performedDateTime | CdmhProcedure | PerformedProcedure.dateRange(IVL[TS.DATETIME]).high |
| procedure_datetime | Procedure.performedDateTime | CdmhProcedure | PerformedProcedure.dateRange(IVL[TS.DATETIME]).high |
| provider_id | Procedure.performer.actor.identifier2 | CdmhProcedure | PerformedProcedure : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| Table : PROVIDER | Practitioner | HealthcareProvider | |
| provider_id | Practitioner.identifier | us-core-practitioner | HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| provider_name | Practitioner.name | us-core-practitioner | HealthcareProvider > Person.name(DSET[EN]).item(EN) |
| npi | Practitioner.identifier | us-core-practitioner | HealthcareProvider.identifier(DSET[ID]).item(ID).identifier WHERE identifier(DSET[ID]).item(ID).typeCode="NPI" |
| dea | Practitioner.qualification | us-core-practitioner | HealthcareProvider.identifier(DSET[ID]).item(ID).identifier WHERE identifier(DSET[ID]).item(ID).typeCode="DEA Number" |
| specialty_concept_id | PractitionerRole.specialty | us-core-practitionerrole | HealthcareProvider.roleCode |
| care_site_id | PractitionerRole.location | us-core-practitionerrole | HealthcareProvider : HealthcareFacility.identifier(DSET[ID]).item(ID).identifier |
| year_of_birth | Practitioner.birthDate | us-core-practitioner | HealthcareProvider : Person.birthDate |
| gender_concept_id | Practitioner.gender | us-core-practitioner | HealthcareProvider : Person.administrativeGenderCode |
| Table : SPECIMEN | Specimen | Specimen | |
| specimen_id | Specimen.identifier2 | CdmhSpecimen | Specimen : Material.identifier |
| person_id | Specimen.subject.identifier2 | CdmhSpecimen | Specimen : PerformedSpecimenCollection : Subject.identifier |
| specimen_concept_id3 | Specimen.type1 | CdmhSpecimen | Specimen : Material.code |
| specimen_date | Specimen.collection.collectedDateTime | CdmhSpecimen | Specimen : PerformedSpecimenCollection.dateRange(IVL[TS.DATETIME]).high |
| specimen_datetime | Specimen.collection.collectedDateTime | CdmhSpecimen | Specimen : PerformedSpecimenCollection.dateRange(IVL[TS.DATETIME]).high |
| quantity | Specimen.collection.quantity | CdmhSpecimen | Specimen : PerformedSpecimenCollection.quantity(PQ).value |
| unit_concept_id | Specimen.collection.quantity.unit` | CdmhSpecimen | Specimen : PerformedSpecimenCollection.quantity(PQ).unit |
| anatomic_site_concept_id | Specimen.bodySite1 | CdmhSpecimen | Specimen : PerformedSpecimenCollection.targetAnatomicSiteCode |
1: codes, Codings and CodeableConcept data types in FHIR which are used to convey specific concepts about a resource have to be mapped to OMOP Vocabulary which contains a large number of concepts with a specific concept_id that is used in the various tables. (For e.g In OMOP table CONDITION_OCCURRENCE, the condition_concept_id contains an id present in the OMOP vocabulary and the FHIR Condition.code value has to be mapped to the OMOP concept_id using guidance present in the OMOP Common Data Model and OMOP OHDSI Documentation. In this case, Condition.code from FHIR resource would actually be retained in the CONDITION_SOURCE_VALUE element).
2: Identifiers in the FHIR resources should be used to generate the ID elements of the OMOP tables unless they are auto-generated. If IDs in OMOP tables are auto-generated, then the identifiers should be stored in the OMOP tables under the
3: The concept_ids identified should be used by queries to retrieve the data from OMOP tables for analysis instead of using the
The table below outlines the mappings between Sentinel and FHIR Resources/profiles and extensions.
| Sentinel Data Element | FHIR Data Element | FHIR Resource/Profile/Extension | BRIDG Mapping |
| Table : DEMOGRAPHIC | Patient | Person | |
| PatID | Patient.identifier | CdmhPatient | Person : Subject.identifier(ID).identifier |
| Birth-Date | Patient.birthDate | CdmhPatient | Person.birthDate |
| Sex | Patient.extension: us-core-birthsex | CdmhPatient | Person.sexGenotypeCode |
| Hispanic | Patient.extension: us-core-ethnicity | CdmhPatient | Person.ethnicGroupCode WHERE Person.ethnicGroupCode = "Hispanic" |
| Race | Patient.extension: us-core-race | CdmhPatient | Person.raceCode |
| Zip | Patient.address | CdmhPatient | Person.postalAddress.item(AD).item(ADXP).value WHERE Person.postalAddress.item(AD).item(ADXP).partType = 'ZIP' |
| Zip_Date | Patient.address.period | CdmhPatient | Person.postalAddress(AD).useablePeriod(IVL_TS).low |
| Table : ENCOUNTER | Encounter | PerformedEncounter WHERE PerformedEncounter : DefinedSubjectActivityGroup.categoryCode = "Encounter" | |
| EncounterID | Encounter.identifier | CdmhEncounter | PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| PatID | Encounter.subject.identifier | CdmhEncounter | PerformedEncounter : Subject.identifier(ID).identifier |
| ADATE | Encounter.period | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| DDATE | Encounter.period | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).high |
| Provider | Encounter.participant.individual.identifier | CdmhEncounter, us-core-practitioner | PerformedEncounter : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| Facility_Location | Encounter.location.location.address | CdmhEncounter, CdmhLocation | PerformedEncounter : Place.physicalAddress(AD).item(ADXP).value WHERE PerformedActivity : Place.physicalAddress(AD).item(ADXP).partType = 'ZIP' |
| EncType | Encounter.class | CdmhEncounter | PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| Facility_Code | Encounter.location.location.identifier | CdmhEncounter, CdmhLocation | PerformedEncounter : Place : ServiceDeliveryLocation : Organization : HealthcareFacility.identifier(DSET[ID]).item(ID).identifier |
| Discharge_Disposition | Encounter.hospitalization.dischargeDisposition | CdmhEncounter | Encounter |
| Discharge_Status | Encounter.hospitalization.extension : cdmh-pcornet-discharge-status | CdmhEncounter | PerformedEncounter : departs for : Place.typeCode |
| DRG | Encounter.extension : cdmh-pcornet-drg-group | CdmhEncounter | PerformedEncounter.classificationCode(CD).code |
| DRG_Type | Encounter.extension : cdmh-pcornet-drg-group-version | CdmhEncounter | PerformedEncounter.classificationCode(CD).codeSystem |
| Admitting_Source | Encounter.hospitalization.extension : cdmh-pcornet-admitting-source-facility-type | CdmhEncounter | PerformedEncounter : arrives from : Place.typeCode |
| Table : DIAGNOSIS | Diagnosis | PerformedDiagnosis | |
| PatID | Condition.subject | CdmhCondition | PerformedDiagnosis : PerformedObservation : Subject.identifier.item(ID).identifier |
| PAdmit | Not mapped for CDMH | Not mapped for CDMH | PerformedDiagnosis.presentAtAdmissionCode |
| EncounterID | Condition.encounter | CdmhCondition | PerformedDiagnosis : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier.item(ID).identifier |
| ADATE | Condition.encounter.period | CdmhCondition,CdmhEncounter | PerformedDiagnosis : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| Provider | Condition.encounter.participant.individual.id | CdmhCondition,CdmhEncounter, us-core-practitioner | PerformedDiagnosis : PerformedObservation : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| EncType | Condition.encounter.class | CdmhCondition,CdmhEncounter | PerformedDiagnosis : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| DX | Condition.code | CdmhCondition | PerformedDiagnosis.value(ANY=CD).code |
| Dx_Codetype | Condition.code | CdmhCondition | PerformedDiagnosis.value(ANY=CD).codeSystem |
| OrigDX | Not mapped for CDMH | Not mapped for CDMH | PerformedDiagnosis.value(ANY=CD).translation(CD).value |
| PDX | Condition.encounter.diagnosis.rank | CdmhCondition,CdmhEncounter | PerformedDiagnosis.priorityAtDischargeCode |
| Table : ENROLLMENT | ResearchStudy | PerformedAdministrativeActivity WHERE PerformedAdministrativeActivity : DefinedSubjectActivityGroup.categoryCode = "ObservationPeriod" | |
| PatID | ResearchStudy.enrollment.member.entity.id | CdmhResearchStudy,CdmhGroup | PerformedAdministrativeActivity : Subject.identifier(ID).identifier |
| Enr_Start | ResearchStudy.enrollment.member.period.low | CdmhResearchStudy,CdmhGroup | PerformedAdministrativeActivity.dateRange(IVL[TS.DATETIME]).low |
| Enr_End | ResearchStudy.enrollment.member.period.high | CdmhResearchStudy,CdmhGroup | PerformedAdministrativeActivity.dateRange(IVL[TS.DATETIME]).high |
| MedCov | Not mapped for CDMH | Not mapped for CDMH | Not mapped for CDMH |
| DrugCov | Not mapped for CDMH | Not mapped for CDMH | Not mapped for CDMH |
| Chart | Not mapped for CDMH | Not mapped for CDMH | Not mapped for CDMH |
| Table : DISPENSING | MedicationDispense | PerformedStudyAgentTransfer WHERE PerformedStudyAgentTransfer : DefinedStudyAgentTransfer.nameCode = "Dispensing" | |
| PatID | MedicationDispense.subject.identifier | CdmhMedicationDispense | PerformedStudyAgentTransfer : Subject.identifier(ID).identifier |
| RxDate | MedicationDispense.whenHandedOver | CdmhMedicationDispense | PerformedStudyAgentTransfer.dateRange(IVL[TS_DATETIME]).high |
| NDC | MedicationDispense.medicationCodeableConcept | CdmhMedicationDispense | PerformedStudyAgentTransfer : Drug.code |
| RxSup | MedicationDispense.daysSupply | CdmhMedicationDispense | PerformedStudyAgentTransfer.daysSupply |
| RxAmt | MedicationDispense.quantity | CdmhMedicationDispense | PerformedStudyAgentTransfer.quantity |
| Table : PROCEDURE | Procedure | PerformedProcedure | |
| PatID | Procedure.subject.identifier | CdmhProcedure | PerformedProcedure : Subject.identifier(ID).identifier |
| EncounterID | Procedure.encounter.identifier | CdmhProcedure,CdmhEncounter | PerformedProcedure : PerformedCompositionRelationship : PerformedEncounter.identifier.item(ID).identifier |
| ADATE | Procedure.encounter.period | CdmhProcedure,CdmhEncounter | PerformedProcedure : PerformedCompositionRelationship : PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| Provider | Procedure.encounter.participant.individual.id | CdmhProcedure,CdmhEncounter,us-core-practitioner | PerformedProcedure : Performer : HealthcareProvider.identifier(DSET[ID]).item(ID).identifier |
| EncType | Procedure.encounter.class | CdmhProcedure,CdmhEncounter | PerformedProcedure : PerformedCompositionRelationship : PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
| PX | Procedure.code | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode |
| PX_CodeType | Procedure.code | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode(CD).codeSystemName |
| Table : DEATH | AdverseEvent | AdverseEvent WHERE AdverseEvent : PerformedObservation : DefinedObservation.nameCode = "Death Information" | |
| PatID | AdverseEvent.subject.identifier | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult : PerformedObservation : Subject.identifier(ID).identifier |
| Code | AdverseEvent.suspectedEntity.causality.extension : cdmh-pcornet-death-cause-code | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult.value(CD) |
| CodeType | AdverseEvent.suspectedEntity.causality.extension : cdmh-pcornet-death-cause-type | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult.value(ANY=CD).codeSystem |
| Source | AdverseEvent.suspectedEntity.causality.extension : cdmh-pcornet-death-cause-source | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult : PerformedObservation.informationSourceTypeCode |
| Confidence | AdverseEvent.suspectedEntity.causality.extension : cdmh-pcornet-death-cause-confidence | CdmhAdverseEvent | AdverseEvent : CausalAssessment : EvaluatedResultRelationship : PerformedObservationResult.uncertaintyCode |
| Table : LABORATORY RESULT | Laboratory Result | PerformedClinicalResult | |
| PatID | Observation.subject.identifier | CdmhLabResults | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection : Subject.identifier(ID).identifier |
| MS_Test_Name | Observation.performer(organization).name | CdmhLabResults, CdmhOrganization | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).originalText |
| Result_Type | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult.value(ANY= X) WHERE X = Result_Type |
| MS_Test_Sub_Category | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedObservation : DefinedObservation.categoryCode |
| Fast_Ind | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedObservation.fastingStatusIndicator |
| Specimen_Source | Observation.specimen.bodySite | CdmhLabResults,CdmhSpecimen | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection.methodCode |
| LOINC | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).code |
| Stat | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedObservation.urgencyCode |
| Pt_Loc | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection : Place.typeCode |
| Result_Loc | Observation.performer(organization).type | CdmhLabResults, CdmhOrganization | PerformedClinicalResult : PerformedObservation : Place.typeCode |
| LOCAL_CD | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item |
| BATTERY_CD | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item |
| PK | Observation.partOf (Procedure) | CdmhLabResults, CdmhProcedure | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item(CD).code |
| PK_CodeType | Observation.partOf (Procedure) | CdmhLabResults, CdmhProcedure | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item(CD).codeSystem |
| Order_dt | Observation.basedOn(ServiceRequest).occurenceDateTime | CdmhLabResults, ServiceRequest | PerformedClinicalResult : PerformedObservation.orderDate |
| Lab_dt | Observation.specimen.collection.collectedDateTime | CdmhLabResults,CdmhSpecimen | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection.dateRange(IVL[TS.DATETIME]).low |
| Lab_tm | Observation.specimen.collection.collectedDateTime | CdmhLabResults,CdmhSpecimen | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection.dateRange(IVL[TS.DATETIME]).low |
| Result_dt | Observation.issued | CdmhLabResults | PerformedClincalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).high |
| Result_tm | Observation.issued | CdmhLabResults | PerformedClincalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).high |
| Orig_Result | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedClinicalResult.value (with the same data type rules as the MS_Result_X attributes) |
| MS_Result_C | Observation.valueCodeableConcept | CdmhLabResults | PerformedClinicalResult.value(ANY=CD).code WHERE value(ANY=CD).codeSystem = "LOINC" |
| MS_Result_N | Observation.valueInt | CdmhLabResults | IF Unit AND Modifier are present, PerformedClinicalResult.value(ANY=URG[PQ]) ELSE IF Unit present, PerformedClinicalResult.value(ANY=PQ).value, ELSE IF Modifier present, PerformedClinicalResult.value(ANY=URG[REAL]), ELSE PerformedClinicalResult.value(ANY=REAL).value |
| Modifier | Observation.value[x] | CdmhLabResults | PerformedClinicalResult.value AND PerformedClinicalResult : PerformedClinicalResult.value |
| Orig_Result_unit | Observation.valueQuantity.unit | CdmhLabResults | PerformedClinicalResult : PerformedClincalResult.value(ANY=PQ).originalText |
| Std_Result_unit | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult : PerformedClinicalResult.value(ANY=PQ).unit |
| MS_Result_unit | Not mapped for CDMH | Not mapped for CDMH | PerformedClinicalResult.value(ANY=PQ).unit |
| Norm_Range_low | Observation.referenceRange.low | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).low |
| Norm_Range_high | Observation.referenceRange.high | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).high |
| Abn_ind | Observation.interpretation | CdmhLabResults | PerformedClinicalResult.normalRangeComparisonCode |
| Order_dept | Location.id | CdmhLocation | TBD |
| Facility_Code | Encounter.location.location.identifier | CdmhEncounter, CdmhLocation | TBD |
| Table : VITALSIGNS | Observation (Vital Signs) | PerformedClinicalResult WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.categoryCode = "Vital Signs" | |
| PatID | Observation.subject.identifier | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : Subject.identifier(ID).identifier |
| EncounterID | Observation.encounter.identifier | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation : PerformedCompositionRelationship : PerformedEncounter.identifier(DSET[ID]).item(ID).identifier |
| Measure_Date | Observation.effectiveDateTime | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).low |
| Measure_Time | Observation.effectiveDateTime | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.dateRange(IVL[TS.DATETIME]).low |
| HT | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Height" |
| WT | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Weight" |
| Diastolic | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult.typeCode = "Diastolic" AND PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Blood Pressure" |
| Systolic | Observation.code,Observation.value[x] | CdmhVitalSigns | PerformedClinicalResult.value(ANY=PQ).value WHERE PerformedClinicalResult.typeCode = "Systolic" AND PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Blood Pressure" |
| BP_Type | PerformedClinicalResult : PerformedObservation.methodCode | ||
| Position | Observation.bodySite | CdmhVitalSigns | PerformedClinicalResult : PerformedObservation.bodyPositionCode |
| Tobacco | Observation.code,Observation.value[x] | us-core-smokingstatus | PerformedClinicalResult.value(ANY=CD).value WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Tobacco use" |
| Tobacco_Type | Observation.code,Observation.value[x] | us-core-smokingstatus | PerformedClinicalResult.typeCode WHERE PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode = "Tobacco use" |
The table below outlines the mappings between i2b2/ACT and FHIR Resources/profiles and extensions.
| i2b2 Data Element | FHIR Data Element | FHIR Resource/Profile/Extension | BRIDG Mapping |
| Table : Demographics | Patient | Person | |
| birth_date | Patient.birthDate | CdmhPatient | Person.birthDate |
| Death_date | Patient.deceasedDateTime | Patient | AdverseEvent.occurrenceDateRange(IVL[TS.DATETIME]).low |
| sex | Patient.extension: us-core-birthsex | CdmhPatient | Person.sexGenotypeCode |
| Hispanic | Patient.extension: us-core-ethnicity | CdmhPatient | Person.ethnicGroupCode WHERE Person.ethnicGroupCode = "Hispanic" |
| Race | Patient.extension: us-core-race | CdmhPatient | Person.raceCode |
| Vital_status | Patient.deceasedBoolean | Patient | Person.deathIndicator |
| Table : DIAGNOSIS | Condition | PerformedDiagnosis | |
| DIAGNOSIS_CODE | Condition.code | CdmhCondition | PerformedDiagnosis.value(ANY=CD).code |
| DIAGNOSIS_CODING_SYSTEM | Condition.code | CdmhCondition | PerformedDiagnosis.value(ANY=CD).codeSystem |
| DIAGNOSIS_CODING_SYSTEM_VERSION | Condition.code | CdmhCondition | PerformedDiagnosis.value(ANY=CD).codeSystemVersion |
| DIAGNOSIS_DATE | Condition.onsetDateTime | CdmhCondition | PerformedDiagnosis.reportedDate |
| DIAGNOSIS_PRIORITY | Condition.encounter.diagnosis.rank | CdmhCondition, CdmhEncounter | PerformedDiagnosis.priorityAtDischargeCode |
| DIAGNOSIS_SOURCE | Condition.category | CdmhCondition | PerformedDiagnosis : PerformedObservation.timePointCode |
| Table : LABORATORY TEST | Observation | PerformedClinicalResult | |
| ABNORMAL_RESULT_INDICATOR | Observation.interpretation | CdmhLabResults | PerformedClinicalResult.normalRangeComparisonCode |
| RAW_MODIFIER_LOW | Observation.referenceRange.modifierExtension | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).low |
| RAW_NORMAL_RANGE_HIGH | Observation.referenceRange.high | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).high |
| RAW_NORMAL_RANGE_LOW | Observation.referenceRange.low | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).low |
| RAW_ORDER_DEPT | Location.id | CdmhLocation | Not mapped for CDMH project |
| RAW_PANEL | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item |
| RAW_RESULT | Observation.value[x] | CdmhLabResults | PerformedClinicalResult : PerformedClinicalResult.value (with the same data type rules as the MS_Result_X attributes) |
| RAW_UNIT | Observation.valueQuantity.unit | CdmhLabResults | PerformedClinicalResult : PerformedClincalResult.value(ANY=PQ).originalText |
| RESULT_LOCATION | Location | CdmhLocation | PerformedClinicalResult : PerformedObservation : Place.typeCode |
| RESULT_MODIFIER | Observation.value[x] | CdmhLabResults | PerformedClinicalResult.value AND PerformedClinicalResult : PerformedClinicalResult.value |
| RESULT_NUMERICAL | Observation.valueInt | CdmhLabResults | IF Unit AND Modifier are present, PerformedClinicalResult.value(ANY=URG[PQ]) ELSE IF Unit present, PerformedClinicalResult.value(ANY=PQ).value, ELSE IF Modifier present, PerformedClinicalResult.value(ANY=URG[REAL]), ELSE PerformedClinicalResult.value(ANY=REAL).value |
| LAB_CLASSIFICATION _SYSTEM_VERSION | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).valueSetVersion |
| RESULT_QUALITATIVE | Observation.valueCodeableConcept | CdmhLabResults | PerformedClinicalResult.value(ANY=CD).code |
| RESULT_UNIT | Observation.valueQuantity.unit | CdmhLabResults | PerformedClinicalResult.value(ANY=PQ).unit |
| SPECIMEN_DATE | Observation.specimen.collection.collectedDateTime | CdmhLabResults,CdmhSpecimen | PerformedClinicalResult : PerformedObservation : Subject : Specimen : PerformedSpecimenCollection.dateRange(IVL[TS.DATETIME]).low |
| LAB_CLASSIFICATION_SYSTEM | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).valueSetVersion |
| LAB_CODING_SYSTEM | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).codeSystem |
| LAB_CODE | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).code |
| LAB_CODING_SYSTEM_VERSION | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).codeSystemVersion |
| RAW_FACILITY_CODE | Encounter.location.location.identifier | CdmhEncounter, CdmhLocation | Not Mapped for CDMH project |
| RAW_LAB_CODE | Observation.code | CdmhLabResults | PerformedClinicalResult : PerformedObservation : DefinedObservation.nameCode(CD).translation(DSET[CD]).item |
| RAW_MODIFIER_HIGH | Observation.referenceRange.modifierExtension | CdmhLabResults | PerformedClinicalResult : ReferenceResult.value(ANY=IVL[PQ]).high |
| Table : MEDICATION | MedicationStatement | PerformedSubstanceAdministration | |
| MEDICATION_CLASSIFICATION_SYSTEM | MedicationStatement.medicationCodeableConcept | CdmhMedicationStatement | PerformedSubstanceAdministration : Drug.code(CD).valueSet |
| RAW_MEDICATION_NAME | MedicationStatement.medicationCodeableConcept.text | CdmhMedicationStatement | Not mapped for CDMH project |
| RAW_MEDICATION_STRENGTH | MedicationStatement.basedOn(MedicationRequest).dosageInstruction.dose[x] | CdmhMedicationStatement, CdmhMedicationRequest | Not mapped for CDMH project |
| RAW_MEDICATION_ROUTE | MedicationStatement.basedOn(MedicationRequest).dosageInstruction.route | CdmhMedicationStatement, CdmhMedicationRequest | Not mapped for CDMH project |
| MEDICATION_CODING_SYSTEM | MedicationStatement.medicationCodeableConcept | CdmhMedicationStatement | PerformedSubstanceAdministration : Drug.code(CD).codeSystemName |
| MEDICATION_CLASSIFICATION_SYSTEM_VERSION | MedicationStatement.medicationCodeableConcept | CdmhMedicationStatement, | PerformedSubstanceAdministration : Drug.code(CD).valueSetVersion |
| MEDICATION_CLASSIFICATION_SYSTEM | MedicationStatement.medicationCodeableConcept | CdmhMedicationStatement | PerformedSubstanceAdministration : Drug.code(CD).codeSystemName |
| MEDICATION_CODE | MedicationStatement.medicationCodeableConcept | CdmhMedicationStatement | PerformedSubstanceAdministration : Drug.code(CD).code |
| MEDICATION_CODING_SYSTEM_VERSION | MedicationStatement.medicationCodeableConcept | CdmhMedicationStatement | PerformedSubstanceAdministration : Drug.code(CD).CodeSystemVersion |
| ORDER_DATE | MedicationStatement.basedOn(MedicationRequest).authoredOn | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration.orderDate |
| ORDER_TYPE | MedicationStatement.basedOn(MedicationRequest).requester | CdmhMedicationStatement, CdmhMedicationRequest | PerformedSubstanceAdministration.orderCareSettingTypeCode |
| RAW_MEDICATION_CODE | MedicationStatement.medicationCodeableConcept | CdmhMedicationStatement | Not mapped for CDMH project |
| Table :PROCEDURE | Procedure | PerformedProcedure | |
| PROCEDURE_CODING_SYSTEM | Procedure.code | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode(CD).codeSystemName |
| PROCEDURE_CODE | Procedure.code | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode |
| PROCEDURE_CODING_SYSTEM_VERSION | Procedure.code | CdmhProcedure | PerformedProcedure : DefinedProcedure.nameCode(CD).codeSystemVersion |
| PROCEDURE_DATE | Procedure.performedDateTime | CdmhProcedure | PerformedProcedure.dateRange(IVL[TS.DATETIME]).high |
| Table : VISIT | Encounter | PerformedEncounter WHERE PerformedEncounter : DefinedSubjectActivityGroup.categoryCode = "Encounter" | |
| ADMIT_DATE | Encounter.period | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).low |
| DISCHARGE_DATE | Encounter.period | CdmhEncounter | PerformedEncounter.dateRange(IVL[TS.DATETIME]).high |
| VISIT_TYPE | Encounter.class | CdmhEncounter | PerformedEncounter : DefinedSubjectActivityGroup.nameCode |
IG © 2019+ HL7 International - Biomedical Research and Regulation Work Group. Package hl7.fhir.us.cdmh#1.0.0 based on FHIR 4.0.1. Generated 2021-12-06
Links: Table of Contents |
QA Report
| Version History |
Search |
|
Propose a change