Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TBIndicatorOid | INT | NOT NULL | This is the primary key. |
DictionaryItemOid | INT | NOT NULL | This indicates which Data Dictionary Item is represented from the HDataDictionaryItem table. |
IconName | VARCHAR(20) | NOT NULL | This is the image to display in the user interface. |
TBColumnOid | SMALLINT | NOT NULL | This indicates what column the indicator is for. |
TrackingBoardOid | INT | NOT NULL | This indicates what tracking board the indicator is for. |
TBIndicatorStartDTimeMins | SMALLDATETIME | NOT NULL | This is the date/time when the indicator became available. |
TBIndicatorEndDTimeMins | SMALLDATETIME | NULL | This is the date/time when the indicator expired. |
TBIndicatorStartedByOid | INT | NOT NULL | This is the user who added the indicator. |
TBIndicatorEndedByOid | INT | NULL | This is the user who deleted the indicator. |
TBIndicatorStartedBy | VARCHAR(100) | NOT NULL | This is the login ID of the user who added the indicator. |
TBIndicatorEndedBy | VARCHAR(100) | NULL | This is the login ID of the user who deleted the indicator. |
TBIndicatorIsEnded | SMALLINT | NOT NULL | This indicates if the indicator has been deleted. Allowable Values: 0 - No, 1 - Yes. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |