Signature table

The Signature table provides access to electronic signatures associated with HOS (Hours of Service) events logged for specific drivers. Signatures are captured, for example, when a driver electronically signs HOS reports or forms.

This table supports Verizon Connect Mobile integrations for Fleet accounts. Contact your account manager for additional information.

Note
Once created, these entities are read-only.

This topic contains the following sections:

Requirements
Signature column descriptions

Requirements

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

Specify the Symbolic Name for the table version to use:
Copy
```
TableID = Signature-1.0
```
Specify an Intent that this table supports:
- Retrieve
- Create
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.

Retrieve templates: This table requires the use of a fetcher. The following fetchers are available and are listed from most efficient to least:

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"])

DriverId (Equals) AND Created (Equals)

Copy

[Filter]
DriverId(ExternalIdName) = Equals("DEF123")       # or use Telogis Id: DriverId = Equals("123456...")
Created = Equals("2013-01-31 15:00, PST")         # can use variables from [User] or [Calculated]

DriverId (Equals)

Copy

[Filter]
DriverId(ExternalIdName) = Equals("ABC123")       # or use Telogis Id: DriverId = Equals("123456...")

Signature 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
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 signature.
DriverId	Id<Driver>	The ID of the associated driver.
Created	Timestamp	The time when the signature was created.
Lines	MultiLineString	The graphical description of the signature shape.
Width	Number	The horizontal length (as a positive integer) of the signature's bounding box.
Height	Number	The vertical length (as a positive integer) of the signature's bounding box.

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.