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
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.
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.
Buttons
|
Field |
Description |
|
Exclude Sys Processes (F14) |
Use this to exclude system-generated changes. |
|
Who Made the Change (F11) |
Use this to view additional fields such as user, program, and workstation ID. This will bring you to the File Maintenance Inquiry - Who/What Made the Change screen. |
|
Clear Filter (F18) |
Use this to remove current filters and return to including all changes. |
|
Export (F9) |
Use this to export complete dashboard information to a file for use in CU*BASE Report Builder (Query). |
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.
|
|
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. |