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

Vault -> Paid in/Out 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 3
    • SCRUM Team:
      Brotherhood of Mutants
    • Story Points:
      3
    • Work Type Classification:
      Sustaining

      Description

      Story

      As an admin, I would like to expose Paid in/Out page data with a stored proc in Vault. 

      Description 

      Paid In/Out Page

      Stored Procedure Data Details:

      1. Type
      2. Category
      3. Cashier
      4. Description
      5. Amount
        Action (lock)

      EDIT: CWG.
      When ther eis a reimbursement there needs to also be a department and a subject

      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

        1. image-2023-03-12-20-54-58-447.png
          75 kB
          Caner Saritac
        2. PaidInPaidOut.sql
          1.0 kB
          Sree Surapaneni
        3. sp_paidinpaidout.sql
          0.9 kB
          Colin Wyatt-Goodall
        4. Vault -_ Paid in_Out Data Stored Procedure DELETE - TestRail.pdf
          650 kB
          Stefan Kruger
        5. Vault -_ Paid in_Out Data Stored Procedure INSERT - TestRail.pdf
          1.31 MB
          Stefan Kruger
        6. Vault -_ Paid in_Out Data Stored Procedure UPDATE - TestRail.pdf
          741 kB
          Stefan Kruger

          Issue Links

          Is Clone Of

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-25452 2023 R3 Testing CLONE - Vault -> Paid in/Out Data Stored Procedure

          • In Dev
          is implemented by

          Feature Request - CFAMX-25605 2023 R3 Vault Stored Procedures

          • Major - Major loss of function.
          • Open

            Activity

              People

              • Assignee:
                caner.saritac Caner Saritac
                Reporter:
                caner.saritac Caner Saritac
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 22h Original Estimate - 22h
                  22h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 37h 1m
                  37h 1m

                    PagerDuty

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