Display the Source for Edited Data

Owned by Kavitha Thangaswamy (Unlicensed)
Last updated: Oct 25, 2023 by Pamela Totas (Deactivated)
2 min read

You can submit the report with filters for the fund, effective date, and range of dates over which changes were made. When the database is updated, the original NAV data that was loaded is not changed. Instead, the data for the entity/effective date is copied over to a new record with a new source, Eagle PACE, and the data change is reflected in this record. You can submit the NAV Maintenance report for a profile that is set to retrieve the data for this source in order to view the new record.

 
 The NAV Maintenance report shares the same query as the NAV Report. The option, Display edited source, allows for the display of the original and edited source data side-by-side. By default, this option is disabled.

If you select the Display edited source check box, the NAV Maintenance report displays an additional column for each field in the report with data from source = 4 (Eagle PACE). See the following figure.

You can edit data only in the edited source columns (light blue background), and cannot edit data in the original source columns (white background).


When the Display Edited Source option is enabled, the source 4 columns have the text [E] appended to the field name. For example, the field NAV has the heading NAV [E] for the edited source column.

The following shows the business logic that the report uses to display records in NAV reporting and maintenance:

IF source = 4 (Eagle PACE) In NAV Report Display only rows for source = 4 In NAV Maintenance Display only columns for source = 4 Only the source = 4 columns can be edited IF source <> 4 In NAV Report IF Overlay edited source is ON Display rows for source = 4 in place of rows for source <> 4 IF Overlay edited source is OFF Display only rows for source <> 4 In NAV Maintenance IF Display edited data is ON Display additional columns for source = 4 and append [E] to the field name Only the source = 4 columns can be edited Display source = 4 columns in different color IF Display edited data is OFF Display only columns for source <> 4 Source <> 4 columns can be edited