Versions Compared

Old Version 42

changes.mady.by.user Tanner Stemle

Saved on

compared with

New Version Current

changes.mady.by.user Tanner Stemle

Saved on

Key

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

...

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

Test Credentials

Username

User Role

Bank Name

Password

tan.ner.ste.m.le@gmail.com

...

Treasury Staff

N/A

Test2022!

tanner.st.e.m.l.e@gmail.com

...

View Only

N/A

Test2022!

tan.ner.nic.ole.1.990@gmail.com

...

Bank User

...

Capital City Bank

...

Test2022!

tanner.ste.m.l.e@gmail.com

...

Bank User

...

Regions

Test2022!

t.a.n.ner.stemle@gmail.com

...

Bank User

First Bank of Boaz

Test2022!

tan.ner.ste.mle@gmail.com

...

Bank User

Troy Bank and Trust

Test2022!

tanner.stem.l.e@gmail.com

...

Bank User

Capital City Bank

Test2022!

tan.ner.ste.ml.e@gmail.com

Bank User

22nd State Bank

Test2022!

ACH Workflow

...

Version 5.2.2 - Deployed

Expand
titleVersion 5.2.2 - Deployed
Jira Legacy
serverSystem JIRA
columnskey,summary,created,updated,status
maximumIssues20
jqlQuerylabels = "IDMS-2.2"
serverIdc76ed893-9292-3c50-a783-d9afa913f29c

...

Expand
titleVersion 5.3.1 - Testing
Jira Legacy
serverSystem JIRA
columnskey,summary,created,updated,status
maximumIssues20
jqlQueryproject = "TSP" AND status IN ("Agency Testing","Info Required","New","PM Prod Review","PM Testing","Prod Ready") ORDER BY created DESC
serverIdc76ed893-9292-3c50-a783-d9afa913f29c

Key

Summary

Notes

TREASCD-345

Change Request | Required Field *

When creating a new bank or editing a bank the * value needs to display on the fields that ARE required.

Requested: 08/15/2022

This was noticed while testing. We had to continue to reference a document to see what we should and should not be required to fill in. Showing a * will help understand what is required.

TREASCD-337

Change Request | Add ‘Renew’ option for Treasury Users

Add ‘Renew’ option for Treasury. Treasury can mark ‘Active’ and ‘Retire’ deposits as ‘Renew’.

Requested: 07/28/2022

Tanner will speak with team about what implications there may be if we allowed Treasury to mark a ‘Retired’ deposit as ‘Renew’.

Treasury states this would not happen more than one day past maturity.

TREASCD-336

Remediation | Agreement PDF, Missing e-signatures

Agreement PDF is missing the ‘By’ value in production (this is working in test) for both the bank and Treasury.

Reported: 07/27/2022

This issue was noticed when a bank asked for an executed copy of the agreement. The signatures are working in test, not in production.  

TREASCD-333

Change Request | Add Decline option to the Bank renew workflow

Add Decline option to the Bank renew workflow.

Change button wording from ‘Renew’ to ‘Take Action’. ‘Take Action’ will open a modal. Provide both a ‘Renew’ and ‘Decline’ button in the modal. If renew, continue the existing workflow.

If decline, display the following wording:

