Page Comparison

...

Production: https://www.alabamainteractive.org/treasury_deposits

Test Credentials

...

...

...

...

...

...

...

...

...

...

ACH Workflow

...

Version 5.2.2 - Deployed

...

Version 5.3.2 -

...

Deployed

...

Expand
title Version 5.3.2 - Deployed
Jira Legacy server System JIRA columns key,summary,created,updated,status maximumIssues 20 jqlQuery issuetype = Task AND labels = IDMS-V5.3.2 ORDER BY key ASC serverId c76ed893-9292-3c50-a783-d9afa913f29c Key Summary Location or User type Bank, Treasury or Both Notes Jira Legacy server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-299 ) Total the interest column View file name Deposit 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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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. Image Modified 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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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 server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-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.

Version 5.3.3 -

...

In Progress

...

...

Add two sections

...

...

Pool Concentration (section name)

• Pool Concentration Percentage

  • Edit on ‘Update Pools’

  • Display entered value on Pools tab

  • Percentage of the Total Treasury Deposit Pool (currently 10%)

    • Percentage values

• Pool Concentration

  • Not editable, value is calculated

  • Display dollar value calculated on Pools tab

  • Total Treasury Deposit Pool * Pool Concentration Percentage

Bank Concentration (section name)

• Bank Concentration Percentage

  • Edit on ‘Update Pools’

  • Display entered value on Pools tab

  • Percentage of Bank Deposits or In-State Deposits (currently 15%)

    • Percentage value

• LTD Minimum

  • Edit LTD Minimum under Pools ‘Update Pools’

  • Display entered value on Pools tab

  • Currently > OR = 50%

  • Percentage value

  • Loans/Deposits Ratio is an imported value in the quarter fiscal import. The LTD minimum is a separate value entered manually on the Pools tab.

...

Treasury

...

Requested: 11/09/2022

Treasury emailed a Word doc with these changes.

Need to review Summary Table calculations

Removed:

• Maximum possible value $100 million (currently)

  • QUESTION: Can we give this value a name?

    • Yes, Max Cap

    • Dollar amount

  • QUESTION: what if the Pool Concentration Percentage of the Total Treasury Deposit Pool exceeds the Ma?

    • Display the Pool Maximum Concentration

  • QUESTION: Does Treasury need to know/see this?

    • Yes, message should display if the Total Treasury Deposit Pool * Pool Concentration Percentage exceeds the Max Cap.

...

Change Request | CRA Field, Bank Profile | Bank Portal

CRA; dropdown (outstanding, satisfactory, needs to improve, or non-compliant)

Allow Banks to edit the CRA field under Bank Profile section 2.

Create a modal that displays upon log in IF the CRA field is empty. Modal will require response to proceed forward and utilize the system.

Allow Treasury to edit this value under the bank edit function. Add value to section two.

If needs to improve or non-compliant is selected

...

Bank Portal

11/14/2022

...

value LTD Minimum New value CRA New value How are the values populated? Remaining Deposits Available to the Bank Calculated CRA IF CRA is needs to improve or non-compliant THEN the Remaining Deposits Available to the Bank value IS $0.00 IF CRA is outstanding or satisfactory THEN move to next criteria (ii) Pool Concentration - Amount Held (found in Treasury Deposit Summary table) IF sum is negative THEN this is the Remaining Deposits Available to the Bank value Display the negative value IF sum is positive THEN move to next criteria (iii) Loan to Deposit Ratio IF Loan / Deposits Ratio IS below LTD Minimum THEN the Remaining Deposits Available to the Bank value IS $0.00 IF Loan / Deposits Ratio IS above LTD Minimum THEN move to next criteria (iv) Percent of Bank Deposits = (Bank Concentration Percentage * Bank Concentration) - Amount Held IF calculated amount is greater than Pool Concentration value THEN the Remaining Deposits Available to the Bank value is the Pool Concentration value IF calculated amount is less than the Pool Concentration value THEN the Remaining Deposits Available to the Bank value IS (Bank Concentration Percentage * Bank Concentration) - Amount Held Deposit Pool Percentage Amount Held (found in Treasury Deposit Summary) / Total Deposits Pool (found on Pools) Pool Concentration Value calculated and displayed on Pools tab Bank Concentration Calculate value IF ‘Multi-state Depository’ IS ‘yes’ THEN Bank Concentration = 'Bank In-State Deposits' * Bank Concentration Percentage (found on Pools) IF ‘Multi-state Depository’ IS ‘no’ THEN Bank Concentration = 'Bank Deposits' (value imported in fiscal data import)* Bank Concentration Percentage (found on Pools) LTD Minimum Value entered on Pools tab CRA Dropdown value entered by Bank OR Treasury Additional Changes Remove ‘Linked Deposits’ deposit type from the Treasury Deposit Summary table on Banks > ‘Select Bank’ > Deposits. Image Added Add new table ‘Linked Deposit Summary’ below the Treasury Deposit Summary table. This table will include all columns on the Treasury Deposit Summary. TYPE, COUNT, AMOUNT HELD, INTEREST, WEIGHTED AVERAGE RATE Bank’s Current Treasury Deposits on Banks > ‘Select Bank’ > Bank Profile (section 4) should total the CD, TDOA, and Restricted deposit types. DO not include Linked Deposits in this calculation. Add wording on Banks > ‘Select Bank’ > Bank Profile (section 4) above all current values: “Linked Deposits are not included in the values below.”	Treasury/Admin Portal
Jira Legacy server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-

