Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HBedTransfer Contains bed information for the visit.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HBedTransfer Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(15)NULL Not Used
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 Date and time when row was created.
FromDatedatetimeNULL Start Date and Time for a Transfer
ToDatedatetimeNULL End Date and Time for a Transfer
ActivebitNULL Active indicator. When 0 - Inactive transfer row, when 1 - Active Transfer row
ReasonforPatientTransfervarchar(75)NULL A String representing Reason For Patient Transfer
FromBedNamevarchar(75)NULL Name of the Bed the patient was transferred from.
ToBedNamevarchar(75)NULL Name of the Bed the patient was transferred to.
IsolationIndicatorvarchar(64)NULL Its a Data Dictionary Item created by client and enterd by the user during transfer.
UserIDvarchar(10)NULL UserId of the user who performed the transfer
AccommodationTypevarchar(64)NULL It is a Data Dictionary Item created by client and enterd by the user during transfer.
FormIDintNULL ID of the Transfer Form used to perform Transfer from Soarian UI(Obsolete)
PatientVisit_oidintNOT NULL Visit ObjectID of the HPatientVisit to which the transfer belongs
FromBed_oidintNULL Bed ObjectID patient was moved from. Must exist in HBed table
ToBed_oidintNULL Bed ObjectID patient was moved to. Must exist in HBed table
FromLocation_oidintNOT NULL Location ObjectID patient was moved from. Should exist in HHealthcareunit table
ToLocation_oidintNULL Location ObjectID patient was moved to. Should exist in HHealthcareunit table
BedTransferExtension_oidintNULL Not used
ExternalIDvarchar(75)NULL It is the move number associated with a transfer. Will be useful while cancelling a transfer.
CancelledsmallintNULL Cancel Indicator. Allowable Values: 0 - false, null - Not valued, 1 - True(Cancelled).
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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