Tables [dbo].[HealthConcern_ClinicalItem_Link]
Linked Clinical items for the Health Concern
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_HealthConcern_ClinicalItem_Link_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the HealthConcern_ClinicalItem_Link table.
Cluster Key CIX_HealthConcern_ClinicalItem_Link_HealthConcernHeaderID_ClinicalItemType: HealthConcernHeaderID\ClinicalItemTypeForeign Keys FK_HealthConcern_ClinicalItem_Link_HealthConcernHeaderID_HealthConcern_Header_ID: [dbo].[HealthConcern_Header].HealthConcernHeaderIDHealthConcernHeaderID[dbo].[uniqueid]9NOT NULLHealth Concern Header ID. Link to HealthConcern_Header.ID.
Cluster Key CIX_HealthConcern_ClinicalItem_Link_HealthConcernHeaderID_ClinicalItemType: HealthConcernHeaderID\ClinicalItemTypeClinicalItemTypevarchar(10)10NOT NULL‘PR’ – Problem
‘RI’ – result
‘MED-AL’ – Med Allergy
‘NONMED-AL’ – Non Med Allergy
ClinicalItemDE[dbo].[dict_id]5NOT NULLProblem_DE.ID OR
QO _DE.ID OR
Medication_Allergy_DE.ID OR
Allergen_DE.ID
CreateDTTMdatetime8NOT NULLCreated date and time
ClinicalItemHeaderID[dbo].[uniqueid]9NULL allowedID of problem/results instance data