Tables [dbo].[Encounter_Status]
Status of an Encounter. This is optional but can be set from the banner.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Encounter_Status_EncounterID: EncounterIDForeign Keys FK_Encounter_Status_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Indexes NIX_Encounter_Status_PatientID_EncounterStatusDE, NIX_Encounter_Status_SiteDE_PatientID_EncounterStatusDE, TWstat_Encounter_Status_EncounterStatusDE(3)Foreign Keys FK_Encounter_Status_EncounterStatusDE_Encounter_Status_DE_ID: [dbo].[Encounter_Status_DE].EncounterStatusDEEncounterStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Encounter_Status_DE.ID
Indexes NIX_Encounter_Status_LastUpdatedDTTM_PatientID, NIX_Encounter_Status_PatientID_EncounterStatusDE, NIX_Encounter_Status_SiteDE_PatientID_EncounterStatusDE(3)LastUpdatedDTTMdatetime8NULL allowedLast updated date and time
Indexes NIX_Encounter_Status_SiteDE_PatientID_EncounterStatusDEForeign Keys FK_Encounter_Status_SiteDE_Site_DE_ID: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULLSite. Link to Site_DE.ID
Indexes NIX_Encounter_Status_LastUpdatedDTTM_PatientID, NIX_Encounter_Status_PatientID_EncounterStatusDE, NIX_Encounter_Status_SiteDE_PatientID_EncounterStatusDE(3)PatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID