Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPendingLocation Contains patient visit pending location information
Column Name Column Datatype Column Null Option Column Comment
PendingLocation_OIDintNOT NULL Primary Key
CreationDTimeMinssmalldatetimeNOT NULL DateTime stamp when the row was created in the database.
PatientVisit_oidintNOT NULL Visit_oid of patient for this pending location request
BedReqPatLoc_OIDintNOT NULL Location unit objectid for the pending patient.
BedReqPatLocNamevarchar(75)NULL Location unit name for the pending patient.
BedRequested_OIDintNULL Holds oid of bed requested.
BedRequestedNamevarchar(75)NULL Name of the bed requested for the patient.
BedReqMRU_OIDintNULL Medically responsible unit(MRU) objectid requested for the patient.
BedReqMRUNamevarchar(75)NULL Medically responsible unit(MRU) name requested for the patient.
BedReqDTimeMinssmalldatetimeNULL DateTime when the pending location is desired for the patient.
PendingStatusvarchar(10)NOT NULL status of the pending location request(Inactive, Active, Canceled, Fulfilled)
LastCngDtimedatetimeNULL Indicates the current Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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