Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TrackingBoardOid | INT | NOT NULL | This is the primary key. |
TrackingBoardName | VARCHAR(64) | NOT NULL | This is the name of the tracking board. |
TrackingBoardDesc | VARCHAR(255) | NOT NULL | This is the description of the tracking board. |
EntityID | INT | NOT NULL | This is the ID of the owning entity. |
TrackingBoardStartedByOid | INT | NOT NULL | This is the user who created the entry. |
TrackingBoardEndedByOid | INT | NULL | This is the user who deleted the entry. |
TrackingBoardStartDTimeMins | SMALLDATETIME | NOT NULL | This indicates the start date/time of the tracking board. |
TrackingBoardEndDTimeMins | SMALLDATETIME | NULL | This indicates the end date/time of the tracking board. |
TrackingBoardStartedBy | VARCHAR(100) | NOT NULL | This is the login ID of the user who created the tracking board. |
TrackingBoardEndedBy | VARCHAR(100) | NULL | This is the login ID of the user who ended the tracking board. |
TrackingBoardIsEnded | SMALLINT | NOT NULL | This indicates if the tracking board is inactive. Allowable Values: 0 - No, 1 - Yes. |
PreviousVisitHistoryDays | SMALLINT | NULL | This is no longer used. |
TrackingBoardType | SMALLINT | NOT NULL | This indicates what kind of tracking board it is. Allowable values: 0, 1. |
TrackingBoardTypeDesc | VARCHAR(10) | NOT NULL | This is the corresponding character value for TrackingBoardType. Allowable values: ED, Other. |
MedRecProcessingType | VARCHAR(30) | NOT NULL | This indicates the default processing for MedRec. Allowable values: 'Continue All Home Meds','Do Not Continue All Home Meds'. |
LayoutMnemonic | VARCHAR(30) | NULL | This indicates which clinical summary layout is used for the chart view. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |