SubclaimICD9


Description

Sub-claim ICD-9 diagnosis associations linking service coordination sub-claims to diagnostic codes. This junction table establishes many-to-many relationships between service coordination claims and ICD-9 diagnosis codes, supporting accurate medical billing, diagnosis coding, and compliance with healthcare coding standards for service coordination activities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkSubclaimID int 4 null
scClaim.SclaimID FK_SubclaimICD9_scClaim R

Sub-claim reference - Links to the service coordination claim (scClaim.SclaimID)
fkICD9ID int 4 null
Diagnosis.pkDiagID FK_SubclaimICD9_Diagnosis R

ICD-9 diagnosis reference - Links to the diagnosis code record (Diagnosis.pkDiagID)
Orderby int 4 √ null

Order sequence - Sequence order for multiple diagnoses on the same claim

Indexes

Constraint Name Type Sort Column(s)
PK_SubclaimICD9 Primary key Asc/Asc fkSubclaimID + fkICD9ID

Relationships

Close relationships within degrees of separation