Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBTempLocation This table holds the temporary location assigned to the patient.
Column Name Column Datatype Column Null Option Column Comment
TBTempLocationOidINTNOT 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.
LocationOidINTNULL This indicates which location the patient is assigned to.
LocationAbbrVARCHAR(64)NULL This is the Data Dictionary Item abbreviation of the assignment as defined in the HDataDictionaryItem table.
LocationDesVARCHAR(64)NOT NULL This is the Data Dictionary Item description of the assignment as defined in the HDataDictionaryItem table.
LocationCommentVARCHAR(255)NULL This is the comment on the temporary location.
TBTempLocationStartDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time when the assignment started.
TBTempLocationEndDTimeMinsSMALLDATETIMENULL This indicates the date/time when the assignment ended.
TBTempLocationStartedByOidINTNOT NULL This indicates the user who started the assignment.
TBTempLocationEndedByOidINTNULL This indicates the user who ended the assignment.
TBTempLocationStartedByVARCHAR(100)NOT NULL This is the login ID of the user who started the assignment.
TBTempLocationEndedByVARCHAR(100)NULL This is the login ID of the user who ended the assignment.
TBTempLocationIsEndedSMALLINTNOT NULL This indicates if the assignment is ended. Allowable Values: 0 - No, 1 - Yes.
TBTempLocationIsUpdatedSMALLINTNOT 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