discharge_detail

Additional information associated with notes documented in the discharge table. Can be linked to the discharge table using note_id.

  • discharge_detail on note_id

Table columns

Name Postgres data type
note_id VARCHAR(25) NOT NULL
subject_id INTEGER NOT NULL
field_name VARCHAR(255) NOT NULL
field_value TEXT NOT NULL
field_ordinal INTEGER NOT NULL

note_id

A unique identifier for the given note. note_id is composed of subject_id, the note_type (always two characters long), and a monotonically increasing integer, note_seq, in the following format: subject_id-note_type-note_seq.

subject_id

subject_id is a unique identifier which specifies an individual patient. Any rows associated with a single subject_id pertain to the same individual.

field_name

Each row provides detail regarding a particular aspect of a note. field_name is the name given to that aspect. As of MIMIC-IV, v1.0, possible values include:

  • author

field_value

field_value is the value associated with the given field_name, associated with a note. For example, for the field_name of ‘author’, the field_value column contains the author of the note.