Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TBColumnOid | SMALLINT | NOT NULL | This is the primary key. |
TBColumnAbbreviation | VARCHAR(20) | NOT NULL | This is the system abbreviation. |
TBColumnIsDeleted | SMALLINT | NOT NULL | This indicates if the column has been deleted and is no longer in use. Allowable Values: 0 - No, 1 - Yes. |
TBColumnDefaultTitle | VARCHAR(64) | NOT NULL | This is the default title in the Emergency Department Tracking Board. |
TBColumnDefaultTooltip | VARCHAR(64) | NOT NULL | This is the default tooltip in the Emergency Department Tracking Board. |
TBColumnDefaultImage | VARCHAR(64) | NULL | This is the default image in the Emergency Department Tracking Board. |
TBColumnType | VARCHAR(10) | NOT NULL | This indicates the type of column. Allowable values include: "static", "staff", "ddi" = Data Dictionary Item, "indicator", "onrsummary" = Orders and Results Summary. |
CodedAttributeAllowsMultiSelect | SMALLINT | NULL | If the column is of Data Dictionary Item type, this indicates whether it allows multi select or not. |
CodedAttributeDDITypeCode | VARCHAR(64) | NULL | This indicates what Data Dictionary Item list is available for values. |
TBColumnMininumWidth | SMALLINT | NULL | This indicates the minimum column width in pixels. |
TBColumnMaximumWidth | SMALLINT | NULL | This indicates the maximum column width in pixels. |
TBColumnDefaultWidth | SMALLINT | NULL | This indicates the default column width in pixels. |