The admissions table
Table source: Hospital database.
Table purpose: Define a patient’s admission.
Number of rows: 1,196
Links to:
- PATIENT on SUBJECT_ID
Summary
The ADMISSIONS table provides information about a patient’s ICU admission. Available information includes timing information for admission and discharge, demographic information, and the release outcome.
Table columns
| Name | Data type |
|---|---|
| ROW_ID | INT |
| SUBJECT_ID | INT |
| ADMITDATE | DATETIME(0) |
| ADMITTIME | TIMESTAMP(0) |
| DISCHDATE | DATETIME(0) |
| DISCHTIME | TIMESTAMP(0) |
| RELEASE_DESCRIPTION | VARCHAR(50) |
Detailed description
The ADMISSIONS table defines all SUBJECT_ID present in the database, covering the admission period from 2015 to 2025.
SUBJECT_ID
Each row of this table contains a unique SUBJECT_ID, representing a single patient’s ICU admission. This table may contain duplicate SUBJECT_ID, indicating that a single patient had multiple hospital admissions. The ADMISSIONS table can be linked to the PATIENTS table and all other table in the database via SUBJECT_ID.
ADMITDATE, ADMITTIME, DISCHDATE, DISCHTIME
ADMITDATE and ADMITTIME provide the date and time the
patient was admitted to the hospital, while DISCHDATE and
DISCHTIME provide the date and time the patient was discharged.
There can be some discrepancies due to typographical errors.
RELEASE_DESCRIPTION
This column records each patient’s ICU outcome and is populated upon discharge. It provides information on the patient's final clinical status or disposition. Common categories include discharged, expired, LAMA (left against medical advice), discharge on request, procedure done, infusion given, and unchanged.