“You have chosen to decline the renewal of [display deposit #]. Please select ‘Yes’ to proceed with declining the renewal and the deposit will retire at maturity. Principal amount will be collected by ACH from account ending in [display account # last four digits] the day after maturity. Please select “NO” to return to the renewal options. Please note that if your bank’s liquidity needs change, you may request Treasury deposits at that time and thank you for being valued partner.”

Below wording ask the bank if they want to proceed ‘Yes’ or ‘No’.

If Yes, display wording

“[display deposit #] will retire on [display maturity date]. On the next business day, [display deposit amount] will be collected by ACH from account ending in [display account # last four digits]. Please note that if your bank’s liquidity needs change, you may request Treasury deposits at that time and thank you for being valued partner.”

with an ‘x’ to close the modal. This action will update the deposit status to ‘Retire’. Add an event to the Bank and Master event log.

If No, close the modal and do not change the status or make an event.

Requested: 07/25/2022 

The current workflow only allows a Bank to Renew, they cannot decline a renewal.

TREASCD-327

Change Request | New or Renew Deposits, Treasury

If treasury creates a new deposit OR renews an existing deposit move the deposit to pending bank approval and use the same 24 hours required action logic for ending bank approval that occurs when the bank renews.

Asked Treasury if there is ever a time they would NOT want the Bank to approve. They do not see a time or reason they would not need the banks approval

Requested: 07/25/2022

TREASCD-310

Remediation, Restricted Rates

Allow Treasury to enter Restricted rates. This should be an open field when a New Deposit is created.

 Reported: 06/22/2022

This issue impacts production. Logic to hide 0% rate with ‘Pending Rates’ seems to have overwritten the ability to manually enter this value.

TREASCD-303

Linked Pool Table | Admin Portal

Linked Deposits Pool Activity
Add a table organized from most recent to oldest. Table can be filtered by date rage (any date range).

Columns
Date: Display date that the linked deposit was ‘New’ ‘Retired’ ‘Void’ OR when Linked Deposit Pool Value was changed by Treasury
Bank name: Display bank associated with New, Retired, or Void category OR display ‘Treasury’ for Linked Deposit Pool Value Change
Category: New, Retired, Void, Linked Deposit Pool Value Change
Amount: Principal Amount. Retired and void amounts will be in green and new in red with ()

Requested: 05/10/2022

TREASCD-338

Change Request | Bank Table, New column ‘Holding Treasury Deposits’

Bank Table

Add a new column ‘Holding Treasury Deposits’. Possible values are ‘Yes’ or ‘No.

If Bank has an Active, Retire, Action Required, Renew, OR Bank Approval deposit, the value is ‘Yes’

If Bank does not have an Active, Retire, Action Required, Renew, OR Bank Approval deposit, the value is ‘No’

Sort bank list by displaying Banks with ‘Yes’ first (still in alphabetical order)

 Requested: 07/28/2022

 

TREASCD-342

Change Request | Add Events to Master Event Log

Add events:

  • Admin declined deposit (Deposit Number: Bank:)

  • Admin approved deposit (Deposit Number: Bank:)

  • Bank approved deposit (Deposit Number: Bank:)

  • Deposit VOIDED (Deposit Number: Bank:)

Requested: 08/04/2022

Treasury Approved: 08/17/2022

TREASCD-311

Enhancement, Close Modal Pending Approval

When a Bank takes an action on a deposit pending bank approval, the modal should close.

Enhancement: 07/01/2022

NIC Approved: 08/17/2022

HOT FIX - Deployed

Expand
titleHot Fix

Key

Summary

Location or User type

Bank, Treasury or Both

Notes

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

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.

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

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.

10/27/2022

Daria wants to hold on this change until the new logic is communicated to Young.

10/28/2022

Debra emailed to confirm we can deploy this change. NIC deployed.

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

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

This issue occurred due to the bug found on

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-358
. Bug fix was deployed and the issue is resolved.

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

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.

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

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

This issue occurred due to the bug found on

Jira Legacy
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-358
. Bug fix was deployed and the issue is resolved.

Version 5.3.2 -

...

Deployed

Expand
titleVersion 5.3.2 - Deployed

Jira Legacy
serverSystem JIRA
columnskey,summary,created,updated,status
maximumIssues20
jqlQueryissuetype = Task AND labels = IDMS-V5.3.2 ORDER BY key ASC
serverIdc76ed893-9292-3c50-a783-d9afa913f29c

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.  

...

0

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.

...

0

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.

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
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

...

0

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

...

Key

...

Summary

...

Priority

...

Location or User type

Bank, Treasury or Both

...

Notes

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

...

341

Change Request |

...

Add two sections

  1. Pool Concentration (previously maximum concentration)

  2. Bank Concentration

New Fields:

Pool Concentration (section name)

  • Pool Concentration Percentage

    • Edit on ‘Update Pools’

    • Display entered value on Pools tab

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

      • Percentage values

  • Pool Concentration

    • Not editable, value is calculated

    • Display dollar value calculated on Pools tab

    • Total 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.

...

1

...

Treasury

...

Requested: 11/09/2022

Treasury emailed a Word doc with these changes.

View file
nameIDMS Calculation.docx

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 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 Deposit Pool * Pool Concentration Percentage exceeds the Max Cap.

...

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

Jira Legacy
serverSystem JIRA
columnskey,summary,created,updated,status
maximumIssues20
jqlQuerylabels = "IDMS-V5.3.3"
serverIdc76ed893-9292-3c50-a783-d9afa913f29c

11/14/2022

Daria mentioned this field should also be added. It needs to be entered by the bank and can be edited at any time. Treasury will post an announcement related to the field on an annual basis as a reminder to update and we will create a modal that requires the value upon log in.

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.

Key

Summary

Location or User type

Bank, Treasury or Both

Notes

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

Change Request |

CRA Field,

Bank Profile Values |

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

Treasury/Admin Portal

Display values under the Bank tab > Deposits sub tab.

  1. Remaining Deposits Available to the Bank

    1. Existing

  2. Deposit Pool Percentage

    1. Existing

  3. Pool Concentration

    1. Existing

  4. Bank Concentration

    1. New value

  5. LTD Minimum

    1. New value

  6. CRA

    1. New value

How are the values populated?

  1. Remaining Deposits Available to the Bank

    1. Calculated

      1. CRA

        1. IF CRA is needs to improve or non-compliant

is selected

1

Bank Portal

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

Change Request | CRA, Dashboard and Banks | Treasury Portal

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).

1

Treasury Portal

11/15/2022

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

        1. THEN the Remaining Deposits Available to the Bank value IS $0.00

        2. IF CRA is outstanding or satisfactory THEN move to next criteria (ii)

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

        1. IF sum is negative THEN this is the Remaining Deposits Available to the Bank value

          1. Display the negative value

        2. IF sum is positive THEN move to next criteria (iii)

      3. Loan to Deposit Ratio

        1. IF Loan / Deposits Ratio IS below LTD Minimum THEN the Remaining Deposits Available to the Bank value IS $0.00

        2. IF Loan / Deposits Ratio IS above LTD Minimum THEN move to next criteria (iv)

      4. 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

  2. Deposit Pool Percentage

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

  3. Pool Concentration

    1. 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

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
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-389

Change Request |

UPDATE

Add Table Totals Deposits, Summary | Treasury/Admin Portal

Deposits Tab > Summary subtab

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.

1

Treasury/Admin Portal

Requested: 11/17/2022

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

  • Number of Deposits

  • Deposits Held

  • Deposits Available

Treasury/Admin Portal

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

Change Request | CRA, Dashboard and Banks | Treasury/Admin Portal

Banks tab

Create a new sub tab ‘Non Compliant CRA Rating’ that includes a table. New tab will be to the right of the In State Deposits subtab

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

The table will only display banks if they have needs to improve or non-compliant as their CRA Rating.
(CRA Rating added in

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

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?

1

Treasury/Admin Portal

Requested: 11/09/2022

Provided by Treasury:

BANK

MAXIMUM CONCENTRATION/ ***POOL CONCENTRATION

a)     10% of Total 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
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-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
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-394

Change Request | New Sections and Editable Values, Admin > Pools | Treasury Portal

Add two sections

  1. Pool Concentration (previously maximum concentration)

  2. 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
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-341

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

1

Treasury Portal

Key

Summary

Priority

keyTREASCD-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
serverSystem JIRA
serverIdc76ed893-9292-3c50-a783-d9afa913f29c
keyTREASCD-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

Expand
titleVersion 5.3.4
Jira Legacy
serverSystem JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQueryissuetype = Task AND labels = IDMS-V5.3.4
serverIdc76ed893-9292-3c50-a783-d9afa913f29c

Key

Summary

Location or User type

Bank, Treasury or Both

Notes

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

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).

