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

2023 R3 Testing CLONE - Vault -> Paid in/Out Data Stored Procedure

    Details

    • Type: Story
    • Status: In Dev (View Workflow)
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: CFA 2023R3
    • Component/s: None
    • Labels:
      None
    • SCRUM Team:
      Great White
    • 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
          Jason Powell
        2. PaidInPaidOut.sql
          1.0 kB
          Jason Powell
        3. sp_paidinpaidout.sql
          0.9 kB
          Jason Powell
        4. Vault -_ Paid in_Out Data Stored Procedure DELETE - TestRail.pdf
          650 kB
          Jason Powell
        5. Vault -_ Paid in_Out Data Stored Procedure INSERT - TestRail.pdf
          1.31 MB
          Jason Powell
        6. Vault -_ Paid in_Out Data Stored Procedure UPDATE - TestRail.pdf
          741 kB
          Jason Powell

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  PagerDuty

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