The Database Menu provides commands to

• create or select the current database,

• import and export data,

• define or erase fields,

• screen data for errors,

• analyze data, as well as

• other database utilities.

These commands operate identically in all ProVal modes – U.S. qualified (private) pension, universal pension (can be used for US non-qualified private or SERP pension plans), U.S. public sector pension, other post-employment benefits (OPEB), Canadian registered pension, German pension and U.K. pension.

Current Database

New Database

Open Database

Close Database

Database Properties

Data Dictionary

Import / Export Data

Import Data

Merge Data

Append Data

List Data

Record Layouts

Export Data

Merge Individual Aggregate

Edit Data

Spreadsheet Edit

Define Field by Expression

Define Field by Table

Expression Sets

Delete Records

Delete Fields

Add Fields

Screen Data

Find Duplicates

Screen Data

Custom Screening Tests

View Error Log

Frequency Tables

Descriptive Statistics

Status Reconciliation

Group Data

Resolve Duplicates

Selection Expressions

Subset Selection