Tables [dbo].[HealthConcern_Impression]
Health Concern Impression
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_HealthConcern_Impression_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the HealthConcern_Impression table.
Cluster Key CIX_HealthConcern_Impression_HealthConcernHeaderID_EncounterID: HealthConcernHeaderID\EncounterIDForeign Keys FK_HealthConcern_Impression_HealthConcernHeaderID_HealthConcern_Header_ID: [dbo].[HealthConcern_Header].HealthConcernHeaderIDHealthConcernHeaderID[dbo].[uniqueid]9NOT NULLHealth Concern Header ID. Link to HealthConcern_Header.ID.
Cluster Key CIX_HealthConcern_Impression_HealthConcernHeaderID_EncounterID: HealthConcernHeaderID\EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
ImpressionTextvarchar(2000)2000NULL allowedImpression Text
IsCurrentImpressionForEncounterbit1NULL allowedIs this Impression is the latest impression for the Encounter?
ImpressionByID[dbo].[uniqueid]9NOT NULLProvider , who added the impression
RecordedDTTMdatetime8NOT NULLImpression recorded date and time