History_PatientDiagnos


Description

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

Columns

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

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

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

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

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

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

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

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

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

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

Indexes

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

Relationships

Close relationships within degrees of separation