Common Data Models Harmonization
1.0.0 - STU 1 Publication

Publication Build: This will be filled in by the publication tooling

## 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