Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5561

The Packard Companies - Billing details report - Enrollment coverage count field

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Implementation
    • Company:
      The Packard Companies
    • Item State:
      Stage QA - Production Deployment on Hold

      Description

      Hi,
      There is a field in the Billing details report that we can pull in called "Enrollment Coverage Count". Could you please let us know what that field is supposed to show? In the Packard Companies client, there is a template named "Packard Billing Details". there are people who are showing up with numbers from 1 - 6. What do these numbers represent? I don't know if this template is corrupted or not.

      I've tried creating a new report with the same parameters, and on the new report, the value in this field is showing "0". Which number is correct? Is this a field that is currently functional? Please let us know what this field should contain.

      Example: Aaron Taylor - on the template for Basic life, his number shows as "2"
      On a newly created report, his number shows a "0"

      Thank you,
      Robyn

      CC: Amannda Johnson; Ashley Marra, Sonja Burns, Jackie Sivigny, Gayle Smelansky

        Attachments

        1. Billing details report.png
          Billing details report.png
          53 kB
        2. coverage tier in report.png
          coverage tier in report.png
          34 kB
        3. Coverage Tier Label added.png
          Coverage Tier Label added.png
          51 kB
        4. cs.png
          cs.png
          52 kB
        5. EE count.png
          EE count.png
          80 kB
        6. FW Hot Fix and Development Approval Request.msg
          74 kB
        7. New report.PNG
          New report.PNG
          9 kB
        8. NF-5561_1.png
          NF-5561_1.png
          98 kB
        9. Template.PNG
          Template.PNG
          8 kB
        10. WT-12723- Issue and implementation Approach.xls
          9 kB

          Issue Links

            Activity

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) created issue -
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones WT-12723 [ WT-12723 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Component/s UI Refresh [ 10902 ]
            Component/s BenAdmin [ 10000 ]
            Key WT-12856 NF-5561
            Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            please refer WT-12723 for all details

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - please refer WT-12723 for all details
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Summary CLONE - The Packard Companies - Billing details report - Enrollment coverage count field The Packard Companies - Billing details report - Enrollment coverage count field
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Sprint WT Sprint 41 [ 95 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            Hide
            sonja.burns Sonja Burns (Inactive) added a comment -

            Hi

            The Enrollment coverage count is the plan enrollment count. Depending on the plan 1-6 could be correct. For Medical, Dental and Vision the plan count would cover the employee and any dependents that are enrolled. For the Life plans the count should be 1 since the coverage is for only 1 person. Child plans will have the number of children enrolled which is manually changed to 1.

            Show
            sonja.burns Sonja Burns (Inactive) added a comment - Hi The Enrollment coverage count is the plan enrollment count. Depending on the plan 1-6 could be correct. For Medical, Dental and Vision the plan count would cover the employee and any dependents that are enrolled. For the Life plans the count should be 1 since the coverage is for only 1 person. Child plans will have the number of children enrolled which is manually changed to 1.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Priya Dhamande [ priya.dhamande ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment Billing details report.png [ 70824 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment cs.png [ 70825 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment Coverage Tier Label added.png [ 70826 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment coverage tier in report.png [ 70827 ]
            Hide
            prasad.patil Prasad Patil (Inactive) added a comment -

            Hi [~parmeshwar.jumbade],

            Checked this issue on Codemap.

            Company: For QA-City of Bellevue-Azure
            Login: sa
            Standard ReportL: Billing Details.

            The Enrollment Coverage count is not appearing correctly on the Report when 'Coverage tier label' field is not added to the display fields

            (Please refer the screenshots below)

            However, when 'Coverage tier label' is added to the display fields, the count is appearing correctly.

            (Please refer the screenshots below)

            Request you to please look into this.
            Thank you,
            ---------------------------------------------------
            CC: Mandar Kulkarni, Satya, Sachin Hingole, Priya Dhamande

            Show
            prasad.patil Prasad Patil (Inactive) added a comment - Hi [~parmeshwar.jumbade] , Checked this issue on Codemap. Company: For QA-City of Bellevue-Azure Login: sa Standard ReportL: Billing Details. The Enrollment Coverage count is not appearing correctly on the Report when 'Coverage tier label' field is not added to the display fields (Please refer the screenshots below) However, when 'Coverage tier label' is added to the display fields, the count is appearing correctly. (Please refer the screenshots below) Request you to please look into this. Thank you, --------------------------------------------------- CC: Mandar Kulkarni , Satya , Sachin Hingole , Priya Dhamande
            prasad.patil Prasad Patil (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 27/Dec/17 12:10 PM
            • Time Spent:
              1.25h
               

              Issue analysis & fix
              Internal discussion
              JIRA update

            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi Prasad Patil,

            Above deployed changes was not working properly on code-map because data-source created for this company reports was pointing to the development DB server db (because we are using this server as development environment report also).

            Now i have deleted existing generated data-source from report server and it is working as expected.

            Request you to please look into this.

            CC: Prasanna Karlekar Gaurav Sodani Nidhi Kaul

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi Prasad Patil , Above deployed changes was not working properly on code-map because data-source created for this company reports was pointing to the development DB server db (because we are using this server as development environment report also). Now i have deleted existing generated data-source from report server and it is working as expected. Request you to please look into this. CC: Prasanna Karlekar Gaurav Sodani Nidhi Kaul
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 1.25h [ 4500 ]
            Worklog Id 98066 [ 98066 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Prasad Patil [ prasad.patil ]
            Hide
            prasad.patil Prasad Patil (Inactive) added a comment -

            Hi,

            Verified on Codemap. Working fine as expected.
            -----------------------------
            CC: Mandar Kulkarni, Satya, Prasanna Karlekar, [~parmeshwar.jumbade], Sachin Hingole

            Show
            prasad.patil Prasad Patil (Inactive) added a comment - Hi, Verified on Codemap. Working fine as expected. ----------------------------- CC: Mandar Kulkarni , Satya , Prasanna Karlekar , [~parmeshwar.jumbade] , Sachin Hingole
            prasad.patil Prasad Patil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            prasad.patil Prasad Patil (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Assignee Prasad Patil [ prasad.patil ] Sachin Hingole [ sachin.hingole ]
            prasad.patil Prasad Patil (Inactive) logged work - 27/Dec/17 01:11 PM
            • Time Spent:
              1.5h
               

              Verification on Codemap and internal discussion.

            prasad.patil Prasad Patil (Inactive) made changes -
            Time Spent 1.25h [ 4500 ] 2.75h [ 9900 ]
            Worklog Id 98103 [ 98103 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Billing Sprint_41
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Link This issue relates to WB-502 [ WB-502 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment NF-5561_1.png [ 74215 ]
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on codemap.
            Enrollment count shown properly.Working as expected.
            PFA,

            Note- The Enrollment Coverage count is not appearing correctly on the Report for some records when 'Coverage tier label' field is not added to the display fields.
            Logged issue for same as WB-502.(which is not in the scope of this jira)

            Thanks,
            Sanjana Jadhav

            CC: Prasad Pise Sachin Hingole Rakesh Roy

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on codemap. Enrollment count shown properly.Working as expected. PFA, Note- The Enrollment Coverage count is not appearing correctly on the Report for some records when 'Coverage tier label' field is not added to the display fields. Logged issue for same as WB-502 .(which is not in the scope of this jira) Thanks, Sanjana Jadhav CC: Prasad Pise Sachin Hingole Rakesh Roy
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 2.75h [ 9900 ] 4.75h [ 17100 ]
            Worklog Id 107333 [ 107333 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Worklog Id 107333 [ 107333 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 08/Mar/18 06:46 AM - edited
            • Time Spent:
              2h
               

              Testing
              Internal discussion
              Jira update
              Log issue

            Transition Time In Source Status Execution Times
            Parmeshwar Jumbad (Inactive) made transition -
            Open In Development
            1h 49m 1
            Prasad Patil (Inactive) made transition -
            In LB Testing Reopen in Local
            5d 17h 53m 1
            Parmeshwar Jumbad (Inactive) made transition -
            Reopen in Local In Development
            1h 42m 1
            Prasad Patil (Inactive) made transition -
            In Development In LB Testing
            8h 10m 2
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            1d 22h 13m 1
            Sanjana Jadhav (Inactive) made transition -
            Stage Testing In Production Testing
            67d 18h 22m 1
            Sanjana Jadhav (Inactive) made transition -
            In Production Testing Production Complete
            1h 1
            Sanjana Jadhav (Inactive) made transition -
            Production Complete Closed
            4s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              parmeshwar.jumbad Parmeshwar Jumbad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4.75h
                  4.75h