System Tables - Obtaining Additional Information about Data
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
System tables are tables that contain information about the database itself such as the version, report, and user information, etc. EarthSoft strongly recommends that edits are not made to these tables. To obtain additional information about data in a database, follow the steps below.
1.Select Tables from the Open group.
2.Click System Tables on the left side of the Data Tables window.
Note that your window may not include all the System Tables displayed above, since some of these tables are associated with EQuIS Enterprise.
3.Open the ST_EDD_BATCH table.
4.Double-click the column header EBATCH to sort the column in descending order.
5.Review the record associated with the ebatch number in ST_EDD_BATCH to determine the following.
a.Source, including file name and sometimes, the directory
b.File format used for data import
c.Time and date of the ebatch
d.User and computer ID
Warning: Do not modify values in system tables unless instructed by EarthSoft. Doing so will cause issues in the functionality of EQuIS. Contact firstname.lastname@example.org for more information.