Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBPrearrival This table contains information about the pre-arrival visits.
Column Name Column Datatype Column Null Option Column Comment
TBPrearrivalOidINTNOT NULL This is the primary key.
TBVisitOidINTNOT NULL This is a foreign key to HTBVisit.
TBVisitStatusSMALLINTNOT NULL This is a foreign key to HTBVisit, it indicates the status of this visit. Allowable values: 0 - active, 1 - ended.
PreArrivalNotificationDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time of when the tracking board was notified of the pre-arrival.
EstimatedArrivalDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time of when the patient is expected to arrive.
PreArrivalStatusVARCHAR(10)NOT NULL This indicates the status of the pre-arrival. Allowable values: notified, arrived, or no-show.
PreArrivalTypeVARCHAR(16)NOT NULL This indicates the type of pre-arrival,(e.g. PreArrival, Transfer, AddToBoard, etc).
ModeOfArrivalVARCHAR(64)NULL This indicates how the patient arrived,(e.g. ambulance, walk-in, etc.).
TransportAgencyVARCHAR(64)NULL This is the identifier for the ambulance.
ReasonForTransferVARCHAR(64)NULL This indicates the reason why the patient is a pre-arrival(e.g. why transfer from urgent care to emergency deptartment).
TransferingFacilityVARCHAR(64)NULL This indicates where did the prearrival came from.
ReasonForNoShowVARCHAR(64)NULL This indicates why the patient did not arrive(e.g. diverted, etc.).
TBPrearrivalStartDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time of when the pre-arrival visit started.
TBPrearrivalStartedByUserOidINTNOT NULL This indicates the user who started the pre-arrival visit.
TBPrearrivalStartedByUserLoginIdVARCHAR(100)NOT NULL This is the login ID of the user who started the pre-arrival visit.
TBPrearrivalEndedDTimeMinsSMALLDATETIMENULL This indicates when the pre-arrival visit ended.
TBPrearrivalEndedByUserOidINTNULL This indicates the user who ended the pre-arrival visit.
TBPrearrivalEndedByUserLoginIdVARCHAR(100)NULL This is the login ID of the user who ended the pre-arrival visit.
TBPrearrivalIsEndedSMALLINTNOT NULL This indicates if the pre-arrival visit is ended. Allowable Values: 0 - No, 1 - Yes.
LastCngDtimeDATETIMENOT NULL This indicates the current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates