View Name: VW_DB_VERSION
View Type: Standard
Description: The VW_DB_VERSION view summarizes the Schemas applied to a database, including builds/versions, number of changes per entry, and dates applied. This information can help database administrators determine which modules to apply when updating the EQuIS database. This view also allows non-admin users to see what modules their database uses upon clicking the Refresh button.
Output Columns: MODULE, VERSION, DATE_UPDATED, REMARK, NUMBER_OF_CHANGES
Tables: ST_MODULE, ST_VERSION
Database Schema: Standard (no custom or add-on schemas required)
Database Version: EQuIS 6.0+
Data Requirements: None
Output Type: Grid
Example Output: View the following example.
Copyright © 2023 EarthSoft, Inc. • Modified: 12 Jul 2022