ClaimICD9


Description

Claim ICD diagnosis codes linking claims to specific ICD-9 diagnosis codes for medical justification and billing. This junction table manages the many-to-many relationship between claims and diagnosis codes, supporting multiple diagnoses per claim and proper medical coding for insurance billing and clinical documentation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkClaimID int 4 null
Claim.ClaimID FK_ClaimICD9_Claim R

Claim reference - Links to Claim table for the associated claim
fkICD9ID int 4 null
Diagnosis.pkDiagID FK_ClaimICD9_Diagnosis R

Diagnosis reference - Links to Diagnosis table for the ICD-9 diagnosis code
Orderby int 4 √ null

Diagnosis order - Order or priority of the diagnosis code for this claim (primary, secondary, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_ClaimICD9 Primary key Asc/Asc fkClaimID + fkICD9ID
IDX_fkClaimID_fkICD9ID Performance Asc/Asc fkClaimID + fkICD9ID

Relationships

Close relationships within degrees of separation