Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HBed Contains detailed bed information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectID of HBed table generated by Architecture
InstanceHFCIDsmallintNOT NULL InstanceHFCID of HBed table generated by Architecture
RecordIdintNULL RecordID of HBed table generated by Architecture
Descriptionvarchar(255)NULL Description of the bed that is being created. Client can value that field as a descriptive name of the bed.
IsVersionedbitNOT NULL Indicates if the row in the table is modified or not. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserID of the user who created the row in the database
CreationTimesmalldatetimeNULL Date and Time when row was created.
BedTypeNamevarchar(75)NOT NULL Bed display name created by Admin user, this is a combination of RoomCode & BedCode columns
BedStatustinyintNOT NULL Bed Status. Allowable Values: 0 - Occupied, 1- House keeping, 2-vacant
ActivebitNOT NULL Active indicator. Allowable Values: 1-Active, 0-Non Active
IsSchedulablebitNULL Is Schedulable indicator.
BedTypetinyintNOT NULL Bed type Allowable Values: 0- Non Technical, 1- Technical
BedPathvarchar(2000)NOT NULL Hospital Organization path till the bed name right from enterprise
HealthCareUnit_oidintNULL ObjectID of HHealthCareUnit under which this bed is created
SeqNointNULL Sequence Number of the Bed
RoomCodevarchar(40)NULL Room Code where the Bed exists
BedCodevarchar(75)NOT NULL Bed Code of the Bed
BedExternalAbbvarchar(75)NOT NULL Similar to BedTypeName column. Used for inbound and outbound interfaces. Indicates the abbreviation of the bed as known by the external systems like Invision,SF etc.
StatusModifiervarchar(64)NULL Stores one of additional Bed Statuses like Needs Cleaning, Needs Terminal Cleaning, Closed, Hold etc.
Commentsvarchar(256)NULL General Comments entered on the Bed that's being created
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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