Tables [dbo].[Patient_Location]
Current Location for a patient. Set from the banner.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Patient_Location_PatientID: PatientIDIndexes NIX_Patient_Location_PatientID_SiteLocationDEForeign Keys FK_Patient_Location_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Key to the Person Table
Indexes NIX_Patient_Location_PatientID_SiteLocationDE, TWstat_Patient_Location_SiteLocationDE(2)Foreign Keys FK_Patient_Location_SiteLocationDE_Site_Location_DE_ID: [dbo].[Site_Location_DE].SiteLocationDESiteLocationDE[dbo].[dict_id]5NOT NULLSite Location. Key to the Site_Location_DE table.
Indexes NIX_Patient_location_LastUpdatedDTTMLastUpdatedDTTMdatetime8NULL allowedLast date location was updated
Indexes TWstat_Patient_Location_SiteDEForeign Keys FK_Patient_Location_SiteDE_Site_DE_ID: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULLSite. Key to the Site_DE table.
Indexes TWstat_Patient_Location_EncounterIDForeign Keys FK_Patient_Location_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Key to the Encounter table