Tables [dbo].[Problem_ICDCode]
Table to Link ICD codes to Problems.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Problem_ICDCode_PID_ICDCode_ICDCodeType: ProblemID\ICDCode\ICDCodeTypeForeign Keys FK_ProblemID_ID: [dbo].[Problem].ProblemIDProblemID[dbo].[uniqueid]9NOT NULLKey to the Problem table
Cluster Primary Key PK_Problem_ICDCode_PID_ICDCode_ICDCodeType: ProblemID\ICDCode\ICDCodeTypeCheck Constraints CK_Problem_ICDCode_ICDCodeType : ([ICDCodeType]='ICD10CM' OR [ICDCodeType]='ICD9CM')ICDCodeTypevarchar(10)10NOT NULLICD Code Type (ICD9CM or ICD10CM)
Check Constraints CK_Problem_ICDCode_Level : ([Level]=(2) OR [Level]=(1) OR [Level]=(0))Leveltinyint1NOT NULLLinked Level
0 - Primary code
1 - Additional Primary code
2 - Secondary code
Cluster Primary Key PK_Problem_ICDCode_PID_ICDCode_ICDCodeType: ProblemID\ICDCode\ICDCodeTypeICDCodevarchar(10)10NOT NULLICD Code