Click or drag to resize
Tables
Print this page

At its core, TDE is a set of simple logical tables (such as Unit, Driver, Job), which are backed by a database or other data source within Verizon Connect. These logical tables simplify and secure how you interact with your data across Verizon Connect products. Every table's columns use the same set of Data types, and every table supports one or more of the following standard data operations:

  • Create
  • Update
  • Delete
  • Retrieve
    Note Note

    Table retrieves are limited to 8 million operations per hour per customer account. Non-retrieves are limited to 1 million operations per hour per user.

You can interact with the tables by creating Templates that let you automate batch operations with your TDE data. You can also work with the tables using the REST API and SOAP API web services.

Tip Tip

TDE has frequent releases. Check the New Features topic to learn about the latest enhancements to these tables.

Supported tables

These are the Verizon Connect tables that are exposed for your use through templates. The Symbolic Name specifies the table name and current version. To reference a table in a template, enter the table's Symbolic Name for the TableID in the [Template] section.

Note Note

  • Product column: Some tables support features that require specific products, such as Response, Route, or Mobile. Contact your account manager or sales representative if you have questions about your licensing.
  • Custom column support: Some tables support adding new columns to manage customer-specific data. For details, see Custom columns.

Table NameProductSymbolic NameCustom Column Support
AlertFleetAlert-1.0
AttributeFleetAttribute-1.0
CapacityMetricLoad ManagementCapacityMetric-1.0tick
CategoryFleetCategory-1.0tick
ColumnTDEColumn-1.0
ConditionFleetCondition-1.0
DataTypeTDEDataType-1.0
DriverFleetDriver-1.0tick
DriverAssignmentFleet, MobileDriverAssignment-1.0
DrivingPeriodFleet, MobileDrivingPeriod-1.0
ErrorCodeTDEErrorCode-1.0
ExternalKeyTDE, FleetExternalKey-1.0
FleetFleetFleet-1.0tick
FormInstanceFleet, MobileFormInstance-1.0
FuelTransactionFleetFuelTransaction-1.0
HierarchyFleetHierarchy-1.0tick
HosEventMobileHosEvent-1.0
JobResponseJob-1.0tick
JobTypeResponseJobType-1.0tick
MarkerFleetMarker-1.0tick
MeasurementUnitTDEMeasurementUnit-1.0
PhotoMobilePhoto-1.0
PointFleetPoint-2.0
MediaVideoFleetMediaVideo-1.0
MediaChannelFleetMediaChannel-1.0
RouteResponseRoute-1.0tick
RouteDriverBreakTDERouteDriverBreak-2.0
ScheduleResponseSchedule-1.0tick
SettingsTDESettings-1.0
ShiftResponseShift-1.0tick
ShiftBreakResponseShiftBreak-1.0tick
ShiftPatternResponseShiftPattern-1.0tick
SignatureMobileSignature-1.0
SiteFleetSite-1.0tick
TableTDETable-1.0
TagFleetTag-1.0
TeamFleetTeam-1.0tick
TerritoryResponseTerritory-1.0tick
TimesheetFleetTimesheet-1.0tick
TimeZoneTDETimeZone-1.0
UnitFleetUnit-1.0tick
UserFleetUser-1.0
UserMessageMobileUserMessage-1.0
VehicleCapacityLimitFleetVehicleCapacityLimit-1.0