Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBVisit This table contains all the Emergency Department tracking board visits.
Column Name Column Datatype Column Null Option Column Comment
TBVisitOidINTNOT NULL This is the primary key.
TBVisitIsDeletedSMALLINTNOT NULL This indicates if this visit has been deleted. Allowable Values: 0 - No, 1 - Yes.
PatientVisitOidINTNOT NULL This indicates what patient visit is this tracking board entry part of.
TBVisitSeveritySMALLINTNULL This indicates the triage level.
TBVisitStartDTimeMinsSMALLDATETIMENOT NULL This indicates the start date/time of the tracking board visit.
TBVisitEndDTimeMinsSMALLDATETIMENULL This indicates the end date/time of the tracking board visit.
TBVisitStatusSMALLINTNOT NULL This indicates the status of this visit. Allowable values: 0 - active, 1 - ended.
TBVisitIsRemovedSMALLINTNOT NULL This indicates if the visit has been manually removed. Allowable Values: 0 - No, 1 - Yes.
TBVisitRemovedDTimeMinsSMALLDATETIMENULL This indicates the date/time when the visit was manually removed.
TBVisitRemovedByOidINTNULL This indicates the user who manually removed the visit.
TBVisitRemovedByVARCHAR(100)NULL This is the login ID of the user who manually removed this visit.
TBVisitIsQualifiedSMALLINTNOT NULL This indicates if the visit is qualified for the current tracking board. Allowable Values: 0 - No, 1 - Yes.
TBVisitHasPreviousVisitSMALLINTNOT NULL This indicates if the patient had a previous visit when this entry was created.
TBVisitHasDupeNameSMALLINTNULL This indicates whether the patient shares a duplicate or similar name with another patient on the tracking board.
TBVisitDupeNameUserOidINTNULL This is the user object ID of the user who marked this visit a duplicate. This will be NULL if the value was system set.
TBVisitDupeNameUserLoginIdVARCHAR(100)NULL This is the login ID of the user who marked this visit a duplicate. This will be NULL if the value was system set.
WFE_LOS_StatusSMALLINTNOT NULL This indicates whether the Workflow Engine has overridden the Length Of Stay statuses. Allowable Values: 0 - No, 1 - Yes.
TrackingBoardOidINTNOT NULL This indicates on which tracking board the visit belongs.
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