Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBIndicator This table holds the list of available indicators.
Column Name Column Datatype Column Null Option Column Comment
TBIndicatorOidINTNOT NULL This is the primary key.
DictionaryItemOidINTNOT NULL This indicates which Data Dictionary Item is represented from the HDataDictionaryItem table.
IconNameVARCHAR(20)NOT NULL This is the image to display in the user interface.
TBColumnOidSMALLINTNOT NULL This indicates what column the indicator is for.
TrackingBoardOidINTNOT NULL This indicates what tracking board the indicator is for.
TBIndicatorStartDTimeMinsSMALLDATETIMENOT NULL This is the date/time when the indicator became available.
TBIndicatorEndDTimeMinsSMALLDATETIMENULL This is the date/time when the indicator expired.
TBIndicatorStartedByOidINTNOT NULL This is the user who added the indicator.
TBIndicatorEndedByOidINTNULL This is the user who deleted the indicator.
TBIndicatorStartedByVARCHAR(100)NOT NULL This is the login ID of the user who added the indicator.
TBIndicatorEndedByVARCHAR(100)NULL This is the login ID of the user who deleted the indicator.
TBIndicatorIsEndedSMALLINTNOT NULL This indicates if the indicator has been deleted. 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