CVR functionality includes options to improve database storage (primarily database size) and maintain and analyse the CVR data.

The Options menu on the CVR Models screen includes a CVR Storage Analysis menu item. When selected, you are taken to a CVR Storage Analysis Screen. You can use this screen to generate a detailed CVR Storage Analysis Report for the current CVR Model, which is detailed in Section CVR Data Storage - CVR Storage Analysis.

CVR > Setup > CVR Models.

A CVR Model Diagnosis submenu is found under the CVR Administration menu, as shown in CVR Model Diagnosis Submenu.

The items found on this submenu are:

You can use the CVR Storage Analysis option on the CVR > Administration > CVR Model Diagnosis submenu to report on data storage for CVR Models. The report is sorted and grouped by Model, Period, CVR Item, and Type.

When you select the CVR Storage Analysis option, a selection screen appears, as shown in CVR Storage Analysis Selection Screen.

CVR Storage Analysis Selection Screen

You can select a range of CVR Models to report on from the current company or a company specified in the CV/KCOMODEL parameter.

You can select a range of periods to report on.

The CVR Storage Analysis Report displays the list of records grouped together for each selected CVR Model and its CVR Items. A sample report is shown in CVR Storage Analysis Report Sample.

CVR Storage Analysis Report Sample

CVRs previously could only be deleted manually from the Contract CVRs screen. This was an extremely time consuming and inconvenient process since each Contract had to be visited. To resolve this, a Purge CVRs menu option is available on the CVR > Administration menu, as shown in Purge CVRs Menu Item.

Once the menu option is selected, it displays the selection screen shown in Purge CVRs Selection Screen.

The periods that can be entered are:

The default for this field is unticked. When unticked, Enquiry data is not purged, and backup is created for part of the data from the purged CVR. When ticked, Enquiry data is deleted, and no backup is created.

When this option is selected, the data to be purged is checked only but not deleted.

When this option is selected, the CVR records in the entered range of Periods are purged. Completed CVRs cannot be purged if they are potentially required for CVR (BPF) Enquiries and Reports; you therefore cannot select a To Period later than the last period of the previous Financial Year. Contract completion validation is run at the stage of processing CVRs.

Once the Next button is clicked for this field, the following warning message appears: "Do you really want to proceed with permanent deletion?" If Yes, processing permanently removes the selected CVRs. If No, processing does not continue.

A sample of the Purge CVRs report that is generated is shown in Purge CVRs Report Sample.

CVR Browse Views previously could only be filtered and sorted using source table fields (e.g., Cost Code Section, WBS Code, etc.). You can also filter and sort by CVR Items (for example, to show Cost Codes with forecast revenue > $100K).

The CV/ITEMFILT parameter lets you decide whether to allow CVR Items to be filtered and sorted.

CV/ITEMFILT - Allow Filtering and Sorting on CVR Items?

Whether to allow Filtering and Sorting on CVR Items.

To set up a list of CVR Items, use CVR Models.

Two fields, List of Items for Enhanced Filtering and List of Items for Enhanced Sorting, appear on the Setup > CVR Models > Details tab if parameter CV/ITEMFILT is set to Y.

Enhanced Filtering/Sorting Fields

List of Items for Enhanced Filtering

Use this field to enter up to 10 CVR Item codes.

List of Items for Enhanced Sorting

Since the information in this field directly corresponds with the information in the List of Items for Enhanced Filtering field, it is automatically filled in when CVR Item codes are entered in that field. It is therefore a View only field.

A Sort field is found on the Setup > CVR Models > Fields tab.

Sort Field

Each time a new CVR is created, new fields cvs_filt_items, cvs_filt_map are populated from the cmh_filt_items and cmh_filt_map fields in CVR Models. You cannot change these fields after the CVR is saved if parameter CV/ITEMFILT is set to Y.