New Features 2017Project Type: software

New Features 2017

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

County of Sutter-Invoice Adjustment Errors

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Others
    • Bug Severity:
      Medium
    • Module:
      BenAdmin
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Ready for Production
    • Issue Importance:
      Must Have

      Description

      Hello,
      Per the client: County of Sutter has notified BCC they are having an issue with the billing adjustments on their August invoice (please see attached).

      We have looked into the issue with Harminder Dosanjh:
      1. Beginning May 1, 2017 when BCC begins administration of COSR, Employee is enrolled in the Anthem PPO 500 plan as Employee + 1 Child (Rate $1,463.00)
      2. On June 20, 2017 QE Add Newborn occurs, takes the Anthem PPO 500 plan enrollment to Employee + 2 Children (Rate $2,072.00)
      3. Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
      a. Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
      b. Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
      4. The August invoice incorrectly credits the June premium.
      5. The August invoice does correctly credit and bill the July adjustments
      6. The August invoice does correctly bill for the month of August
      Kenya Olivas is having the exact same issue as Harminder Dosanjh
      a. EE has been effective since 5/1/17 on the Anthem PPO 1000 plan with EE + SP + 2+ Children on the plan (Rate $1,698.00)
      b. On 6/23/17 QE Add Newborn was initiated for a baby born 5/24/17. This has no effect on the enrollment level as the EE already has 2+ Children on the plan
      c. Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
      i. Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
      ii. Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
      d. The August invoice incorrectly credits the May premium
      e. The August invoice does correctly credit and bill the June and July adjustments
      f. The August invoice does correctly bill for the month of August

      Could you please have your development team look into this ASAP, the group is extremely unhappy with their invoices.

        Attachments

          Issue Links

          clones

          Bug - A problem which impairs or prevents the functions of the product. WT-11244 County of Sutter-Invoice Adjustment Errors

          • Medium - Has the potential to affect progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            jyoti.agrawal Jyoti Agrawal (Inactive) created issue -
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones WT-11244 [ WT-11244 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Dev Due Date 27/Nov/2017
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            Permalink
            harshada.borole Harshada Borole (Inactive) added a comment -

            For 3C's please refer linked jira WT-11244

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - For 3C's please refer linked jira WT-11244
            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)
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Sachin Hingole [ sachin.hingole ]
            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)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested the below scenarios. System not working as per expectation for Non health plans.

            Working Fine for below scenarios :-
            1) Health benefits
            a)Self Insured rate - Change in cost and tier, when change in tier doesnt really effect tier id
            Tier change and cost change in same month of enrollment
            Tier change and cost change in different month of enrollment
            b) Billed rate
            Tier change and cost change in same month of enrollment
            Tier change and cost change in different month of enrollment

            Failed for below scenarios
            2)Non health benefits :-
            Coverage change and cost change in same month
            Coverage change and cost change in diff month

            REOPEN

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested the below scenarios. System not working as per expectation for Non health plans. Working Fine for below scenarios :- 1) Health benefits a)Self Insured rate - Change in cost and tier, when change in tier doesnt really effect tier id Tier change and cost change in same month of enrollment Tier change and cost change in different month of enrollment b) Billed rate Tier change and cost change in same month of enrollment Tier change and cost change in different month of enrollment Failed for below scenarios 2)Non health benefits :- Coverage change and cost change in same month Coverage change and cost change in diff month REOPEN Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Jyoti Agrawal [ jyoti.agrawal ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 04/Dec/17 09:36 AM - edited
            • Time Spent:
              5h
               

              Testing on Codemap

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ]
            Original Estimate 4h [ 14400 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 94541 [ 94541 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 27/Nov/2017 05/Dec/2017
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 4h [ 14400 ] 5h [ 18000 ]
            Worklog Id 94541 [ 94541 ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 04/Dec/17 01:09 PM
            • Time Spent:
              2h
               

              Discussion with Venkatesh
              Analysis of the issue

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 5h [ 18000 ] 7h [ 25200 ]
            Worklog Id 94586 [ 94586 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Prasanna Karlekar [ prasanna ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 05/Dec/17 10:43 AM
            • Time Spent:
              2h
               

              Unit testing,discussion with prasanna

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 7h [ 25200 ] 9h [ 32400 ]
            Worklog Id 94712 [ 94712 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 05/Dec/17 11:00 PM
            • Time Spent:
              0.5h
               

              Issue discussion

            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Non Health related issue #2 mentioned in above comment is same as WT-11691.
            For 3C's, please refer WT-11691.

            Thank you!

            cc: Jyoti Agrawal

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Non Health related issue #2 mentioned in above comment is same as WT-11691 . For 3C's, please refer WT-11691 . Thank you! cc: Jyoti Agrawal
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 06/Dec/17 10:00 PM
            • Time Spent:
              0.25h
               

              Code compare and check in

            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Issue Importance Must Have [ 11800 ]
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Prasanna Karlekar
            Please go ahead and check in the files once checkin window opens.

            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Prasanna Karlekar Please go ahead and check in the files once checkin window opens. Nidhi.
            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)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Kunal Kedari [ kunal.kedari ]
            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)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            This is tested on Codemap on For QA-CHMC-Azure company. The issue has been resolved for policy free in pay out only. Correct adjustments are displayed in the invoices.

            This is ready for Pre-prod.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , This is tested on Codemap on For QA-CHMC-Azure company. The issue has been resolved for policy free in pay out only. Correct adjustments are displayed in the invoices. This is ready for Pre-prod. Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 9h [ 32400 ] 11h [ 39600 ]
            Worklog Id 97974 [ 97974 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 27/Dec/17 06:07 PM
            • Time Spent:
              2h
               

              Testing on Codemap

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            This is tested on Pre-prod on City of SSF For HSPL company. The issue has been resolved for policy free in pay out only. Correct adjustments are displayed in the invoices.

            This is ready for Production.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , This is tested on Pre-prod on City of SSF For HSPL company. The issue has been resolved for policy free in pay out only. Correct adjustments are displayed in the invoices. This is ready for Production. Thanks, Venkatesh
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 28/Dec/17 02:52 PM
            • Time Spent:
              2h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 11h [ 39600 ] 13h [ 46800 ]
            Worklog Id 98393 [ 98393 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 13h [ 46800 ] 13.5h [ 48600 ]
            Worklog Id 99102 [ 99102 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 13.5h [ 48600 ] 13.75h [ 49500 ]
            Worklog Id 99105 [ 99105 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            This is tested on Prod on Affco For HSPL company. The issue has been resolved for policy free in pay out only. Correct adjustments are displayed in the invoices.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - This is tested on Prod on Affco For HSPL company. The issue has been resolved for policy free in pay out only. Correct adjustments are displayed in the invoices.
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 13/Mar/18 12:46 PM
            • Time Spent:
              2h
               

              Testing on production

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 13.75h [ 49500 ] 15.75h [ 56700 ]
            Worklog Id 108132 [ 108132 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            		4d 2h 27m 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Reopen in Local
            		5d 7h 8m 1
            Jyoti Agrawal (Inactive) made transition -
            Reopen in Local In Development
            		8m 30s 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		19d 23m 2
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Stage Testing
            		6d 18h 39m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            		74d 23h 34m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		43m 48s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		3s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              jyoti.agrawal Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 15.75h
                  15.75h