File Maintenance Inquiry

Screen ID:  ICUFMNT-01
Screen Title: File Maintenance Inquiry - What Was Changed
Panel ID: 165
Tool Number: 159
    Click here to magnify

Access this screen by selecting Tool #159: Audit CU File Maintenance (CUFMAINT) (Shortcut: cufmaint).

Helpful Resources

Visit Show Me the Steps for easy instructions on how to use CU*BASE to research maintenance on a corporate check or money order and complete other head teller-related tasks.

Screen Overview

This screen is used to monitor file maintenance activity made by various programs throughout the CU*BASE system. Data from the CUFMAINT file is displayed with the most current activity at the top.

  • The CUFMAINT file includes data from the CUFMNT file, as well as additional data not included in CUFMAINT.   Starting with the 17.10 release (October 22 for online clients) this dashboard will include the data of the CUFMAINT file for one month.  Each month, an additional month's data is added until a rolling six months of data is available.  

  • Attention auditors: This tool and the printed File Maintenance report (Tool #644) will include data for the entire month the release is implemented (October 2017 for online clients.  However, for reviewing data prior to the release date, continue to use Query or the Daily LELOG report.  (The dashboard and printed report are not designed to be used with data prior to the release since they use the new file format.) 

  • This report can be used in conjunction with the printed File Maintenance report and the CU*Spy End-of-Day Maintenance Log CUFMNT Version Report (LELOG2).

  • NOTE: Changes to Employee Security, such as password changes or access to tools is not recorded in CUFMAINT. To view these changes to the SECMAINT file which records these changes, refer to the online or printed report with filters to view data in this file.

  • NOTE:  If you are searching for the program UMBRSHIP, look for UCMAST, as changes to this program are written as UMCAST in CUFMAINT.  This is due to the fact that nightly maintenance needs the changes to be in CUFMAINT under UCMAST.

Critical Monitoring

Use the Select buttons next to Program, File, and Field to filter the dashboard to filter to show only certain programs, files, or programs.  When you use these buttons on this Inquiry, you’ll access a Selection screen and will see a CRITIC indicator that will note the programs, fields, and file names that AuditLink has flagged as “critical” for your auditing team to monitor on a daily basis. You can quickly sort by that indicator and select only those items, for a quick scan of that maintenance that directly affects member accounts.

  • Viewing only critical items: While on the Selection screen filter on the final column to make the CRITIC items sort to the top.  Then select only these items to view only critical changes on the dashboard.

  • A note about the “Field” search option: Remember that the same type of data might have a different field name depending on what file it is in. For example, most files use the field name ACCTBS for account base, but there are some files that use a different name for the account base field. Conversely, the same field name might be used in multiple files but mean something very different for each file.

  • This Answer Book Item includes a listing of all critical programs, tables, and columns.

Filtering

You can filter this screen to view only items in a date range, for a specific account. Use the multiple Select buttons to view only specific programs, table/files, column/fields, or Employee IDs.

  • When filtering for program, table, or columns, disregard the selections beginning with "CRUD."

  • To clear your filters use the Clear filter (F20) button.

Buttons

Exclude System-Generated Changes

To exclude system changes use Exclude Sys Processes (F14).

Include Only Work Done by Credit Union Employees/Exclude Changes Made by Data Center Employees

To include only work done by a credit union employee and exclude changes made by data center employees, click the Select button next to Emp ID.  Then use the Select All button.  Scroll to the end of the listing and deselect Employee IDs greater than 89.  (Do this by holding down your Ctrl key on your keyboard and individually selecting each Employee ID to deselect it.  Employee ID 96 (online banking, which also includes Audio Response) can be include or excluded as desired.  Then use Select to return to the dashboard.

Also use Excl Sys Processes (F14) if you also want to exclude maintenance done by the System.

To return to include all changes use Clear Filer (F18)

Tell Who Made the Change

Use the Who made the change (F11) button to view additional fields such as user, program, and workstation ID.

What happens if a manual freeze is placed on an account?

You can to select to place a manual freeze (1-3) on a loan and remove the account from having its freeze code from being changed by delinquency monitoring.  Learn more about placing a manual freeze on a loan.  In this case, in addition to the freeze code change, a FRZIND code change will also be recorded. 

Field Descriptions

Field

Description

Date/Time

The date on which the change was made.

Time

The time the change was made.

ID

The Employee ID that was used to make the change.

Account

The account base, if applicable. The format of the data in this field may vary depending on the program that was used to make the change.

Type

The account suffix, if applicable.

Table/File

This column shows the data file name that was changed.

Column/Field

The column/ field name that was affected by the change.

  • Remember that the same type of data might have a different field name depending on what file it is in. For example, most files use the field name ACCTBS for account base, but there are some files that use a different name for the account base field. Conversely, the same field name might be used in multiple files but mean something very different for each file.

Change Made (Before / After)

The actual field contents both before (top) and after (bottom) the change was made.

Misc Infor

This field includes miscellaneous information and is generally blank.