Diagnosis


Description

Medical diagnosis codes managing ICD diagnosis codes and descriptions for medical billing and clinical documentation. This master table defines diagnosis codes with their descriptions to support accurate medical coding, claim justification, and clinical documentation for healthcare services and billing operations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DateCreated smalldatetime 16 √ null

Creation date - Date when the diagnosis code was added to the system
CreatedBy int 4 √ null

Created by user - UserID of the person who added the diagnosis code
Deleted bit 1 √ null

Deletion flag - Boolean indicator for soft deletion
DeletedDate Unknown 0 null

Deletion date - Date when the diagnosis code was marked as deleted
DiagnosisCode varchar 20 null

Diagnosis code - ICD diagnosis code (ICD-9, ICD-10, etc.)
DiagnDesc varchar 100 √ null

Diagnosis description - Description of the medical diagnosis
pkDiagID int identity 4 √ null
AuthorizeICD9.fkICD9ID FK_AuthorizeICD9_Diagnosis R
ClaimICD9.fkICD9ID FK_ClaimICD9_Diagnosis R
PatientEvaluationICD9.fkICD9ID FK_PatientEvaluationICD9_Diagnosis R
SubclaimICD9.fkICD9ID FK_SubclaimICD9_Diagnosis R

Primary key - Unique identifier for each diagnosis record
ICD10 bit 1 √ null

ICD-10 flag - Boolean indicator whether this is an ICD-10 diagnosis code

Indexes

Constraint Name Type Sort Column(s)
PK_Diagnosis Primary key Asc pkDiagID

Relationships

Close relationships within degrees of separation