Tables [dbo].[Encounter_Case]
Linking of a case to an encounter
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Encounter_Case_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Encounter_Case table
Foreign Keys FK_Encounter_Case_PatientCaseID: [dbo].[Patient_Case].PatientCaseIDPatientCaseID[dbo].[uniqueid]9NOT NULL((0))Case. Link to Patient_Case.ID
Indexes NIX_Encounter_Case_EncounterIDForeign Keys FK_Encounter_Case_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULL((0))Encounter. Link to Encounter.ID
CaseStatusDE[dbo].[dict_id]5NOT NULL((0))Case Status. Link to Case_Status_DE.ID
RecordedDTTMdatetime8NOT NULL('01/01/1900')When recorded
WhoDidItID[dbo].[uniqueid]9NOT NULL((0))User who entered. Link to IDX_User.ID
PrevVersionID[dbo].[uniqueid]9NOT NULL((0))Previous version. Link to Encounter_Case.ID
NextVersionID[dbo].[uniqueid]9NOT NULL((0))Next version. Link to Encounter_Case.ID