Topic: Data Dictionary of the reporting tables
Is it possible to get a data dictionary of the reporting tables so that we know what each of the fields in the tables represents?
We are running reports and getting data but we do not realy undestand what the data is actually telling us.
We have a report created that is looking for all trucks that have stopped for longer than an hour and we are using the events and stops tables. When the report runs we get figures for Duration, Total Time and Off-Time that we canot work out what us the relationship.
Begining time 2013-02-10 21:28:06
End Time 2013-02-10 21:48:55
Total Time 0:20:49 we think this is end time - Beginning time
Mobile Visible Secure
Specialists in data acquisition and analysis for mobile and fixed assets. Integration in to content management systems is a specialty we have.