This section contains articles about the EQuIS views developed by EarthSoft, Inc.
In a SQL database, a view is a virtual table (not saved to the database) based on the output of a SQL statement, similar to a report output. They are not editable and are used to view data or report it more efficiently. Rows within a view do not count towards the total number of rows in a database. For information on creating a custom view for a database, see Create Custom View.
In EQuIS Professional, access Views from the Open window:
The following views are part of the standard EQuIS Schema (i.e., EQuIS Professional, Enterprise, and StandardReports):
CM_TSCONC CM_TSSOILDEPTH ST_ID ST_REPORT_USE ST_USER_FACILITY ST_USER_ROLE VW_AUDIT |
VW_COORD_NON_NUMERIC VW_DB_VERSION VW_DOWNHOLE_DATA VW_GEOGRAPHY_POINT VW_GROUP_MEMBER_TREE VW_LITHOLOGY VW_LITHOLOGY_GAP_OVERLAP |
VW_LOCATION VW_RESULT_NON_NUMERIC VW_TABLE_COLUMN VW_TABLE_ORDER VW_TABLE_ROW_COUNT VW_WELL VW_WELL_SEGMENT |
Note: If VW_TABLE_ROW_COUNT returns the error, "VIEW DATABASE PERFORMANCE STATE permission denied in database", the database administrator should run the following on the database: GRANT VIEW DATABASE PERFORMANCE STATE to ES_PUBLIC |