Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientTemporaryLocation Contains information about patient temporary location.
Column Name Column Datatype Column Null Option Column Comment
PtTempLocation_OIDintNOT NULL Next available oid generated by ADT code.
TempLocationNamevarchar(64)NOT NULL Temporary location Name assigned by the user.
StartDTimeMinssmalldatetimeNOT NULL Date and Time when patient entered temporary location.
EndDTimeMinssmalldatetimeNULL Date and time when patient left temporary location.
ActivetinyintNOT NULL Active indicator.
Commentvarchar(255)NULL Comment entered by user.
PatientVisit_oidintNOT NULL Patient visit oid as it is in HPatientVisit table.
LastCngDtimedatetimeNULL System UTC date /time when row was updated.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates