Click or drag to resize
Timesheet table
Print this page

The Timesheet table provides information about when drivers swipe in or out using their timecards on vehicles that have a timecard swipe installed.

This topic contains the following sections:


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

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

    TableID = Timesheet-1.0

  2. Specify an Intent that this table supports:

    • Retrieve
    • Create
    • CreateOrUpdate
    • Update

  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 requires the use of a fetcher. The following fetchers are available and are listed from most efficient to least:
    1. Id (Equals/In)
      Id(ExtId) = Equals(Id1)   # You can filter on literals or on variables from the [User] or [Calculated] sections.
      Id(ExtId) = In(["Id1","Id2","Id3"])
    2. ShiftTime (Between) AND DriverId (Equals)
      ShiftTime = Between(TimeStart,TimeEnd)           # can use variables from [User] or [Calculated]
      DriverId(ExternalIdName) = Equals("DOE123")      # or use Telogis Id: DriverId = Equals("123456...")
    3. ShiftTime (GreaterThan) AND DriverId (Equals)
      ShiftTime = GreaterThan(TimeStart)
      DriverId(ExternalIdName) = Equals(userinput_id)  # or use Telogis Id: DriverId = Equals("123456...")
    4. ShiftTime (GreaterThan)
      ShiftTime = GreaterThan(TimeStart)
Timesheet column descriptions

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 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.
Column Data Type Description
Id Id (primary key) The ID of the timesheet event.
DriverId Id<Driver> The ID of the driver generating the event.
UnitId Id<Unit> The ID of the vehicle (if any) assigned to the driver generating the event.
ShiftOn BoolType True if the driver is clocking in, false if the driver is clocking out.
Latitude Angle The latitude of the vehicle at the time of the event.
Longitude Angle The longitude of the vehicle at the time of the event.
ShiftTime Timestamp The time when the event occurred.

Additional columns:

Column Data Type Description
CustomerId Id (read-only, all Fleet tables) The ID of the customer/owner.
CustomerFullName Text (read-only, all Fleet tables) The human-readable full name of the customer/owner.
Custom columns
Column Data Type Description Text Specifies a user-defined custom column name to store additional information in the table. If the column name contains non-alphanumeric characters, enclose the value in brackets, for example Custom.[Special column].