Data Models‎ > ‎

Order Management, Billing, Multi-Rates Pricing

Sybase PowerDesigner, Oracle 8i 


Although it does not appear to be too involved, this was a very complicated data model. The primary structure is price schedule, price schedule detail and rates. However, the complexity is primarily due to the flexibility required for each price schedule. Price schedule attributes define setup and billing details, the number of rates and purpose. The data model supports unlimited attributes, rates, and rate attributes.

In addition, the database supports the definitions required for the Siebel Order Manageement web service. This web service received the Siebel XML Order Pricing request, parsed the XML, formatted Oracle stored procedure calls, called the underlying Oracle rates pricing stored procedure, and repackage the results in the return XML document. This web service supported multiple parallel operations and is still in use today.