claim_anesthesia_procedure

The anesthesia related surgical procedure (Loop 2300 HI). This could be the principal (HI01-01='BP') or secondary (HI01-01='BO') Healthcare Common Procedure Coding System (HCPCS) code. See the 837i x12 spec for more information.

Primary Key:

• claim_id
• claim_anesthesia_procedure_index

Checks:

• claim_anesthesia_procedure_hcpcs_code_check - (hcpcs_code <> ''::text)

Foreign Keys:

• claim_id => claim.claim_id
• line_item_procedure_code_id => line_item_procedure_code_lookup.line_item_procedure_code_id

Indexes:

• claim_anesthesia_procedure_claim_id_idx - claim_id
• claim_anesthesia_procedure_line_item_procedure_code_id_idx - line_item_procedure_code_id

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	Link to the claim record. Generated through expression:
claim_anesthesia_procedure_index	smallint	No	Yes	Deprecated (to be removed in future release). Generated through expression:
hcpcs_code	text	No	No	Healthcare Common Procedure Coding System (HCPCS) are the standard codes used to describe medical procedures, supplies, products and services. For more information, see https://www.cms.gov/medicare/coding-billing/healthcare-common-procedure-system. Generated through expression:
is_principal	boolean	No	No	If true, this is the principal anesthesia procedure. Generated through expression:
line_item_procedure_code_id	bigint	Yes	Yes	Link to the HCPCS lookup record. Generated through expression: