Using Query Filters in NAV Maintenance

When you perform NAV maintenance, you identify the NAV data you want to scrub by either:

  • Specifying an existing NAV report profile in the Net Asset Value Maintenance window

  • Defining a set of query filters in the Net Asset Value Maintenance window

The following table provides a detailed comparison of these two methods.



Profile Method

Filter Method



Profile Method

Filter Method

Funds

Any number of funds.

One fund at a time.

Source

Any source.

Any source.

Fields

You can configure fields that appear in the Net Asset Value Maintenance window, based on the fields you specify in the selected NAV report profile.

Not configurable. The Net Asset Value Maintenance window shows all field attributes from the NAV table, where you store class level prices, distributions, and so on.
If you have more than one field defined against the same column, the Net Asset Value Maintenance window displays the field created first. The window does not display internal fields and does not display the 'mutual fund' type fields used by the Performance engine for processing purposes.

Date Range

Any date range.

Any date range.

Data Maintenance

Operation of the scrubbing and journaling are the same.

Operation of the scrubbing and journaling are the same.

Changing Parameters

You make parameter changes in the Net Asset Value report profile.

You make parameter changes directly in the Net Asset Value Maintenance window.

Typical Use

You first use the Net Asset Value report to research errors. You reuse the report and its parameters in the Net Asset Value Maintenance window.

You need to review NAV data for a particular fund because you know there was an error for that fund.


To assign query filters for NAV maintenance:

  1. Open the Net Asset Value Maintenance window, as described in Maintain NAV Data and select the Filter option.

  2. In the Entity field, select the fund with the NAV data you want to scrub.
    You can select one entity at a time.

  3. In the From and To fields, enter the date range for the NAV data you want to scrub.

  4. In the Source field, select the source of the NAV data you want to scrub.

  5. Continue the procedure described in Maintain NAV Data.
    You see the Net Asset Value Maintenance window displays the NAV data that met the filter criteria. It displays columns that correspond to all field attributes in the NAV table.