CBX Query: Q-ARU Detail Stats

The ARU Detail Statistics tool uses IBM Query to produce a display showing all member activity using CU*TALK Audio Response. This Query produces a detailed list showing each individual member call. SEE ALSO: Online Banking Statistics

I am working with a Query report that uses the AUDICC file. What are the values in the CCTYPE field that shows the type of connection (i.e. Phone, Spanish, English)

Specifications

File(s) used by this Query: AUDICC, MASTER

Access: Tool #137 ARU Detail Stats (AUDICC)

The list will be sorted in descending order by date, with subtotals for each date by Input Type:

 P CU*TALK Audio Response (Phone)

Sample Conditions

Following are some sample conditions which could be used when running the ARU Detail Stats Query:

Description

Field

Test

Value

Display only activity for March 9, 2000

A.CCDATE

EQ

'2000-03-09'

Display calls that lasted longer than 5 minutes

MINUTE

GT

5.00

 

Displays only members listing to audio response in Spanish (not available for online banking statistics)

A:CCLOGT

EQ

‘S’

 

 

 

 

For complete instructions on navigating the “Display Report” screen and using the available buttons, see Displaying a Custom Report as an Online Inquiry.