IDMS Work Log

TREASCD-370 - Getting issue details... STATUS

Change Request | Deposit Date Logic, Bank Requested Deposits

The current deposit date logic is a New Deposit request ‘Deposit Date’ is the current weeks Friday if requested on Monday or Tuesday, otherwise it must be the following weeks Friday date. Treasury would like the following changes to be made to deposit date logic: 

1. Bank users can open deposits on Wednesday from 12:01 AM – 11:59 PM. Bank users cannot open deposits on any other day.

2. A New Deposit requested by a bank will always be the current week’s Friday date. If Friday is a holiday, the deposit date will be the following business day.

Both Portals

Requested: 10/20/2022
Related to: Deposit Date Logic | Bank Portal – 256

10/24/2022

Prioritize this change. 370 will be launched before 5.3.2.

Reviewed by development team, no questions at this time.

TREASCD-283 - Getting issue details... STATUS

Change Request | Bank, Deposit History Tab | Admin Portal

Create a tab under Admin Portal Bank: Deposit History. The tab will include a table of deposit history with the ability to view all history or filter to view a specific date range or status.

Table will default to show ALL history.

Filters:

• Date Range

  • Date filter will show all deposits within the range selected. If a deposit was active during the range selected, it will display in the table.

• Status (dropdown)
  

Search and Export:

• Search field

• EXCEL and PDF export
  

Table Columns:

• Status

• Type

• Deposit Date

• Maturity Date

• Term

• Interest Paid

  • Display the interest paid based on the date range selected or if no date range is selected show interest paid as of the current date.

• Amount

• Rate

• Deposit Number

• Deposit ID (details found in ticket TREASCD-299 - Getting issue details... STATUS )

Total the interest column

Treasury / Admin Portal

This table will allow Treasury to view interest paid within a certain time frame. This table will also allow Treasury to view a specific deposits history without navigating to a date in the main deposits table.

Question (5/27): Does Treasury want to see declined or VOID deposits on this table? If so, what would the values be?

Answer (6/8): Declines and voids are not to be including in the Deposit History. Deposit History will maintain deposits that collect interest. Declined or Voided deposits will not be part of the ACH report.

Declined or void deposits will be housed in the bank event log with dates, interest, and amount values. (TREASCD-125).

User Story:

ABC Bank requested for two new separate deposits on 01/01/2021. Both the deposits were for the same amount and since they were opened on the same day, they also have the same rate. ABC Bank continued to renew both deposits until 09/03/2021 when they decided to retire one of their deposits and renew the other deposit.

As a Treasury user, I am looking at ABC Bank and I want to see what the history was for ABC Bank’s deposits from 01/01/2021 - 10/02/2021. I also want to understand how much interest had been paid from 01/01/2021 - 10/02/2021. By filtering the Bank Deposit History table by 01/01/2021 - 10/02/2021 I am able to see the deposits that were active during those dates and their life by referencing their Deposit ID. I see that we collect $61.00 from 01/01/2021 - 10/02/2021 in interest. I can filter the Deposit ID column to see which renewals are associated with which original deposit when we first funded the monies.

Requested: 05/12/2022

TREASCD-288 - Getting issue details... STATUS

Change Request | Internal Documents, Document Library

Internal Documents, Document Library

Add a checkbox to the Document Library (on the admin side) upload to mark a specific document as ‘private’. All documents that are not marked as ‘private’ will be displayed to Banks in document library.

Treasury can edit a document upload to check or uncheck ‘private’ later.  

Both Portals

Treasury has a document library for Banks currently. Initially this library was not to be shared with Banks. The library now needs to be shared with banks with the ability to mark documents as ‘private’ if they don’t want the banks to see them.

Requested: 05/12/2022

TREASCD-293 - Getting issue details... STATUS

Change Request | Event wording, Renewal Declined

Update event history note ‘Deposit set to Retire' to 'Renewal Declined’. This event should display in the Master, Bank and deposits event log.

Treasury / Admin Portal

This change will clarify an event log entry.

Requested: 05/23/2022

TREASCD-298 - Getting issue details... STATUS

Change Request | Available Deposit Types Section, Dashboard | Treasury Portal

Display the Available Deposit Types section on the Treasury Dashboard. Only display the deposit/term that is selected on Available Deposit Types & Terms (Treasury Admin).

Add section above ‘Deposit Information’ section.

Add ‘Last Rate Update' below the table inside this section.

