SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

DropOffLocationID 
Definition  A foreign key to the TransportLocationID column in the SXAAMTransportLocation table. 

PickupLocationID 
Definition  A foreign key to the TransportLocationID column in the SXAAMTransportLocation table. 

PickupDtm 
Definition  Visit TimeZone - Date/time of pickup 

DropOffDtm 
Definition  Visit TimeZone - Date/time of drop off 

IsEmergency 
Definition  An enumerated type with the following list of possible values: 0 = [No],1 = [Yes],2 = [Unanswered], 

ReportNumber 
Definition  Free-text field identifying ambulatory company 

Note 
Definition  Note regarding transportation 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

NumPatientsTransported 
Definition  Number of Patients Transported 

IsCertFormSigned 
Definition  An enumerated type with the following list of possible values: 0 = [No],1 = [Yes],2 = [Unanswered], 

Complaint 
Definition  Patient Complaint 

WaitingTimeMin 
Definition  Waiting Time in minutes 

PatientWeight 
Definition  Patient's weight 

RoundTripPurpose 
Definition  Round Trip Purpose 

StretcherPurpose 
Definition  Stretcher Purpose 

AirPurpose 
Definition  Air Transport Purpose 

OrigLocationTypeID 
Definition  A foreign key to the TransportLocationTypeID column in the SXAAMTransportLocationType table. 

DestLocationTypeID 
Definition  A foreign key to the TransportLocationTypeID column in the SXAAMTransportLocationType table. 

OrigAddressOverrideGUID 
Definition  A foreign key to the GUID column in the CV3Address table. 

DestAddressOverrideGUID 
Definition  A foreign key to the GUID column in the CV3Address table. 

TransportServiceID 
Definition  A foreign key to the TransportServiceID column in the SXAAMTransportService table. 

TransportTripTypeID 
Definition  The Transport Trip Type 

TransportReasonID 
Definition  A foreign key to the TransportReasonID column in the SXAAMTransportReason table. 

IsMedicallyNecessary 
Definition  An enumerated type with the following list of possible values: 0 = [No],1 = [Yes],2 = [Unanswered], 

Distance 
Definition  The distance traveled 

ClientVisitGUID 
Definition  A foreign key to the ClientVisitGUID column in the SXAAMVisitRegistration table.