Tables [dbo].[HealthConcern]
Health Concern instance
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_HealthConcern_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the HealthConcern table
Indexes NIX_HealthConcern_HealthConcernHeaderIDForeign Keys FK_HealthConcern_HealthConcernHeaderID_HealthConcern_Header_ID: [dbo].[HealthConcern_Header].HealthConcernHeaderIDHealthConcernHeaderID[dbo].[uniqueid]9NOT NULLHealth Concern Header ID. Link to HealthConcern_Header.ID.
Foreign Keys FK_HealthConcern_HealthConcernStatusDE: [dbo].[HealthConcern_Status_DE].HealthConcernStatusDEHealthConcernStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to HealthConcern_Status_DE.ID.
LinkedClinicalItemsvarchar(8000)8000NOT NULL('')PR^<Problem_DE.ID>|
MED-AL^< Medication_Allergy_DE.ID >|
NONMED-AL ^< Allergen_DE.ID >|
RI^< QO _DE.ID >
StartDTTMdatetime8NULL allowedHealth concern identified date and time
EndDTTMdatetime8NULL allowedHealth concern end date and time
WhoDiditID[dbo].[uniqueid]9NOT NULLProvider who added the Health Concern into Patient Chart
ManagedByProviderID[dbo].[uniqueid]9NOT NULLProvider who is treating the particular health Concern
ManagedByProviderTypechar(1)1NULL allowedManaged by Provider type - 'P' - for Provider 'R' for referring provider
HealthConcernDescriptionvarchar(1024)1024NULL allowedBrief Description about the health Concern
CurrentImpressionID[dbo].[uniqueid]9NULL allowedLatest impression ID for the Health Concern. Link to HealthConcern_Impression.ID.
RecordedDTTMdatetime8NOT NULLHealth Concern instance recorded date and time
SiteDE[dbo].[dict_id]5NOT NULLProvider logged-in site. Link to Site_DE.ID.
CurrentHealthConcernNamevarchar(255)255NULL allowedCorresponding name matching Source Dictionary ID value.
CurrentHealthConcernSourceDE[dbo].[dict_id]5NOT NULL((0))Source Dictionary ID value