Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
TBVisitOid | INT | NOT NULL | This is a foreign key to HTBVisit. |
TBVisitStatus | SMALLINT | NOT NULL | This is a foreign key to HTBVisit, it indicates the status of this visit. Allowable values: 0 - active, 1 - ended. |
TBColumnOid | SMALLINT | NULL | This indicates which column is delayed. |
TBElementType | VARCHAR(8) | NULL | This is a mnemonic that points to what kind of data element is delayed, allowable values are "IND", "DDI". |
TBElementOid | INT | NULL | This indicates what data element in the column is delayed, this might point to HTBVisitIndicator, HTBCodedText, or be empty. The TBElementType will tell you what it points to. |
TBTimerSource | VARCHAR(4) | NOT NULL | This indicates what is the source of the delay; "USER", "WFE", or "EDTB". |
TBTimerLevel | TINYINT | NOT NULL | This indicates what stage of timer is this 0-3. It controls the user selected timer colors on the user interface. |
TBTimerInitialDTimeMins | SMALLDATETIME | NOT NULL | This indicates when the whole timer started. |
TBTimerStartDTimeMins | SMALLDATETIME | NOT NULL | This indicates when did this value start. |
TBTimerStartedByUserOid | INT | NOT NULL | This is the user who started the indicator. |
TBTimerStartedByUserLoginId | VARCHAR(100) | NOT NULL | This is the login ID of the user who started the indicator. |
TBTimerEndedDTimeMins | SMALLDATETIME | NULL | This indicates when did this value end. |
TBTimerEndedByUserOid | INT | NULL | This is the user who ended the indicator. |
TBTimerEndedByUserLoginId | VARCHAR(100) | NULL | This is the login ID of the user who ended the indicator. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |