Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Key

Summary

Location or User type

Bank, Treasury or Both

Notes

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-283

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

    Jira Legacy
    serverSystem JIRA
    serverIdc76ed893-9292-3c50-a783-d9afa913f29c
    keyTREASCD-299
    )

Total the interest column

View file
nameDeposit History IDMS (1).xlsx

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

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-288

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

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-293

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

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-298

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

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-334

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

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-335

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.

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-346

Change Request | Remove/Delete User

Add the ability to remove/delete a user. If a user is deleted and a new user is created with the same email information, do not stop the creation of the user. If a user is removed/deleted, keep their information on the event logs and agreements signed.

When a user is deleted, show in master and bank event log with the user name in the event.

Treasury needs this because the list will soon grow to be too large if they cannot remove accounts. We may want to retain this information but hide from the IDMS view.

Treasury Portal

Requested: 08/28/2022

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-341

Change Request | Field Name Updates, (Box/Quadrant 4), Bank Profile and Pools Tab

Bank Profile, Quadrant/Box 4

  • TREASURY DEPOSITS
    Update name from Treasury Deposits to Bank’s Current Treasury Deposits.

  • DEPOSITS AVAILABLE
    Update name from Deposits to Total Deposits Available to the Bank

  • TREASURY DEPOSITS REMAINING
    Update name from Treasury Deposits Remaining to Remaining Deposits Available to the Bank.

  • TOTAL TREASURY DEPOSITS –
    Update name to All Outstanding Treasury Deposits

  • Total Treasury Deposit Pool
    Update name to Total Treasury Deposit Pool

Pools Tab

  • Total Treasury Deposit Pool
    Update name to 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.

11/07/2022

Treasury will work on calculations separately and provide to the project team.

...