Follow these guidelines when using the HosEvent table.

• For compliance with HOS rules, each event must indicate the place where it occurred. If there is no Location (Location) or Remark (Text) provided, TDE uses the depot of the specified Driver. If the Driver has no depot, an error will be returned.
• Standard driver status events (OffDuty, SleeperBerth, Driving, OnDutyNotDriving, and OffDutyWellSite) cannot use the same EventTime as other standard driver status events.

When you write templates that access this table, follow these requirements:

1. Specify the Symbolic Name for the table version to use:

   Copy

   TableID = HosEvent-1.0

2. Specify an Intent that this table supports:

   • Retrieve

3. 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.

4. Retrieve templates: This table does not require the use of a fetcher. However, the following fetchers are available to optimize your query and are listed from most efficient to least:
   1. Id (Equals/In)
      Copy

      [Filter]
      Id(ExtId) = Equals(Id1)   # You can filter on literals or on variables from the [User] or [Calculated] sections.

      Copy

      [Filter]
      Id(ExtId) = In(["Id1","Id2","Id3"])

   2. DriverId (Equals/In/InHierarchy)
      Copy

      [Filter]
      DriverId(ExtId) = Equals("100057")

   3. EventTime (Between/GreaterThan)
      Copy

      [Filter]
      EventTime = Between(TimeStart,TimeEnd) # You can use either the Between function as shown
                                     # or the GreaterThan function: GreaterThan(Start)

   4. ModifiedTime (Between/GreaterThan)
      Copy

      [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.

Note
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.

Additional columns: