Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TBTempLocationOid | 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. |
LocationOid | INT | NULL | This indicates which location the patient is assigned to. |
LocationAbbr | VARCHAR(64) | NULL | This is the Data Dictionary Item abbreviation of the assignment as defined in the HDataDictionaryItem table. |
LocationDes | VARCHAR(64) | NOT NULL | This is the Data Dictionary Item description of the assignment as defined in the HDataDictionaryItem table. |
LocationComment | VARCHAR(255) | NULL | This is the comment on the temporary location. |
TBTempLocationStartDTimeMins | SMALLDATETIME | NOT NULL | This indicates the date/time when the assignment started. |
TBTempLocationEndDTimeMins | SMALLDATETIME | NULL | This indicates the date/time when the assignment ended. |
TBTempLocationStartedByOid | INT | NOT NULL | This indicates the user who started the assignment. |
TBTempLocationEndedByOid | INT | NULL | This indicates the user who ended the assignment. |
TBTempLocationStartedBy | VARCHAR(100) | NOT NULL | This is the login ID of the user who started the assignment. |
TBTempLocationEndedBy | VARCHAR(100) | NULL | This is the login ID of the user who ended the assignment. |
TBTempLocationIsEnded | SMALLINT | NOT NULL | This indicates if the assignment is ended. Allowable Values: 0 - No, 1 - Yes. |
TBTempLocationIsUpdated | SMALLINT | NOT NULL | This indicates if the entry has been changed historically. Allowable Values: 0 - No, 1 - Yes. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |