...
Key | Summary | Location or User type Bank, Treasury or Both | Notes | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Change Request | Deposit Date Logic, Bank Requested DepositsThe 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:
| Both Portals | Requested: 10/20/2022 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. | ||||||||||||||||
| Remediation | Admin Approved deposit, not removedIn 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
|
Version 5.3.2 - In Progress
|
...
Key
Summary
Location or User type
Bank, Treasury or Both
Notes
...
|
| Change Request | |
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 | ||
|---|---|---|
|
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 | ||||||
|---|---|---|---|---|---|---|
|
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/2022Deposit NumberChange the logic that generates the Deposit Number. The deposit number should now be: 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. |
Version 5.3.2 - In Progress
| Jira Legacy | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Key | Summary | Location or User type Bank, Treasury or Both | Notes | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Change Request | Bank, Deposit History Tab | Admin PortalCreate 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:
Search and Export:
Table Columns:
Change Request | Event wording, Renewal DeclinedUpdate event history note ‘Deposit set to Retire' to 'Renewal Declined’. This event should display in the Master, Bank and deposits event log.
Total the interest column
| Treasury / Admin Portal | This change will clarify an event log entry. Requested: 05/23/2022 | ||||||||||||||||||||||
| Change Request | Available Deposit Types Section, Dashboard | Treasury PortalDisplay 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 | ||||||||||||||||||||||
| Change Request | Deposit NumberChange the logic that generates the Deposit Number. The deposit number should now be: 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. | ||||||||||||||||||||||
| Change Request | Wording Change, Pools History | Treasury PortalTreasury 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 entrytable 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 | ||||||||||||||||||||||
| Change Request | Internal Documents, Document LibraryInternal 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 | ||||||||||||||||||||||
| Change Request | Event wording, Renewal DeclinedUpdate 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 | ||||||||||||||||||||||
| Change Request | Available Deposit Types Section, Dashboard | Treasury PortalDisplay 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 | ||||||||||||||||||||||
| Change Request | Wording Change, Pools History | Treasury PortalTreasury 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. | ||||||||||||||||||||||
| Change Request | Pools History, Active Deposits BalanceWithin 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). | ||||||||||||||||||||||
| Enhancement | Bank Dashboard, ‘Upcoming Maturities’ | Bank PortalBank 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 | ||||||||||||||||||||||
| Change Request | Allow Bank to look at past rates on Available Deposit Types, Bank DashboardAllow 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. | ||||||||||||||||||||||
| Change Request | Deposits Availability Data (Box 4), Bank ProfileTREASURY DEPOSITS – Open and active deposits on the current date for this specific bank
DEPOSITS AVAILABLE – (10% *Total Treasury Deposit Pool with a max of $100 M) TREASURY DEPOSITS REMAINING – (Total Deposits Available to the Bank - Bank’s Current Treasury Deposits.)
DEPOSIT POOL PERCENTAGE – Percent of Bank’s Current Treasury Deposits of the Total Treasury Deposit Pool
TOTAL TREASURY DEPOSITS – Open and active deposits on the current date for this all banks.
TOTAL DEPOSIT POOL – Treasury 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. | ||||||||||||||||||||||
| Enhancement | Sort Document Library by DateSort Document Library by Date for bank portals | Bank Portal | Enhancement: 10/20/2022 This was noticed by Tanner during testing. | ||||||||||||||||||||||
| Change Request | Funding Deposits tableSummary: 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 / 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. | ||||||||||||||||||||||
| Change Request | Add Events, Bank Event LogThe 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.
Relates to
| 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. | ||||||||||||||||||||||
| Remediation | Incorrect Values, Deposits > Summary, Deposits Held and Deposit Pool Percentage | Admin/Treasury PortalSummary 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. Revisit this section in daily IDMS meeting. 11/07/2022 Treasury will work on calculations separately and provide to the project team. | ||||||||||||||||||||||
| Remediation | Admin Approved deposit, not removedIn 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
| ||||||||||||||||||||||
| Change Request | Bank Profile > Deposit, Deposit Pool Percentage and Maximum ConcentrationNeither of these fields below are populating correctly.
Add another value to Bank | 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. Revisit this section in daily IDMS meeting. 11/07/2022 Treasury will work on calculations separately and provide to the project team. | ||||||||||||||||||||||
| Change Request | New Deposits, Weekly EmailGenerate 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 | 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. | ||||||||||||||||||||||
| Change Request | New Deposits Table, Treasury Portal, DashboardSummary: 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.” | 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. | ||||||||||||||||||||||
| Change Request | PoolsHistoryTable,Active Deposits BalanceWithin 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)ExportSummary: In the current Pools export, include the parenthesis that are displayed in the pools table in the export files, Copy Excel CSV PDF Print. | 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. | ||||||||||||||||||||||
| Change Request | Remove Start Date Default, Pools HistorySummary: Remove the start date default on the Pools History table. | Treasury/Admin Portal | RequestedRequested: 0611/3001/2022 Treasury needs the ability to view the active deposits on a given date to reconcile with STARS (external application)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. | ||||||||||||||||||||||
| Enhancement | Bank Dashboard, ‘Upcoming Maturities’ | Bank PortalBank 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 |
| Change Request | Update In-State Deposits reminder emailCurrently, 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. | 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. | ||||||||||||||||||
| Change Request | Allow Bank to look at past rates on Available Deposit Types, Bank DashboardAllow 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. |
| 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. | |||||||||||||||||||
| Enhancement | Sort Document Library by DateSort Document Library by Date for bank portals | Bank Portal | Enhancement: 10/20/2022 This was noticed by Tanner during testing. | ||||||||||||||||||||||
| Change Request | Funding Deposits tableSummary: 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 / 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. |
| Change Request | Add Events, Bank Event LogThe 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.
Relates to
| Treasury / Admin Portal | |||||||||||||||||||
| Remediation | Incorrect Values, Deposits > Summary, Deposits Held and Deposit Pool Percentage | Admin/Treasury PortalSummary 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. Revisit this section in daily IDMS meeting. | ||||||||||||||||||||||
| Remediation | Admin Approved deposit, not removedIn 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
| ||||||||||||||||||||||
| Remediation | Bank Profile > Deposit, Deposit Pool Percentage, Maximum ConcentrationNeither of these fields below are populating. Bank > Bank Profile Tab Deposit pool percentage
Bank > Deposit Tab Deposit pool percentage
Maximum concentration
| 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. Revisit this section in daily IDMS meeting. | ||||||||||||||||||||||
| Change Request | New Deposits, Weekly EmailGenerate 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: | 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. Who should we sent the email to? | ||||||||||||||||||||||
| Change Request | New Deposits Table, Treasury Portal, DashboardSummary: 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.” | 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. | ||||||||||||||||||||||
| Change Request | Pools Table, ExportSummary: In the current Pools export, include the parenthesis that are displayed in the pools table in the export files, Copy Excel CSV PDF Print. | 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. | ||||||||||||||||||||||
| Change Request | Remove Start Date Default, Pools HistorySummary: Remove the start date default on the Pools History table. | 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. | ||||||||||||||||||||||
| Change Request | Update In-State Deposits reminder emailCurrently, 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. | 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.
| Remediation | File Quarter, Missing in production | Treasury/Admin PortalFile Quarter is missing in production. This value is populating as expected in test. | Treasury | Reported: 11/07/2022 Values works in test. |
Admin 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 |
|
| |||
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 |
| |||
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 Deposit Pool | ||||
Banks | Deposits | Treasury Deposits Remaining | ||||
Banks | Deposits | Deposit Pool Percentage | ||||
Banks | Deposits | Maximum Concentration | ||||
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 | |||||
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 % |
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"),
...