HCPCS events

Hospital level table


  • 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 is a unique identifier which specifies an individual patient. Any rows associated with a single subject_id pertain to the same individual.


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


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


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.


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

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