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

SQL cleanup

    Details

    • Type: Story
    • Status: In Product Review (View Workflow)
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Sprint:
      System Health 2020R4 Sprint 2
    • SCRUM Team:
      Watchmen
    • Story Points:
      3
    • Work Type Classification:
      Sustaining

      Description

      Code Cleanup items found during tbTransactionItem Partitioning Research

      1. qryMMSAggregation_AggregateTransactionItem.sql
      2. qryMMSForecast_InsertActual.sql
      3. qryMMSItem_GetRecipeUsage.sql
      4. qryMMSReportData_InventorySpecialEvent.sql
      5. qryMMSReportData_InventorySpecialEvent_MultiItem.sql
      6. qryMMSReportData_InventoryUsageForWeekPt1.sql
      7. qryMMSReportData_KeyItemSales.sql
      8. qryMMSReportData_ProductSalesAnalysis.sql
      9. qryMMSReportData_Weekly_OPS_Summary_GP.sql
      10. qryMMSReportData_WeeklyTakingsAnalysis_1.sql
      11. qryMMSSystem_DeleteSalesData.sql
      12. qryMMSTransactionItem_AggregateByTradingDay.sql
      13. qryMMSTransactionItem_GetByEntityIDItemIDStartEndTime.sql
      14. qryMMSTransactionSalesItemForSAP_ListByEntityIDCurrentDay.sql
      15. qryMMSTransactionSAP_ListForSMJJournal.sql
      16. qryMMSTransactionSummary_DeleteForInjectSales
      17. qryMMSTransactionItem_WasteVsSold
      18. qryMMSReportData_StocktakeInventoryMovement
      19. qryMMSReportData_InventoryWeeklyUsageByHour
      20. qryMMSReportData_InventoryMovement
      21. qryMMSReportData_InventoryItemClassDetail
      22. qryMMSReportData_InventoryAggregatedItemClass
      23. qryMMSReportData_InventoryActivity_HH
      24. qryMMSReportData_DailyScorecard
      25. qryMMSReportData_DailyActivity_Sub_2
      26. qryMMSInventoryActivity_DA
      27. fn_SalesByInterval
      28. fn_InventoryActivity_GetInventoryData_CPK

        Attachments

          Issue Links

          implements

          Feature Request - CFAMX-9167 Unused Code Cleanup

          • Critical - Crashes, loss of data, severe memory leak.
          • In Development
          Is Clone Of

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10917 UnUsed Reports cleanup

          • Closed
          1.
          		 Review Test Scripts QA Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          2.
          		 Deploy QA Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          3.
          		 Functional Review with QA Dev Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          4.
          		 DIT Dev Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          5.
          		 Remove unused SQL Dev Task Done Kevin Reid (Inactive)

          100%
          Original Estimate - 21h
          Time Spent - 19h Time Not Required

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                Corey.Amend Corey Amend (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 23h
                  23h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 19h Time Not Required
                  19h

                    PagerDuty

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