line_item_procedure_code_lookup

Unified lookup for procedure codes (CPT, HCPCS, ADA CDT, and user-defined).

Primary Key:

• line_item_procedure_code_id

Checks:

• line_item_procedure_code_lookup_clean_code_check - (line_item_procedure_code = upper(TRIM(BOTH FROM line_item_procedure_code)))
• line_item_procedure_code_lookup_not_empty_check - (line_item_procedure_code <> ''::text)

Indexes:

• line_item_procedure_code_lookup_procedure_code_release_date_idx (Unique) - line_item_procedure_code, release_date

Column	Data Type	Nullable	Indexed	Description
line_item_procedure_code_id	bigint	No	Yes	Snowflake ID for procedure code. Generated through expression:
line_item_procedure_qualifier	product_service_id_type	No	No	Source of the procedure code. Generated through expression:
line_item_procedure_code	text	No	Yes	The procedure code. Generated through expression:
release_date	date	No	Yes	Date these descriptions were released. Generated through expression:
deleted_date	date	Yes	No	Date the procedure code was removed. Generated through expression:
long_description	text	No	No	Long description of the code. Generated through expression:
medium_description	text	No	No	Medium description of the code. Generated through expression:
short_description	text	No	No	Short description of the code. Generated through expression:
consumer_friendly_description	text	No	No	Consumer-friendly description of the code. Generated through expression: