Skip to main content
. 2022 Oct 13;10(10):e42429. doi: 10.2196/42429

Table 2.

The data mapping table of the FHIRa ETLb in this study.

Data model of HISc database FHIR resource name FHIR resource attribute Description
Patient_ID Patient identifier An identifier for the patient in the hospital
Patient_name Patient name Patient’s name that is human-readable
Gender Patient gender Patient’s gender
BirthDate Patient birthDate Patient’s birth date
Practitioner_ID Practitioner identifier An identifier for the physician in the hospital
Practitioner_name Practitioner name Physician’s name that is human-readable
Organization_ID Organization identifier An identifier for the department in the hospital
Organization_name Organization name Department’s name that is human-readable
Location_ID Location identifier An identifier for the location in the hospital
Location_name Location name Location’s name that is human-readable
Heart rate Observation valueQuantity.value Heart rate
Temperature Observation valueQuantity.value Temperature
Respiratory rate Observation valueQuantity.value Respiratory rate
Systolic blood pressure Observation valueQuantity.value Systolic blood pressure
Diastolic blood pressure Observation valueQuantity.value Diastolic blood pressure
Timestamp Observation effectiveDateTime The created time of the value

aFHIR: Fast Healthcare Interoperability Resources.

bETL: Extract Transform Load.

cHIS: healthcare information system.