PatientEvaluationICD9


Description

Patient evaluation ICD-9 diagnosis associations linking evaluations to specific diagnostic codes for clinical documentation and billing. This junction table manages the relationship between patient evaluations and ICD-9 diagnosis codes including ordering information, supporting accurate diagnosis coding, clinical documentation, and evaluation-based diagnosis tracking for healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkEvalID int 4 null
PatientEvaluation.EvalID FK_PatientEvaluationICD9_PatientEvaluation R

Evaluation reference - Links to PatientEvaluation table for the associated evaluation (foreign key to PatientEvaluation.EvalID)
fkICD9ID int 4 null
Diagnosis.pkDiagID FK_PatientEvaluationICD9_Diagnosis R

ICD-9 diagnosis reference - Links to Diagnosis table for the associated diagnostic code (foreign key to Diagnosis.pkDiagID)
Orderby int 4 √ null

Diagnosis order - Numeric order for displaying or prioritizing diagnoses in the evaluation

Indexes

Constraint Name Type Sort Column(s)
PK_PatientEvaluationICD9 Primary key Asc/Asc fkEvalID + fkICD9ID

Relationships

Close relationships within degrees of separation