Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TBVisitIndicatorOid | INT | NOT NULL | This is the primary key. |
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. |
TBIndicatorOid | INT | NOT NULL | This indicates which indicator is assigned to the visit. |
TBVisitIndicatorStartDTimeMins | SMALLDATETIME | NOT NULL | This is the start date/time of the indicator assignment. |
TBVisitIndicatorStartedByOid | INT | NOT NULL | This indicates the user who assigned the indicator. |
TBVisitIndicatorEndedDTimeMins | SMALLDATETIME | NULL | This is the end date/time of the indicator asssignment. |
TBVisitIndicatorEndedByOid | INT | NULL | This indicates the user who ended the indicator. |
TBVisitIndicatorStartedBy | VARCHAR(100) | NOT NULL | This is the login ID of the user who started the indicator assignment. |
TBVisitIndicatorEndedBy | VARCHAR(100) | NULL | This is the login ID of the user who ended the indicator assignment. |
TBVisitIndicatorIsEnded | SMALLINT | NOT NULL | This indicates if the indicator assignment has ended. Allowable Values: 0 - No, 1 - Yes. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |