Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (9) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Problem table |
(3)![Foreign Keys FK_Problem_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderID Foreign Keys FK_Problem_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderID](../../../../Images/fk.png) | ProblemHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | Problem Header. Link to Problem_Header.ID |
(4)![Foreign Keys FK_Problem_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDE Foreign Keys FK_Problem_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDE](../../../../Images/fk.png) | ProblemDE | [dbo].[dict_id] | 5 | NOT NULL | | Problem. Link to Problem_DE.ID |
| ProblemDET | varchar(255) | 255 | NOT NULL | | Problem Entry Name |
(5) | Problem | varchar(255) | 255 | NOT NULL | | Problem Name |
| ClinicalSeverityDE | [dbo].[dict_id] | 5 | NOT NULL | | Severity of the problem. Link to Clinical_Severity_DE.ID. |
| ClinicalSeverityDET | varchar(255) | 255 | NOT NULL | | Clinical Severity entered |
| ClinicalSeverity | varchar(255) | 255 | NOT NULL | | Clinical Severity |
| ClinicalSeverityCode | [dbo].[code] | 10 | NOT NULL | | Clinical Severity Code |
 ![Foreign Keys FK_Problem_SecondaryToID_Problem_Header_ID: [dbo].[Problem_Header].SecondaryToID Foreign Keys FK_Problem_SecondaryToID_Problem_Header_ID: [dbo].[Problem_Header].SecondaryToID](../../../../Images/fk.png) | SecondaryToID | [dbo].[uniqueid] | 9 | NOT NULL | | The current problem as a secondary problem to one of the patient’s other existing problems. Link to Problem_Header.ID. |
 ![Foreign Keys FK_Problem_ProblemTypeDE_Problem_Type_DE_ID: [dbo].[Problem_Type_DE].ProblemTypeDE Foreign Keys FK_Problem_ProblemTypeDE_Problem_Type_DE_ID: [dbo].[Problem_Type_DE].ProblemTypeDE](../../../../Images/fk.png) | ProblemTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Problem Type. Link to Problem_Type_DE.ID |
(3)![Foreign Keys FK_Problem_ProblemStatusDE_Problem_Status_DE_ID: [dbo].[Problem_Status_DE].ProblemStatusDE Foreign Keys FK_Problem_ProblemStatusDE_Problem_Status_DE_ID: [dbo].[Problem_Status_DE].ProblemStatusDE](../../../../Images/fk.png) | ProblemStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Problem Status. Link to Problem_Status_DE.ID |
 | ProblemStatus | varchar(255) | 255 | NOT NULL | | Problem Status |
 | ManagementEffectiveDE | [dbo].[dict_id] | 5 | NOT NULL | | Clinical Progress Dictionary ID. Link to Management_Effective_DE.ID |
| ManagementEffectiveDET | varchar(255) | 255 | NOT NULL | | Clinical Progress EntryName |
| ProblemDescription | varchar(1000) | 1000 | NOT NULL | ('') | Problem Description |
(2) | IdentifiedByID | [dbo].[uniqueid] | 9 | NOT NULL | | The 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') Check Constraints CK_Problem_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')](../../../../Images/c-constraint.png) | ReasonForCreateType | char(1) | 1 | NOT NULL | | Reason for create Allowed values 'A' 'C' 'E' |
| WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who requested to add the problem for the patient. Link to Person.ID |
| WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who added the problem for the patient. Link to Person.ID |
| PerformedDTTM | datetime | 8 | NOT NULL | | Date time the problem was added to the Patient |
(2) | RecordedDTTM | datetime | 8 | NOT NULL | | Date time the problem was added to the Patient |
 ![Foreign Keys FK_Problem_ICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].ICD9DiagnosisDE Foreign Keys FK_Problem_ICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].ICD9DiagnosisDE](../../../../Images/fk.png) | ICD9DiagnosisDE | [dbo].[dict_id] | 5 | NOT NULL | | ICD9 Diagnosis. Link to ICD9_Diagnosis_DE.ID. |
 | ManagedByID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who is managing the problem for the patient. Link to Person.ID. |
| ResolvedByID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who resolved the problem for the patient. Link to Person.ID. |
| Goal | varchar(255) | 255 | NOT NULL | | Goal |
| NoteActivityID | [dbo].[uniqueid] | 9 | NULL allowed | | Note Activity ID |
| LateralityDE | numeric(8,0) | 5 | NULL allowed | | laterality. Link to Laterality_Qualifier_DE.ID. |
| ProblemSiteDE | numeric(8,0) | 5 | NULL allowed | | Problem Location. Link to Body_Site_DE.ID |
 | ProblemIncludeFlags | int | 4 | NULL allowed | | Problem included in the views 1 – Active 2 – PMH 4 – PSH 8 – SH 16 – FH |
