DB Update

This operation updates a single field in one database record.  For example, you might create a menu that allows callers to update survey information in a database (1=agree, 2=disagree).  Database Update is limited.  It can't do more than replace the contents of a field.  For instance, it cannot add, subtract, increment numeric values, or update a row.

To update a field in a database table, follow these simple steps:

Identify the data source and table name. 

Perform Record Selection, by opening the DB Record Selection dialog to select a record to update.

Identify the Update Action, by opening the Update Column dialog to specify which column (field) will be updated and the data that will be assigned to the field.

Define flow-of-control actions that take place when this menu operation finishes.

Node Characteristics frame

Options in this frame name the node, assign the digit used to select it,  and establish whether or not it is active, used by default, logged, or tracked for reporting purposes.

Name field

The label you enter here becomes the name of the node in the tree structure.

Digit list box

Use this list to select the key that callers press to enter a caller data entry operation.  When you assign a digit, the list displays only available digits—those that are not already in use at this level of the tree.  If no digit is assigned, callers cannot invoke the operation directly.  It is possible to create menu options that are invoked by a routing process, rather than by a user selection.  For details, see invoke a menu operation automatically.

Active check box

By default, forms are "on", or "active", which means that Interaction Attendant will process them.  If you uncheck a form's Active check box, the name of the node turns gray in the tree to indicate that the form is inactive.  Interaction Attendant and its handlers will thereafter ignore the form and its children.  Use this feature to save a configuration that you are testing.  Inactive forms are invisible to callers.  When a node is inactive, it appears grayed out in the tree view.

Default Action check box

At any given "level" in the tree structure, one node can be marked as the default action.  The operation defined by the default node is performed if the caller does not press a key within the timeout period specified by that menu. The icon for default forms has a green border in the tree structure.  Any node below a menu or schedule can be marked as the default action, by checking the form's default action check box.

Enable IVR Reporting

This option determines whether or not reporting data will be collected when control passes through this node.  Several IVR Reports summarize this information.  IVR Reporting is disabled by default.  Enable it to capture the date, time and duration of time that the call remained in the node and its children.  This option is hidden when Attendant is connected to a server that does not have reporting installed.  For more information about this feature, see IVR Reporting Option.

Add entry to the Interaction Log

When this option is enabled, information about this node is appended to the call's Interaction Log when the call enters this node.  This helps track the path that a call took through Attendant.  The Interaction Log is maintained for reporting purposes.  See View the Interaction Log for details.

Configure Speech Recognition... button

Select this button to configure words or phrases that can be associated with menu options. Callers can verbally indicate the options they want in the IVR instead of pressing a digit on the phone. You can enter multiple words and phrases for each menu item, just as callers may phrase the same request in different ways. For example, "transfer funds" or "funds transfer". See Add Speech Recognition keywords or phrases to Inbound Call Operations.

DB Information frame

IC Data Source

Select the name of a database as it is defined in Interaction Administrator.  See IC Data Source Configuration in the Interaction Administrator help to find out data sources are defined for CIC and its subsystems.  Typically, this list contains I3Text White Pages, CIC Contacts, CIC Report Logging, CIC Report Logs, Tracker, and custom databases defined by your organization.

Table Name

Records will be updated in the table whose name you enter here.  If you do not know the names of tables in your database, contact your Database Administrator.

Record Selection button

This button opens the DB Record Selection dialog, so that you can define criteria that Attendant will use to select a database record. 

Update Action button

Opens the Update Column dialog so that you can specify which field that will be updated, and the content that will be assigned to the field.

Action When Finished frame

These options set the processing that occurs after the operation completes successfully, when flow of control leaves the node.  You can return control to the previous menu, disconnect the call, transfer to an operator profile, or jump to any node or action that has been defined for the current server.

Go back to previous menu

This option returns control to the parent menu.  This sets up a simple loop that "reruns" the menu from the top.

Disconnect

This option disconnects the call when the database operation completes successfully.

Transfer to Operator Processing

Transfers the call for evaluation by operator profiles defined for this server.

Jump to a custom location

This option allows you to jump to any profile, schedule, menu, or operation that is defined for the current server.