...

2

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).

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

Change Request | Funding Deposits table

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.

Development team can display the account number, ticket updated.

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

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

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

...

2

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.

List of all events is below.

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

Change Request | Pools Table, Export

Summary: In the current Pools export, include the parenthesis that are displayed in the pools table in the export files, Copy Excel CSV PDF Print.

...

2

Treasury/Admin Portal

Requested: 10/31/2022

Treasury emailed Tanner that the export file does not indicate if an amount is a debit or a credit. Treasury agrees that the export should include parenthesis as shown on the pools table.

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

Change Request | Update In-State Deposits reminder email

Currently, IDMS sends the Update In-State Deposits email reminder to multi state banks with active users. The reminder does not consider if the bank has deposits currently.

Change the Update In-State Deposits email reminder to send to multi state banks, with active deposits (Holding Treasury Deposits ‘NO’ on the Outstanding In State Deposits table) and active users.

...

2

Treasury/Admin Portal

Requested: 11/02/2022

Treasury emailed Tanner stating a bank should not have received a reminder to update their in-state deposits amount when they do not have an active deposit in IDMS.

Version 5.3.

...

5

Expand
titleVersion 5.3.3 - New5
Jira Legacy
serverSystem JIRA
columnskey,summary,created,updated,status
maximumIssues20
jqlQueryissuetype = Task AND labels = IDMS-V5.3.2 ORDER BY key ASC 5
serverIdc76ed893-9292-3c50-a783-d9afa913f29c