...

...

...

Create table under ‘Banks’ titled ‘Non Compliant CRA Rating’. Only display banks if they have needs to improve or non-compliant as their CRA Rating.

Columns: Bank Name, CRA Rating, City, State, FDIC, and Holding Deposits

Create a button on the Dashboard titled: Non Compliant CRA Rating. The count should be the number of banks with needs to improve or non-compliant as their CRA Rating (same as Non Compliant CRA Rating table).

...

Treasury Portal

...

11/15/2022

Add table and count on dashboard to highlight the CRA ratings that are not compliant

...

...

Treasury/Admin Portal

Requested: 11/17/2022

NOTE: The deposits available and Deposit Pool % are not calculating correctly.

Total the following columns:

• Weighted average (this is not a sum total, value calculated on Dashboard Treasury Deposit Summary)

• Interest Total

• Number of Deposits

• Deposits Held

• Deposits Available

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.

...

Change Request | Bank Profile Values

Display values under the Bank tab > Deposits sub tab.

1. Treasury Deposits Remaining

2. Deposit Pool Percentage

3. Pool Concentration

   1. Pool Concentration IS Maximum Concentration

4. Bank Concentration

5. LTD Minimum

6. CRA

How are the values populated?

1. Treasury Deposits Remaining

   1. Calculated

      1. Pool Concentration - Amount Held (found in Treasury Deposit Summary)

         1. IF sum is negative THEN this is the Treasury Deposits Remaining value

            1. Display the negative value

         2. IF sum is positive THEN move to next criteria

      2. Loan to Deposit Ratio

         1. IF Loan / Deposits Ratio IS below LTD Minimum THE the Treasury Deposits Remaining value IS $0.00

         2. IF Loan / Deposits Ratio IS above LTD Minimum THE the Treasury Deposits Remaining value IS the Pool Concentration value

      3. Percent of Bank Deposits = (Bank Concentration Percentage * Bank Concentration) - Amount Held

         • IF calculated amount is greater than Pool Concentration value THEN the Treasury Deposits Remaining value is the Pool Concentration value

         • IF calculated amount is less than the Pool Concentration value THEN move to next criteria

2. Deposit Pool Percentage

   1. Amount Held (found in Treasury Deposit Summary) / Total Deposits Pool (found on Pools)

3. Pool Concentration

   1. Pool Concentration IS Maximum Concentration currently, update the title.

   2. Value calculated and displayed on Pools tab

4. Bank Concentration

   1. Calculate value

      1. IF ‘Multi-state Depository’ IS ‘yes’ THEN

         • Bank Concentration = 'Bank In-State Deposits' * Bank Concentration Percentage (found on Pools)

      2. IF ‘Multi-state Depository’ IS ‘no’ THEN

         • Bank Concentration = 'Bank Deposits' (value imported in fiscal data import)* Bank Concentration Percentage (found on Pools)

5. LTD Minimum

   1. Value entered on Pools tab

6. CRA

   1. Dropdown value entered by Bank OR Treasury

• Remove ‘Linked Deposits’ deposit type from the Treasury Deposit Summary table on Banks > ‘Select Bank’ > Deposits.

• Add new table ‘Linked Deposit Summary’ below the Treasury Deposit Summary table. This table will include all columns on the Treasury Deposit Summary.

  • CAN THIS TABLE BE HIDDEN IF THERE ARE NO LINKED DEPOSITS OPEN?

• Treasury Deposits on Banks > ‘Select Bank’ > Bank Profile (section 4) should only total the CD, TDOA, and Restricted

• Add ‘Linked Deposits’ on Banks > ‘Select Bank’ > Bank Profile (section 4) and display the total amount held for Linked Deposit deposit type.

Add value to

• Treasury Deposits Remaining

  • Pool Concentration - Bank’s Current Treasury Deposits (341)

    • Is the sum is negative, then the negative sum amount is the total deposits available

      • Sum= -1,000 then display 1,000?

...

Treasury/Admin Portal

Requested: 11/09/2022

Provided by Treasury:

BANK

MAXIMUM CONCENTRATION/ ***POOL CONCENTRATION

a)     10% of Total Treasury Deposit Pool

b)     Cannot exceed $100 million

 ***BANK CONCENTRATION***

a)     May Multi-State Depository – Answer is NO

