System Tables - Obtaining Additional Information about Data

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Tables and Forms > System Tables (ST) >

System Tables - Obtaining Additional Information about Data

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.

 

15465-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 support@earthsoft.com for more information.