PatientDiagnos


Description

Patient diagnoses managing patient diagnosis assignments including ICD codes, diagnosis dates, and clinical tracking. This table links patients to their diagnoses with ordering, creation tracking, and status management to support clinical documentation, treatment planning, and medical record management for healthcare services and early intervention programs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DiagID int identity 4 √ null

Primary key - Unique identifier for each patient diagnosis record
caseID int 4 √ null
PatientAdministration.AdmitID FK__PatientDiag__PatientAdmin C

Case reference - Links to PatientAdministration table for the patient case
DiagnosisID varchar 20 √ null

Diagnosis code - ICD diagnosis code or identifier
DateDiagnos smalldatetime 16 √ null

Diagnosis date - Date when the diagnosis was made or confirmed
PatientID int 4 √ null

Patient reference - Links to Patient table for the diagnosed patient
Orderby int 4 √ null

Display order - Order in which this diagnosis should be displayed (primary, secondary, etc.)
fkDiagID int 4 √ null

Diagnosis reference - Links to Diagnosis table for detailed diagnosis information
DateCreated smalldatetime 16 √ null

Creation date - Date when this diagnosis record was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this diagnosis record
Deleted bit 1 √ null

Deleted flag - Boolean indicating if this diagnosis has been deleted (soft delete)
DateInactive smalldatetime 16 √ null

Inactive date - Date when this diagnosis became inactive or was resolved

Indexes

Constraint Name Type Sort Column(s)
PK__PatientDiagnos__2DFCAC08 Primary key Asc DiagID

Relationships

Close relationships within degrees of separation