| LastAssessedDTTM | datetime | 8 | NULL allowed | | The date the problem was last assessed for the patient |
| OnsetFuzzyWhen | varchar(50) | 50 | NULL allowed | | Onset Fuzzy date |
| ResolvedFuzzyWhen | varchar(50) | 50 | NULL allowed | | Problem resolved Fuzzy date |
| OnsetFuzzySortAs | datetime | 8 | NULL allowed | | Indicates the problem was first noticed or reported by the patient or diagnosed by the provider |
(2) | ResolvedFuzzySortAs | datetime | 8 | NULL allowed | | Problem resolved date |
| OnsetFuzzySpecificity | char(1) | 1 | NULL allowed | | Onset Date Type 'D' - Date 'F' - Fuzzy Date |
| ResolvedFuzzySpecificity | char(1) | 1 | NULL allowed | | Problem resolved date Type 'D' - Date 'F' - Fuzzy Date |
| ProblemCategoryDE | [dbo].[dict_id] | 5 | NULL allowed | | Problem Category. Link to Problem_Category_DE.ID. |
 | ManagedBy | varchar(80) | 80 | NULL allowed | | Provider who is managing the problem for the patient. Link to person.ID. |
 | IdentifiedBy | varchar(80) | 80 | NULL allowed | | Provider who identified the problem for the associated patient. Link to Person.ID. |
(2) | ICD9DiagnosisCode | varchar(10) | 10 | NULL allowed | | ICD9Diagonisis Code added to the patient's problem. |
![Check Constraints CK_Problem_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_Problem_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is the Problem in Unverified State (Y/N) ? |
| VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Provider or Team to whom the Problem verification task was created. Link to IDX_User.ID or Team_DE.ID. |
| VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | Problem verification task owner type |
 | ManagedByProviderType | char(1) | 1 | NULL allowed | | Whether the Managed By provider is a Provider or a Referring Provider P - Provider R - Referring Provider |
 | IdentifiedByProviderType | char(1) | 1 | NULL allowed | | Whether 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') Check Constraints CK_Problem_IsInjuryDateFLAG_Yes_Or_No : ([IsInjuryDateFLAG]='N' OR [IsInjuryDateFLAG]='Y')](../../../../Images/c-constraint.png) | IsInjuryDateFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Indicates the problem is an injury or trauma, rather than an illness or condition and the OnSet date is InjuryDate |
| CPT4ProcedureCODE | char(10) | 10 | NOT NULL | ('') | CPT4 Procedure Code |
| Variable | varchar(20) | 20 | NOT NULL | ('') | Variable |
| ICD10DiagnosisCode | [dbo].[code] | 10 | NULL allowed | | ICD10Diagonisis Code added to the patient's problem. |
| SnomedCode | varchar(18) | 18 | NULL allowed | | SNOMED 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') Check Constraints CK_Problem_SuppressOnResolveFLAG_Yes_Or_No : ([SuppressOnResolveFLAG]='N' OR [SuppressOnResolveFLAG]='Y')](../../../../Images/c-constraint.png) | SuppressOnResolveFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Suppress (Don't display) the problem when resolved (Y/N)? |
| CurrentImpressionProblemID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | ProblemID in which the last impression was added to the problem. |
| LinkedClinicalRelationDEs | varchar(255) | 255 | NOT NULL | ('') | Linked Clinical Relations for family history problems (Clinical_Relation_DE). Comma Seperated List. |
| 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 |
| SnomedVersion | varchar(70) | 70 | NULL allowed | | Snomed Version |
![Foreign Keys FK_Problem_ActiveProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ActiveProblemDE Foreign Keys FK_Problem_ActiveProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ActiveProblemDE](../../../../Images/fk.png) | ActiveProblemDE | [dbo].[dict_id] | 5 | NOT 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].ProblemEMComplexityDE Foreign Keys FK_Problem_ProblemEMComplexityDE_Problem_EM_Complexity_DE_ID: [dbo].[Problem_EM_Complexity_DE].ProblemEMComplexityDE](../../../../Images/fk.png) | ProblemEMComplexityDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Complexity for E&M coder. Link to Problem_EM_Complexity_DE.ID |