Locations
The Locations tables list U.S. counties, countries, states/provinces, and time zones available in the system. These read-only tables are useful for looking up the country, county, and state IDs for use in report filters and for populating the address fields of records. The list of time zones is used in the capture of telemetry data.
Use the following tools to interact with the tables:
- Print the list
- Download the list
- Search the list
The data sets are built into the software and are read-only. Please contact Assetas with questions.
Counties
The Counties table includes every United States county, sorted alphabetically by state, along with the country FIPS code and 36-character GUID.
Countries
The Countries table includes the full country name, two-digit code, and 36-character GUID.
States
The States table includes US states, US territories, and Canadian provinces, along with the two-digit code and the 36-character GUID.
Time Zones
The Time Zone table includes key elements for each global time zone.
- ID: The unique identifier of the time zone.
- Display: How the time zone will display in the system.
- Standard Name: The name of the time zone during standard time (when Daylight Saving Time is not in use).
- DST Name: The name of the time zone during Daylight Saving Time.
- Offset: The difference from Coordinated Universal Time (UTC).
- DST: If the time zone supports Daylight Saving Time.