claim_procedure
Provides information about the ICD procedure codes associated with a claim
Primary Key:Foreign Keys:claim_id=>claim.claim_idhcup_procedure_group_id=>hcup_procedure_group_lookup.hcup_procedure_group_idicd_procedure_id=>icd_procedure_lookup.icd_procedure_id
claim_procedure_claim_id_idx-claim_idclaim_procedure_hcup_procedure_group_id_idx-hcup_procedure_group_idclaim_procedure_icd_procedure_id_idx-icd_procedure_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
claim_id | bigint | No | Yes | - |
procedure_code | text | No | No | - |
procedure_date | date | Yes | No | - |
icd_version | text | No | No | - |
is_principal | boolean | Yes | No | - |
icd_procedure_id | bigint | Yes | Yes | - |
claim_procedure_index | smallint | No | Yes | - |
hcup_procedure_group_id | bigint | Yes | Yes | - |