Change Performance Status and Maintain Data

The Commit Journal provides powerful tools that allow you to change return status or drill down and work with the underlying performance calculation data of any view to which you have access rights.

Change Status of Performance Data

The Commit Journal allows you to manually change the return status of committed performance data. Your ability to approve or disapprove returns is granted in PACE User Security. With the appropriate privileges, you can assign performance data a status of:

  • Preliminary. Data can be recalculated.
  • Final. Data is locked down and cannot be recalculated. Setting the status to final means the return is approved.
  • Custom. You can track additional performance statuses that occur after Preliminary and before Final, if they have been made available in PACE.

You can change the status assignment of a single entity or multiple entities.

Change Status of a Single Entity

A single entity is considered to be the combination of an entity and a period start date. If you change the status of one instance of an entity and start date, all instances will be changed.

To change the status of a single entity:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Right click a row to see the Status options available. Options include Preliminary or Final, as well as any custom statuses.
  4. Select a Status option.
    You see a message confirming the change and the view reflects the new status for the selected entity.
Content on this page:

Change Status of Multiple Entities with Approval Wizard

The Approval Wizard allows you change the status of more than one entity across a date range that you specify. The entities selected must have the same status. You can also use the Approval Wizard for a single entity when you wish to enter a comment or choose a specific date range. 

If you have a view displayed, the view criteria do not affect the Approval Wizard settings.

To change the status of multiple entities:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Click the Approval Wizard icon on the ribbon.
    You see the Approval Wizard dialog box.
  4. Click the Change Status drop down and select a status.
    Options include:
    –  Preliminary
    –  Final
    –  Custom (if available)
  5. Enter a Comment to describe the reason for changing the performance status, if necessary.
  6. Select Entities by using the Entity Selector.
  7. Click the Effective Date drop down and select a date type.
    Options include:
    –  Date Range. There are two calendars for setting the begin and end dates. The default is Current Date.
    –  From the Date Rule. The date rule derives the effective dates to be retrieved by the report. The date rule is helpful for rolling updates that occur on a regular basis (such as current day or current month).
  8. If you selected Date Range, enter the begin and end dates.
  9. If you selected Date Rule, click the lookup icon to see a list of available rules. Or, you can click the ellipsis to open a search dialog box. After selecting the rule enter an As Of date.
  10. Select Frequency.
  11. Click OK.
    You see a message confirming that the status has been changed for the performance results of the given criteria.
  12. Click OK.
    You see the view updated with the new status.

Create Status Audit Journal

The Status Audit Journal allows you to create a customized audit trail that records the history of a return status for particular funds, dates, and frequencies. After creating a Status Audit Journal you can view the contents in a later session and track any changes that had been made.

To create a status audit journal:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Click Status Audit Journal on the ribbon.
    You see the Status Audit Journal open in a new tab and a Status Audit Journal Criteria dialog box.
  4. Select Entities by using the Entity Selector.
    You can select any entity to which you have access. The default is the entity of the row selected.
  5. Click the Effective Date drop down and select a date type.
    Options include:
    –  Date Range. There are two calendars for setting the begin and end dates. The default is Current Date.
    –  From the Date Rule. The date rule derives the effective dates to be retrieved by the report. The date rule is helpful for rolling updates that occur on a regular basis (such as current day or current month).
  6. If you selected Date Range, enter the begin and end dates.
  7. If you selected Date Rule, click the lookup icon to see a list of available rules. Or, you can click the ellipsis to open a search dialog box. After selecting the rule enter an As Of date.
  8. Select Frequency.
  9. Click OK.
    You see the Status Audit Journal populated with records of any status activity for the selected entity, dates, and frequencies.

View/Download Calculation Results

The View/Download Calculation Results feature allows you see the Performance Returns report results for auditing and maintenance of report profile entities. You can drill down into the underlying data and run diagnostic queries. With the appropriate privileges you can then edit the data. You can also export the results to Excel.

The following are the options for View/Download:

  • Calculation Results. Opens the underlying performance calculation report results for auditing and maintenance of all entities associated with that report.
  • Calculation Results For This Entity. Opens the underlying performance calculation data for auditing and maintenance for only that entity in the row.

To view/download results for all entities in a view:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Click the View/Download icon on the ribbon and then select Calculation Results.
    You see the underlying performance calculation results with tabs for details of Report, Diagnostics, Cash Activity, Price, Analytics, Position Cross Reference, Security Cross Reference, Performance, Ratings, and Details.
  4. You can print, export to Excel, or email the results by clicking the appropriate icon on the ribbon.

To view/download results for a single entity:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Select a single entity.
  4. Click the View/Download icon on the ribbon and then select Calculation Results for This Entity.
    You see the underlying performance calculation results with tabs for details of Report, Diagnostics, Cash Activity, Price, Analytics, Position Cross Reference, Security Cross Reference, Performance, Ratings, and Details.
  5. You can print, export to Excel, or email the results by clicking the appropriate icon on the ribbon.

