CBX 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

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

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)

 

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