Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TBVisitOid | INT | NOT NULL | This is the primary key. |
TBVisitIsDeleted | SMALLINT | NOT NULL | This indicates if this visit has been deleted. Allowable Values: 0 - No, 1 - Yes. |
PatientVisitOid | INT | NOT NULL | This indicates what patient visit is this tracking board entry part of. |
TBVisitSeverity | SMALLINT | NULL | This indicates the triage level. |
TBVisitStartDTimeMins | SMALLDATETIME | NOT NULL | This indicates the start date/time of the tracking board visit. |
TBVisitEndDTimeMins | SMALLDATETIME | NULL | This indicates the end date/time of the tracking board visit. |
TBVisitStatus | SMALLINT | NOT NULL | This indicates the status of this visit. Allowable values: 0 - active, 1 - ended. |
TBVisitIsRemoved | SMALLINT | NOT NULL | This indicates if the visit has been manually removed. Allowable Values: 0 - No, 1 - Yes. |
TBVisitRemovedDTimeMins | SMALLDATETIME | NULL | This indicates the date/time when the visit was manually removed. |
TBVisitRemovedByOid | INT | NULL | This indicates the user who manually removed the visit. |
TBVisitRemovedBy | VARCHAR(100) | NULL | This is the login ID of the user who manually removed this visit. |
TBVisitIsQualified | SMALLINT | NOT NULL | This indicates if the visit is qualified for the current tracking board. Allowable Values: 0 - No, 1 - Yes. |
TBVisitHasPreviousVisit | SMALLINT | NOT NULL | This indicates if the patient had a previous visit when this entry was created. |
TBVisitHasDupeName | SMALLINT | NULL | This indicates whether the patient shares a duplicate or similar name with another patient on the tracking board. |
TBVisitDupeNameUserOid | INT | NULL | This is the user object ID of the user who marked this visit a duplicate. This will be NULL if the value was system set. |
TBVisitDupeNameUserLoginId | VARCHAR(100) | NULL | This is the login ID of the user who marked this visit a duplicate. This will be NULL if the value was system set. |
WFE_LOS_Status | SMALLINT | NOT NULL | This indicates whether the Workflow Engine has overridden the Length Of Stay statuses. Allowable Values: 0 - No, 1 - Yes. |
TrackingBoardOid | INT | NOT NULL | This indicates on which tracking board the visit belongs. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |