Deposit Reports > Deposit Reports - Numerical Order

Availability

These reports should be run daily in the afterhours.

Purpose

The Employee/Officer Code Reject Handler Reports can print reject records from the Reject Handler for employee accounts and accounts with an officer code. (This is when Employee Account? = “Y” (DMDEMP) on the Deposit Additional Fields screen (Application 4, function 3/4) and Account Representative Code and Name ≠ “0” (DMOFCD) on the Miscellaneous Fields screen (Application 4, function 37/38).)

The Employee/Officer Code Reject Handler Reports can also print reject records for employee accounts only. (This is when Employee Account? = “Y” (DMDEMP) on the Deposit Additional Fields screen (Application 4, function 3/4).)

These reports are similar to the Reject Handler Report (FPSDR067).

These reports are sorted by Reject Handler sequence number only, though the user may set up the reports to sort (not total) by the following fields:

80 Tran/Mod/Torc

81 Account Number

82 Primary Reject Reason

83 Secondary Reject Reason

84 Reject Date

Miscellaneous option 1 in the report setup may be used to report only employee accounts (when DMDEMP = “Y” on the Deposit Additional Fields screen (Application 4, function 3/4)).

Miscellaneous option 2 in the report setup may be used to discard inclearing items that are not rejected from being displayed on this report.

	GOLDPoint Systems Only: These reports can be run one time per day.

Report Column Information

See FPSDR132 Example for an example of this report.

Column Heading	Description
Sequence Number	This is the sequence from the Reject Handler record.
Account Number	This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account.
IRS Owner Name	This is the full name of the IRS owner of the account in last-first- middle format.
Transaction Amount	This is the amount of the transaction that was rejected.
Tcod	Deposit System transaction code that was rejected for this transaction.
Md	This is the transaction modifier code (if any) that is part of this transaction.
Torc	This is the Transaction Origination Code for the transaction.
Primary Reject Reason	This is the reason why the transaction was placed in the Reject Handler files.
Secondary Reject Reason	This is an additional reason why the transaction was placed in the Reject Handler. This is usually to clarify the Primary Reason.

In addition to the main information, there are 6 other lines of data for each reject item, arranged in 4 columns across the report, each item with its own description. Information arranged this way is:

Column 1

Reject Status

Date Account Opened

Date of Last Transaction

Date Account Last Went Negative

Home Phone Number

Work Phone Number

Column 2

Payable Balance at Time of Transaction

Available Balance (Includes Overdraft Available)

Current Balance

Uncollected Funds

Monetary Holds

Over-the-Counter Holds

Column 3

Reference Number

Trace Number

Originator Number or ATM Switch Date and Time

Number of Returned Items Year-to-Date

Number of Overdrafts Year-to-Date

Column 4

Account Type

Statement Cycle

Product Code

Overdraft Types (all 5)

Officer Code

Employee Account Indicator

Hold/Action Codes

When the report includes an ATM transaction, the switch date and time will replace and be displayed in the Originator # field.

Totals and Subtotals Provided

These reports are always subtotaled by transaction code for the number of each transaction code, total amount of all transactions, total amount posted to accounts, total amount rejected, total amount returned, and the total service fee charged. Final totals are displayed for all transactions.

Employee/Officer Code Reject Handler Reports (FPSDR132)

Employee/Officer Code Reject Handler Reports (FPSDR132)