hcpcsevents
Links to
- d_hcpcs on hcpcs_cd
Table columns
| Name | Postgres data type |
|---|---|
subject_id |
INTEGER NOT NULL |
hadm_id |
INTEGER NOT NULL |
chartdate |
DATE |
hcpcs_cd |
CHAR(5) NOT NULL |
seq_num |
INTEGER NOT NULL |
short_description |
VARCHAR(180) |
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.
chartdate
The date associated with the coded event.
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.