Tables [dbo].[Encounter_Audit]
Encounter form audit
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Encounter_Audit: EncounterIDCluster Key CIX_Encounter_Audit_LastChangeDTTM_EncounterID: LastChangeDTTM\EncounterIDForeign Keys FK_Encounter_Audit_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
audittextvarchar(max)maxNOT NULLHTML rendering of all encounter form edits
CreateDTTMdatetime8NOT NULL('01/01/1900')Creation data and time
Cluster Key CIX_Encounter_Audit_LastChangeDTTM_EncounterID: LastChangeDTTM\EncounterIDLastChangeDTTMdatetime8NOT NULL('01/01/1900')Last updated date and time