Key

Summary

Priority

Location or User type

Bank, Treasury or Both

Notes

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

Change Request | Restricted Bank required, Restricted Rate

To create a restricted rate for a deposit the bank MUST be a restricted bank.

5.3.3

Treasury Portal

Requested: 09/15/2022

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

Enhancement | Sort Document Library by Date

Sort Document Library by Date for bank portals

5.3.3

Bank Portal

Enhancement: 10/20/2022

This was noticed by Tanner during testing.

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

Change Request | New Deposits, Weekly Email

Generate an email to be sent on Monday at 10:00 AM every week. The email will include a list of all deposits opened within the last week.

Subject: IDMS Deposits | Weekly Update

Body: Last week the following deposits were opened.

Bank Name, Amount, Deposit Date

This email should be sent to: young.boozer@treasury.alabama.gov

5.3.3

Treasury/Admin Portal

Requested: 10/31/2022

Treasurer, Young Boozer needs a way to receive a list of new deposits. Young has not made a specific request for this table but the Treasury staff is attempting to anticipate his needs.

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

Change Request | New Deposits Table, Treasury Portal, Dashboard

Summary: Create a table under the Dashboard tab called New Deposits.

Include deposits opened within the last 30 days. LOGIC: Deposit date IS today or in the past (within 30 days) AND deposit is ‘Completed’ on the Funding Deposits table.

Table columns: Bank name (hyperlink the bank), deposit date, term, type, rate, and amount

If there are no new deposits within the last 30 days, display wording “No new deposits within the last 30 days.”

5.3.3

Treasury/Admin Portal

Requested: 10/31/2022

Treasurer, Young Boozer needs a way to view new deposits. Young has not made a specific request for this table but the Treasury staff is attempting to anticipate his needs.

This information is going to be placed on the dashboard and will have similar columns to 369.

Daria mentioned the design updates shown in 2021/2022. NIC Alabama plans to continue to hold on redesign until the IDMS is complete.

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

Change Request | Remove Start Date Default, Pools History

Summary: Remove the start date default on the Pools History table.

5.3.3

Treasury/Admin Portal

Requested: 11/01/2022

Treasury would like the preset start date removed. In the future, they anticipate changing years and dates to be cumbersome and do not see the value in presetting the start date, unless it is required by NIC Alabama to complete the table logic.

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

Change Request | Treasury Deposit Summary, Dashboard | Treasury Portal

  • Remove Certificate of Deposit (CD), Time Deposit Open Account (TDOA), and Restricted from Treasury Deposit Summary table

  • Rename Treasury Deposit Summary table Linked Deposit Summary table

  • Add new values to the top of the dashboard

    • Weighted Average: Display the weighted average (calculated on currently on the Treasury Deposit Summary)

      • Hyperlink 'Weighted Average', navigates to Deposits tab > Summary sub tab

    • Total Deposit Count: Display the total count of Certificate of Deposit (CD), Time Deposit Open Account (TDOA), and Restricted deposits.

      • Hyperlink ‘Total Deposit Count’, navigates to Deposits tab > Summary sub tab

  • Hyperlink the existing values

    • Treasury Deposit Pool

      • Hyperlink, navigates to Admin tab > Pools sub tab

    • Treasury Deposits Available

      • Hyperlink, navigates to Admin tab > Pools sub tab

    • Active Deposits

      • Hyperlink, navigates to Deposits tab > Daily sub tab

  • Organize values in this order

  • Image Modified

5.3.3

Treasury Portal

11/15/2022

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

Change Request | Remove Linked Deposits, Deposits, Summary | Treasury/Admin Portal

Currently the Deposits tab > Summary sub tab includes Linked Deposits in the table values. Please remove Linked Deposits type from the table.

5.3.3

Treasury/Admin Portal

Requested: 11/17/2022

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

Change Request | Remove .00 value

Remove the .00 from the dollar value in the following locations:

Treasury/Admin Portal

  • Dashboard

    • Treasury Deposit Pool

    • Active Deposits

    • Treasury Deposits Available

    • Amount column in Top 5 Depositors table

    • Amount column in Linked Deposit Summary table (previously Treasury Deposit Summary)

  • Bank Profile

    • TREASURY DEPOSITS

    • TREASURY DEPOSITS AVAILABLE

    • TREASURY DEPOSITS REMAINING

    • TOTAL TREASURY DEPOSITS

...

    • Total Treasury Deposit Pool

  • Banks > select Bank > Deposits sub tab

    • Treasury Deposits Remaining

  • Deposits tab > Summary sub tab

    • Deposits Held

  • Admin tab > Pools sub tab

    • Total Deposits Pool

    • Active Deposits Amount

    • Linked Deposits Pool

    • Treasury Deposits Available

Bank Portal

  • Bank Profile tab

    • Bank deposits

5.3.3

Treasury/Admin and Bank Portal

Requested: 11/17/2022

Change Request | Document Library, Rates | Treasury Portal

Add a document upload. Treasury may add documents at separate times when they add their rates.

5.3.3

Treasury

11/28/2022

Tanner to discuss internally

Admin Definitions and Calculations

Expand
titleAdmin Definitions and Calculations

Portal

Tab

Subtab/Table

Label Text

Specifications

Requirement

User Role

Admin/Treasury

Dashboard

-

Last rate update

Dashboard

-

Treasury Deposit Pool

Dashboard

-

Treasury Deposits Available

Dashboard

-

Active deposits

Dashboard

-

Upcoming Maturations

Dashboard

-

Incomplete Multi-State Data

Dashboard

-

Approval Queue

Dashboard

Top 5 Depositors

Top 5 Depositors

Dashboard

Top 5 Depositors

Amount

Dashboard

Top 5 Depositors

Count

Dashboard

Treasury Deposit Summary

Type

Dashboard

Treasury Deposit Summary

Count

Dashboard

Treasury Deposit Summary

Amount

Dashboard

Treasury Deposit Summary

Weighted Rate

Banks

-

New Bank

Banks

Banks

Search

Banks

Banks

Bank Name

Banks

Banks

City

Banks

Banks

State

Banks

Banks

FDIC

Banks

Banks

  • Status

  • Active

  • Inactive

  • Restricted

  • Merged

Banks

Banks

Holding Treasury Deposits

Banks

Bank Profile / 1st Quadrant

Edit

Banks

Bank Profile / 1st Quadrant

Name

Banks

Bank Profile / 1st Quadrant

Address

Banks

Bank Profile / 2nd Quadrant

FDIC

Banks

Bank Profile / 2nd Quadrant

Bank In-state Deposits

Banks

Bank Profile / 2nd Quadrant

Regulatory Restricted

Banks

Bank Profile / 2nd Quadrant

Multi-state Depository

Banks

Bank Profile / 2nd Quadrant

Status

  • Active

  • Inactive

  • Restricted

  • Merged

Banks

Bank Profile / 2nd Quadrant

Bank Edit Date

Banks

Bank Profile / 2nd Quadrant

Routing Number

Banks

Bank Profile / 2nd Quadrant

Account Number

Banks

Bank Profile / 2nd Quadrant

Account Type

Banks

Bank Profile / 3rd Quadrant

Bank Assets

Banks

Bank Profile / 3rd Quadrant

Bank Deposits

Banks

Bank Profile / 3rd Quadrant

ROAA

Banks

Bank Profile / 3rd Quadrant

Ranking

Banks

Bank Profile / 3rd Quadrant

Loan/Deposits Ratio

Banks

Bank Profile / 3rd Quadrant

Import Date

Banks

Bank Profile / 3rd Quadrant

File Quarter

Banks

Bank Profile / 4th Quadrant

Treasury Deposits

Banks

Bank Profile / 4th Quadrant

Treasury Deposits Available

Banks

Bank Profile / 4th Quadrant

Treasury Deposits Remaining

Banks

Bank Profile / 4th Quadrant

Deposit Pool Percentage

Banks

Bank Profile / 4th Quadrant

Total Treasury Deposits

Banks

Bank Profile / 4th Quadrant

Total Treasury Deposit Pool

Banks

Deposits

Treasury Deposits Remaining

Banks

Deposits

Deposit Pool Percentage

Banks

Deposits

Maximum Concentration

Maximum Concentration is ‘Total Treasury Deposit Pool’ * .10

Banks

