product_service_code_lookup

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

Primary Key:

• product_service_id

Checks:

• product_service_code_lookup_clean_code_check - (product_service_code = upper(TRIM(BOTH FROM product_service_code)))
• product_service_code_lookup_not_empty_check - (product_service_code <> ''::text)

Indexes:

• product_service_code_lookup_uq (Unique) - product_service_code, release_date

Column	Data Type	Nullable	Indexed	Description
product_service_id	bigint	No	Yes	Snowflake ID for product/service code.
product_service_code_qualifier	product_service_code_type	No	No	Source of the product/service code.
product_service_code	text	No	Yes	The product/service code.
release_date	date	No	Yes	Date these descriptions were released.
deleted_date	date	Yes	No	Date the product/service code was removed.
long_description	text	No	No	Long description of the product/service code.
medium_description	text	No	No	Medium description of the product/service code.
short_description	text	No	No	Short description of the product/service code.
consumer_friendly_description	text	No	No	Consumer-friendly description of the product/service code.