Tables [dbo].[HealthConcern_Header]
Health Concern Header
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_HealthConcern_Header_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the HealthConcern_Header table
Cluster Key CIX_HealthConcern_Header_PatientID: PatientIDForeign Keys FK_HealthConcern_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
CurrentHealthConcernID[dbo].[uniqueid]9NOT NULLCurrent instance of the Health Concern. Link to HealthConcern.ID.
EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
HealthConcernNamevarchar(255)255NOT NULLName of the Health Concern
HealthConcernSourceDE[dbo].[dict_id]5NOT NULLProblem_DE.ID OR
QO _DE.ID OR
Medication_Allergy_DE.ID OR
Allergen_DE.ID
ClinicalItemTypevarchar(10)10NOT NULL‘PR’ – Problem
‘RI’ – result
‘MED-AL’ – Med Allergy
‘NONMED-AL’ – Non Med Allergy
CreatedByID[dbo].[uniqueid]9NOT NULLProvider who added the Health Concern  into the patient Chart
CreateDTTMdatetime8NOT NULLDate and time of Health Concern added into the patient Chart
LastUpdateDTTMdatetime8NOT NULLLast updated date and time
ClinicalItemHeaderID[dbo].[uniqueid]9NULL allowedID of problem/results instance data