...
When submitting a Price Data Strategy for the Demand phase, it inserts records into the RULESDBO.PRICE_RULE_SECURITIES and RULESDBO.RDC_PRICE_STATUS tables. The records from the RULESDBO.RDC_PRICE_STATUS table are shown in the Vendor Prices Summary Screen view. The records from the RULESDBO.PRICE_RULE_SECURITIES table are shown in the Gold Copy Prices Summary Screen view.
The RDC_PRICE_STATUS table contains information on the price validation status for all securities. After creating demand, records are inserted into this table with a status of '0'. A list of all values, along with their corresponding descriptions is provided below:
...
Once the list of securities is determined, the security data is converted into a vendor required format, and a requestor file is created. These requestor files include security details such as the Primary Asset ID, Base Currency, and Exchange. They are then typically sent out to the respective vendors at a scheduled time. After requesting files from a vendor, the final validation status is modified to ‘6-Securities Requested’ in the RDC_PRICE_STATUS table.
Vendor Response
...
Prices are then loaded to both the SECURITYDBO.PRICE_EXCHANGE and RULESDBO.RDC_PRICE_STATUS tables. The PRICE_EXCHANGE table is an intermediary table, referred to as such because these prices are not final Gold Copy prices that would be used for accounting/valuation and the prices by various types across multiple vendors reside here. After files are loaded from the vendor, the final validation status is modified to ‘5-Price Received not validated’ in the RDC_PRICE_STATUS table.
| Info |
|---|
Prices only load to the RDC_PRICE_STATUS table if demand had been generated Within EagleML, there is a flag required to route to the RDC process defined as useRdcPricing which must be set to Y on the record or a global value W_USE_RDC_PRICING that may be set as part of the system configuration. Global parameters should be specified in the /eagle_ml-2-0_custom_cm/w_config_custom.inc. |
...
Based on Data Strategy release logic and the results of the individual test, the RDC_PRICE_STATUS.FINAL_VALIDATION value updates. This result determines whether the price record has a proper value to composite, if it is the highest record in the hierarchy. The system value for this column joins to the RULESDBO.PRICE_EDIT table to display the description such as Released to determine whether it should be composited.
...