HCPCS events

Hospital level table

hcpcsevents

  • d_hcpcs on hcpcs_cd

Table columns

Name Postgres data type
subject_id INTEGER
hadm_id INTEGER
hcpcs_cd CHAR(5)
seq_num INTEGER
short_description TEXT

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.

hadm_id

hadm_id is an integer identifier which is unique for each patient hospitalization.

hcpcs_cd

A five character code which uniquely represents the event. Link this to code in D_HCPCS for a longer description of the code.

seq_num

An assigned order to HCPCS codes for an individual hospitalization. This order sometimes conveys meaning, e.g. sometimes higher priority, but this is not guaranteed across all codes.

short_description

A short textual descriptions of the hcpcs_cd listed for the given row.


Last modified August 14, 2020: update website to use docsy (adc506c)