Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBTimer This table holds the tracking board timers.
Column Name Column Datatype Column Null Option Column Comment
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.
TBColumnOidSMALLINTNULL This indicates which column is delayed.
TBElementTypeVARCHAR(8)NULL This is a mnemonic that points to what kind of data element is delayed, allowable values are "IND", "DDI".
TBElementOidINTNULL This indicates what data element in the column is delayed, this might point to HTBVisitIndicator, HTBCodedText, or be empty. The TBElementType will tell you what it points to.
TBTimerSourceVARCHAR(4)NOT NULL This indicates what is the source of the delay; "USER", "WFE", or "EDTB".
TBTimerLevelTINYINTNOT NULL This indicates what stage of timer is this 0-3. It controls the user selected timer colors on the user interface.
TBTimerInitialDTimeMinsSMALLDATETIMENOT NULL This indicates when the whole timer started.
TBTimerStartDTimeMinsSMALLDATETIMENOT NULL This indicates when did this value start.
TBTimerStartedByUserOidINTNOT NULL This is the user who started the indicator.
TBTimerStartedByUserLoginIdVARCHAR(100)NOT NULL This is the login ID of the user who started the indicator.
TBTimerEndedDTimeMinsSMALLDATETIMENULL This indicates when did this value end.
TBTimerEndedByUserOidINTNULL This is the user who ended the indicator.
TBTimerEndedByUserLoginIdVARCHAR(100)NULL This is the login ID of the user who ended the indicator.
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