hcup_hcpcs_crosswalk

HCUP HCPCS crosswalk. See hcpcs_hcup_group for the linkage between product_service_id and hcup_hcpcs_group_id. (https://hcup-us.ahrq.gov/toolssoftware/ccs_svcsproc/ccssvcproc.jsp)

Primary Key:

• hcpcs_code
• release_date

Foreign Keys:

• hcup_hcpcs_group_id => hcup_hcpcs_group_lookup.hcup_hcpcs_group_id

Indexes:

• hcup_hcpcs_crosswalk_hcup_hcpcs_group_id_idx - hcup_hcpcs_group_id

Column	Data Type	Nullable	Indexed	Description
hcpcs_code	text	No	Yes	HCPCS code. Generated through expression:
release_date	date	No	Yes	- Generated through expression:
hcup_hcpcs_group_id	bigint	No	Yes	Link to the HCUP HCPCS group record. Generated through expression: