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

            Activity

            Hide
            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
            Hide
            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
            Hide
            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
            Hide
            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.
            Hide
            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
            Hide
            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
            Hide
            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.

              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