The GPA gathers information from a variety of sources listed below, alongside the information they each hold.
[Interact][https://awsys.com/products/software/interact/]
[Samsara][https://cloud.samsara.com/signin]
Warning
Samsara integration is currently disabled. Any prompts, buttons, or other things referencing Samsara within the GPA DO NOT do, or affect, anything.
Samsara is third party fleet management software that we currently use to monitor Aggregate Express trucks.
Samsara monitors and logs many things, but for the GPA the useful things are:
- GPS location
- Fuel Efficiency
[Supabase][https://supabase.com/dashboard/sign-in]
Supabase is an auxiliary database to Interact to store additional information that does not have location within Interact.
List of Tables
Critical Tables
These are tables that are critical for GPA accuracy. Any errors or missing information in these tables can compromise the information shown.
Current Pricing
Cost of material/service at the specified location.
This pricing is what the GPA uses for estimating the cost of material/service on a per ticket basis.
[! tip] While you can update this table manually, it is much better to update it within the GPA.
See Vendor Pricing for instructions.
Historic Pricing
Stores previous entries in Current Pricing for referencing cost information of items that have had their price updated.
Adjustments
These are imported occasionally from QuickBooks. These are adjustments to jobs that were made outside of Interact.
Users
Holds user information such as permissions and the last time they were active.
Other Tables
Addresses
Holds address information for locations where jobs can start (usually quarries). The purpose is to eventually use routing to optimize job routes.
Bad Waypoints
List of addresses that were not found with the mapping API. This is used for routing.
Inventory
Items being tracked by inventory.
Adding new entries with their respective code and inventory value will add them to Metabase.
Interact Clone Tables
These tables are cloned directly from Interact and updated automatically at regular intervals. They are the main source of information for Metabase
| Table | Frequency |
|---|---|
| Jobs | Once a day at Midnight |
| Loads | Hourly from 6AM-6PM |
| Locations | Hourly from 6AM-6PM |
| Products | Hourly from 6AM-6PM |
Metadata
Holds miscellaneous data. At this time, it only has the last and next time the Interact clone tables were and will be updated.
Route Cache
Since most mapping tools do not account for traffic after a date has passed, this table stores route information with the date they were recorded to try and capture traffic information after the fact.
Bing Maps
Deprecated as Microsoft transitioned to Azure Maps and functionality has not been migrated.