For Verizon Connect Mobile integrations.
The HosEvent table provides information about HOS (hours of service) events logged for specific drivers.
This table supports Verizon Connect Mobile integrations for Fleet accounts. Contact your account manager for additional information.
This topic contains the following sections:
Follow these guidelines when using the HosEvent table.
When you write templates that access this table, follow these requirements:
Specify the Symbolic Name for the table version to use:
TableID = HosEvent-1.0
Specify an Intent that this table supports:
Input templates: In your [Output] section, be sure to map an input value to every table column that is flagged as being a primary key or required.
[Filter] Id(ExtId) = Equals(Id1) # You can filter on literals or on variables from the [User] or [Calculated] sections.
[Filter] Id(ExtId) = In(["Id1","Id2","Id3"])
[Filter] DriverId(ExtId) = Equals("100057")
[Filter] EventTime = Between(TimeStart,TimeEnd) # You can use either the Between function as shown # or the GreaterThan function: GreaterThan(Start)
[Filter] ModifiedTime = Between(TimeStart,TimeEnd) # You can use either the Between function as shown # or the GreaterThan function: GreaterThan(Start)
This list includes each column's name, which you use in expressions to retrieve or create data, and data type, which defines how the data is retrieved and set.
|If a column of data type Id is a primary key OR if it refers to other tables (Id <OtherTable>), then you can map it to an external key or, in some cases, a Telogis key.|
|Id||Id||(primary key) The Id of the HosEvent event.|
|DriverId||Id<Driver>||The Id of the driver assigned to the vehicle when the event occurred.|
|EventType||Text||Indicates the type of the event (the driver's new status). Values: OffDuty, Driving, OnDutyNotDriving, HoS16HourExtension, SleeperBerth, SignedEmptyDay.|
|EventTime||Timestamp||The time when the status change event occurred.|
|ModifiedTime||Timestamp||The time the event was most recently updated, if ever.|
|Location||Location||The location where the event occurred (where the driver changed status).|
|Remarks||Text||A string of notes attached to the event.|
|SubStatus||Text||(read-only) An additional classification for the EventType, which is used for reporting purposes. This field is only used if the EventType is set to OnDuty, OffDuty, or Driving. Values: No event type, Fuel, Meal, BREAK, DOT Break, Unloading, Loading, Personal Conveyance, Meeting, Warehouse, Office, Pre-Inspection, Post-Inspection, Roadside Inspection, Delivery, Other.|