Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBColumn This table contains default and system values for each column on the board.
Column Name Column Datatype Column Null Option Column Comment
TBColumnOidSMALLINTNOT NULL This is the primary key.
TBColumnAbbreviationVARCHAR(20)NOT NULL This is the system abbreviation.
TBColumnIsDeletedSMALLINTNOT NULL This indicates if the column has been deleted and is no longer in use. Allowable Values: 0 - No, 1 - Yes.
TBColumnDefaultTitleVARCHAR(64)NOT NULL This is the default title in the Emergency Department Tracking Board.
TBColumnDefaultTooltipVARCHAR(64)NOT NULL This is the default tooltip in the Emergency Department Tracking Board.
TBColumnDefaultImageVARCHAR(64)NULL This is the default image in the Emergency Department Tracking Board.
TBColumnTypeVARCHAR(10)NOT NULL This indicates the type of column. Allowable values include: "static", "staff", "ddi" = Data Dictionary Item, "indicator", "onrsummary" = Orders and Results Summary.
CodedAttributeAllowsMultiSelectSMALLINTNULL If the column is of Data Dictionary Item type, this indicates whether it allows multi select or not.
CodedAttributeDDITypeCodeVARCHAR(64)NULL This indicates what Data Dictionary Item list is available for values.
TBColumnMininumWidthSMALLINTNULL This indicates the minimum column width in pixels.
TBColumnMaximumWidthSMALLINTNULL This indicates the maximum column width in pixels.
TBColumnDefaultWidthSMALLINTNULL This indicates the default column width in pixels.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates