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.