VW_DB_VERSION

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Views >

VW_DB_VERSION

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.

 

Language: English

 

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.

 

VW_DB_VERSION_ex_output