This section will not have an effective rate picker. A different effective date will confuse the ‘Last Rate Update’ field. If Treasury needs to look at different rates, they will leverage the Rates tab OR the Available Deposit Types and Terms tab.

Treasury / Admin Portal

Relates to 260 and 259.

05/27  Add a dashboard section to display rates Banks can select for Treasury to view without navigating to Admin, Available Deposit Types and Terms.

Treasury wants to move Last Rate Update under this section (outside of the table) because it makes more sense to live here then alone towards the top of the dashboard.

Requested: 05/27/2022

TREASCD-299 - Getting issue details... STATUS

Change Request | Deposit Number

Change the logic that generates the Deposit Number. The deposit number should now be:
FDIC number-Originating deposit number (5 digit)-Sequential number (4 digit)

Originating deposit number: Number is set when the deposit is originally created. The number begins with 00001 and adds one with each newly created NEW deposit.

Sequential number: Number is 0001 when the deposit is originally created. The number adds one per renewal within an originating deposit.

This needs to be retrofit to past deposits.

Treasury / Admin Portal

Relates to 283

Treasury needs to know what original deposit renewals are associated with. We need to assign an identifier to do this.

10/24/2022 - We need to discuss how to number this differently than we have now. Treasury need to be able to tell what deposits are associated with an originating deposit AND what number that renewal the deposit is associated with the originating deposit. Treasury proposes using the ‘Deposit Number’ value to denote the originating deposit (do not change the Deposit Number value with renewals as we do currently) and use the ‘Deposit ID’ to denote what number of renewal the deposit is. Tanner will discuss with development team to ensure we can use the Deposit Number differently and if there are implications.

Development team and Tanner worked on a new deposit number sequence. Treasury needs to review and approve.

10/25/2022 - Treasury agrees with the proposal, removed previous change “Change Request | Deposit ID | Bank, Deposit History Table | Treasury Portal

Add a column to the deposit history called ‘Deposit ID’. This value will be the same for all renewals associated with their initial/originating deposit.”

We discussed the retrofit and Tanner confirmed that the new renewals will have the correct numbering but past agreement numbers will not change.

TREASCD-306 - Getting issue details... STATUS

Change Request | Wording Change, Pools History | Treasury Portal

Treasury wants to change the first (static) entry title from ‘Initial Pool Balance’ to ‘Available Pool Balance’

Treasury / Admin Portal

Reported: 06/22/2022

 Daria mentioned ‘Initial’ may be confusing and ‘Available’ would more clearly represent the entry.

TREASCD-312 - Getting issue details... STATUS

Change Request | Pools History, Active Deposits Balance

Within the Pools History section add an ‘Active Deposits Balance’. The balance will include a calendar picker and a dollar value display. The date chosen on the calendar picker will populate the dollar value with the number of active deposits on the date chosen.

This value will be the same value as the Daily Deposits table Amount column totaled.

Active deposits – Includes deposits with the status of Active, Action Required, and Retire (as opposed to Retired which indicate an inactive deposit or deposit that was previously active).

When exporting the table, include the date range (if chosen) and Active Deposit Balance (if end date is chosen).

Treasury / Admin Portal

 Requested: 06/30/2022

 Treasury needs the ability to view the active deposits on a given date to reconcile with STARS (external application).

TREASCD-334 - Getting issue details... STATUS

Enhancement | Bank Dashboard, ‘Upcoming Maturities’ | Bank Portal

Bank Dashboard

‘Upcoming Maturities’ button. Value is the count of deposits with an upcoming maturity (7 days). If the user clicks the button, they are navigated to the deposits tab.

Bank Portal

Enhancement: 07/28/2022

TREASCD-335 - Getting issue details... STATUS

Change Request | Allow Bank to look at past rates on Available Deposit Types, Bank Dashboard

Allow Bank to look at past rates on Available Deposit Types, Bank Dashboard.

Bank can view the past 4 weeks

Bank Portal

Requested: 06/14/2022

This will allow Banks to understand how the rates are trending. Especially when there are not rates entered for the current week.

TREASCD-341 - Getting issue details... STATUS

Change Request | Deposits Availability Data (Box 4), Bank Profile

TREASURY DEPOSITS – Open and active deposits on the current date for this specific bank
Update name from Treasury Deposits to Bank’s Current Treasury Deposits.

DEPOSITS AVAILABLE – (10% *Total Treasury Deposit Pool with a max of $100 M)
Update name from Deposits to Total Deposits Available to the Bank.
This is not populating, we need it to display the value.  

