Skip to main content
. 2024 May 14;31(1):e100890. doi: 10.1136/bmjhci-2023-100890

Table 1.

Overview of the TMUCRD table data

Category/table name Description
Demographics
CHR_BASIC Basic demographic characteristic of unique patients in the database (defines ID_NO)
 NDR_CASE Patients and their cause of death registered by the Taiwan Ministry of Health and Welfare linked to the database
 BIO_INF Vital signs recorded for a given patient in different visits
Diagnosis
OPD_BASIC Patients’ diagnosis at outpatient departments (defines FEE_NO)
IPD_BASIC Patients’ diagnosis at admissions (defines FEE_NO)
 CHR_ICD Summary information of patients discharge from admissions
EPD_HIS Patients’ diagnosis at emergency department (defines FEE_NO)
Medication
OPD_MED Medication order for a given patient at the outpatient department (defines FEE_NO)
 OPD_WARNING Drug allergy recorded of patients at the outpatient department
UD_ORDER Medication order for a given patient at admissions (defines FEE_NO)
 UD_ORDER_LOG Drug uses recorded of patients at admissions
Procedure
OPD_FEE Procedure orders for a given patient at the outpatient department, using local hospital codes
IPD_FEE Procedure orders for a given patient at admissions, using local hospitals codes
Measurement
OPD_EXPER/EXPER_ORDER Laboratory measurement orders for patients both at the outpatient and admissions
 LABRESULT/EXPER_SIGN Laboratory measurement values for patients both at the outpatient and admissions
Image examination and radiology
LAB_SCHE Examination orders for patients both at the outpatient and admissions
 CARDIAC_ECHO_REPORT All recorded echocardiography report information for a given patient
 X_RAY All recorded X-Ray report information for a given patient
 RAD_REPORT All recorded radiographic imaging report information for a given patient
 MMSE All recorded mental examination report information for a given patient
Surgery
OP_BASIC All recorded surgery report information for a given patient (except nursing reports)
Cancer
CR_TCASE Patients and their cancer information registered by the Taiwan Ministry of Health and Welfare linked to the database
Pathology
PATT_REPORT All recorded pathology report information for a given patient
Vocabulary
FEE_BASIC Dictionary of the procedure, laboratory and other Item codes, including local hospitals and Taiwan National Health Insurance (NHI) codes
ICD9_BASIC Dictionary of the International Statistical Classification of Diseases and Related Health Problems, 9th revision codes relating to diagnosis
ICD10_BASIC Dictionary of the International Statistical Classification of Diseases and Related Health Problems, 10th revision codes relating to diagnosis
MED_BASIC Dictionary of the Medication codes, including local hospitals and Taiwan NHI codes
EXPERIMENT/EXPER_REFERDATA Dictionary of the examination codes, including local hospitals and Taiwan NHI codes
BED_BASIC Information on the different types of beds in the database
DEPT_BASIC Information on the different departments in the database
DOC_BASIC Information on every physician and pharmacist who had recorded data in the database

TMUCRD, Taipei Medical University Clinical Research Database.