CU*BASE Query: Online Banking Statistics

The Online Banking Detail Statistics tool uses IBM Query to produce a display showing all member activity using online banking. SEE ALSO: ARU Statistics

SEE ALSO: Audio Response/Online Banking Statistical Dashboard

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. online banking)

Specifications

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

Access: Tool #565: Online Banking Detail Stats (AUDICC)

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

An "I" is entered for the canned Query to show only Online Banking via Internet access

  • NOTE:  IP addresses is included in the file, but this information is not shown if the member has "Jumped" to the account from another account using the Jump feature.

Sample Conditions

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

Description

Field

Test

Value

Display only activity for March 9, 2013

 

A.CCDATE

EQ

20130309

CCYYMMDD

Display mobile banking visits by day with totals.

 

 

To add for a single member

 

 

(A total count will be shown beneath each day.)

 

 

 

To

A.CCTYPE

AND

A.CCLOGT

 

AND
A.CCBSAC

EQ

 

EQ

 

EQ

‘I’

 

‘W’

 

xxxxxxxxx

(account base)

 

Clickherefor complete instructions on navigating around the “Display Report” screen or using the available buttons.