Tables [dbo].[Problem_DE]
Problem Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Problem_DE_ID: IDIndexes NIX_Problem_DE_MedcinID_With_Include, NIX_ProblemDE_NonSynonymProblemDE_ID, TWstat_Problem_DE_ICD9DiagnosisCODE_EntryName_IsCurrentFLAG_ID, TWstat_Problem_DE_PMODPickListID2_EntryName_IsCurrentFLAG_ID, TWstat_Problem_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(5)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Problem_DE table
Indexes XAK99Problem_DEEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Problem_DE_ContentSynonymUID_WithIncludeColumns, NIX_Problem_DE_EntryCode_WithIncludeColumns, NIX_Problem_DE_EntryMnemonic_WithIncludeColumns, NIX_Problem_DE_EntryName_WithIncludeColumns, NIX_Problem_DE_ICD10DiagnosisCode_INC_EntryCode, NIX_Problem_DE_ICD9DiagnosisCode_INC_EntryCode, NIX_Problem_DE_MedcinID_WithIncludeColumns, NIX_Problem_DE_MedcinID_With_Include(8)EntryCodevarchar(25)25NULL allowedEntry Code
Indexes NIX_Problem_DE_ContentSynonymUID_WithIncludeColumns, NIX_Problem_DE_EntryCode_WithIncludeColumns, NIX_Problem_DE_EntryMnemonic_WithIncludeColumns, NIX_Problem_DE_EntryName_WithIncludeColumns, NIX_Problem_DE_MedcinID_WithIncludeColumns, NIX_Problem_DE_MedcinID_With_Include, NIX_Problem_DE_ProblemVendorID_IsInactiveFlag_IsRetired_EntryName_INC_ContentUID, TWstat_Problem_DE_ICD9DiagnosisCODE_EntryName_IsCurrentFLAG_ID, TWstat_Problem_DE_PMODPickListID2_EntryName_IsCurrentFLAG_ID, TWstat_Problem_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(10)EntryNamevarchar(900)900NOT NULLEntry Name
Indexes NIX_Problem_DE_EntryCode_WithIncludeColumns, NIX_Problem_DE_EntryMnemonic_WithIncludeColumns, NIX_Problem_DE_EntryName_WithIncludeColumns, NIX_Problem_DE_MedcinID_WithIncludeColumns, NIX_Problem_DE_MedcinID_With_Include(5)EntryMnemonicvarchar(25)25NULL allowedEntry Mnemonic
Indexes NIX_Problem_DE_EntryCode_WithIncludeColumns, NIX_Problem_DE_EntryMnemonic_WithIncludeColumns, NIX_Problem_DE_EntryName_WithIncludeColumns, NIX_Problem_DE_MedcinID_WithIncludeColumns, NIX_Problem_DE_ProblemVendorID_IsInactiveFlag_IsRetired_EntryName_INC_ContentUID(5)Check Constraints CK_Problem_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Problem_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Indexes NIX_Problem_DE_ContentSynonymUID_WithIncludeColumns, NIX_Problem_DE_EntryCode_WithIncludeColumns, NIX_Problem_DE_EntryMnemonic_WithIncludeColumns, NIX_Problem_DE_EntryName_WithIncludeColumns, NIX_Problem_DE_MedcinID_WithIncludeColumns, TWstat_Problem_DE_ICD9DiagnosisCODE_EntryName_IsCurrentFLAG_ID, TWstat_Problem_DE_PMODPickListID2_EntryName_IsCurrentFLAG_ID, TWstat_Problem_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(8)Check Constraints CK_Problem_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date. This is the last edited date.
Indexes NIX_Problem_DE_ICD9DiagnosisCode_INC_EntryCode, TWstat_Problem_DE_ICD9DiagnosisCODE_EntryName_IsCurrentFLAG_ID(2)ICD9DiagnosisCODE[dbo].[code]10NOT NULL('0')ICD9 Diagnosis Code
Indexes NIXProblem_DE_Snomed3CODESnomed3CODEvarchar(18)18NOT NULL('0')Snomed Code
ICD9ProcedureCODE[dbo].[code]10NOT NULL(' ')ICD9 Procedure Code
CPT4ProcedureCODE[dbo].[code]10NOT NULL(' ')CPT4 Procedure Code
Indexes TWstat_Problem_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_IDSecurityCodeDE[dbo].[dict_id]5NOT NULLSecurity Code. Link to Security_Code_DE.ID
ExpectedDurationnumeric(16,0)9NOT NULLExpected Duration
Foreign Keys FK_Problem_DE_ProblemCategoryDE_Problem_Category_DE_ID: [dbo].[Problem_Category_DE].ProblemCategoryDEProblemCategoryDE[dbo].[dict_id]5NOT NULLProblem Category. Link to Problem_Category_DE.ID
PMODPickListID1numeric(8,0)5NULL allowedLaterality
Indexes TWstat_Problem_DE_PMODPickListID2_EntryName_IsCurrentFLAG_IDPMODPickListID2numeric(8,0)5NULL allowedProblem Site
PMODPickList1ReqFLAGchar(1)1NULL allowedIs Laterality Required (Y/N)?
PMODPickList2ReqFLAGchar(1)1NULL allowedIs Problem site required (Y/N) ?
Indexes NIX_Problem_DE_EntryCode_WithIncludeColumns, NIX_Problem_DE_EntryMnemonic_WithIncludeColumns, NIX_Problem_DE_EntryName_WithIncludeColumns, NIX_Problem_DE_MedcinID_WithIncludeColumns(4)ProblemViewFlagsint4NULL allowedProblem View
        4 – Past Surgical History
        8 – Social History
        16 – Family History
