Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 28 Next »

In the Reference Data Center Prices Summary window, you can view pricing data by:

  • Date Type
  • Source
  • View Data By

Date Type. The Date type field default to the effective date. This is the date on which the records will be viewed. You can also choose the Process date.

Source. The Source field defaults to All Sources. This displays all sources with data for the view that you have elected that the business group that you have access to.

View data By. This field defaults to vendor prices. This is the summary view of vendor price records. Additional views are vendor exceptions, gold prices, and gold exceptions.

The Summary Window

In addition to the default fields that display by default in the Summary window, you can elect to add additional fields to assist you with identifying additional securities. You choose these fields from a drop-down list that displays under columns.

To select additional fields to display:

  1. Click the 

View Vendor Prices or Gold Copy Records

In the prices summary window you can view vendor level records from the RULESDBO_PRICE.STATUS table. This is the table where gold copy prices are managed, scrubbed and displayed from. In the Summary view, you can also view vendor level records from the RULES_DBO.PRICE_RULESECURITIES table. This is the table where gold level prices are managed, scrubbed and displayed from. 

To View Vendor Prices or Gold Copy Records:

  1. In the Reference Desk workspace,click Prices in the left navigation.
    You see the Prices workspace.
  2. In the View Data By Drop Down, select Vendor Prices.
  3. The Effective Date defaults to today's date. 
  4. Complete the search criteria and click the Search button.
  5. Click Search.
    All records matching your search criteria display.






View Vendor Exceptions

This view displays vendor exceptions from the RULESDBO.PRICE_VALIDATION_STATUS_DETAIL table.  This is the table where validation results and details are stored after validation tests are applied by a validation rule.  Once an exception record is highlighted by a customer the lower pane populates with the price records that this exception applies to.





  • No labels