i)      15% of Bank Deposits

b)     May Multi-State Depository – Answer is Yes

i)      15% of Bank In-State Deposits

TREASURY DEPOSITS REMAINING

a)     Pool Concentration minus Bank’s Deposit Held

i)      If sum is negative, then negative sum amount is the total deposits available

ii)     If sum is positive, then sum moves to next criteria

b)     Percent of Bank Deposits –

i)      If calculated amount is greater than 15%, then treasury deposits available becomes zero; no further calculations

ii)     If calculated amount is less than 15%, then amount available becomes the lesser of the sum from a)ii) or this calculation; go to next criteria

c)     Loan to Deposit Ratio

i)      If Loan/Deposit Ratio is below 50% then amount available becomes zero

ii)     If Loan/Deposit Ratio is 50% or above, then amount available is the same as 6)b)ii)

DEPOSIT POOL PERCENTAGE

a)     Bank’s Amount Held divided by Total Deposits Pool

TREASURY DEPOSITS

a)     Total Deposits Held – CD & TDOA

b)     ***Link Deposit will need a separate field***

CRA Rating

a)     Add CRA Rating dropdown in Bank FDIC Profile Box

b)     Dropdown to be Outstanding, Satisfactory, Needs to Improve and Substantial Noncompliance

c)     Bank will choose one

d)     If bank chooses Need to Improve or Substantial Noncompliance:

i)      Notation “CRA Rating” is made somewhere noticeable

...

393 ) Dashboard tab Create a button on the Dashboard titled: Non Compliant CRA Rating. The button will display a number. The count should be the number of banks with needs to improve or non-compliant as their CRA Rating (same as Non Compliant CRA Rating table). If the button is clicked, the user will navigate to the Banks tab > Non Compliant CRA Rating subtab	Treasury/Admin Portal
Jira Legacy server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-393	Change Request | CRA Field, Bank Profile | Bank Portal Create a new value ‘CRA’. The value can be viewed and edited under Bank and Treasury Portals. CRA: dropdown (outstanding, satisfactory, needs to improve, or non-compliant) Add ‘Release Date’ field MM/DD/YYYY; this is required if the CRA field is updated Bank Portal Allow Banks to edit the CRA field under Bank Profile section 2. Create a modal that displays upon log in IF the CRA field is empty AND the bank has deposits. Modal will require response to proceed and utilize the system. Image Added Treasury Portal Allow Treasury to edit this value under the bank edit function. Add value to section two of the Bank Profile. If needs to improve or non-compliant is selected, the 'REMAINING DEPOSITS AVAILABLE TO THE BANK' (displayed on section 4 of Bank Profile and Bank > Deposits sub tab) value will be $0.00. If the CRA is updated at a later date to outstanding or satisfactory, the REMAINING DEPOSITS AVAILABLE TO THE BANK value would go back to its previous calculation. Event Log Display at the Bank Level - “CRA Updated” [Display previous CRA value and new CRA value (Updated from: to:)] Date/Time User	Bank Portal
Jira Legacy server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-394	Change Request | New Sections and Editable Values, Admin > Pools | Treasury Portal Add two sections Pool Concentration (previously maximum concentration) Bank Concentration New Fields: Pool Concentration (section name) Pool Concentration Percentage Edit on ‘Update Pools’ button Display entered value on Pools tab (photo in comments) Percentage of the Total Treasury Deposit Pool (currently 10%) Percentage values Pool Concentration Not editable, value is calculated Display dollar value calculated on Pools tab (photo in comments) Total Treasury Deposit Pool * Pool Concentration Percentage Bank Concentration (section name) Bank Concentration Percentage Edit on ‘Update Pools’ button Display entered value on Pools tab (photo in comments) Percentage of Bank Deposits or In-State Deposits (currently 15%) Percentage value LTD Minimum Edit LTD Minimum under Pools ‘Update Pools’ button Display entered value on Pools tab (photo in comments) Currently > OR = 50% Percentage value Loans/Deposits Ratio is an imported value in the quarter fiscal import. The LTD minimum is a separate value entered manually on the Pools tab. Entered by and entered date will update when these values are edited. Event Log Create new events on the Master event log: Pool Concentration Percentage To and from percentages Date/Time User Bank Concentration Percentage To and from percentages Date/Time User LTD Minimum To and from percentages Date/Time User	Treasury/Admin Portal
Jira Legacy server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-400	Remediation | Incorrect Calculation Deposits Available and Deposit Pool % | Treasury/Admin Portal Deposits Tab > Summary subtab The deposits available and Deposit Pool % are not calculating correctly.	Treasury/Admin Portal
Jira Legacy server System JIRA serverId c76ed893-9292-3c50-a783-d9afa913f29c key TREASCD-401	Remediation | Inactive Deposits Displayed | Treasury/Admin Portal Deposit tab > Summary subtab 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.	Treasury/Admin Portal

Version 5.3.4

...