The Database Views functionality available in the LEXICON module provides the System Administrator with the ability to map element data into sets of related tables (Database View Sets). The database view sets are populated with rows that exists in a table for each element that meets specified criteria. The columns are derived from attributes, PML 1 or XPath1.0 expressions. Attributes and expressions for the columns are specified from the elements defined in the view definition (that is from multiple elements not just the row element).

It is advised to create Database Views as User Views with the Database Views Editor in the relevant module. Refer to Database Views Editor for further information.

If the editor is not available it can be added with the customisation command Aveva.Pdms. Database View Editor. The customisation command allows a user, the opportunity to test the view as a user view with full data access.