View Data in Reference Data Center Prices

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

1. Date type defaults to effective date. This is the effective date of the records that will be viewed.  The other option is process date.  This is the date the record was updated last.
2. Source defaults to All Sources. This displays all sources with data for the view the customer has elected that the business group the individual has assigned has access to.
3. View data by defaults to vendor prices. This is the summary view of vendor price records. Additional views are vendor exceptions, gold prices, and gold exceptions.

Filters

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. 

View Data by Vendor Prices 

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.