Tables [dbo].[Problem]
Problem Instance
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Problem_ID: IDIndexes TWstat_Problem_ICD9DiagnosisDE_ID, TWstat_Problem_ManagementEffectiveDE_ID, TWstat_Problem_Problem_ID, TWstat_Problem_ProblemDE_ID, TWstat_Problem_ProblemIncludeFlags_ID, TWstat_Problem_ProblemStatus_ID, TWstat_Problem_ProblemStatusDE_ID, TWstat_Problem_ProblemTypeDE_ID, TWstat_Problem_RecordedDTTM_ID(9)ID[dbo].[uniqueid]9NOT NULLKey to the Problem table
Indexes XIE1Problem, NIX_Problem_ProblemStatusDE_WithIncludeColumns, NIX_Problem_RecordedDttm_INC_ProblemHeaderID_IdentifiedByID(3)Foreign Keys FK_Problem_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderIDProblemHeaderID[dbo].[uniqueid]9NOT NULLProblem Header. Link to Problem_Header.ID
Indexes NIX_Problem_ProblemDE_WithIncludeColumns, XIE1Problem, NIX_Problem_ProblemStatusDE_WithIncludeColumns, TWstat_Problem_ProblemDE_ID(4)Foreign Keys FK_Problem_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDEProblemDE[dbo].[dict_id]5NOT NULLProblem. Link to Problem_DE.ID
ProblemDETvarchar(255)255NOT NULLProblem Entry Name
Indexes NIX_Problem_Problem, NIX_Problem_ProblemDE_WithIncludeColumns, XIE1Problem, NIX_Problem_ProblemStatusDE_WithIncludeColumns, TWstat_Problem_Problem_ID(5)Problemvarchar(255)255NOT NULLProblem Name
ClinicalSeverityDE[dbo].[dict_id]5NOT NULLSeverity of the problem. Link to Clinical_Severity_DE.ID.
ClinicalSeverityDETvarchar(255)255NOT NULLClinical Severity entered
ClinicalSeverityvarchar(255)255NOT NULLClinical Severity
ClinicalSeverityCode[dbo].[code]10NOT NULLClinical Severity Code
Indexes XAK1Problem_SecondaryToIDForeign Keys FK_Problem_SecondaryToID_Problem_Header_ID: [dbo].[Problem_Header].SecondaryToIDSecondaryToID[dbo].[uniqueid]9NOT NULLThe current problem as a secondary problem to one of the patient’s other existing problems. Link to Problem_Header.ID.
Indexes TWstat_Problem_ProblemTypeDE_IDForeign Keys FK_Problem_ProblemTypeDE_Problem_Type_DE_ID: [dbo].[Problem_Type_DE].ProblemTypeDEProblemTypeDE[dbo].[dict_id]5NOT NULLProblem Type. Link to Problem_Type_DE.ID
Indexes NIX_Problem_ProblemDE_WithIncludeColumns, NIX_Problem_ProblemStatusDE_WithIncludeColumns, TWstat_Problem_ProblemStatusDE_ID(3)Foreign Keys FK_Problem_ProblemStatusDE_Problem_Status_DE_ID: [dbo].[Problem_Status_DE].ProblemStatusDEProblemStatusDE[dbo].[dict_id]5NOT NULLProblem Status. Link to Problem_Status_DE.ID
Indexes TWstat_Problem_ProblemStatus_IDProblemStatusvarchar(255)255NOT NULLProblem Status
Indexes TWstat_Problem_ManagementEffectiveDE_IDManagementEffectiveDE[dbo].[dict_id]5NOT NULLClinical Progress Dictionary ID. Link to Management_Effective_DE.ID
ManagementEffectiveDETvarchar(255)255NOT NULLClinical Progress EntryName
ProblemDescriptionvarchar(1000)1000NOT NULL('')Problem Description
Indexes NIX_Problem_RecordedDttm_INC_ProblemHeaderID_IdentifiedByID, TWstat_Problem_IdentifiedByID(2)IdentifiedByID[dbo].[uniqueid]9NOT NULLThe provider who identified the problem for the associated patient.
Check Constraints CK_Problem_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')ReasonForCreateTypechar(1)1NOT NULLReason for create
         Allowed values
                 'A'
                  'C'
                  'E'
WhoForID[dbo].[uniqueid]9NOT NULLProvider who requested to add the problem for the patient.  Link to Person.ID
WhoDidItID[dbo].[uniqueid]9NOT NULLProvider who added the problem for the patient.  Link to Person.ID
PerformedDTTMdatetime8NOT NULLDate time the problem was added to the Patient
Indexes NIX_Problem_RecordedDttm_INC_ProblemHeaderID_IdentifiedByID, TWstat_Problem_RecordedDTTM_ID(2)RecordedDTTMdatetime8NOT NULLDate time the problem was added to the Patient
Indexes TWstat_Problem_ICD9DiagnosisDE_IDForeign Keys FK_Problem_ICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].ICD9DiagnosisDEICD9DiagnosisDE[dbo].[dict_id]5NOT NULLICD9 Diagnosis. Link to ICD9_Diagnosis_DE.ID.
Indexes TWstat_Problem_ManagedByIDManagedByID[dbo].[uniqueid]9NOT NULLProvider who is managing the problem for the patient. Link to Person.ID.
ResolvedByID[dbo].[uniqueid]9NOT NULLProvider who resolved the problem for the patient. Link to Person.ID.
Goalvarchar(255)255NOT NULLGoal
NoteActivityID[dbo].[uniqueid]9NULL allowedNote Activity ID
LateralityDEnumeric(8,0)5NULL allowedlaterality. Link to Laterality_Qualifier_DE.ID.
ProblemSiteDEnumeric(8,0)5NULL allowedProblem Location. Link to Body_Site_DE.ID
Indexes TWstat_Problem_ProblemIncludeFlags_IDProblemIncludeFlagsint4NULL allowedProblem included in the views
1 – Active
2 – PMH
4 – PSH
8 – SH
16 – FH
LastAssessedDTTMdatetime8NULL allowedThe date the problem was last assessed for the patient
OnsetFuzzyWhenvarchar(50)50NULL allowedOnset Fuzzy date
ResolvedFuzzyWhenvarchar(50)50NULL allowedProblem resolved  Fuzzy date
OnsetFuzzySortAsdatetime8NULL allowedIndicates the problem was first noticed or reported by the patient or diagnosed by the provider
Indexes Portal_Problem_Auto_Resolved_DateTime, TWstat_Problem_ResolvedFuzzySortAs(2)ResolvedFuzzySortAsdatetime8NULL allowedProblem resolved date
OnsetFuzzySpecificitychar(1)1NULL allowedOnset Date Type
 'D' - Date
 'F' - Fuzzy Date
