Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Availability
This report can be run on any day of the week for a week. Contact your customer service representative to schedule this report.
Purpose
The Rate Offset Report prints accounts that meet the following criteria. The account must be open, the rate offset must be greater than or equal to .01. If no options are set, the report will only print accounts that were either opened six days before the run date or if the last maturity roll date (DMCMRD) is within six days of the run date. The run date is included and considered the seventh day. If miscellaneous option 1 is set to "yes," available accounts (unopened accounts opened in the past week) will be reported. If option 2 is set to "yes," all new accounts regardless of rate offset will be reported. If option 3 is set to "yes," all accounts with rate offsets regardless of dates will be reported. Set this option to audit all opened accounts with rate offsets.
Report Column Information
See FPSDR115 Example for an example of this report.
Column Heading |
Description |
---|---|
Account Number |
This is the office number (DMACTO) and check digit (DMCKDG) for the account. |
Name |
This is the IRS owner's name as listed on the account. |
Prod Code |
This is the product code taken from the Product Code field (DMPDCD) on the CIM GOLD Customer Profile screen, Platform tab. |
Term |
This is the maturity term taken from the Term field (DMCTRM) on the CIM GOLD Deposits > Account Informatiion > Account Information screen, Features/Options tab. |
Date Opened |
This is the date opened taken from the Date Opened (DMDTOP) field on the CIM GOLD Deposits > Account Informatiion > Account Information screen, Account Information tab. |
Last Mat Roll Dat |
This is the last maturity roll date taken from the Last Maturity Date field (DMLMRD) on the CIM GOLD Deposits > Account Informatiion > Account Information screen, Features/Options tab. |
Current Balance |
This is the account current balance, taken from the Current Balance field (DMCRBL) on the CIM GOLD Deposits > Account Informatiion > Account Information screen, Account Information tab. |
Int Rate |
This is the interest rate taken from the Rate field (DMRATE) on the Deposit Interest Fields screen (Deposits > Account Informatiion > Account Information screen, Features/Options tab). |
Rate Offset |
This is the rate offset taken from the Rate Offset field (DMROFF) on the CIM GOLD (Deposits > Interest Fields screen, Interest Fields tab). |
Minimum Rate |
This is the minimum interest rate taken from the Miminum Rate field (DMRTMN) on the Deposits > Interest Fields screen, Interest Fields tab. The minimum rate will override any interest rate calculated in the afterhours that exceeds the minimum rate limit. |
Maximum Rate |
This is the maximum interest rate taken from the Maximum Rate field (DMRTMX) on the Deposits > Interest Fields screen, Interest Fields tab. The maximum rate will override any interest rate calculated in the afterhours that exceeds the maximum rate limit. |
Invalid
Any account that does not have a date opened will show "invalid" to the right of Rate Offset or show an invalid date.