New Features 2017Project Type: software

New Features 2017

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

CLONE - COSR - Billing Adjustment Issue

    Details

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

      Description

      Please see the issue below. I have attached the pre bill and the steps they followed. Please correct the billing table

      The Active Anthem rates are Self Insured. Two of the component’s rates needed to be changed back to 5/1 (when BCC took over the group). I went into the system and successfully adjusted the rates for all Active Anthem plans. I ran the August Invoice to make sure all adjustments (May – July) would be accounted for. While reviewing the July Adjustments I noticed that if an individual had a future term date in the system (ie: the group went into the system 6/20 and put in a termination date of 7/7 for an EE) the system correctly credited the EE but never re-billed the Medical rate for July. This affected 4 Employees:

      Debra Bagley

      Harry Cheng

      Judy Maral

      Mitchell Moore

        Attachments

          Issue Links

          clones

          Bug - A problem which impairs or prevents the functions of the product. WT-9973 COSR - Billing Adjustment Issue

          • High - Serious problem that could block progress.
          • Closed

            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-9973 [ WT-9973 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ]
            Component/s UI Refresh [ 10902 ]
            Component/s BenAdmin [ 10000 ]
            Environment_Old Stage [ 10004 ]
            Key WT-12298 NF-5132
            Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Debbie Kulling [ dkulling ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            harshada.borole Harshada Borole (Inactive) made changes -
            Dev Due Date 12/Jul/2017 24/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)
            harshada.borole Harshada Borole (Inactive) made changes -
            Code Review Date 24/Nov/2017
            Hide
            Permalink
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are 3C's :-
            Concern :- Incorrect adjustment when there is cost change and election termination on mid of same month.
            Cause :- Billing policies were not handled properly for mid month term and cost change on same month
            Correction :- Handled above scenario

            Affected Areas :-
            All retro term adjustment

            Affected File :- OES_SP_GetRetroBillingDetails_InvoiceBenefitWise

            Tested Scenarios :-
            Retro term and cost change on same month
            1) Mid month term - on month equal to billing month
            2) Mid month term - on prior to billing month
            3) Mid month term - on later to billing month
            4) End of month termination - with above 3 conditions
            5) Add, term and cost change all on same month
            Tested above scenarios with all billing policies - Bill for entire month, Premiums Waived Prior the Cut-Off Day,Premiums are Prorated

            Note :- This ticket needs regression testing for retro term scenario with cost change

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are 3C's :- Concern :- Incorrect adjustment when there is cost change and election termination on mid of same month. Cause :- Billing policies were not handled properly for mid month term and cost change on same month Correction :- Handled above scenario Affected Areas :- All retro term adjustment Affected File :- OES_SP_GetRetroBillingDetails_InvoiceBenefitWise Tested Scenarios :- Retro term and cost change on same month 1) Mid month term - on month equal to billing month 2) Mid month term - on prior to billing month 3) Mid month term - on later to billing month 4) End of month termination - with above 3 conditions 5) Add, term and cost change all on same month Tested above scenarios with all billing policies - Bill for entire month, Premiums Waived Prior the Cut-Off Day,Premiums are Prorated Note :- This ticket needs regression testing for retro term scenario with cost change
            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 below scenarios :-
            Retro term and cost change on same month
            1) Mid month term - on month equal to billing month
            2) Mid month term - on prior to billing month
            3) Mid month term - on later to billing month
            4) End of month termination - with above 3 conditions
            5) Add, term and cost change all on same month
            Also tested above scenarios with all billing policies - Bill for entire month, Premiums Waived Prior the Cut-Off Day,Premiums are Prorated

            Working fine as expected.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested below scenarios :- Retro term and cost change on same month 1) Mid month term - on month equal to billing month 2) Mid month term - on prior to billing month 3) Mid month term - on later to billing month 4) End of month termination - with above 3 conditions 5) Add, term and cost change all on same month Also tested above scenarios with all billing policies - Bill for entire month, Premiums Waived Prior the Cut-Off Day,Premiums are Prorated Working fine as expected. 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: On Hold(10211)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 05/Dec/17 10:14 AM
            • Time Spent:
              5.5h
               

              Testing on Codemap

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 6h [ 21600 ]
            Original Estimate 0h [ 0 ] 6h [ 21600 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 0.5h [ 1800 ]
            Time Spent 5.5h [ 19800 ]
            Worklog Id 94708 [ 94708 ]
            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: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 15/Mar/18 11:50 AM - edited
            • Time Spent:
              5.25h
               
              <No comment>
            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 -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 5.5h [ 19800 ] 9.5h [ 34200 ]
            Worklog Id 108522 [ 108522 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested below scenarios on Production :-

            Retro term and cost change on same month
            1) Mid month term - on month equal to billing month
            2) Mid month term - on prior to billing month
            3) Mid month term - on later to billing month
            4) End of month termination - with above 3 conditions
            5) Add, term and cost change all on same month
            Also tested above scenarios with all billing policies - Bill for entire month, Premiums Waived Prior the Cut-Off Day,Premiums are Prorated

            Working fine as expected.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested below scenarios on Production :- Retro term and cost change on same month 1) Mid month term - on month equal to billing month 2) Mid month term - on prior to billing month 3) Mid month term - on later to billing month 4) End of month termination - with above 3 conditions 5) Add, term and cost change all on same month Also tested above scenarios with all billing policies - Bill for entire month, Premiums Waived Prior the Cut-Off Day,Premiums are Prorated Working fine as expected.
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 9.5h [ 34200 ] 10.75h [ 38700 ]
            Worklog Id 108522 [ 108522 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            		3d 23h 48m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		1d 23h 9m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		23d 2h 21m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            		83d 5m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		3h 1m 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		41s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              jyoti.agrawal Jyoti Agrawal (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 6h Original Estimate - 6h
                  6h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10.75h
                  10.75h