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 unless directed. To obtain additional information about data in a database, follow the steps below:
1.Select Tables from the Home – Open group of the EQuIS Professional.
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 EarthSoft Support for more information. |
FACILITY_ID for EDDs
ST_EDD_BATCH does not currently have a FACILITY_ID column, but the FACILITY_ID for EDDs loaded via Enterprise EDP is recorded in the related ST_FILE_REGISTRATION table. To include EDDs loaded via EQuIS Professional, enable RegisterFile in ST_CONFIG as outlined here.
The following example query can be used to display ST_EDD_BATCH information plus the corresponding FACILITY_ID for the EDD from ST_FILE_REGISTRATION:
SELECT
ST_FILE_REGISTRATION.FACILITY_ID,
ST_EDD_BATCH.*
FROM ST_EDD_BATCH LEFT JOIN ST_FILE_REGISTRATION ON ST_EDD_BATCH.EBATCH=ST_FILE_REGISTRATION.EBATCH
Not all EDDs target a single facility; in those cases, ST_FILE_REGISTRATION.FACILITY_ID is left null.