claim_procedure

Provides information about the ICD procedure codes associated with a claim. (https://www.cms.gov/medicare/coding-billing/icd-10-codes)

Primary Key:

• claim_id
• claim_procedure_index

Checks:

• claim_procedure_procedure_code_check - ((procedure_code = upper(procedure_code)) AND (procedure_code <> ''::text))

Foreign Keys:

• claim_id => claim.claim_id
• icd_procedure_id => icd_procedure_lookup.icd_procedure_id

Indexes:

• claim_procedure_claim_id_is_principal_idx - claim_id, is_principal
• claim_procedure_icd_procedure_id_idx - icd_procedure_id
• claim_procedure_principal_uq (Unique) - claim_id
• claim_procedure_procedure_code_uq (Unique) - claim_id, procedure_code

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	Link to the claim record. Generated through expression:
procedure_code	text	No	Yes	ICD procedure code (Loop 2300 HIxx_01=BBR 'Principal Procedure' or BBQ 'Other Procedure' / UB04 FL74 when is_principal is true, FL74a-e when is_principal is false). Generated through expression:
procedure_date	date	Yes	No	Date of procedure (Loop 2300 HI01_03). Generated through expression:
icd_version	text	No	No	ICD version. Value will be 9 for ICD-9, 10 for ICD-10, etc. (Loop 2300 seg HIxx_01). Generated through expression:
is_principal	boolean	No	Yes	Is the ICD procedure code the principal code. Generated through expression:
icd_procedure_id	bigint	Yes	Yes	Link to the ICD procedure record. Generated through expression:
claim_procedure_index	smallint	No	Yes	Order of claim procedure codes found in the claim. Indexes are 0-based so the first occurrence code in the claim will have an index of 0, second will have an index of 1 and so on.. Generated through expression: