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

Stored Procedure for Remaining Change Fund Data.

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: CFA 2023R2
    • Component/s: None
    • Labels:
      None

      Description

      Details

      Based on the new information from Harrison, what do we need to get the requested data for them on Vault?

      Deposits, receiving

      Requested Data for Deposits and Change Fund Received

      • Monies Received from Courier
      • Total

      AC

      1. The stored procedure is included in this ticket
      2. The data provided by the stored procedure is accurate when compared to the data in the site.

        Attachments

        1. RDS Export Testing.sql
          0.6 kB
          Colin Wyatt-Goodall
        2. sp_changefunddeposited.sql
          0.7 kB
          Colin Wyatt-Goodall
        3. sp_changefundreceived.sql
          0.7 kB
          Colin Wyatt-Goodall

          Issue Links

            Activity

              People

              • Assignee:
                jason.powell Jason Powell
                Reporter:
                jason.powell Jason Powell
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 23h
                  23h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 17h 1m Time Not Required
                  17h 1m

                    PagerDuty

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