Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (5) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Problem_DE table |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
| DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
| Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(8) | EntryCode | varchar(25) | 25 | NULL allowed | | | Entry Code |
(10) | EntryName | varchar(900) | 900 | NOT NULL | | | Entry Name |
(5) | EntryMnemonic | varchar(25) | 25 | NULL allowed | | | Entry Mnemonic |
(5)![Check Constraints CK_Problem_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Problem_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry inactive (Y/N)? |
![Check Constraints CK_Problem_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Problem_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry Enforced (Y/N)? Enforced entries can not be modified by the application. |
(8)![Check Constraints CK_Problem_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Problem_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry Current (Y/N)? |
| EffectiveDT | datetime | 8 | NULL allowed | | | Effective Date. This is the last edited date. |
(2) | ICD9DiagnosisCODE | [dbo].[code] | 10 | NOT NULL | | ('0') | ICD9 Diagnosis Code |
 | Snomed3CODE | varchar(18) | 18 | NOT NULL | | ('0') | Snomed Code |
| ICD9ProcedureCODE | [dbo].[code] | 10 | NOT NULL | | (' ') | ICD9 Procedure Code |
| CPT4ProcedureCODE | [dbo].[code] | 10 | NOT NULL | | (' ') | CPT4 Procedure Code |
 | SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Security Code. Link to Security_Code_DE.ID |
| ExpectedDuration | numeric(16,0) | 9 | NOT NULL | | | Expected Duration |
![Foreign Keys FK_Problem_DE_ProblemCategoryDE_Problem_Category_DE_ID: [dbo].[Problem_Category_DE].ProblemCategoryDE Foreign Keys FK_Problem_DE_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 |
| PMODPickListID1 | numeric(8,0) | 5 | NULL allowed | | | Laterality |
 | PMODPickListID2 | numeric(8,0) | 5 | NULL allowed | | | Problem Site |
| PMODPickList1ReqFLAG | char(1) | 1 | NULL allowed | | | Is Laterality Required (Y/N)? |
| PMODPickList2ReqFLAG | char(1) | 1 | NULL allowed | | | Is Problem site required (Y/N) ? |
(4) | ProblemViewFlags | int | 4 | NULL allowed | | | Problem View 4 – Past Surgical History 8 – Social History 16 – Family History |
(2) | MedcinID | int | 4 | NOT NULL | | (0) | Medcin ID |
 ![Check Constraints CK_Problem_DE_IsBillableFLAG_Yes_Or_No : ([IsBillableFLAG]='N' OR [IsBillableFLAG]='Y') Check Constraints CK_Problem_DE_IsBillableFLAG_Yes_Or_No : ([IsBillableFLAG]='N' OR [IsBillableFLAG]='Y')](../../../../Images/c-constraint.png) | IsBillableFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Billable Problem (Y/N) ? |
 ![Check Constraints CK_Problem_DE_HCCFLAG_Yes_Or_No : ([HCCFLAG]='N' OR [HCCFLAG]='Y') Check Constraints CK_Problem_DE_HCCFLAG_Yes_Or_No : ([HCCFLAG]='N' OR [HCCFLAG]='Y')](../../../../Images/c-constraint.png) | HCCFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | HCC Flag (Y/N)? |
![Check Constraints CK_Problem_DE_SmokingStatus_Yes_Or_No : ([SmokingStatus]='N' OR [SmokingStatus]='Y') Check Constraints CK_Problem_DE_SmokingStatus_Yes_Or_No : ([SmokingStatus]='N' OR [SmokingStatus]='Y')](../../../../Images/c-constraint.png) | SmokingStatus | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Smoking Status |
 ![Foreign Keys FK_Problem_DE_DSMAxisDE: [dbo].[DSM_Axis_DE].DSMAxisDE Foreign Keys FK_Problem_DE_DSMAxisDE: [dbo].[DSM_Axis_DE].DSMAxisDE](../../../../Images/fk.png) | DSMAxisDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | DSM Axis. Link to DSM_Axis_DE.ID. |
 | ICD10DiagnosisCode | [dbo].[code] | 10 | NULL allowed | | | ICD10Diagonisis Code |
| ICD10DiagnosisText | varchar(255) | 255 | NULL allowed | | | Name of the ICD10Diagonisis |
 | ContentUID | uniqueidentifier | 16 | NULL allowed | | | Unique ID generated to link the IMO base problem |
 | ContentSynonymUID | uniqueidentifier | 16 | NULL allowed | | | Unique Synonym Id generated to link the IMO Synonym problem. |
![Foreign Keys FK_Problem_DE_BaseProblemDE: [dbo].[Problem_DE].BaseProblemDE Foreign Keys FK_Problem_DE_BaseProblemDE: [dbo].[Problem_DE].BaseProblemDE](../../../../Images/fk.png) | BaseProblemDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | ProblemDE for the Base term name ( References to Problem_DE.ID) |
| BaseTermName | varchar(255) | 255 | NULL allowed | | | Name of the Base problem term. |
| BillingModifiers | varchar(255) | 255 | NULL allowed | | | Billing Modifiers |
| ClinicalModifiers | varchar(255) | 255 | NULL allowed | | | Clinical Modifiers |
![Foreign Keys FK_Problem_DE_ProblemTypeDE: [dbo].[Problem_Type_DE].ProblemTypeDE Foreign Keys FK_Problem_DE_ProblemTypeDE: [dbo].[Problem_Type_DE].ProblemTypeDE](../../../../Images/fk.png) | ProblemTypeDE | [dbo].[dict_id] | 5 | NULL allowed | | | Type of problem ( references to Problem_Type_DE.ID) |
![Foreign Keys FK_Problem_DE_ExpectedDurationUnitsDE: [dbo].[HMP_Freq_Unit_DE].ExpectedDurationUnitsDE Foreign Keys FK_Problem_DE_ExpectedDurationUnitsDE: [dbo].[HMP_Freq_Unit_DE].ExpectedDurationUnitsDE](../../../../Images/fk.png) | ExpectedDurationUnitsDE | [dbo].[dict_id] | 5 | NULL allowed | | | Expected 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') Check Constraints CK_Problem_DE_SuppressOnResolveFLAG_Yes_Or_No : ([SuppressOnResolveFLAG]='N' OR [SuppressOnResolveFLAG]='Y')](../../../../Images/c-constraint.png) | SuppressOnResolveFLAG | [dbo].[BOOL] | 1 | NULL allowed | | | Suppress (Don't display) the problem when resolved (Y/N)? |
 | ProblemVendorID | smallint | 2 | NOT 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].ClinicalProgPickListID Foreign Keys FK_Picklist_ID_ClinicalProgPickListID: [dbo].[Picklist].ClinicalProgPickListID](../../../../Images/fk.png) | ClinicalProgPickListID | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Clinical progress pick list (References to PickList.ID) |
![Check Constraints CK_Problem_DE_ClinicalProgPickListReqFLAG_Yes_Or_No : ([ClinicalProgPickListReqFLAG]='N' OR [ClinicalProgPickListReqFLAG]='Y') Check Constraints CK_Problem_DE_ClinicalProgPickListReqFLAG_Yes_Or_No : ([ClinicalProgPickListReqFLAG]='N' OR [ClinicalProgPickListReqFLAG]='Y')](../../../../Images/c-constraint.png) | ClinicalProgPickListReqFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is Clinical Progress Picklist required to save the problem (Y/N) ? |
![Foreign Keys FK_Picklist_ID_SeverityPickListID: [dbo].[Picklist].SeverityPickListID Foreign Keys FK_Picklist_ID_SeverityPickListID: [dbo].[Picklist].SeverityPickListID](../../../../Images/fk.png) | SeverityPickListID | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Severity pick list (References to PickList.ID) |
![Check Constraints CK_Problem_DE_SeverityPickListReqFLAG_Yes_Or_No : ([SeverityPickListReqFLAG]='N' OR [SeverityPickListReqFLAG]='Y') Check Constraints CK_Problem_DE_SeverityPickListReqFLAG_Yes_Or_No : ([SeverityPickListReqFLAG]='N' OR [SeverityPickListReqFLAG]='Y')](../../../../Images/c-constraint.png) | SeverityPickListReqFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is Severity Picklist required to save the problem (Y/N) ? |
| Post_Coord_Lex_FLAG | tinyint | 1 | NULL allowed | | ((0)) | values: 0 = No Post-Coordination Exists 1 = No Post-Coordination Needed - Hyper Pre-Coordinated 3 = Post-Coordination Needed |
| HomeView | varchar(10) | 10 | NOT NULL | | ('') | Home view of the IMO problems - Active, PMH, PSH , FHX, SHX. |
| SynonymType | char(1) | 1 | NOT NULL | | ('N') | Type of Synonym: N -not a synonym Y -Synonym created through EEHR E -enforced synonym provided through content (IMO) |
| BaseMedcinID | int | 4 | NOT NULL | | ((0)) | ParentMedcinID for the Synonyms |
 ![Foreign Keys FK_Problem_DE_ID_NonSynonymProblemDE: [dbo].[Problem_DE].NonSynonymProblemDE Foreign Keys FK_Problem_DE_ID_NonSynonymProblemDE: [dbo].[Problem_DE].NonSynonymProblemDE](../../../../Images/fk.png) | NonSynonymProblemDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | If the problem is synonym then holds the parent parented ( References to Problem_DE.ID) |
| AdditionalICD9PrimaryDxCodes | varchar(255) | 255 | NOT NULL | | ('') | List of additional primary ICD9 Diagnosis Codes. Comma delimited list. |
| AdditionalICD9SecondaryDxCodes | varchar(255) | 255 | NOT NULL | | ('') | List of additional secondary ICD9 Diagnosis Codes. Comma delimited list. |
| AdditionalICD10PrimaryDxCodes | varchar(255) | 255 | NOT NULL | | ('') | List of additional primary ICD10 Diagnosis Codes. Comma delimited list. |
| AdditionalICD10SecondaryDxCodes | varchar(255) | 255 | NOT NULL | | ('') | List of additional secondary ICD10 Diagnosis Codes. Comma delimited list. |
 | SnomedUSExt | varchar(18) | 18 | NULL allowed | | | US extended SNOMED code if exists |
 | VendorSourceCode | varchar(25) | 25 | NULL allowed | | | Vendor Source Code |
 | VendorCatalog | varchar(50) | 50 | NULL allowed | | | Content Source |
![Check Constraints CK_Problem_DE_IncludeMUSmokingStatusAlertFlag_Yes_Or_No : ([IncludeMUSmokingStatusAlertFlag]='N' OR [IncludeMUSmokingStatusAlertFlag]='Y') Check Constraints CK_Problem_DE_IncludeMUSmokingStatusAlertFlag_Yes_Or_No : ([IncludeMUSmokingStatusAlertFlag]='N' OR [IncludeMUSmokingStatusAlertFlag]='Y')](../../../../Images/c-constraint.png) | IncludeMUSmokingStatusAlertFlag | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Include in MU Smoking Status Alert (Y/N) ? |
![Check Constraints CK_Problem_DE_CognitiveStatus_Yes_Or_No : ([CognitiveStatus]='N' OR [CognitiveStatus]='Y') Check Constraints CK_Problem_DE_CognitiveStatus_Yes_Or_No : ([CognitiveStatus]='N' OR [CognitiveStatus]='Y')](../../../../Images/c-constraint.png) | CognitiveStatus | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Cognitive Status (Y/N) ? |
![Check Constraints CK_Problem_DE_FunctionalStatus_Yes_Or_No : ([FunctionalStatus]='N' OR [FunctionalStatus]='Y') Check Constraints CK_Problem_DE_FunctionalStatus_Yes_Or_No : ([FunctionalStatus]='N' OR [FunctionalStatus]='Y')](../../../../Images/c-constraint.png) | FunctionalStatus | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Functional Status (Y/N) ? |
| CommercialHCC | varchar(50) | 50 | NULL allowed | | | Commercial HCC (Hierarchical Condition Code) |
| SourceCode | varchar(100) | 100 | NULL allowed | | | Source Code |
| LocalInactivationFlag | char(1) | 1 | NULL allowed | | ('N') | Locally Inactivated (Y/N) ? |
 | IsRetired | char(1) | 1 | NULL allowed | | ('N') | Is Retired(Y/N) ? |
| SnomedVersion | varchar(70) | 70 | NULL allowed | | | Snomed version for the problem |
| Specificity | tinyint | 1 | NULL allowed | | | Specificity value |
| ICD10CommercialHCC | varchar(50) | 50 | NULL allowed | | | Commercialhcc value for ICD10 problem |
| HCCFactorValue | varchar(50) | 50 | NOT NULL | | ('') | HCC factor value from Terminology sync job |
| ICD10CMHCCModelCAT | varchar(50) | 50 | NOT NULL | | ('') | ICD 10 Commercial HCC Model Category Codes |
 | IncludeAsSmokingStatusInCCDAFlag | [dbo].[BOOL] | 1 | NOT 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 |
| ICD10CMHCCModelCATNext | varchar(50) | 50 | NOT NULL | | ('') | ICD 10 Commercial HCC Model Category V28 Codes |
| HCCFactorValueNext | varchar(50) | 50 | NOT NULL | | ('') | HCC factor value |