History_Diagnosis


Description

Diagnosis audit history maintaining comprehensive audit trail of changes to diagnosis records for clinical data integrity and compliance. This audit table tracks all modifications to diagnosis data including field-level changes, timestamps, user accountability, and before/after values, supporting clinical audit requirements, data integrity verification, and regulatory compliance for patient diagnosis management and medical record keeping.

Columns

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

History primary key - Unique identifier for each diagnosis audit history record
DateArchived datetime 16,3 √ null

Archive timestamp - Date and time when the diagnosis change was recorded in the audit history
TableName varchar 50 √ null

Source table name - Name of the diagnosis table where the original change occurred
FieldName varchar 50 √ null

Changed field name - Name of the specific diagnosis field that was modified
ValueBefore varchar 4000 √ null

Previous value - Value of the diagnosis field before the change was made
ValueAfter varchar 4000 √ null

New value - Value of the diagnosis field after the change was made
ArchivedBy int 4 √ null
AccessUser.UserID FK__History_D__Archi__4B6F7563 R

Change user reference - Links to AccessUser table for the healthcare provider who made the diagnosis change (foreign key to AccessUser.UserID)
InsertID int 4 √ null

Record identifier - Primary key of the diagnosis record that was modified in the source table
FieldID int 4 √ null

Field identifier - Numeric identifier for the diagnosis field that was changed

Indexes

Constraint Name Type Sort Column(s)
PK__History_Diagnosis Primary key Asc HistID

Relationships

Close relationships within degrees of separation