Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TBPrearrivalOid | 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. |
PreArrivalNotificationDTimeMins | SMALLDATETIME | NOT NULL | This indicates the date/time of when the tracking board was notified of the pre-arrival. |
EstimatedArrivalDTimeMins | SMALLDATETIME | NOT NULL | This indicates the date/time of when the patient is expected to arrive. |
PreArrivalStatus | VARCHAR(10) | NOT NULL | This indicates the status of the pre-arrival. Allowable values: notified, arrived, or no-show. |
PreArrivalType | VARCHAR(16) | NOT NULL | This indicates the type of pre-arrival,(e.g. PreArrival, Transfer, AddToBoard, etc). |
ModeOfArrival | VARCHAR(64) | NULL | This indicates how the patient arrived,(e.g. ambulance, walk-in, etc.). |
TransportAgency | VARCHAR(64) | NULL | This is the identifier for the ambulance. |
ReasonForTransfer | VARCHAR(64) | NULL | This indicates the reason why the patient is a pre-arrival(e.g. why transfer from urgent care to emergency deptartment). |
TransferingFacility | VARCHAR(64) | NULL | This indicates where did the prearrival came from. |
ReasonForNoShow | VARCHAR(64) | NULL | This indicates why the patient did not arrive(e.g. diverted, etc.). |
TBPrearrivalStartDTimeMins | SMALLDATETIME | NOT NULL | This indicates the date/time of when the pre-arrival visit started. |
TBPrearrivalStartedByUserOid | INT | NOT NULL | This indicates the user who started the pre-arrival visit. |
TBPrearrivalStartedByUserLoginId | VARCHAR(100) | NOT NULL | This is the login ID of the user who started the pre-arrival visit. |
TBPrearrivalEndedDTimeMins | SMALLDATETIME | NULL | This indicates when the pre-arrival visit ended. |
TBPrearrivalEndedByUserOid | INT | NULL | This indicates the user who ended the pre-arrival visit. |
TBPrearrivalEndedByUserLoginId | VARCHAR(100) | NULL | This is the login ID of the user who ended the pre-arrival visit. |
TBPrearrivalIsEnded | SMALLINT | NOT NULL | This indicates if the pre-arrival visit is ended. Allowable Values: 0 - No, 1 - Yes. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |