Common Data Models Harmonization
1.0.0 - STU 1 Publication

Common Data Models Harmonization, published by HL7 International - Biomedical Research and Regulation Work Group. This is not an authorized publication; it is the continuous build for version 1.0.0). This version is based on the current content of https://github.com/HL7/cdmh/ and changes regularly. See the Directory of published versions

Detailed Specification

Mappings

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.

Mapping Conventions and usage of US Core IG

The mappings use the US Core profiles, value sets and code systems where they exist and overlap with CDMH.

  • For the data elements required for the CDMH project which are not marked as “MUST SUPPORT” in the US core profile but present in the base resource, the CDMH project will still leverage the US Core profile and add the needed data elements.
  • For the data elements required for the CDMH project, but are not present in the base resource, extensions will be added to the corresponding US Core profiles.
  • For the data elements where multiple resources/profiles will/can be used, the list of the resources and profiles will be listed separated by comma.
  • Wherever identifiers or id elements are used to map to CDM Id columns it is assumed that as part of the loading process if there needs to be any processing required such as de-identification it is performed and the process will be used to re-link back to the original record when needed for identification.

CDMs to BRIDG 5.1 Mappings

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.

CDMs to BRIDG Mappings

PCORnet CDM version 4 to FHIR R4 Mappings

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

OMOP 5.2 to FHIR R4 Mappings

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 _SOURCE_VALUE element. For e.g If the PERSON_ID is auto-generated, then the Patient.identifier from the FHIR resource should be stored in the PERSON_SOURCE_VALUE column in the OMOP PERSON table. This will allow linkages between the FHIR resources and OMOP tables when data is extracted for population of the OMOP tables. If the FHIR resources do not contain identifiers, then the id element of the FHIR resources can be used to map back and forth between FHIR resources and OMOP tables created from the FHIR resources.

3: The concept_ids identified should be used by queries to retrieve the data from OMOP tables for analysis instead of using the _SOURCE_VALUE elements.

Sentinel 6.0.2 to FHIR R4 Mappings

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"

i2b2/ACT 1.4 to FHIR R4 Mappings

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