Note events. Patient nursing/doctor notes, discharge summaries and reports such as echo, ecg, radiology
| Name | Type | Nullable | Default value | Comment |
|---|
| SUBJECT_ID | NUMBER(7) | N | | Unique patient identifier |
| HADM_ID | NUMBER(7) | Y | | The hospital admission id of the note event |
| ICUSTAY_ID | NUMBER(7) | Y | | The icustay id of the note event |
| ELEMID | NUMBER(7) | Y | | Element of each note |
| CHARTTIME | TIMESTAMP(6) WITH TIME ZONE | N | | Date/time of the note request |
| REALTIME | TIMESTAMP(6) WITH TIME ZONE | Y | | Real time of the notes entry |
| CGID | NUMBER(7) | Y | | Caregiver who requested/entered the note |
| CORRECTION | CHAR(1) | Y | | Is this report a correction to a previous note |
| CUID | NUMBER(7) | Y | | Care unit where this note was entered |
| CATEGORY | VARCHAR2(26) | Y | | Type of note |
| TITLE | VARCHAR2(255) | Y | | Title of the note |
| TEXT | CLOB | Y | | Main body of the note |
| EXAM_NAME | VARCHAR2(100) | Y | | Name of the examination |
| PATIENT_INFO | VARCHAR2(4000) | Y | | Patient information |
