Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Rate Offset Report (FPSDR115)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Rate Offset Report (FPSDR115)

Previous pageReturn to chapter overviewNext page  Print this Topic

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.

©2021 GOLDPoint Systems. All rights reserved.