Tables [dbo].[UnverifiedItem_Problem]
Unverified Probem
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key CIX_UnverifiedItem_Problem_UnverifiedItemID: UnverifiedItemIDForeign Keys FK_UnverifiedItem_Problem_UnverifiedItemID_Unverified_Item_ID: [dbo].[Unverified_Item].UnverifiedItemIDUnverifiedItemID[dbo].[uniqueid]9NOT NULLUnverified Item Identifier. Link to Unverified_Item.ID
OnsetFuzzyWhenvarchar(50)50NULL allowedOnset Fuzzy date
OnsetFuzzySortAsdatetime8NULL allowedOnset date
OnsetFuzzySpecificitychar(1)1NULL allowedOnset Date Type
 'D' - Date
 'F' - Fuzzy Date
ProblemDescriptionvarchar(600)600NULL allowedProblem Description
ResolvedFuzzyWhenvarchar(50)50NULL allowedResolved Fuzzy date
ResolvedFuzzySortAsdatetime8NULL allowedResolved Date
ResolvedFuzzySpecificitychar(1)1NULL allowedResolved Date Type
 'D' - Date
 'F' - Fuzzy Date
ICD9DiagnosisCode[dbo].[code]10NULL allowedImported problem's ICD9DiagnosisCode
ICD10DiagnosisCode[dbo].[code]10NULL allowedImported problem's ICD10DiagnosisCode
Snomed3CODEvarchar(18)18NOT NULLImported problem's Snomed code
ClinicalSeverityDE[dbo].[dict_id]5NOT NULL((0))Clinical Severity. Link to Clinical_Severity_DE.ID.
ManagedByvarchar(80)80NOT NULL('')Managed By Provider
ImpressionTextvarchar(2000)2000NOT NULL('')Impression Text