Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBMainLocation This table contains the main location assigned to the patient visit.
Column Name Column Datatype Column Null Option Column Comment
TBMainLocationOidINTNOT NULL This is the primary key.
TBVisitOidINTNOT NULL This is a foreign key to HTBVisit.
TBVisitStatusSMALLINTNOT NULL This is a foreign key to HTBVisit, it indicates the status of this visit. Allowable values: 0 - active, 1 - ended.
LocationOidINTNOT NULL This indicates which location is assigned to the patient visit.
BedOidINTNULL This indicates which bed is assigned to the patient.
BedNameVARCHAR(75)NOT NULL This indicates which bed name is assigned to the patient.
TBMainLocationIsDeletedSMALLINTNOT NULL This indicates if the entry was deleted. Allowable Values: 0 - No, 1 - Yes.
TBMainLocationStartDTimeMinsSMALLDATETIMENOT NULL This indicates when the assignment started.
TBMainLocationEndDTimeMinsSMALLDATETIMENULL This indicates when the assignment ended.
TBMainLocationStartedByOidINTNOT NULL This is the user who started the assignment.
TBMainLocationEndedByOidINTNULL This is the user who ended the assignment.
TBMainLocationStartedByVARCHAR(100)NOT NULL This is the Login ID of the user who started the assignment.
TBMainLocationEndedByVARCHAR(100)NULL This is the login ID of the user who ended the assignment.
TBMainLocationIsEndedSMALLINTNOT NULL This indicates if the assignment ended. Allowable Values: 0 - No, 1 - Yes.
TBMainLocationIsReservedSMALLINTNOT NULL This indicates if this location is reserved. Allowable Values: 0 - No, 1 - Yes.
TBMainLocationIsUpdatedSMALLINTNOT NULL This indicates if the entry has been changed historically. Allowable Values: 0 - No, 1 - Yes.
LastCngDtimeDATETIMENOT NULL This 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