Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Reference Data Center Pricing tool enables you to view pricing data by data type, by sources and by designation.

...

Filter fields available are controlled by RDC system setting 1038 (Client: Fields to display in pricing summary screen (view by vendor)) and RDC system setting 1037 (Client: Fields to display in pricing summary screen (view by gold copy).  Any fields from the SECURITYDBO schema can be added to the default fields in this setting to assist with targeting specific data sets.  You can then elect which of these filter fields to display using the green plus sign to the right of the filter fields.  The filter fields and pre-set values for each can be saved for an individual’s profile for queries the person will use often.

...


View Data by Vendor Prices

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 data by Vendor Prices

  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. 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.

View Gold Copy Exceptions

View Gold Copy Prices

...