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

Day Track Report - Update Report to accept 0 Benchmark hours from Web Service

    Details

    • Sprint:
      CFAMX 2019R3 Sprint 5
    • SCRUM Team:
      Brotherhood of Mutants
    • SOW (Time Tracking) Project:
      44918
    • Work Type Classification:
      Sustaining

      Description

      As a store manager I want to be able to successfully run the Day Track Report, with zero benchmark hours coming from the Web Service, so that I view the report

      Notes

      • The benchmark hours have been set to zero for all FSU stores in the Testing Web Service (JAT uses the CFA Testing Endpoint)
      • Note from CFA:
        • For example stores 01919 & 02693 will pull back zero benchmark hours, and when they do the report fails:
      • Other store types, such as Mall (00198) do return data in JAT
      • AC from Feature:
        • As a BA on the Payroll & Labor team, I can set the constants (Daily Sales Minimum, BPR Above Minimum, and Minimum Staffing Hours) to 0 in Oracle, and the DayTrack report generates with the following columns empty of all values: Labor Hours Used, Benchmark Hours, Labor Cost Opportunity $, Labor Cost Opportunity %, Actual Labor Cost %, Hours Difference, Actual Productivity Rate, Benchmark Productivity Rate, and Average Wage Rate.
        • When I set the constants to 0 in Oracle, the DayTrack report looks just like the DayTrack report for a Dwarf House.
          • Sample DH report

      Acceptance Criteria

      1. Confirm that Day Track Report displays correctly, with blank columns (like DH stores) when zeros are received from the CFA Web Service
      2. Confirm that the Day Track Report displays data accurately for days when the benchmark hours are returned not as zero (regression testing)

        Attachments

        1. image-2019-05-28-07-34-11-792.png
          image-2019-05-28-07-34-11-792.png
          31 kB
        2. image-2019-05-28-08-06-57-305.png
          image-2019-05-28-08-06-57-305.png
          482 kB
        3. image-2019-05-28-08-16-54-462.png
          image-2019-05-28-08-16-54-462.png
          219 kB
        4. image-2019-05-28-15-11-23-516.png
          image-2019-05-28-15-11-23-516.png
          139 kB
        5. image-2019-05-28-15-11-39-633.png
          image-2019-05-28-15-11-39-633.png
          11 kB
        6. screenshot-1.png
          screenshot-1.png
          248 kB
        7. screenshot-2.png
          screenshot-2.png
          89 kB
        8. screenshot-3.png
          screenshot-3.png
          13 kB

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 36h
                  36h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 26.75h Time Not Required
                  26.75h

                    PagerDuty

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