View Application Server Log

You can view the Application Server log of operations recorded for your current session.

To view the application server log:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Click the Appserver Log icon on the ribbon.
    You see the PACE Application Server Log dialog box displaying application server details and file contents.
  4. Click View Complete File to see the entire contents of the file.
    You see the file open in a Notepad window which allows you to save or print the file.

Edit Performance Returns

You can edit or scrub underlying data if you have the appropriate privileges to perform data maintenance.

When you edit performance returns a new or replacement record is inserted into the database, but the original source data is not changed. The scrubbed record is an image of the original and is tagged with a different source interface instance. If you enter a new value for a performance return, you must run the Client Side Commit process to save the new value. For more information, see Client Side Commit.

To edit underlying data:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Click View/Download on the ribbon and then select Calculation Results or Calculation Results for This Entity.
    You see the underlying performance calculation results.
  4. Select a cell you wish to change and right click to view the editing options.
    Options include:
    –  Add Security Position
    –  Edit Security Position
    –  Edit Performance Returns
    –  Performance Returns Maintenance Journal
    –  Go to Cash Activity Maintenance
  5. To add a security position select Add Security Position.
    You see the Add Security Position dialog box.
  6. Enter security and other data in the appropriate fields as needed.
  7. To edit a security position select Edit Security Position.
    You see the Edit Security Position dialog box.
  8. Select a security and make changes to the appropriate fields as needed.
  9. To make changes to an existing value select Edit Performance Returns.
    You see the Edit dialog box showing the Existing Value and a blank field for New Value.
  10. Enter a New Value.
  11. Click Save.
    You see the changes in the cell, which is now highlighted to show that it has been changed.

Client Side Commit

The Client Side Commit process allows you to manually commit changed performance calculation results to the database.

To manually commit results:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Click View/Download on the ribbon and then select Calculation Results or Calculation Results for This Entity.
    You see the underlying performance calculation results.
  4. Edit underlying data as needed. See "Edit Performance Returns."
  5. Click Client Side Commit on the ribbon. Or, right click and select Client Side Commit.
    You see the Commit Options dialog box.
  6. Select one or more Entities by using the Entity Selector.
  7. Select whether you wish to calculate to-date returns, Yes or No.
  8. If you selected Yes, specify the returns you wish to commit.
    Options include:
    –  Year End
    –  Quarter End
    –  Month End
    –  I would like to use the Business Calendar for this option.
  9. Select Additional Options as necessary.
  10. Select the Commit Source.
  11. Click Publish.
    You see a message confirming the action.

Resubmit Performance Calculation

After you make changes or additions to Performance returns, you must resubmit the Performance Calculation report in order for the scrubbed records to be picked up.

To resubmit a performance calculation:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click Submit View on the ribbon. Or, double click the view.
    You see the selected view in the workspace.
  3. Select the row you want to submit.
  4. Select Submit Calculation on the ribbon.
    You see a message confirming that the report was submitted successfully.

Resubmit Calculation with Override

The Submit Calculation with Override option allows you to resubmit performance calculation data with different parameters without first needing to download return results. You can enter values that temporarily override the options associated with the report profile and its assigned report rule. You can select dates and entities, report rule, field rule, benchmarks, and commit options.

The fields on the Submit with Override dialog box are optional. You only need to change those fields that are appropriate.

To resubmit with override:

  1. From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
    You see the Commit Journal workspace displaying a list of available views in the right navigation.
  2. Select a view and click the Submit View icon on the ribbon.
    You see the selected view in the workspace.
  3. Click the Submit Calculation with Override icon on the ribbon.
    You see the Submit with Override dialog box with options to select dates and entities.
  4. Select an Effective Date option and enter a date or date range as appropriate.
  5. If you wish to override the server log level, select a number from 1 to 6.
  6. Specify an Entity by using the Entity Selector and then select Additional Options.
    Options include:
    –  Use Entity History (default)
    –  Auto Add Benchmarks
  7. Click the Generate Eagle Eye output check box to run EagleEye Analysis.
  8. Click the Select Commit Options tab and check whether you wish to commit the returns on the server side, Yes or No and then select how you wish the returns to be committed.
    Options include:
    –  Preliminary
    –  Final
    –  Only if With-in Tolerance
  9. Select the Only When Materially Different check box to commit returns only when a value has changed.
  10. Select an Alternate Commit Source from the drop down.
  11. Select a Security Commit Option.
    Options include:
    –  None
    –  Rollup Relations with Security Level (default)
    –  Rollup Relations only
  12. Select a Commit Source from the drop down and then click OK.
    You see a message confirming that the report was submitted successfully.