TREASURY DEPOSITS REMAINING – (Total Deposits Available to the Bank - Bank’s Current Treasury Deposits.)
Update name from Treasury Deposits Remaining to Remaining Deposits Available to the Bank.

DEPOSIT POOL PERCENTAGE – Percent of Bank’s Current Treasury Deposits of the Total Treasury Deposit Pool
This is not populating, we need it to display the value.

• Amount Held / Total deposit pool

TOTAL TREASURY DEPOSITS – Open and active deposits on the current date for this all banks.
All Outstanding Treasury Deposits

TOTAL DEPOSIT POOL – Treasury Pool
Total Treasury Deposit Pool

Treasury Portal

10/25/2022

Discussed the Deposits Available and Deposit Pool Percentage values not populating. Daria is going to speak with Young and ensure Treasury wants to calculate these values the same way or if they may need to change. We will hold off on making these changes until the end of 5.3.2 to make sure Treasury has finalized.

TREASCD-367 - Getting issue details... STATUS

Enhancement | Sort Document Library by Date

Sort Document Library by Date for bank portals

Bank Portal

Enhancement: 10/20/2022

TREASCD-369 - Getting issue details... STATUS

Summary: Create a table under the Deposits tab called Funding Deposits.

Table columns: Bank name, deposit date, term, status, type, amount, account number last 4, and ‘Completion’ column. 

‘Completion’: In the column, there should either be a ‘Complete’ button, or the word ‘Completed’. 
Treasury will click ‘Complete’ and that will change the cell from a ‘Complete’ button to the word ‘Completed’. 
Only retain data in this table for seven years after the deposit maturity.

Treasury / Admin Portal

Requested: 10/20/2022

Related to: Matured Deposits | Admin Approval Queue | Admin Portal – 276

10/24/2022

Tanner to ask development team if we can a column called ‘Account Number’ and display the bank account last 4.

TREASCD-371 - Getting issue details... STATUS

Change Request | Add Events, Bank Event Log

The following events currently display on a deposits event log. Please add these events to the Banks event log (Notes). Bank event log can only be viewed by a Treasury administrator.

• Admin declined deposit (Deposit Number: [display number], Bank: [display bank name)

• Bank declined deposit (Deposit Number: [display number], Bank: [display bank name)

• Admin approved deposit (Deposit Number: [display number], Bank: [display bank name)

• Bank approved deposit (Deposit Number: [display number], Bank: [display bank name)

Relates to TREASCD-125 - Getting issue details... STATUS

Treasury / Admin Portal

Requested: 10/20/2022

10/24/2022

Tanner to request for full list of events in the Master, Bank and Deposit logs.

TREASCD-372 - Getting issue details... STATUS

Remediation | Incorrect Values, Deposits > Summary, Deposits Held and Deposit Pool Percentage | Admin/Treasury Portal

Summary table is displaying banks that do not have an active deposit. This table should only show banks with active deposits.

This issue occurs in production. In the Deposit Summary table the Deposits available and Deposit pool percent are not populating correctly for all deposits. Some are showing, but they all should be populating.

How are we calculating these values?

Treasury / Admin Portal

10/25/2022

We will hold off on making these changes until the end of 5.3.2 to make sure Treasury has finalized.

TREASCD-373 - Getting issue details... STATUS

Remediation | Admin Approved deposit, not removed

In test we have an ‘Admin Approved’ deposit that has not been removed after the deposit date.

22nd State Bank 16910-00013

Treasury / Admin Portal

10/25/2022

TREASCD-374 - Getting issue details... STATUS

Remediation | Bank Profile > Deposit, Deposit Pool Percentage, Maximum Concentration

Neither of these fields below are populating.

Bank > Bank Profile Tab

Deposit pool percentage

• Amount Held / Total deposit pool

Bank > Deposit Tab

Deposit pool percentage

• Amount Held / Total deposit pool

Maximum concentration

• IF MULTI-STATE DEPOSITORY IS ‘YES’ THEN Maximum concentration = 15% of ‘BANK IN-STATE DEPOSITS’

• IF MULTI-STATE DEPOSITORY IS ‘NO’ THEN Maximum concentration = 15% of ‘BANK DEPOSITS’

Treasury / Admin Portal

10/25/2022

We will hold off on making these changes until the end of 5.3.2 to make sure Treasury has finalized.