-
Type: Story
-
Status: Closed (View Workflow)
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: CFA 2023R3
-
Component/s: None
-
Labels:None
-
Sprint:2023.R3 New Features Sprint 4, 2023.R3 New Features Sprint 5
-
SCRUM Team:Brotherhood of Mutants
-
Story Points:3
-
Work Type Classification:Sustaining
Story
As an admin, I would like to expose Daily Deposits page data with a stored proc in Vault.
Description
Stored Procedure Data Details:
- Total of Cashier Deposits
- Change Fund Deposit
- Monies to be Deposited
- Total Deposit
- Bills Accepted by Safe (Whole Dollar Value)
- Manual Vault Drop (Cash)
- Manual Vault Drop (Checks)
- Third Party ACH
- Total Bills + Drops from Safe Report
AC
- The stored procedure is included in this ticket
- The data provided by the stored procedure is accurate when compared to the stored procedure details listed above.
- When the data in InFORM changes, the data provided by the stored procedure is updated accurately to reflect the change. This includes inserts, updates, etc.
- is implemented by
-
CFAMX-25605 2023 R3 Vault Stored Procedures
- Open
1.
|
Create Test Scripts | Done | Stefan Kruger |
|
||||||||
2.
|
Review Test Scripts | Done | Stefan Kruger |
|
||||||||
3.
|
Deploy | Done | Colin Wyatt-Goodall |
|
||||||||
4.
|
Execute Test Cases | Done | Stefan Kruger |
|
||||||||
5.
|
Functional Review with QA | Done | Colin Wyatt-Goodall |
|
||||||||
6.
|
DIT | Done | Colin Wyatt-Goodall |
|
||||||||
7.
|
Design Review | Done | Unassigned |
|
||||||||
8.
|
Story Documentation | Done | Colin Wyatt-Goodall |
|
||||||||
9.
|
Migrate tables to RDS | Done | Colin Wyatt-Goodall |
|
||||||||
10.
|
Implement Stored procedure | Done | Colin Wyatt-Goodall |
|
||||||||
11.
|
Dev Testing | Done | Colin Wyatt-Goodall |
|