Versions Compared

Old Version 43

changes.mady.by.user Tanner Stemle

Saved on

compared with

New Version 44

changes.mady.by.user Tanner Stemle

Saved on

Key

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

...

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

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

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.

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.

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.

...

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

Banks

Deposits

Treasury Deposits Remaining

Banks

Deposits

Deposit Pool Percentage

Banks

Deposits

Maximum Concentration

Maximum Concentration is ‘Total 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 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")