In a telecommunication service creation environment providing for call processing records and value tables, the value tables comprising one or more columns and one or more rows of values, a method of creating a call processing procedure to retrieve a value from the value table for call processing, the method comprising the steps, executed by a data processor, of:
- prompting an operator to name a value table to be searched;
- receiving from the operator a name of the value table to be searched;
- prompting an operator to identify one or more columns in the value table to be searched;
- receiving from the operator an identification of one or more columns in the value table to be searched;
- prompting an operator to specify a value to be searched for in the one or more columns to be searched;
- receiving from the operator a value to be searched for in the one or more columns to be searched;
- prompting an operator to specify comparison criteria for the value specified and values to be retrieved from the one or more columns to be searched
- receiving from the operator a comparison criteria for the value specified and values to be retrieved from the one or more columns to be searched;
- prompting an operator to specify one or more call variable names to which one or more of the retrieved values should be assigned;
- receiving from the operator one or more call variable names to which one or more of the retrieved values should be assigned;
- and
- instantiating the table name, one or more columns, one or more values to be searched for, comparison criteria, and one or more call variables as part of the call processing procedure.