Dimension table: hcpcs

Hospital level table

The d_hcpcs table

The D_HCPCS table is used to acquire human readable definitions for the codes used in the HCPCSEVENTS table. The concepts primarily correspond to hospital billing.

  • HCPCSEVENTS on code

Table columns

Name Postgres data type
code CHAR(5)
category SMALLINT
long_description TEXT
short_description VARCHAR(180)

Detailed description


A five character code which uniquely represents the event.


Broad classification of the code.

long_description, short_description

Textual descriptions of the code listed for the given row.

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