Tables [dbo].[Problem_Header]
Problem Instance Header
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Problem_Header_ID: IDIndexes NIX_Problem_Header_CurrentProblemID, NIX_Problem_Header_ProblemCategoryDE_INC_ID_CurrentProblemID(2)ID[dbo].[uniqueid]9NOT NULLKey to the Problem_Header table.
Cluster Key XAK1Problem: PatientIDIndexes TWstat_Problem_Header_CurrentProblemID_PatientID, TWstat_Problem_Header_ProblemCategoryDE_PatientID(2)Foreign Keys FK_Problem_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
DocFolderIDnumeric(16,0)9NOT NULLNot used
Indexes NIX_Problem_Header_CurrentProblemID, NIX_Problem_Header_ProblemCategoryDE_INC_ID_CurrentProblemID, TWstat_Problem_Header_CurrentProblemID_PatientID(3)CurrentProblemID[dbo].[uniqueid]9NOT NULL(0)Latest problem instance. Link to Problem.ID.
ManualRanksmallint2NOT NULL(0)Not used
OnsetFuzzyWhenvarchar(50)50NOT NULLOnset Fuzzy date
DiagnoseFuzzyWhenvarchar(50)50NOT NULL(' ')Diagnosis Fuzzy date
ResolvedFuzzyWhenvarchar(50)50NOT NULLResolved Fuzzy date
Indexes NIX_Problem_Header_CreateDTTM, TWstat_Problem_Header_CreateDTTM(2)CreateDTTMdatetime8NOT NULLDatetime problem was added
Indexes Portal_Problem_HeaderLastUpdateDTTMdatetime8NOT NULLDatetime Problem was last updated
Check Constraints CK_Problem_Header_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLHas Security Restrictions  (Y/N) ?
Check Constraints CK_Problem_Header_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotation Exists FLAG (Y/N)
Check Constraints CK_Problem_Header_IsChronicFLAG_Yes_Or_No : ([IsChronicFLAG]='N' OR [IsChronicFLAG]='Y')IsChronicFLAG[dbo].[BOOL]1NOT NULLIs Chronic Problem (Y/N) ?
Check Constraints CK_Problem_Header_ProblemType_ProblemTypes : ([ProblemType]='' OR [ProblemType]='A' OR [ProblemType]='C' OR [ProblemType]='T' OR [ProblemType]='P')ProblemTypechar(1)1NOT NULLProblem Type
Check Constraints CK_Problem_Header_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')IsErrorFLAG[dbo].[BOOL]1NOT NULLEntered In Error FLAG (Y/N)
Indexes TWstat_Problem_Header_OnsetFuzzySortAsOnsetFuzzySortAsdatetime8NULL allowedOnset date
DiagnoseFuzzySortAsdatetime8NULL allowedDiagnosis date
Indexes XIE2Problem_HeaderResolvedFuzzySortAsdatetime8NULL allowedResolved date
Check Constraints CK_Problem_Header_OnsetFuzzySpecificity_FuzzyDate_Types : ([OnsetFuzzySpecificity]='F' OR [OnsetFuzzySpecificity]='Y' OR [OnsetFuzzySpecificity]='D' OR [OnsetFuzzySpecificity]='M')OnsetFuzzySpecificitychar(1)1NOT NULLOnset 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')DiagnoseFuzzySpecificitychar(1)1NOT NULLDiagnosis 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')ResolvedFuzzySpecificitychar(1)1NOT NULLResolved Date Type
 'D' - Date
 'F' - Fuzzy Date
Indexes NIX_Problem_Header_ProblemCategoryDE_INC_ID_CurrentProblemID, TWstat_Problem_Header_ProblemCategoryDE_PatientID(2)Foreign Keys FK_Problem_Header_ProblemCategoryDE_Problem_Category_DE_ID: [dbo].[Problem_Category_DE].ProblemCategoryDEProblemCategoryDE[dbo].[dict_id]5NOT NULLProblem Category. Link to Problem_Category_DE.ID.
Indexes NIX_Problem_Header_CurrentProblemIDCheck Constraints CK_Problem_Header_HMConceptFLAG_Yes_Or_No : ([HMConceptFLAG]='N' OR [HMConceptFLAG]='Y')HMConceptFLAG[dbo].[BOOL]1NULL allowed('N')IS HM (Health Management) Concept (Y/N) ?
AgeAtDeathFamMemint4NULL allowedAge of death of family member due to this problem
Check Constraints CK_Problem_Header_IsCauseOfDeathFamMem_Yes_Or_No : ([IsCauseOfDeathFamMem]='N' OR [IsCauseOfDeathFamMem]='Y')IsCauseOfDeathFamMem[dbo].[BOOL]1NULL allowedIs this Problem caused death of family member (Y/N) ?
LastAssessedDTTMdatetime8NULL allowedDatetime the problem was last assessed
LastAssessedByID[dbo].[uniqueid]9NOT NULL((0))UserID who last assessed the problem.
CommunitySourceIDvarchar(255)255NULL allowedOID of the Source EHR
CommunitySourceNamevarchar(255)255NULL allowedName of the Source EHR
CommunityItemIDvarchar(100)100NULL allowedinternal Problem ID in the Source EHR