Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HExtendedBedTransfer Contains patient's Bed Transfer Extended information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HExtendedBedTransfer Rows generated by Architecture same as BedTransferExtension_oid in hbedtransfer table
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(25)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 created the HExtendedBedTransfer row
CreationTimesmalldatetimeNULL date and time when the object is created.
UserDefinedNumeric1float(53)NULL Additional numeric information about a bed transfer.
UserDefinedNumeric2float(53)NULL Additional numeric information about a bed transfer.
UserDefinedNumeric3float(53)NULL Additional numeric information about a bed transfer.
UserDefinedNumeric4float(53)NULL Additional numeric information about a bed transfer.
UserDefinedNumeric5float(53)NULL Additional numeric information about a bed transfer.
UserDefinedString1varchar(255)NULL Additional information about a bed transfer.
UserDefinedString2varchar(255)NULL Additional information about a bed transfer.
UserDefinedString3varchar(255)NULL Additional information about a bed transfer.
UserDefinedString4varchar(255)NULL Additional information about a bed transfer.
UserDefinedString5varchar(255)NULL Additional information about a bed transfer.
UserDefinedString6varchar(255)NULL Additional information about a bed transfer.
UserDefinedString7varchar(255)NULL Additional information about a bed transfer.
UserDefinedString8varchar(255)NULL Additional information about a bed transfer.
UserDefinedString9varchar(255)NULL Additional information about a bed transfer.
UserDefinedString10varchar(255)NULL Additional information about a bed transfer.
UserDefinedString11varchar(255)NULL Additional information about a bed transfer.
UserDefinedString12varchar(255)NULL Additional information about a bed transfer.
UserDefinedString13varchar(255)NULL Additional information about a bed transfer.
UserDefinedString14varchar(255)NULL Additional information about a bed transfer.
UserDefinedString15varchar(255)NULL Additional information about a bed transfer.
UserDefinedString16varchar(255)NULL Additional information about a bed transfer.
UserDefinedString17varchar(255)NULL Additional information about a bed transfer.
UserDefinedString18varchar(255)NULL Additional information about a bed transfer.
UserDefinedString19varchar(255)NULL Additional information about a bed transfer.
UserDefinedString20varchar(255)NULL Additional information about a bed transfer.
UserDefinedString21varchar(255)NULL Additional information about a bed transfer.
UserDefinedString22varchar(255)NULL Additional information about a bed transfer.
UserDefinedString23varchar(255)NULL Additional information about a bed transfer.
UserDefinedString24varchar(255)NULL Additional information about a bed transfer.
UserDefinedString25varchar(255)NULL Additional information about a bed transfer.
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.

Return to Table-Index

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