Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HBedTransferHistory Contains detaile bed transfer history information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HBedTransferHistory Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIDintNULL RecordId of the Patient
Descriptionvarchar(15)NULL Valued by the User.
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIDintNULL UserId of the user who performed the transfer
CreationTimesmalldatetimeNULL CreationTime of the row creation
FromDatedatetimeNULL Start Date and Time for a Transfer.
UserIDvarchar(10)NULL UserId of the user who performed the transfer
PatientVisitOIDintNOT NULL ObjectID of the HPatientVisit to which the transfer belongs
BedTransfer_OIDintNOT NULL ObjectID of the HBedTransfer to which the transfer belongs
ReasonforPatientTransfervarchar(75)NULL A String representing Reason For Patient Transfer
AccommodationTypevarchar(64)NULL Accommodation Type of the bed
BedNamevarchar(75)NULL BedName of the From bed
Bed_OIDintNULL ObjectID of the FromBed in HBed table
Location_OIDintNOT NULL ObjectID of the Location in HHealthcareunit table
ExternalIDvarchar(75)NULL It is the move number associated with a transfer. Will be useful while cancelling a transfer.
CancelledsmallintNULL Bed transfer Cancel Indicator. Allowable Values: 0 - not cancelled, 1 - Cancelled, Null - Not Valued.
LastCngDtimedatetime System UTC date /time when row was updated.

Return to Table-Index

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