Tables [dbo].[Problem_Impression]
New table created to store Impressions added for each Patient's problem. This is Encounter specific. Impressions are added on the problem details screen.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Prob_Impr_ProbHderID_EncID_RecDTTM: ProblemHeaderID\EncounterID\RecordedDTTMForeign Keys FK_Problem_Impression_ProblemHeaderID: [dbo].[Problem_Header].ProblemHeaderIDProblemHeaderID[dbo].[uniqueid]9NOT NULLKey to the Problem_Header table
Indexes NIX_Problem_Impression_ProbIDForeign Keys FK_Problem_Impression_ProblemID: [dbo].[Problem].ProblemIDProblemID[dbo].[uniqueid]9NOT NULLKey to the Problem table. Problem version the impression was entered under.
Cluster Primary Key PK_Prob_Impr_ProbHderID_EncID_RecDTTM: ProblemHeaderID\EncounterID\RecordedDTTMForeign Keys FK_Problem_Impression_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLKey to the Encounter table.
ImpressionTextvarchar(2000)2000NOT NULLImpression text
ImpressionByID[dbo].[uniqueid]9NOT NULLUserID of the user who entered the impression
Cluster Primary Key PK_Prob_Impr_ProbHderID_EncID_RecDTTM: ProblemHeaderID\EncounterID\RecordedDTTMRecordedDTTMdatetime8NOT NULLRecorded time