Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (2) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Problem_Header table. |
 (2)![Foreign Keys FK_Problem_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Problem_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | | Not used |
(3) | CurrentProblemID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Latest problem instance. Link to Problem.ID. |
| ManualRank | smallint | 2 | NOT NULL | (0) | Not used |
| OnsetFuzzyWhen | varchar(50) | 50 | NOT NULL | | Onset Fuzzy date |
| DiagnoseFuzzyWhen | varchar(50) | 50 | NOT NULL | (' ') | Diagnosis Fuzzy date |
| ResolvedFuzzyWhen | varchar(50) | 50 | NOT NULL | | Resolved Fuzzy date |
(2) | CreateDTTM | datetime | 8 | NOT NULL | | Datetime problem was added |
 | LastUpdateDTTM | datetime | 8 | NOT NULL | | Datetime Problem was last updated |
![Check Constraints CK_Problem_Header_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Problem_Header_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Has Security Restrictions (Y/N) ? |
![Check Constraints CK_Problem_Header_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Problem_Header_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Annotation Exists FLAG (Y/N) |
![Check Constraints CK_Problem_Header_IsChronicFLAG_Yes_Or_No : ([IsChronicFLAG]='N' OR [IsChronicFLAG]='Y') Check Constraints CK_Problem_Header_IsChronicFLAG_Yes_Or_No : ([IsChronicFLAG]='N' OR [IsChronicFLAG]='Y')](../../../../Images/c-constraint.png) | IsChronicFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is Chronic Problem (Y/N) ? |
![Check Constraints CK_Problem_Header_ProblemType_ProblemTypes : ([ProblemType]='' OR [ProblemType]='A' OR [ProblemType]='C' OR [ProblemType]='T' OR [ProblemType]='P') Check Constraints CK_Problem_Header_ProblemType_ProblemTypes : ([ProblemType]='' OR [ProblemType]='A' OR [ProblemType]='C' OR [ProblemType]='T' OR [ProblemType]='P')](../../../../Images/c-constraint.png) | ProblemType | char(1) | 1 | NOT NULL | | Problem Type |
![Check Constraints CK_Problem_Header_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y') Check Constraints CK_Problem_Header_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')](../../../../Images/c-constraint.png) | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Entered In Error FLAG (Y/N) |
 | OnsetFuzzySortAs | datetime | 8 | NULL allowed | | Onset date |
| DiagnoseFuzzySortAs | datetime | 8 | NULL allowed | | Diagnosis date |
 | ResolvedFuzzySortAs | datetime | 8 | NULL allowed | | Resolved date |
![Check Constraints CK_Problem_Header_OnsetFuzzySpecificity_FuzzyDate_Types : ([OnsetFuzzySpecificity]='F' OR [OnsetFuzzySpecificity]='Y' OR [OnsetFuzzySpecificity]='D' OR [OnsetFuzzySpecificity]='M') Check Constraints CK_Problem_Header_OnsetFuzzySpecificity_FuzzyDate_Types : ([OnsetFuzzySpecificity]='F' OR [OnsetFuzzySpecificity]='Y' OR [OnsetFuzzySpecificity]='D' OR [OnsetFuzzySpecificity]='M')](../../../../Images/c-constraint.png) | OnsetFuzzySpecificity | char(1) | 1 | NOT NULL | | Onset Date Type 'D' - Date 'F' - Fuzzy Date |
![Check Constraints CK_Problem_Header_DiagnoseFuzzySpecificity_FuzzyDate_Types : ([DiagnoseFuzzySpecificity]='F' OR [DiagnoseFuzzySpecificity]='Y' OR [DiagnoseFuzzySpecificity]='D' OR [DiagnoseFuzzySpecificity]='M') Check Constraints CK_Problem_Header_DiagnoseFuzzySpecificity_FuzzyDate_Types : ([DiagnoseFuzzySpecificity]='F' OR [DiagnoseFuzzySpecificity]='Y' OR [DiagnoseFuzzySpecificity]='D' OR [DiagnoseFuzzySpecificity]='M')](../../../../Images/c-constraint.png) | DiagnoseFuzzySpecificity | char(1) | 1 | NOT NULL | | Diagnosis Date Type 'D' - Date 'F' - Fuzzy Date |
![Check Constraints CK_Problem_Header_ResolvedFuzzySpecificity_FuzzyDate_Types : ([ResolvedFuzzySpecificity]='F' OR [ResolvedFuzzySpecificity]='Y' OR [ResolvedFuzzySpecificity]='D' OR [ResolvedFuzzySpecificity]='M') Check Constraints CK_Problem_Header_ResolvedFuzzySpecificity_FuzzyDate_Types : ([ResolvedFuzzySpecificity]='F' OR [ResolvedFuzzySpecificity]='Y' OR [ResolvedFuzzySpecificity]='D' OR [ResolvedFuzzySpecificity]='M')](../../../../Images/c-constraint.png) | ResolvedFuzzySpecificity | char(1) | 1 | NOT NULL | | Resolved Date Type 'D' - Date 'F' - Fuzzy Date |
(2)![Foreign Keys FK_Problem_Header_ProblemCategoryDE_Problem_Category_DE_ID: [dbo].[Problem_Category_DE].ProblemCategoryDE Foreign Keys FK_Problem_Header_ProblemCategoryDE_Problem_Category_DE_ID: [dbo].[Problem_Category_DE].ProblemCategoryDE](../../../../Images/fk.png) | ProblemCategoryDE | [dbo].[dict_id] | 5 | NOT NULL | | Problem Category. Link to Problem_Category_DE.ID. |
 ![Check Constraints CK_Problem_Header_HMConceptFLAG_Yes_Or_No : ([HMConceptFLAG]='N' OR [HMConceptFLAG]='Y') Check Constraints CK_Problem_Header_HMConceptFLAG_Yes_Or_No : ([HMConceptFLAG]='N' OR [HMConceptFLAG]='Y')](../../../../Images/c-constraint.png) | HMConceptFLAG | [dbo].[BOOL] | 1 | NULL allowed | ('N') | IS HM (Health Management) Concept (Y/N) ? |
| AgeAtDeathFamMem | int | 4 | NULL allowed | | Age of death of family member due to this problem |
![Check Constraints CK_Problem_Header_IsCauseOfDeathFamMem_Yes_Or_No : ([IsCauseOfDeathFamMem]='N' OR [IsCauseOfDeathFamMem]='Y') Check Constraints CK_Problem_Header_IsCauseOfDeathFamMem_Yes_Or_No : ([IsCauseOfDeathFamMem]='N' OR [IsCauseOfDeathFamMem]='Y')](../../../../Images/c-constraint.png) | IsCauseOfDeathFamMem | [dbo].[BOOL] | 1 | NULL allowed | | Is this Problem caused death of family member (Y/N) ? |
| LastAssessedDTTM | datetime | 8 | NULL allowed | | Datetime the problem was last assessed |
| LastAssessedByID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | UserID who last assessed the problem. |
| CommunitySourceID | varchar(255) | 255 | NULL allowed | | OID of the Source EHR |
| CommunitySourceName | varchar(255) | 255 | NULL allowed | | Name of the Source EHR |
| CommunityItemID | varchar(100) | 100 | NULL allowed | | internal Problem ID in the Source EHR |