Deposit Reports > Deposit Reports - Numerical Order

Availability

This report should be run daily in the afterhours.

Purpose

The File Maintenance Journal lists all file maintenance performed on each account for the processing day. It will sort by account number only and will have no totals.

There are several options that may be used to limit this report. The options allow you to specify the report to include only retirement accounts, employee accounts, or 1180 transactions, or you can skip teller #9999. This report can also be used to report stop payments that have been dropped from accounts. If you want to use any of these options, send in a work order with your request.

A miscellaneous parameter is available that will run a report called "New Account Audit Report" (FPSDR015). This report will show the file maintenance for the day for new and unopened accounts only. The name and address information will also be included. This report also has an option that will allow you to report daily activity for a specified time period since the date opened (up to 999 days). Only accounts with activity during the specified time frame will show up on the report. For example, if the parameter is “30,” then all file maintenance will be reported daily for any accounts opened in the last 30 days.

A report option to show only file maintenance done by GOLDPoint Systems employees is available.

GOLDPoint Systems Only: To set up the New Account Audit Report, positions 1-3 of the Misc Parm field must contain the number of days to report new accounts. If this option is used, the input records must be TG, DM, and MN.

To set up the retirement accounts file maintenance report, set Misc Opts 1 to "Y." This option can also utilize the employee file maintenance option; however, it cannot utilize the new accounts file maintenance option.

To set up the employee accounts file maintenance report, set Misc Opts 2 to "Y." This option can also utilize the new accounts file maintenance option.

To set up the skip teller #9999 file maintenance report, set Misc Opts 3 to "Y."

To set up the 1180 transactions file maintenance report, set Misc Opts 4 to "Y."

To set up a report of stop payments that are dropping, set Misc Opts 5 to "Y."

To report only file maintenance done by GOLDPoint Systems employees, set Misc Opts 6 to "Y."

Report Column Information

See FPSDR015 Example for an example of this report.

Column

Description

Account Number

This column displays the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account.

Tran Code & MD

This column displays the transaction code used to run this transaction. If a modifier was used, it is also displayed in this column as TTTT MM, where TTTT is the tran code and MM is the modifier.

Ovr

This column displays the transaction override level, if one was used on this transaction. These levels are:

TOV	Teller override
SOV	Supervisor override
OOV	Officer override

Teller/Emp Number

This column displays the teller ID number of the employee who performed this transaction. If an asterisk is displayed, an GOLDPoint Systems employee processed this transaction.

Terminal ID

This column displays the identification number of the terminal where this transaction was entered.

Tran Time

This column displays the time that the transaction took place in HH.MM.SS format, where HH is the hour, MM is the minute and SS is the second.

Field Name

This column displays the mnemonic for the field that was changed by this transaction. Several field names may be listed in this column for one transaction since several fields may be changed at one time.

If the mnemonic shown in the Field Name column on this line is one of several possible fields of that type, such as one of the 12 possible hold codes, this column will contain the number of the field that was changed. For example, if the field that was changed was hold code 3, the mnemonic for the hold code field will appear in the Field Namecolumn, and 3 will appear in this column to indicate that hold code 3 was changed.

This field may appear several times on one transaction since several fields may be changed at one time.

Field Description

This is the field description of the field that changed. Only 15 spaces are available in this column, so descriptions may be truncated. If several fields are changed in one transaction, this field will appear for each of the changed fields.

Previous Data

This is the data found in the field prior to the change. If this column is blank, the field was empty prior to this change. If several fields are changed in one transaction, data will appear for each of the changed fields.

Current Data

This is the data found in this field after the change was made, or the current data in the column. If several fields are changed in one transaction, this field will appear for each of the changed fields.

File Maintenance Journal/New Account Audit Report (FPSDR015)

File Maintenance Journal/New Account Audit Report (FPSDR015)