Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBDelay This table indicates that there is a delay either through application logic or workflow for this column.
Column Name Column Datatype Column Null Option Column Comment
TBDelayOidINTNOT 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.
TBColumnOidSMALLINTNOT NULL This indicates which column is delayed.
TBDelaySourceVARCHAR(4)NOT NULL This indicates what the source of the delay is. Allowable values: USER, WFE, or EDTB.
TBDelayStartDTimeMinsSMALLDATETIMENOT NULL This indicates when this value started.
TBDelayStartedByUserOidINTNOT NULL This indicates the user who started the indicator.
TBDelayStartedByUserLoginIdVARCHAR(100)NOT NULL This is the login ID of the user who started the indicator.
TBDelayEndedDTimeMinsSMALLDATETIMENULL This indicates the date/time of when this value ended.
TBDelayEndedByUserOidINTNULL This indicates the user who ended the indicator.
TBDelayEndedByUserLoginIdVARCHAR(100)NULL This is the login ID of the user who ended the indicator.
TBDelayIsEndedSMALLINTNOT NULL This indicates if the value is no longer active. 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