Deposits/Treasury Deposit Summary

Type

Banks

Deposits/Treasury Deposit Summary

Count

Banks

Deposits/Treasury Deposit Summary

Amount Held

Banks

Deposits/Treasury Deposit Summary

Interest

Banks

Deposits/Treasury Deposit Summary

Weighted Average Rate

Banks

Deposits/Deposit Details

New Deposit

Banks

Deposits/Deposit Details

Calendar Picker

Banks

Deposits/Deposit Details

Status

Banks

Deposits/Deposit Details

Type

Banks

Deposits/Deposit Details

Deposit Date

Banks

Deposits/Deposit Details

Maturity Date

Banks

Deposits/Deposit Details

Term

Banks

Deposits/Deposit Details

Amount

Banks

Deposits/Deposit Details

Rate

Banks

Deposits/Deposit Details

Magnifying Glass

Banks

Documentation/Notes

Add Note

Banks

Documentation/Notes

Banks

Documentation/Document Library

Add Document

Banks

Documentation/Document Library

Document

Banks

Documentation/Document Library

Description

Banks

Documentation/Document Library

User

Banks

Documentation/Document Library

Date

Banks

Documentation/Document Library

Delete

Banks

Documentation/Contacts

New Contact

Banks

Documentation/Contacts

Name

Banks

Documentation/Contacts

Title

Banks

Documentation/Contacts

Phone

Banks

Documentation/Contacts

Email

Banks

Documentation/Contacts

Status

Banks

Documentation/Contacts

Pencil

Deposits

Daily

Calendar Picker

Deposits

Daily

New Deposit Request

Deposits

Daily

Bank Name

Deposits

Daily

FDIC

Deposits

Daily

Deposit Date

Deposits

Daily

Maturity Date

Deposits

Daily

Term

Deposits

Daily

Status

Deposits

Daily

Type

Deposits

Daily

Rate

Deposits

Daily

Amount

Deposits

Daily

Monthly Interest

Deposits

Summary

Bank Name

Deposits

Summary

Weighted Rate

Deposits

Summary

Interest Total

Deposits

Summary

Number of Deposits

Deposits

Summary

Deposits Held

Deposits

Summary

Deposits Available

Deposits

Summary

Deposit Pool %

Admin

Pools

Update Pools

Treasury/Admin

Admin

Pools

Total Deposits Pool

Display dollar value provided under ‘Update Pools’ button

N/A

Treasury/Admin

Admin

Pools

Active Deposit Amount

Active Deposit Amount is the total deposit amount of all open deposits (status: active, renew, retire, action required ?)

N/A

Treasury/Admin

Admin

Pools

Entered Date

Date ‘Update Pools’ values are changed and saved.

N/A

Treasury/Admin

Admin

Pools

Linked Deposit Pool

Display dollar value provided under ‘Update Pools’ button

N/A

Treasury/Admin

Admin

Pools

Treasury Deposits Available

Treasury Deposits Available = ‘Total Treasury Deposit Pool’ - ‘Active Deposit Amount’

N/A

Treasury/Admin

Admin

Pools

Entered By

User who changed ‘Update Pools’ values.

N/A

Expand
titleEvent Log

Event Log

/

/ Bank

  • BANK_CREATED("Bank Created")

  • BANK_MERGED("Bank Merged")

  • BANK_STATUS_UPDATED("Bank Status Updated")

  • BANK_STREET_ADDRESS_UPDATED("Bank Street Address Updated")

  • BANK_CONTACT_NAME_UPDATED("Bank Contact Name Updated")

  • BANK_EMAIL_UPDATED("Bank Contact Email Updated")

  • BANK_PHONE_NUMBER_UPDATED("Bank Contact Phone Number Updated")

  • BANK_FDIC_UPDATED("Bank FDIC Updated")

  • BANK_REGIONAL_DEPOSITORY_UPDATED("Bank Regional Depository Updated")

  • BANK_REGULATORY_RESTRICTED_UPDATED("Bank Regulatory Restricted Updated")

  • BANK_AS_OF_DATE_UPDATED("Bank As of Date Updated")

  • BANK_ROUTING_NUMBER_UPDATED("Bank Routing Number Updated")

  • BANK_ACCOUNT_NUMBER_UPDATED("Bank Account Number Updated")

  • BANK_ACCOUNT_TYPE_UPDATED("Bank Account Type Updated")

  • BANK_QUARTERLY_IN_STATE_DEPOSITS_UPDATED("Bank Quarterly In-State Deposits Updated")

  • BANK_DOCUMENT_REMOVED("Bank Document Removed")

  • BANK_UNDER_REVIEW("Bank Submitted For Review")

  • BANK_APPROVED("Bank Approved"),

// FRB

  • FRB_RATE_ENTERED("FRB Rate Entered")

  • FRB_RATE_APPROVED("FRB Rate Approved")

// Deposit

  • DEPOSIT_CREATED("Deposit created")

  • DEPOSIT_PROJECTED("Deposit projected")

  • NEW_DEPOSIT_REQUESTED("New deposit requested")

  • RENEW_DEPOSIT_REQUESTED("Renew deposit requested")

  • NEW_DEPOSIT_REQUEST_ADMIN_DECLINED("New deposit request declined by admin")

  • NEW_DEPOSIT_REQUEST_ADMIN_APPROVED("New deposit request approved by admin")

  • NEW_DEPOSIT_REQUEST_BANK_DECLINED("New deposit request declined by bank")

  • NEW_DEPOSIT_REQUEST_BANK_APPROVED("New deposit request approved by bank")

  • RENEW_DEPOSIT_REQUEST_ADMIN_DECLINED("Renew deposit request declined by admin")

  • RENEW_DEPOSIT_REQUEST_ADMIN_APPROVED("Renew deposit request approved by admin")

  • RENEW_DEPOSIT_REQUEST_BANK_DECLINED("Renew deposit request declined by bank")

  • RENEW_DEPOSIT_REQUEST_BANK_APPROVED("Renew deposit request approved by bank")

//old events used for pulling event log history, plan to remove in the future but keeping for now to be safe

  • DEPOSIT_ADMIN_APPROVED("New deposit request has been approved by admin")

  • DEPOSIT_BANK_APPROVED("Agreement has been accepted by bank")

  • DEPOSIT_BANK_DECLINED("Agreement has been declined by bank")

  • DEPOSIT_DECLINED("Deposit request has been declined")

  • DEPOSIT_AGREEMENT_DECLINED("New Deposit Request Pending Bank Approval was declined")

// Transitions

  • DEPOSIT_ACTIVE("Deposit set to Active")

  • DEPOSIT_ACTION_REQUIRED("Deposit needs action taken")

  • DEPOSIT_PENDING_RATES("Deposit is pending rates")

  • DEPOSIT_REVIEWING("Deposit is being reviewed")

  • DEPOSIT_UNDER_REVIEW("Rates have been entered, deposit has been added to the approval queue")

  • DEPOSIT_PENDING_REVIEW("Deposit is pending review")

  • DEPOSIT_ROLL_OVER("Deposit set to Renew")

  • DEPOSIT_RETIRE("Deposit set to Retire")

  • DEPOSIT_ACTION_UNKNOWN("Deposit set to Unknown action")

  • DEPOSIT_AGREEMENT_RECEIVED("Deposit agreement received")

  • DEPOSIT_AGREEMENT_NOT_RECEIVED("Deposit agreement not received")

  • DEPOSIT_RETIRED("Deposit retired")

  • DEPOSIT_RETIRED_EARLY("Deposit Retired Early")

  • DEPOSIT_ROLLED_OVER("Deposit renewed")

  • DEPOSIT_VOIDED("Deposit voided")

// Edits

  • DEPOSIT_MATURITY_CHANGED("Deposit Maturity Date changed")

  • DEPOSIT_RATE_CHANGED("Deposit Rate changed")

  • DEPOSIT_TERM_CHANGED("Deposit Term Changed")

  • DEPOSIT_AMOUNT_CHANGED("Deposit Amount Changed")

  • DEPOSIT_DATE_CHANGED("Deposit Date Changed")

// Pools

  • POOLS_UPDATE("Pool value(s) have been updated.")

// ACH

  • ACH_SENT("ACH Sent")

  • DEPOSIT_INTEREST_DEBITED("Interest Debited")

  • DEPOSIT_MONTHLY_INTEREST_DEBITED("Monthly interest debited")

  • DEPOSIT_MATURITY_INTEREST_DEBITED("Maturity interest debited"),

// Admin

  • DEPOSIT_TYPES_AND_TERMS_UPDATE("Deposit types and terms selection has been ubdated.")

  • NOTE("Note")

  • UNKNOWN("Unknown")