Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the HealthConcern table |
 ![Foreign Keys FK_HealthConcern_HealthConcernHeaderID_HealthConcern_Header_ID: [dbo].[HealthConcern_Header].HealthConcernHeaderID Foreign Keys FK_HealthConcern_HealthConcernHeaderID_HealthConcern_Header_ID: [dbo].[HealthConcern_Header].HealthConcernHeaderID](../../../../Images/fk.png) | HealthConcernHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | Health Concern Header ID. Link to HealthConcern_Header.ID. |
![Foreign Keys FK_HealthConcern_HealthConcernStatusDE: [dbo].[HealthConcern_Status_DE].HealthConcernStatusDE Foreign Keys FK_HealthConcern_HealthConcernStatusDE: [dbo].[HealthConcern_Status_DE].HealthConcernStatusDE](../../../../Images/fk.png) | HealthConcernStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Status. Link to HealthConcern_Status_DE.ID. |
| LinkedClinicalItems | varchar(8000) | 8000 | NOT NULL | ('') | PR^<Problem_DE.ID>| MED-AL^< Medication_Allergy_DE.ID >| NONMED-AL ^< Allergen_DE.ID >| RI^< QO _DE.ID > |
| StartDTTM | datetime | 8 | NULL allowed | | Health concern identified date and time |
| EndDTTM | datetime | 8 | NULL allowed | | Health concern end date and time |
| WhoDiditID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who added the Health Concern into Patient Chart |
| ManagedByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who is treating the particular health Concern |
| ManagedByProviderType | char(1) | 1 | NULL allowed | | Managed by Provider type - 'P' - for Provider 'R' for referring provider |
| HealthConcernDescription | varchar(1024) | 1024 | NULL allowed | | Brief Description about the health Concern |
| CurrentImpressionID | [dbo].[uniqueid] | 9 | NULL allowed | | Latest impression ID for the Health Concern. Link to HealthConcern_Impression.ID. |
| RecordedDTTM | datetime | 8 | NOT NULL | | Health Concern instance recorded date and time |
| SiteDE | [dbo].[dict_id] | 5 | NOT NULL | | Provider logged-in site. Link to Site_DE.ID. |
| CurrentHealthConcernName | varchar(255) | 255 | NULL allowed | | Corresponding name matching Source Dictionary ID value. |
| CurrentHealthConcernSourceDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Source Dictionary ID value |