ResolvedFuzzySpecificitychar(1)1NULL allowedProblem resolved  date Type
 'D' - Date
 'F' - Fuzzy Date
ProblemCategoryDE[dbo].[dict_id]5NULL allowedProblem Category. Link to Problem_Category_DE.ID.
Indexes TWstat_Problem_ManagedByManagedByvarchar(80)80NULL allowedProvider who is managing the problem for the patient. Link to person.ID.
Indexes TWstat_Problem_IdentifiedByIdentifiedByvarchar(80)80NULL allowedProvider who identified the problem for the associated patient. Link to Person.ID.
Indexes NIX_Problem_ProblemDE_WithIncludeColumns, NIX_Problem_ProblemStatusDE_WithIncludeColumns(2)ICD9DiagnosisCodevarchar(10)10NULL allowedICD9Diagonisis Code added to the patient's problem.
Check Constraints CK_Problem_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Is the Problem in Unverified State (Y/N) ?
VerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)Provider or Team to whom the Problem verification task was created. Link to IDX_User.ID or Team_DE.ID.
VerificationTaskOwnerTypechar(10)10NOT NULL('')Problem verification task owner type
Indexes TWstat_Problem_ManagedByProviderTypeManagedByProviderTypechar(1)1NULL allowedWhether the Managed By provider is a Provider or a Referring Provider
P - Provider
R - Referring Provider
Indexes TWstat_Problem_IdentifiedByProviderTypeIdentifiedByProviderTypechar(1)1NULL allowedWhether the Identified By provider is a Provider or a Referring Provider
P - Provider
R - Referring Provider
Check Constraints CK_Problem_IsInjuryDateFLAG_Yes_Or_No : ([IsInjuryDateFLAG]='N' OR [IsInjuryDateFLAG]='Y')IsInjuryDateFLAG[dbo].[BOOL]1NOT NULL('N')Indicates the problem is an injury or trauma, rather than an illness or condition and the OnSet date is InjuryDate
CPT4ProcedureCODEchar(10)10NOT NULL('')CPT4 Procedure Code
Variablevarchar(20)20NOT NULL('')Variable
ICD10DiagnosisCode[dbo].[code]10NULL allowedICD10Diagonisis Code added to the patient's problem.
SnomedCodevarchar(18)18NULL allowedSNOMED Code saved to the patient's problem ( taken from Problem_DE.SNOMED3Code)
Check Constraints CK_Problem_SuppressOnResolveFLAG_Yes_Or_No : ([SuppressOnResolveFLAG]='N' OR [SuppressOnResolveFLAG]='Y')SuppressOnResolveFLAG[dbo].[BOOL]1NOT NULL('N')Suppress (Don't display) the problem when resolved (Y/N)?
CurrentImpressionProblemID[dbo].[uniqueid]9NOT NULL((0))ProblemID in which the last impression was added to the problem.
LinkedClinicalRelationDEsvarchar(255)255NOT NULL('')Linked Clinical Relations for family history problems (Clinical_Relation_DE). Comma Seperated List.
AdditionalICD9PrimaryDxCodesvarchar(255)255NOT NULL('')List of additional primary ICD9 Diagnosis Codes. Comma delimited list.
AdditionalICD9SecondaryDxCodesvarchar(255)255NOT NULL('')List of additional secondary ICD9 Diagnosis Codes. Comma delimited list.
AdditionalICD10PrimaryDxCodesvarchar(255)255NOT NULL('')List of additional primary ICD10 Diagnosis Codes. Comma delimited list.
AdditionalICD10SecondaryDxCodesvarchar(255)255NOT NULL('')List of additional secondary ICD10 Diagnosis Codes. Comma delimited list.
SnomedUSExtvarchar(18)18NULL allowedUS extended SNOMED code if exists
SnomedVersionvarchar(70)70NULL allowedSnomed Version
Foreign Keys FK_Problem_ActiveProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ActiveProblemDEActiveProblemDE[dbo].[dict_id]5NOT NULL((0))Active Problem Dictionary ID for the corresponding Parent history term.
Link to Problem_DE.ID.
Foreign Keys FK_Problem_ProblemEMComplexityDE_Problem_EM_Complexity_DE_ID: [dbo].[Problem_EM_Complexity_DE].ProblemEMComplexityDEProblemEMComplexityDE[dbo].[dict_id]5NOT NULL((0))Complexity for E&M coder. Link to Problem_EM_Complexity_DE.ID