hpcsevents
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.
Feedback
Was this page helpful?
Glad to hear it! Please raise an issue here to tell us how we can improve.
Sorry to hear that. Please raise an issue here to tell us how we can improve.