The “Core” category consists of a total of 3 tables - ADMISSIONS, PATIENTS, TRANSFERS.
The admissions table gives information regarding a patient’s admission to the hospital.
Since each unique hospital visit for a patient is assigned a unique hadm_id, the admissions table can be considered as a definition table for hadm_id.
Information available includes timing information for admission and discharge, demographic information, the source of the admission, and so on.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
ADMITTIME TIMESTAMP
DISCHTIME TIMESTAMP
DEATHTIME TIMESTAMP
ADMISSION_TYPE VARCHAR(30)
ADMISSION_LOCATION VARCHAR(60)
DISCHARGE_LOCATION VARCHAR(60)
INSURANCE VARCHAR(50)
MARITAL_STATUS VARCHAR(80)
EDREGTIME TIMESTAMP
EDOUTTIME TIMESTAMP
HOSPITAL_EXPIRE_FLAG SMALLINT
ICU_EXPIRE_FLAG SMALLINT
NATIONALITY VARCHAR(60)
HOSPITAL_ID VARCHAR(3)
SUBJECT_ID
Patient number of patients with a history of ICU stay
HADM_ID
Admission Registration ID
ADMITTIME
Date and Time Registered for Admission
DISCHTIME
Date and Time Registered for Discharge
DEATHTIME
Date and Time of Patient's Death
ADMISSION_TYPE
Type of Admission
Value Priority Description
Emergency department 1 Patients admitted through the emergency room
Outpatient department 2 Patients whose admission orders issued at outpatient visits were used for admission procedures
Admission 3 Patients whose admission orders issued at inpatient visits were used for admission procedures
Neonate 4 Patients whose date of birth is the same as the admission date
ADMISSION_LOCATION
Patient's Location Before Arrival at the Hospital
Last emergency room number for patients admitted through the emergency room
(Last location information of the patient in emergency care)
Otherwise, NULL
DISCHARGE_LOCATION
Patient's Location After Discharge from the Hospital
[Discharge location] information in the discharge record
Home
Nursing home
Other hospital
Died
Run away
Etc
INSURANCE
Patient's Insurance Information
Patient's insurance type information in the hospital admission records
National Healthcare Insurance Service
Automobile insurance
medical insurance 1
medical insurance 2
medical insurance disabled
no insurance
clinical trial center
self research
research patient
MARITAL_STATUS
Patient's Current Marital Status Information
[Marital status] information in the nursing information survey
married
single
cohabit
no answer
separated
widowed
divorced
unclassifiable
EDREGTIME
Date and Time of Emergency Room Arrival for Patients Admitted through the Emergency Room
EDOUTTIME
Date and Time of Emergency Room Discharge for Patients Admitted through the Emergency Room
HOSPITAL_EXPIRE_FLAG
Survival Information at Discharge
Value Description
1 [Discharge outcome] in the discharge record is death or A death certificate has been issued
0 All other cases except the above (survived)
ICU_EXPIRE_FLAG
Survival Information at ICU Discharge
Value Description
1 [Discharge outcome] of ICU admission and discharge information is death
0 All other cases except the above
NATIONALITY
Patient's Nationality
Collected in English country names.
(Example: Republic of Korea, China, United States of America… )
HOSPITAL_ID
Hospital Code Assigned to Each Institution
Patients' gender, age, and date of death if information exists.
Information that is consistent for the lifetime of a patient is stored in this table.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR(50)
SEX VARCHAR(1)
ANCHOR_AGE VARCHAR(20)
ANCHOR_YEAR INTEGER
ANCHOR_YEAR_GROUP VARCHAR(20)
DOD TIMESTAMP
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
SEX
Patient's Gender
M - Male
F - Female
ANCHOR_AGE
Patient's Age at Time of Admission
If within 30 days, calculate as 'days'
If within 48 months, calculate as 'months'
If over 48 months, calculate as 'years'
If 90 years or older, mark as '90 years or older'
(Example: 87 years, 4 months, 1 day … )
ANCHOR_YEAR
De-identified Patient's Admission Year
ANCHOR_YEAR_GROUP
Categorized Year Group Based on Actual Year of Admission
DOD
Date and Time of Patient's Death
Information on the patient's date of death
Detailed information about patients' unit transfers.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
TRANSFER_SEQ INTEGER
TRANSFER_ID VARCHAR(50)
EVENTTYPE VARCHAR(10)
CAREUNIT VARCHAR(10)
INTIME TIMESTAMP
OUTTIME TIMESTAMP
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID Unique key information to distinguish hospital admission records
TRANSFER_SEQ
Sequence number for each patient location movement
Time-ordered sequence information about changes in patient location
(In cases where patients are admitted through the emergency room, information on their movement to the emergency room admission must also be included. Combine the ICU admission and discharge information with the transfer information to construct the patient's location change history in minute detail.)
TRANSFER_ID
Unique key to distinguish patient movement details
Admission ID (HADM_ID) + Patient movement sequence (TRANSFER_SEQ)
EVENTTYPE
Type of patient location movement
ed - at the time of emergency room admission
admit - at the time of hospital admission
transfer - transfer between wards
discharge - at discharge
CAREUNIT
ward information where the patient is located
Ward code information of the moved patient
INTIME
Admission date and time to the current location
Administrative transfer information is managed on a daily basis, and ICU admission and discharge information is managed by the minute. To construct more detailed date information, the patient's admission date is based on the ICU admission and discharge information.
If a patient moves from the ICU to a general ward, the admission date for the general ward is set to the previous ICU discharge date + 1 minute as there is no admission date in the transfer information.
If the movement is unrelated to ICU admission or discharge, the date information in the transfer information remains unchanged.
If discharged from the hospital, the discharge date is used as the admission date.
OUTTIME
Discharge date and time from the current location
Administrative transfer information is managed on a daily basis, and ICU admission and discharge information is managed by the minute. To construct more detailed movement information for the patient, the patient's movement information is based on the ICU admission and discharge information.
When discharging from a general ward and admitting to the ICU, the ICU admission date is set to one minute before the general ward discharge date.
If the movement is unrelated to ICU admission or discharge, the date information in the transfer information remains unchanged.
If discharged from the hospital, the discharge date is set to a NULL value.
The “Hosp” category consists of a total of 11 tables - DIAGNOSES_ICD, D_LABITEMS, D_TESTITEMS, EMAR, EMAR_DTAIL, LABEVENTS, MICROBIOLOGYEVENTS, PRESCRIPTIONS, PROCEDURES_ICD, SERVICES, TESTEVENTS.
Billed ICD-9/ICD-10 diagnoses for hospitalizations.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
SEQ_NUM INTEGER
ICD_CODE VARCHAR(10)
ICD_VERSION VARCHAR(10)
ITEMID VARCHAR(30)
IS_ICU CHAR(1)
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number for patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
Diagnoses for the entire hospital stay are collected, excluding rare diseases.
HADM_ID
Admission Registration ID
Unique key information to distinguish hospital admission records
SEQ_NUM
Sequence of ICU Diagnosis
Diagnostic sequence information to differentiate diagnoses issued during the ICU stay.
If multiple diagnoses are made by different departments during the ICU stay, they are ordered by main diagnosis, date of diagnosis, and diagnosis name.
(If there are duplicate ICD codes, duplicates are removed and the sequence is determined. The department during the ICU stay is based on transfer information.)
ICD_CODE
ICD Code among ICU Diagnosis Information
ICD code of diagnoses made during the ICU stay
ICD_VERSION
ICD Version among ICU Diagnosis Information
ICD version of diagnoses made during the ICU stay
ITEMID
Diagnosis Code
IS_ICU
ICU Diagnosis Presence
Whether the diagnosis was issued by the department treating patient during the ICU stay
Value Description
Y Diagnosis issued by the department treating the patient during their stay in the ICU
N All diagnoses not covered by Y
Dimension table for labevents provides a description of all lab items.
COLUMN_NAME TYPE
ITEMID VARCHAR(30)
LABEL VARCHAR(500)
FLUID VARCHAR(500)
CATEGORY VARCHAR(200)
EDI_CODE VARCHAR(500)
ITEMID
Unique Key to Distinguish Test Information
LABEL
Test Name
Name of the test code with prescription form code "Clinical Pathology and Other Specimen Tests (CP)
FLUID
Specimen Name
Information on the specimen targeted by the test
CATEGORY
Test Classification Information
List the classification information of the test.
For tests that belong to multiple classification stages, list all higher-level classification information.
(Example: Clinical Pathology and Other Specimen Tests > General Blood)
EDI_CODE
EDI Code
Collect the insurance EDI code that matches the fee code of the test.
(If not billed and there is no EDI code, collect as 'KMM90000')
This table lists records in the DICOM file database
COLUMN_NAME TYPE
ITEMID VARCHAR(30)
LABEL VARCHAR(500)
CATEGORY VARCHAR(200)
EDI_CODE VARCHAR(500)
ITEMID
Imaging Test Code
LABEL
Test Name
Imaging examination name
CATEGORY
Test Classification Information
List the classification information of the test.
EDI_CODE
EDI Code
Collect the insurance EDI code that matches the fee code of the test.
If not billed and there is no EDI code, collect as 'KMM90000'
The EMAR table is used to record administrations of a given medicine to an individual patient.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
EMAR_TYPE VARCHAR(20)
EMAR_ID VARCHAR(60)
EMAR_SEQ INTEGER
POE_ID VARCHAR(60)
PHARMACY_ID VARCHAR(60)
CHARTTIME TIMESTAMP
MEDICATION VARCHAR(500)
EVENT_TXT TEXT
STORETIME TIMESTAMP
ITEMID VARCHAR(30)
STAY_ID VARCHAR(50)
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
Medication administrations during the entire hospital stay are collected.
HADM_ID
Admission Registration ID Unique key information to distinguish hospital admission records
EMAR_TYPE
Source Type of Medication Administration Information
Acting: Signed information for Nursing action
Note: Clinical observation record
EMAR_ID
Unique Key Information to Distinguish Patient Medication Administration History
EMAR_SEQ
Nursing Action Sequence
Sequence information for drug administrations performed in chronological order
(Each sequence is determined based on the source; if there is data signed by the nursing action and recorded in the clinical observation records, a sequence number is assigned for each source.
Example:
Medication was administered for "Dextrose 5% & Na K2 1L bag (D5WNa77K20)"
Nursing action performed at 00:00, 01:30
Clinical observation recorded at 00:00, 01:30, 07:00, 07:30
Signed nursing action data are sequenced as 1, 2 and clinical observation records as 1, 2, 3)
POE_ID
Prescription ID
PHARMACY_ID
Prescription ID
Unique key to distinguish medication order details
Collect information on all medication orders with performance data (nursing actions + clinical observation [medication])
(Even information for actions that were not actually administered, such as Not given or Hold, should be collected, thus collecting all orders with a history of actions regardless of whether the order was returned or discontinued.
Additionally, performance information from clinical observations is collected, but since there is no mapping information between clinical observation records and medication orders, arbitrary order information is collected based only on order date + order code)
CHARTTIME
Performance Date and Time
Date and time information when medication was administered
MEDICATION
Administered Medication Name Information
Name of the drug in the administered medication order
EVENT_TXT
Administered: Administered
Not given: Not given
Held: ETC
Finished: Off
[Nursing actions]
Administered: Y, Y-, doctor, null (empty)
Not given: E, IV-, M-, N, R, X, outing, request, refusal, discharge
ETC: H
( A+, A- : not collected (excluded))
[Clinical observation records]
Off: cases recorded as 'off'
Administered: all other cases
STORETIME
Storage Date and Time Information
Point in time information when data was stored in the HIS system
ITEMID
Medication Code
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
If it is a medication order issued during the ICU stay, only collect the ICU admission and discharge ID.
Otherwise, collect as NULL (empty value).
The emar_detail table contains information for each medicine administration made in the EMAR table.
Information includes the associated pharmacy order, the dose due, the dose given, and many other parameters associated with the medical administration.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
EMAR_ID VARCHAR(60)
EMAR_SEQ INTEGER
PARENT_FIELD_ORDINAL INTEGER
PHARMACY_ID VARCHAR(60)
NOTE_TXT TEXT
ON_OFF VARCHAR(10)
INFUSION_RATE_DAY VARCHAR(100)
INFUSION_RATE_HR VARCHAR(100)
INFUSION_RATE_MIN VARCHAR(100)
ITEMID VARCHAR(30)
STAY_ID VARCHAR(50)
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
Collection medication administrations during the entire hospital stay.
HADM_ID
Admission Registration ID
Unique information to distinguish hospital admission records
EMAR_ID
Unique Key Information to Distinguish Patient Medication Administration History
EMAR_SEQ
Nursing Action Sequence
Sequence information for drug administrations performed in chronological order
(Each sequence is determined based on the source; if there is data signed by the nursing staff and recorded in the clinical observation records, a sequence number is assigned for each source.
Example: Medication was administered for "Dextrose 5% & Na K2 1L bag (D5WNa77K20) 중외"
Nursing action performed at 00:00, 01:30
Clinical observation recorded at 00:00, 01:30, 07:00, 07:30
Nursing data are sequenced as 1, 2 and clinical observation records as 1,2,3)
PARENT_FIELD_ORDINAL
Sequence of Performance by Prescription
Sequence information for actions performed in chronological order per prescription ID
(Example: ""Midazolam 5mg/5mL Inj Bukwang (Midazolam)"", ""Vecaron 4mg inj (Vecuronium)"" administered at 01:00
Midazolam 5mg/5mL Inj Bukwang (Midazolam)"" again administered at 07:00
EMAR_SEQ PARENT_FIELD_ORDINAL
Midazolam 5mg/5mL Inj 부광(Midazolam) 1 1
Vecaron 4mg inj(Vecuronium) 2 1
Midazolam 5mg/5mL Inj 부광(Midazolam) 3 2 )
PHARMACY_ID
Prescription ID
Unique key to distinguish medication order details
Collect information on all medication orders with performance data (nursing actions + clinical observation [medication])
(Even information for actions not actually administered, such as Not given or Hold, should be collected, thus collecting all orders with a history of actions regardless of whether the order was returned or discontinued.
Additionally, performance information from clinical observations is also collected, but since there is no mapping information between clinical observation records and medication orders, arbitrary order information is collected based only on order date + order code)
NOTE_TXT
Recorded Information Written on Clinical Observation Records
Recorded information in clinical observation records
ON_OFF
Medication Start and End
INFUSION_RATE_DAY
Daily Infusion Rate
INFUSION_RATE_HR
Hourly Infusion Rate
INFUSION_RATE_MIN
Minute-by-Minute Infusion Rate
ITEMID
Medication Code
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
ICU admission and discharge ID only for medication orders issued during the ICU stay period.
Otherwise, collected as NULL (empty value).
The labevents table stores the results of all laboratory measurements made for a single patient.
These include hematology measurements, blood gases, chemistry panels, and less common tests such as genetic assays.
COLUMN_NAME TYPE
LABEVENT_ID VARCHAR2(60)
SUBJECT_ID VARCHAR2(50)
HADM_ID VARCHAR2(50)
SPECIMEN_ID VARCHAR2(20)
ITEMID VARCHAR(30)
CHARTTIME TIMESTAMP
STORETIME TIMESTAMP
VALUE TEXT
VALUENUM DOUBLE
VALUEUOM VARCHAR(50)
REF_RANGE_LOWER TEXT
REF_RANGE_UPPER TEXT
FLAG VARCHAR(10)
COMMENTS TEXT
STAY_ID VARCHAR(50)
LABEVENT_ID
Unique Key to Distinguish Patient Test Details
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
HADM_ID
Admission Registration ID
Unique key to distinguish hospital admission records
SPECIMEN_ID
Information on Test Specimens Extracted from the Patient
Collect specimen numbers only for tests that involve specimens
ITEMID
Test Code
CHARTTIME
Time point information of the patient as indicated by the test results
(For test results conducted on specimens, the date and time the specimen was collected serve as the time point information indicating the patient's condition at that time)
진검/핵체외 - Date and time of blood collection (if there is no collection date and time, then admission date and time)
STORETIME
Date and time information when test results were entered
Interpretation date and time, result date and time
VALUE
Test Result
VALUENUM
Numeric Test Result
VALUEUOM
Test Result Unit
REF_RANGE_LOWER
Reference Range Lower Limit Content
REF_RANGE_UPPER
Reference Range Upper Limit Content
FLAG
Abnormality Presence
abnormal : Results outside the normal range
null : All other cases
COMMENTS
Remarks on Test Results
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
ICU admission and discharge ID only for test orders issued during the ICU stay period.
Otherwise, collected as NULL (empty value).
Contains microbiology information, including cultures acquired and associated sensitivities.
COLUMN_NAME TYPE
MICROEVENT_ID VARCHAR2(100)
SUBJECT_ID VARCHAR2(50)
HADM_ID VARCHAR2(50)
MICRO_SPECIMEN_ID VARCHAR2(20)
CHARTDATE TIMESTAMP
CHARTTIME TIMESTAMP
SPEC_ITEMID VARCHAR2(10)
SPEC_TYPE_DESC VARCHAR2(500)
TEST_SEQ INTEGER
STOREDATE TIMESTAMP
STORETIME TIMESTAMP
TEST_ITEMID VARCHAR2(30)
TEST_NAME VARCHAR2(500)
ORG_ITEMID VARCHAR2(30)
ORG_NAME TEXT
ISOLATE_NUM INTEGER
QUANTITY TEXT
AB_ITEMID VARCHAR2(30)
AB_NAME VARCHAR2(500)
DILUTION_TEXT TEXT
DILUTION_COMPARISON TEXT
DILUTION_VALUE TEXT
INTERPRETATION TEXT
COMMENTS TEXT
ORDERDATE TIMESTAMP
ORDER_COMMENTS TEXT
STAY_ID VARCHAR(50)
MICROEVENT_ID
Unique Key to Distinguish Patient Microbiology Test Details
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key to distinguish hospital admission records
MICRO_SPECIMEN_ID
Specimen Number
Unique key to distinguish the collected specimen
CHARTDATE
Date of Blood Collection
Date information when the specimen was collected
CHARTTIME
Date and Time of Blood Collection
Time information when the specimen was collected
SPEC_ITEMID
Specimen Code
SPEC_TYPE_DESC
Specimen Name
TEST_SEQ
(Culture Result) Sequence Number
Example
1, 2, 3, 4, 5 …
STOREDATE
Interpretation Date
Date information when the test was interpreted
STORETIME
Interpretation Date and Time
Time information when the test was interpreted
TEST_ITEMID
Test Code
TEST_NAME
Test Name
EXAMPLE
"URINE CULTURE"
"Blood Culture, Routine"
"WOUND CULTURE"
"FLUID CULTURE"
"TISSUE"
ORG_ITEMID
Identification Code
EXAMPLE
"canalb"
"citfre"
"corstr"
"entaer"
"esccol"
"klepne"
"mrsach"
"noana"
ORG_NAME
Identification Result Code Name
EXAMPLE
"ESCHERICHIA COLI"
"STAPH AUREUS COAG +"
"KLEBSIELLA PNEUMONIAE"
"PROTEUS MIRABILIS"
"STAPHYLOCOCCUS, COAGULASE NEGATIVE"
"ENTEROCOCCUS SP."
"PSEUDOMONAS AERUGINOSA"
"CANCELLED"
"YEAST"
ISOLATE_NUM
Colony Sequence
EXAMPLE
1, 2, 3, 4, 5 …
QUANTITY
Colony Count Content
EXAMPLE
null
"MODERATE-NUMBER"
"FEW"
"RARE"
AB_ITEMID
Antibiotic ID
AB_NAME
Antibiotic Name
EXAMPLE
null
"GENTAMICIN"
"TRIMETHOPRIM/SULFA"
"CIPROFLOXACIN"
"CEFTAZIDIME"
"MEROPENEM"
"TOBRAMYCIN"
DILUTION_TEXT
Diluent Name (Included Equipment Result Content + Antibiotic Diameter Content)
EXAMPLE
null
"<=1"
"<=0.25"
"<=4"
"<=0.5"
"<=2"
"=>32"
DILUTION_COMPARISON
Diluent Comparison Value (Included Equipment Result Content)
EXAMPLE
null
"<="
"="
"=>"
DILUTION_VALUE
Diluent Quantity (Antibiotic Diameter Content)
EXAMPLE
null
"1"
"0.25"
"4"
INTERPRETATION
S - Sensitive
R - Resistant
I - Intermediate
P - Pending
EXAMPLE
null
"S"
"R"
"I"
"P"
COMMENTS
Identification Result Remark Content
Microbial identification remark content
ORDERDATE
Order Date
Test order date information
ORDER_COMMENTS
Order Remark Content
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
ICU admission and discharge ID only for microbiology test orders issued during the ICU stay period.
Otherwise, collected as NULL (empty value).
Contains medication related order entries, i.e. prescriptions.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR2(50)
HADM_ID VARCHAR2(50)
PHARMACY_ID VARCHAR2(60)
STARTTIME TIMESTAMP
STOPTIME TIMESTAMP
DRUG_TYPE VARCHAR(20)
DRUG VARCHAR2(500)
GSN VARCHAR(10)
NDC VARCHAR(10)
PROD_STRENGTH TEXT
FORM_RX VARCHAR(25)
DOSE_VAL_RX VARCHAR(50)
DOSE_UNIT_RX VARCHAR(50)
FORM_VAL_DISP VARCHAR(50)
FORM_UNIT_DISP VARCHAR(50)
DOSES_PER_24_HRS REAL
ROUTE VARCHAR(50)
ITEMID VARCHAR(30)
STAY_ID VARCHAR(50)
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
Collection targets medication administrations during the entire hospital stay.
HADM_ID
Admission Registration ID
Unique key to distinguish hospital admission records
PHARMACY_ID
Unique Key to Distinguish Medication Prescription Details
STARTTIME
Date and Time When Medication Prescription Started
Prescription date of the medication order
STOPTIME
Date and Time When Medication Prescription Stopped
Prescription date of the medication order
DRUG_TYPE
Type of Medication Composition Information
Value Description
MAIN If the prescription is for the primary medication among bundled medications.
(top order in the bundle)
BASE If the prescription is for an additional medication within a bundle of drugs.
(remaining orders other than the top one in the bundle)
NULL (empty value) For cases other than the above
DRUG
Name of Prescribed Medication
GSN
ATC International Code
NDC
EDI Insurance Code
If not a covered medication, collected as 'KMM999999'
PROD_STRENGTH
Usage of Medication Prescribed
Collect information about the dose, unit, frequency, and duration of the order at the time of issue in free text format
(Example: 500 mg, q8h, 1 DAY)
FORM_RX
Administration Unit
Unit of the medication administered at the time of the order
DOSE_VAL_RX
Medication Content
Content of the prescribed medication
DOSE_UNIT_RX
Medication Content Unit
Unit of content of the prescribed medication
FORM_VAL_DISP
Medication Specifications
Specification of the prescribed medication
FORM_UNIT_DISP
Medication Specification Unit
Unit of specification of the prescribed medication
DOSES_PER_24_HRS
24-Hour Adjusted Dose
ROUTE
Medication Administration Route
Route of administration name
Standardized and collected under the following 20 administration routes:
Nasogastric Tube / Oral / Sublingual / Apply / Drop / Gargling / Inhalation / Epidural / IM / IntraArtery / Intraarticular / IntraPeritoneal / IntraThecal / IntraVesical / IV / Perineural / SC / Subconjunctival / Tracheal / Vaccination
ITEMID
Medication Code
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
ICU admission and discharge ID only for medication orders issued during the ICU stay period.
Otherwise, collected as NULL (empty value).
Contains ICD procedures for patients, most notably ICD-9 procedures.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR2(50)
HADM_ID VARCHAR2(50)
SEQ_NUM INTEGER
CHARTDATE TIMESTAMP
ICD_CODE VARCHAR2(10)
ICD_VERSION VARCHAR2(20)
ITEMID VARCHAR(30)
STAY_ID VARCHAR(50)
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key to distinguish hospital admission records
SEQ_NUM
Surgery Sequence
Surgical sequence number in the order of scheduled surgery registration
Example
1, 2, 3…
CHARTDATE
Surgery Date
Patient's surgery date information
ICD_CODE
ICD Code of Surgery Name
Example
77.89
ICD_VERSION
ICD Code Version of Surgery Name
Example
ICD9CM
ITEMID
Surgery Name Code
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
ICU admission and discharge ID only if the procedure was performed during the ICU stay period.
Otherwise, collected as NULL (empty value)
Lists services that a patient was admitted/transferred under.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR2(50)
HADM_ID VARCHAR2(50)
TRANSFERTIME TIMESTAMP
PREV_SERVICE VARCHAR(20)
CURR_SERVICE VARCHAR(20)
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key to distinguish hospital admission records
TRANSFERTIME
Transfer Application Start Date
PREV_SERVICE
Previous Department Code
CURR_SERVICE
Current Department Code
Corresponding to a x-ray, is assigned a unique dicom file path.
COLUMN_NAME TYPE
TESTEVENT_ID VARCHAR2(60)
SUBJECT_ID VARCHAR2(50)
HADM_ID VARCHAR2(50)
ITEMID VARCHAR(30)
CHARTTIME TIMESTAMP
STORETIME TIMESTAMP
FILE_PATH VARCHAR2(100)
STAY_ID VARCHAR(50)
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number with ICU admission and discharge time information
HADM_ID
Admission Registration ID
Unique key information to distinguish hospital admission records
ITEMID
Test Code
CHARTTIME
Time Point Information of Patient Indicated by Test Results
Imaging examination date and time, admission date and time
STORETIME
Date and time information when test results were entered
Interpretation date and time, result date and time
FILE_PATH
File Location
DICOM file path of the imaging examination results within the central platform
For imaging examinations performed during the ICU stay (or issued by the ICU)
Anonymous ID (excluding R, only 12 digits) + De-identified order date YYMMDD + SEQ 4 digits (adopting the institution's unique SEQ)
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
Only applicable for examination orders issued during the ICU stay period.
Otherwise, collected as NULL.
The “ICU” category consists of a total of 7 tables - CHARTEVENTS, DATETIMEEVENTS, D_ITEMS, ICUSTAYS, INPUTEVENTS, OUTPUTEVENTS, PROCEDUREEVETNS.
Contains all charted data for patients.
COLUMN_NAME TYPE
CHARTEVENT_ID VARCHAR(50)
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
STAY_ID VARCHAR(50)
CHARTTIME TIMESTAMP
STORETIME TIMESTAMP
ITEMID VARCHAR(60)
VALUE TEXT
VALUENUM DOUBLE
VALUEUOM VARCHAR(50)
WARNING SMALLINT
CHARTEVENT_ID
Unique Key to Distinguish Patient Clinical Observation Record Details
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key information to distinguish hospital admission records
STAY_ID
Patient's ICU STAY_ID at the time the record was created
CHARTTIME
Record Date and Time
STORETIME
Record Storage Date and Time
ITEMID
Item ID of the Record
VALUE
Record Content
Original content recorded in the item
VALUENUM
Numeric Record Content
Only numeric records of the content recorded in the item are collected after refinement
VALUEUOM
Record Unit
Unit of the content recorded in the item
WARNING
Alert
Contains Patient Nursing Log and Nursing Activity Record Details
COLUMN_NAME TYPE
DATETIMEEVENT_ID VARCHAR(50)
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
STAY_ID VARCHAR(50)
CHARTTIME TIMESTAMP
STORETIME TIMESTAMP
ITEMID VARCHAR(60)
VALUE TEXT
VALUEUOM VARCHAR(50)
WARNING SMALLINT
DATETIMEEVENT_ID
Unique Key to Distinguish Patient Nursing Log and Nursing Activity Record Details
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key information to distinguish hospital admission records
STAY_ID
Patient's ICU STAY_ID at the time the record was created
CHARTTIME
Record Date and Time
STORETIME
Record Storage Date and Time
ITEMID
Item ID of the Record
VALUE
Record Content
Original content originally recorded in the item
VALUEUOM
Record Unit
Unit of the content recorded in the item
WARNING
Alert
Dimension table describing itemid. Defines concepts recorded in the events table in the ICU module.
COLUMN_NAME TYPE
ITEMID VARCHAR(60)
LABEL VARCHAR(500)
ABBREVIATION VARCHAR(500)
LINKSTO VARCHAR(20)
CATEGORY VARCHAR(500)
UNITNAME VARCHAR(30)
PARAM_TYPE VARCHAR(30)
LOWNORMALVALUE DOUBLE
HIGHNORMALVALUE DOUBLE
ITEMID
Unique Key to Distinguish Item Details
Collection of IDs for items documented in nursing narratives, nursing activities, clinical observation records, and test codes recognized as procedures. As a single nursing term is used across multiple types of record items through mapping connections, each item is specifically constructed and collected in combinations like ItemID + TermID.
LABEL
Item Name
Collect names of items written in nursing narratives, nursing activities, and clinical observation records.
Collect names of surgical fees and test orders.
ABBREVIATION
Abbreviation Name
Collect under the abbreviation registered in the nursing terms.
(If the item is not mapped to a nursing term or if there is no registered abbreviation for the mapped term, collect as NULL.)
LINKSTO
Associated event Table Name
Specify the associated event name.
Examples
charevents
datetimeevents
inputevents
outputevents
procedureevents
CATEGORY
Item Classification Name
If there is a classification system for the item, collect it.
UNITNAME
Item Unit
Examples
%
FB
Fr
IU
J
L
L%/R%
L/min
L/min/m2
Tab.
U
V
amp.
Basal
...
etc.
PARAM_TYPE
Item Type
Examples
Coded Text
Text
Multi Text
Date
Date & Time
Integer Number
Real Number
Image
LOWNORMALVALUE
Lower Limit Value of Item
If there is a lower limit value for the item, collect it.
HIGHNORMALVALUE
Upper Limit Value of Item
If there is an upper limit value for the item, collect it.
Tracking information for ICU stays including admission and discharge times.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
STAY_ID VARCHAR(50)
FIRST_CAREUNIT VARCHAR(10)
LAST_CAREUNIT VARCHAR(10)
INTIME TIMESTAMP(0)
OUTTIME TIMESTAMP(0)
LOS DOUBLE
OP_FLAG SMALLINT
SUBJECT_ID
Patient number of patients with a history of ICU stay "Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)"
HADM_ID
Admission Registration ID
Unique key information to distinguish hospital admission records
STAY_ID
Unique Key to Distinguish ICU Admission and Discharge Details
FIRST_CAREUNIT
Admission Ward Department Code
LAST_CAREUNIT
Discharge Ward Department Code
INTIME
Admission Date and Time to Current Location
OUTTIME
Discharge Date and Time from Current Location
LOS
Discharge Date and Time - Admission Date and Time
Discharge time - Admission time
OP_FLAG
Post-surgery ICU Admission Presence
Value Description
1 Admission after a scheduled surgery
(There is an OR exit time within 30 minutes before or after the ICU admission time, and the surgery schedule is non-emergency)
2 Admission after emergency surgery
(There is an OR exit time within 30 minutes before or after the ICU admission time, and the surgery schedule is emergency)
0 Admissions other than 1 or 2
Information documented regarding continuous infusions or intermittent administrations.
COLUMN_NAME TYPE
INPUTEVENT_ID VARCHAR(50)
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
ICUSTAY_ID VARCHAR(50)
STARTTIME TIMESTAMP
ENDTIME TIMESTAMP
ITEMID VARCHAR(60)
AMOUNT TEXT
AMOUNTUOM VARCHAR(50)
RATE TEXT
RATEUOM VARCHAR(50)
PATIENTWEIGHT DOUBLE PRECISION
STORETIME TIMESTAMP
CGID BIGINT
ORDERID BIGINT
LINKORDERID BIGINT
INPUTEVENT_ID
Unique Key to Distinguish Patient Intake Details
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key information to distinguish hospital admission records
ICUSTAY_ID
Patient's ICU STAY_ID at the time the record was created
STARTTIME
Infusion Start Date and Time
ENDTIME
Infusion End Date and Time
ITEMID
Item ID of the Record
AMOUNT
Dose
Collect the content recorded in the clinical observation intake.
AMOUNTUOM
Dose Unit
Dosage unit
RATE
Infusion Rate
RATEUOM
Infusion Rate Unit
PATIENTWEIGHT
Patient's Weight at the Time
If there is no weight information measured at the time of recording, collect the most recent weight information measured before the STARTTIME
STORETIME
Record Storage Date and Time
CGID
ORDERID
Order ID
LINKORDERID
Connected Order ID
Information regarding patient outputs including urine, drainage, and so on.
COLUMN_NAME TYPE
OUTPUTEVENT_ID VARCHAR(50)
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
ICUSTAY_ID VARCHAR(50)
CHARTTIME TIMESTAMP
STORETIME TIMESTAMP
ITEMID VARCHAR(60)
VALUE TEXT
VALUEUOM VARCHAR(50)
WARNING SMALLINT
OUTPUTEVENT_ID
Unique Key to Distinguish Patient Excretion Details
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key information to distinguish hospital admission records
ICUSTAY_ID
Patient's ICU STAY_ID at the time the record was created
CHARTTIME
Record Date and Time
STORETIME
Record Storage Date and Time
ITEMID
Item ID of the Record
VALUE
Item Value
Original ontent recorded in the item
VALUEUOM
Item Unit
Unit of the content recorded in the item
WARNING
Alert
Contains procedures for patients
COLUMN_NAME TYPE
PROCEDUREEVENT_ID VARCHAR(50)
SUBJECT_ID VARCHAR(50)
HADM_ID VARCHAR(50)
STAY_ID VARCHAR(50)
STARTTIME TIMESTAMP
ENDTIME TIMESTAMP
STORETIME TIMESTAMP
ITEMID VARCHAR(60)
VALUE TEXT
VALUEUOM VARCHAR2(50)
LOCATION VARCHAR(100)
LOCATIONCATEGORY VARCHAR(500)
ORDERCATEGORYNAME VARCHAR(500)
SECONDARYORDERCATEGORYNAME VARCHAR(500)
ORDERCATEGORYDESCRIPTION VARCHAR(500)
PATIENTWEIGHT DOUBLE PRECISION
PROCEDUREEVENT_ID
Unique Key to Distinguish Patient Procedure Details
SUBJECT_ID
Patient number of patients with a history of ICU stay
Patient number of patients with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)
HADM_ID
Admission Registration ID
Unique key to distinguish hospital admission records
STAY_ID
Patient's ICU STAY_ID at the time the record was created
STARTTIME
Procedure Start Date and Time
Surgery - Surgery start date and time
Procedure (test) - Order date
Surgical timing information - OR(Operation Room) admission date and time, surgery start date and time, anesthesia start date and time, recovery room admission date and time
ENDTIME
Procedure End Date and Time
Surgery - Surgery end date and time
Procedure (test) - Order date
Surgical timing information - OR exit date and time, surgery end date and time, anesthesia end date and time, recovery room exit date and time
STORETIME
Order Issue Date and Time
ITEMID
Item ID of the Record
Surgery - P_Surgery Fee Code
Procedure (test) - P_Test Code
OR admission and exit times - P_OR
Surgery start and end times - P_Surgery
Anesthesia start and end times - P_Anesthesia
Recovery room admission and exit times - P_PACU
Collected in combination.
VALUE
Test Result
Numeric, text, and other structured test results
(Excludes unstructured test results (excludes results in form or image formats))
VALUEUOM
Test Result Unit
LOCATION
Test Site Name
LOCATIONCATEGORY
Test Site Classification Name
ORDERCATEGORYNAME
Top-Level Order Classification Name
SECONDARYORDERCATEGORYNAME
Sub-Level Order Classification Name
ORDERCATEGORYDESCRIPTION
Order Classification Name
PATIENTWEIGHT
Patient's Weight at the Time
If there is no recorded weight at the time of the test or surgery, collect the most recent weight measured before the STARTTIME
The “ED” category consists of a total of 3 tables - EDSTAY, MEDRECON, TRIAGE.
The edstays table is the primary tracking table for emergency department visits.
It provides the time the patient entered the emergency department and the time they left the emergency department.
COLUMN_NAME TYPE
SUBJECT_ID VARCHAR2(50)
STAY_ID(pk) VARCHAR(50)
INTIME TIMESTAMP
OUTTIME TIMESTAMP
SEX CHAR(1)
DX1 VARCHAR(500)
DX1_ICD VARCHAR(10)
DX2 VARCHAR(500)
DX2_ICD VARCHAR(10)
DX3 VARCHAR(500)
DX3_ICD VARCHAR(10)
DX4 VARCHAR(500)
DX4_ICD VARCHAR(10)
DX5 VARCHAR(500)
DX5_ICD VARCHAR(10)
DX6 VARCHAR(500)
DX6_ICD VARCHAR(10)
DX7 VARCHAR(500)
DX7_ICD VARCHAR(10)
DX8 VARCHAR(500)
DX8_ICD VARCHAR(10)
DX9 VARCHAR(500)
DX9_ICD VARCHAR(10)
SUBJECT_ID
Patient number of patients with a history of ICU stay "Patient number of patients admitted through the emergency room with ICU admission and discharge time information
Patients discharged during a specific period based on the discharge date
(Example: Patients discharged from 2021.01.01 to 2021.01.10 who have a history of ICU stays)"
STAY_ID
Emergency Room Admission ID
Unique key to distinguish emergency room admission records
INTIME
Emergency Room Arrival Date and Time
OUTTIME
Emergency Room Discharge Date and Time
SEX
Gender Code
DX1
First Diagnosis Name
The main diagnosis of the emergency visit is collected as the first diagnosis, and the remaining diagnoses are collected in order of date of issue and alphabetically.
DX1_ICD
First Diagnosis ICD Code
Primary diagnosis ICD code of the emergency visit
DX2
Second Diagnosis Name
Diagnosis name of the emergency visit
(If there is no second diagnosis, null)
DX2_ICD
Second Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no second diagnosis, null)
DX3
Third Diagnosis Name
Diagnosis name of the emergency visit
(If there is no third diagnosis, null)
DX3_ICD
Third Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no third diagnosis, null)
DX4
Fourth Diagnosis Name
Diagnosis name of the emergency visit
(If there is no fourth diagnosis, null)
DX4_ICD
Fourth Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no fourth diagnosis, null)
DX5
Fifth Diagnosis Name
Diagnosis name of the emergency visit
(If there is no fifth diagnosis, null)
DX5_ICD
Fifth Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no fifth diagnosis, null)
DX6
Sixth Diagnosis Name
Diagnosis name of the emergency visit
(If there is no sixth diagnosis, null)
DX6_ICD
Sixth Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no sixth diagnosis, null)
DX7
Seventh Diagnosis Name
Diagnosis name of the emergency visit
(If there is no seventh diagnosis, null)
DX7_ICD
Seventh Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no seventh diagnosis, null)
DX8
Eighth Diagnosis Name
Diagnosis name of the emergency visit
(If there is no eighth diagnosis, null)
DX8_ICD
Eighth Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no eighth diagnosis, null)
DX9
Ninth Diagnosis Name
Diagnosis name of the emergency visit
(If there is no ninth diagnosis, null)
DX9_ICD
Ninth Diagnosis ICD Code
ICD code of the emergency visit's diagnosis
(If there is no ninth diagnosis, null)
On admission to the emergency departments, staff will ask the patient what current medications they are taking.
This process is called medicine reconciliation, and the medrecon table stores the findings of the care providers.
COLUMN_NAME TYPE
STAY_ID VARCHAR(50)
CHARTTIME TIMESTAMP
NAME TEXT
GSN VARCHAR(10)
NDC VARCHAR(10)
STAY_ID
Emergency Room Admission ID
Unique key that distinguishes emergency room admission records
CHARTTIME
Record Date and Time
NAME
Emergency Medication Information
Collect detailed information on the most recent medication status (freetext) from the hospital admission nursing information survey.
GSN
ATC Code
Since this information is absent in the HIS, it is collected as NULL
NDC
EDI Code
Since this information is absent in the HIS, it is collected as NULL
The triage table contains information about the patient when they were first triaged in the emergency department.
COLUMN_NAME TYPE
STAY_ID VARCHAR(50)
TEMP DOUBLE
HR DOUBLE
RR DOUBLE
SAO2 VARCHAR(50)
PAIN VARCHAR(50)
ACUITY DOUBLE
SBP DOUBLE
DBP DOUBLE
STAY_ID
Emergency Room Admission ID
Unique key that distinguishes emergency room admission records
TEMP
Body Temperature at Emergency Room Visit
Collection of following information
Emergency nursing information survey > Physical Examination > body temperature(BT)
HR
Pulse at Emergency Room Visit
Collection of following information
Emergency nursing information survey > Physical Examination > pulse
RR
Respiration at Emergency Room Visit
Collection of following information
Emergency nursing information survey > Physical Examination > respiration (RR)
SAO2
SPO2 at Emergency Room Visit
Collection of following information
Emergency nursing information survey > Physical Examination > Saturation Pulse Oxygen (SPO2)
PAIN
Pain
Collection of following information
Emergency nursing information survey > Physical Examination > Pain presence
"Present", "Absent", "Not assessable" collected as named
ACUITY
Severity
Collection of following information
Emergency nursing information survey > General Information > KTAS level
SBP
Systolic Blood Pressure at Emergency Room Visit
Collection of following information
Emergency nursing information survey > Physical Examination > Vital Signs > Systolic Blood Pressure (SBP)
DBP
Diastolic Blood Pressure at Emergency Room Visit
Collection of following information
Emergency nursing information survey > Physical Examination > Vital Signs > Diastolic Blood Pressure (DBP)
The “HIS” category consists of 1 table - HOSPITAL.
Contains hospital id
COLUMN_NAME TYPE
HOSPITAL_ID VARCHAR(3)
STATUS CHAR(1)
HOSPITAL_ID
Hospital ID
Initialize with arbitrarily assigned data
Example
001, 002, ...
STATUS
Data Collection Medical Institution Presence
Value Description
Y If it is the hospital code to be used during data collection
N If it is a hospital code not to be used during data collection