At-Risk Transactions Report (FPSDR171) |
  
|
Navigation: Deposit Reports > Deposit Reports - Numerical Order >
At-Risk Transactions Report (FPSDR171) |
|
Availability
This report should run daily in the afterhours.
Purpose
The At-Risk Transactions Report prints all check deposit or deposit correction transactions for which the check-in amount is greater than the uncollected funds hold amount, and the check-in amount is equal to or greater than the limit amount specified in the report setup. The default check-in limit amount is $0.00, which will allow all check-in transactions that meet the other criteria to be reported. You can specify the check-in limit setup to be used by your institution.
This report is sorted and subtotaled by Social Security number (or federal identification number). For transactions with no Social Security number (or federal identification number) available, the subtotaling will not be done and the transaction information will be placed at the beginning of the report.
|
GOLDPoint Systems Only: The report setup must include the following:
Input records are: DM, MN, TG.
Misc Parm: This field contains the transaction limit amount. Only transactions equal to or greater than this amount will be considered on the report. The amount must start in column 1 and end in column 14, with the amount right justified and with leading zeroes. Do not enter any punctuation.
Critical must be set at 1 to 4.
Subprog Cntrls Print = Y. |
|---|
Report Column Information
See FPSDR171 Example for an example of this report.
Column |
Description |
|---|---|
SS Number |
This column displays the social security number (or federal identification number) (MNSSFI) of the person or organization making the check-in transactions. This number is associated with the IRS owner of the account. |
Short Name |
This column displays the name (MNSNAM) of the person or organization whose Social Security number (or federal identification number) appears on this line of the report. If no name is found, N/A NOT AVAILABLE will appear in this field. |
Account Number |
This column displays the account number (DMACTO, DMACTA, DMCKDG) for the account associated with the check-in transaction. |
Date Opened |
This column displays the date (DMDTOP) the account was opened. |
Average Balance |
This column displays the average balance (DMAVBL) of the account for the current statement cycle. If asterisks appear in this field, the account was either closed and re-opened or the Do Not Calculate APY field (DMNAPY) was set to Y when this report processed for this account. The correct average balance can not be calculated in this case. |
Current Balance |
This column displays the current balance (DMCRBL) of the account. |
Excp LTD |
This column displays the number of times non-sufficient and uncollected funds exceptions (ECEXCL) have occurred since GOLD ExceptionManager was implemented for the institution. |
Draws on UCF |
This column displays the number of times draws on uncollected funds (DMDUFC) were made during the current cycle for this account. |
UCF Today |
This column displays the amount of uncollected funds for today for this account as of the time this transaction took place. |
Check In |
This column displays the check-in amount for this transaction. |
Tran Amount |
This column displays the transaction amount for this transaction. |
Totals and Subtotals Provided
Only subtotals for each Social Security number (or federal identification number) are provided on this report. The subtotals are included for everything to the left of the date opened column. Subtotals are not provided for blank Social Security numbers (or federal identification numbers).