Indexes NIX_Problem_DE_MedcinID_WithIncludeColumns, NIX_Problem_DE_MedcinID_With_Include(2)MedcinIDint4NOT NULL(0)Medcin ID
Indexes TWstat_Problem_DE_IsBillableFLAGCheck Constraints CK_Problem_DE_IsBillableFLAG_Yes_Or_No : ([IsBillableFLAG]='N' OR [IsBillableFLAG]='Y')IsBillableFLAG[dbo].[BOOL]1NOT NULL('N')Billable Problem (Y/N) ?
Indexes TWstat_Problem_DE_HCCFLAGCheck Constraints CK_Problem_DE_HCCFLAG_Yes_Or_No : ([HCCFLAG]='N' OR [HCCFLAG]='Y')HCCFLAG[dbo].[BOOL]1NOT NULL('N')HCC Flag (Y/N)?
Check Constraints CK_Problem_DE_SmokingStatus_Yes_Or_No : ([SmokingStatus]='N' OR [SmokingStatus]='Y')SmokingStatus[dbo].[BOOL]1NOT NULL('N')Smoking Status
Indexes NIX_Problem_DE_ContentSynonymUID_WithIncludeColumnsForeign Keys FK_Problem_DE_DSMAxisDE: [dbo].[DSM_Axis_DE].DSMAxisDEDSMAxisDE[dbo].[dict_id]5NOT NULL((0))DSM Axis. Link to DSM_Axis_DE.ID.
Indexes NIX_Problem_DE_ICD10DiagnosisCode_INC_EntryCodeICD10DiagnosisCode[dbo].[code]10NULL allowedICD10Diagonisis Code
ICD10DiagnosisTextvarchar(255)255NULL allowedName of the ICD10Diagonisis
Indexes NIX_Problem_DE_ProblemVendorID_IsInactiveFlag_IsRetired_EntryName_INC_ContentUIDContentUIDuniqueidentifier16NULL allowedUnique ID generated to link the IMO base problem
Indexes NIX_Problem_DE_ContentSynonymUID_WithIncludeColumnsContentSynonymUIDuniqueidentifier16NULL allowedUnique Synonym Id generated to link the IMO Synonym problem.
Foreign Keys FK_Problem_DE_BaseProblemDE: [dbo].[Problem_DE].BaseProblemDEBaseProblemDE[dbo].[dict_id]5NOT NULL((0))ProblemDE for the Base term name ( References to Problem_DE.ID)
BaseTermNamevarchar(255)255NULL allowedName of the Base problem term.
BillingModifiersvarchar(255)255NULL allowedBilling Modifiers
ClinicalModifiersvarchar(255)255NULL allowedClinical Modifiers
Foreign Keys FK_Problem_DE_ProblemTypeDE: [dbo].[Problem_Type_DE].ProblemTypeDEProblemTypeDE[dbo].[dict_id]5NULL allowedType of problem ( references to Problem_Type_DE.ID)
Foreign Keys FK_Problem_DE_ExpectedDurationUnitsDE: [dbo].[HMP_Freq_Unit_DE].ExpectedDurationUnitsDEExpectedDurationUnitsDE[dbo].[dict_id]5NULL allowedExpected duration to change the problem to Resolve ( References to HMP_Freq_Unit_DE (ID))
Check Constraints CK_Problem_DE_SuppressOnResolveFLAG_Yes_Or_No : ([SuppressOnResolveFLAG]='N' OR [SuppressOnResolveFLAG]='Y')SuppressOnResolveFLAG[dbo].[BOOL]1NULL allowedSuppress (Don't display) the problem when resolved (Y/N)?
Indexes NIX_Problem_DE_ProblemVendorID_IsInactiveFlag_IsRetired_EntryName_INC_ContentUIDProblemVendorIDsmallint2NOT NULL((2))Vendor providing the Problem Term:
1 - Medcin problems
2 - Free text problems
3 - IMO problems
Foreign Keys FK_Picklist_ID_ClinicalProgPickListID: [dbo].[Picklist].ClinicalProgPickListIDClinicalProgPickListID[dbo].[dict_id]5NOT NULL((0))Clinical progress pick list (References to PickList.ID)
Check Constraints CK_Problem_DE_ClinicalProgPickListReqFLAG_Yes_Or_No : ([ClinicalProgPickListReqFLAG]='N' OR [ClinicalProgPickListReqFLAG]='Y')ClinicalProgPickListReqFLAG[dbo].[BOOL]1NOT NULL('N')Is Clinical Progress Picklist required to save the problem (Y/N) ?
Foreign Keys FK_Picklist_ID_SeverityPickListID: [dbo].[Picklist].SeverityPickListIDSeverityPickListID[dbo].[dict_id]5NOT NULL((0))Severity pick list (References to PickList.ID)
Check Constraints CK_Problem_DE_SeverityPickListReqFLAG_Yes_Or_No : ([SeverityPickListReqFLAG]='N' OR [SeverityPickListReqFLAG]='Y')SeverityPickListReqFLAG[dbo].[BOOL]1NOT NULL('N')Is Severity Picklist required to save the problem (Y/N) ?
Post_Coord_Lex_FLAGtinyint1NULL allowed((0))values:
0 = No Post-Coordination Exists
1 = No Post-Coordination Needed - Hyper Pre-Coordinated
3 = Post-Coordination Needed
HomeViewvarchar(10)10NOT NULL('')Home view of the IMO problems - Active, PMH, PSH , FHX, SHX.
SynonymTypechar(1)1NOT NULL('N')Type of Synonym:
N -not a synonym
Y -Synonym created through EEHR
E -enforced synonym provided through content (IMO)
BaseMedcinIDint4NOT NULL((0))ParentMedcinID for the Synonyms
Indexes NIX_ProblemDE_NonSynonymProblemDE_IDForeign Keys FK_Problem_DE_ID_NonSynonymProblemDE: [dbo].[Problem_DE].NonSynonymProblemDENonSynonymProblemDE[dbo].[dict_id]5NOT NULL((0))If the problem is synonym then holds the parent parented ( References to Problem_DE.ID)
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.
Indexes NIXProblem_DE_SnomedUSExtSnomedUSExtvarchar(18)18NULL allowed US extended SNOMED code if exists
Indexes Nix_Problem_DE_VendorSourceCode_VendorCatalogVendorSourceCodevarchar(25)25NULL allowedVendor Source Code
Indexes Nix_Problem_DE_VendorSourceCode_VendorCatalogVendorCatalogvarchar(50)50NULL allowedContent Source
Check Constraints CK_Problem_DE_IncludeMUSmokingStatusAlertFlag_Yes_Or_No : ([IncludeMUSmokingStatusAlertFlag]='N' OR [IncludeMUSmokingStatusAlertFlag]='Y')IncludeMUSmokingStatusAlertFlag[dbo].[BOOL]1NULL allowed('N')Include in MU Smoking Status Alert (Y/N) ?
Check Constraints CK_Problem_DE_CognitiveStatus_Yes_Or_No : ([CognitiveStatus]='N' OR [CognitiveStatus]='Y')CognitiveStatus[dbo].[BOOL]1NULL allowed('N')Cognitive Status (Y/N) ?
Check Constraints CK_Problem_DE_FunctionalStatus_Yes_Or_No : ([FunctionalStatus]='N' OR [FunctionalStatus]='Y')FunctionalStatus[dbo].[BOOL]1NULL allowed('N')Functional Status (Y/N) ?
CommercialHCCvarchar(50)50NULL allowedCommercial HCC (Hierarchical Condition Code)
SourceCodevarchar(100)100NULL allowedSource Code
LocalInactivationFlagchar(1)1NULL allowed('N')Locally Inactivated (Y/N) ?
Indexes NIX_Problem_DE_ProblemVendorID_IsInactiveFlag_IsRetired_EntryName_INC_ContentUIDIsRetiredchar(1)1NULL allowed('N')Is Retired(Y/N) ?
SnomedVersionvarchar(70)70NULL allowedSnomed version for the  problem
Specificitytinyint1NULL allowedSpecificity value
ICD10CommercialHCCvarchar(50)50NULL allowedCommercialhcc value for ICD10 problem
HCCFactorValuevarchar(50)50NOT NULL('')HCC factor value from Terminology sync job
ICD10CMHCCModelCATvarchar(50)50NOT NULL('')ICD 10 Commercial HCC Model Category Codes
Indexes NIX_Problem_DE_IncludeAsSmokingStatusInCCDAFlagIncludeAsSmokingStatusInCCDAFlag[dbo].[BOOL]1NOT NULL('N')If this column value is set to True then this problem gets displayed in CCDA> Social history section> Smoking Status sub header otherwise, it gets displayed in CCDA> Social history section. Based on this checkbox value Smoking Alert will get displayed in Encounter Summary
ICD10CMHCCModelCATNextvarchar(50)50NOT NULL('')ICD 10 Commercial HCC Model Category V28  Codes
HCCFactorValueNextvarchar(50)50NOT NULL('')HCC factor value