AuthorizeICD9


Description

Authorization diagnosis codes linking service authorizations to specific ICD-9 diagnosis codes for medical justification. This table manages the relationship between authorizations and their supporting medical diagnoses, enabling proper medical coding, insurance billing, and clinical documentation for healthcare service approvals.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkAuthID int 4 null
Authorize.AuthID FK_AuthorizeICD9_PatientEvaluation R

Authorization reference - Links to Authorize table for the service authorization
fkICD9ID int 4 null
Diagnosis.pkDiagID FK_AuthorizeICD9_Diagnosis R

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

Order sequence - Order in which this diagnosis appears for the authorization (primary, secondary, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_AuthorizeICD9 Primary key Asc/Asc fkAuthID + fkICD9ID

Relationships

Close relationships within degrees of separation