Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-24527

Vault -> Daily Deposits Data Stored Procedure

    Details

    • 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

      Description

      Story

      As an admin, I would like to expose Daily Deposits page data with a stored proc in Vault. 

      Description 

      Daily Deposits Page:

      Stored Procedure Data Details:

      1. Total of Cashier Deposits
      2. Change Fund Deposit
      3. Monies to be Deposited
      4. Total Deposit
      5. Bills Accepted by Safe (Whole Dollar Value)
      6. Manual Vault Drop (Cash)
      7. Manual Vault Drop (Checks)
      8. Third Party ACH
      9. Total Bills + Drops from Safe Report

      AC

      1. The stored procedure is included in this ticket
      2. The data provided by the stored procedure is accurate when compared to the stored procedure details listed above.
      3. 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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jason.powell Jason Powell
                Reporter:
                caner.saritac Caner Saritac
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 29h Original Estimate - 29h
                  29h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 45h 22m
                  45h 22m

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.