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 | |
---|---|---|
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. |
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:
Open the Net Asset Value Maintenance window, as described in Maintain NAV Data and select the Filter option.
In the Entity field, select the fund with the NAV data you want to scrub.
You can select one entity at a time.In the From and To fields, enter the date range for the NAV data you want to scrub.
In the Source field, select the source of the NAV data you want to scrub.
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.