Tables [dbo].[Problem_Encounter]
Problems associated to an Encounter (usually assessments)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
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: EncounterIDForeign Keys FK_Problem_Encounter_Encounter: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter Identifier. Link to Encounter.ID
Indexes NIX_Problem_Encounter_ProblemID_INC_AssessedCheck 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)?
AssessmentSequenceint4NOT NULL((0))Assessment sequence.
ProblemDE[dbo].[dict_id]5NULL allowedAssessed Problem dictionary entry. References Problem_DE.ID
Primary Key PK_Problem_Encounter_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Problem_Encounter table