Tables [dbo].[Problem_Encounter]
Problems associated to an Encounter (usually assessments)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Indexes NIX_Problem_Encounter_ProblemID_INC_AssessedForeign Keys FK_Problem_Encounter_Problem: [dbo].[Problem].ProblemIDProblemID[dbo].[uniqueid]9NOT NULLProblem Identifier. Link to Problem.ID
Cluster Key IX_Prob_Enc_EncounterID: EncounterIDIndexes TWstat_Problem_Encounter_Assessed_EncounterIDForeign Keys FK_Problem_Encounter_Encounter: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter Identifier. Link to Encounter.ID
Indexes NIX_Problem_Encounter_ProblemID_INC_Assessed, TWstat_Problem_Encounter_Assessed_EncounterID(2)Check Constraints CK_Problem_Encounter_Assessed_Yes_Or_No : ([Assessed]='N' OR [Assessed]='Y')Assessed[dbo].[BOOL]1NULL allowed('N')Is the problem Assessed (Y/N)?
Indexes TWstat_Problem_Encounter_AssessmentSequenceAssessmentSequenceint4NOT NULL(0)Assessment sequence.
ProblemDE[dbo].[dict_id]5NULL allowedAssessed Problem dictionary entry. References Problem_DE.ID