Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-647

Kittitas County - Providerwise file Issue

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Labels:
      None
    • Environment:
      Production
    • Categories:
      Report - Invoice Management
    • Company:
      Kittitas County
    • Reported by:
      White Label
    • Caused by UI Refresh:
      Yes

      Description

      Hi,

      Per BCC: We have an issue with the providerwise file for Kittitas County. The EHCW admin fee has self-insured components, but the total premium is being allocated to the EHCW provider on the providerwise file. It is not being allocated properly across the components. The self-insured components were originally set up as nonbillable which I believe was causing the issue. We have corrected the buckets to billable and extended and recalculated the rates and it is still being allocated improperly. The April invoice cannot be posted until this is corrected so this will need corrected as soon as possible.

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Issue Links

            Activity

            Kira.Hamilton Kira Hamilton (Inactive) created issue -
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Rakesh Shahane [ rakesh.shahane ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Assignee Rakesh Shahane [ rakesh.shahane ] Vinayak Kulkarni [ vinayak.kulkarni ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Kira,

            We couldn't work on this yesterday, We will try to update you on this today, Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Kira, We couldn't work on this yesterday, We will try to update you on this today, Thanks.
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Jyoti Agrawal

            As per initial analysis, we found entries for April's invoice to be inconsistent. We will check this tomorrow, Thanks

            Amruta Lohiya [~parmeshwar.jumbade]

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jyoti Agrawal As per initial analysis, we found entries for April's invoice to be inconsistent. We will check this tomorrow, Thanks Amruta Lohiya [~parmeshwar.jumbade]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 66618 ] 2203 WB: Bugs Project Management Workflow [ 66973 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Categories Parent values: Export(18505)Level 1 values: Manual Export(18508) Parent values: Report(18507)Level 1 values: Invoice Management(18516)
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 22/Mar/18 11:31 AM
            • Time Spent:
              1.5h
               
              <No comment>
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Amruta Lohiya and Jyoti Agrawal

            Can you check this?

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Amruta Lohiya and Jyoti Agrawal Can you check this?
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Amruta Lohiya [ amruta.baheti ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 109331 [ 109331 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 22/Mar/18 01:37 PM
            • Time Spent:
              0.25h
               

              Analysis and discussion

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 1.5h [ 5400 ] 1.75h [ 6300 ]
            Worklog Id 109375 [ 109375 ]
            Hide
            dkulling Debbie Kulling added a comment -

            Can we please get an update on when this will be fixed

            Show
            dkulling Debbie Kulling added a comment - Can we please get an update on when this will be fixed
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 26/Mar/18 06:02 AM
            • Time Spent:
              2h
               

              Issue analysis

            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Debbie Kulling,

            On making Self Insured components from non-billable to billable, proper records have not been updated in Self Insured tracking tables due to which cost is not allocated properly across the components. We are still finding the root cause.

            We will do the correction and update root cause by tomorrow(3/27). 

            Thanks,

            Jyoti A.

            cc: Amruta Lohiya,Vinayak Kulkarni

             

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Debbie Kulling , On making Self Insured components from non-billable to billable, proper records have not been updated in Self Insured tracking tables due to which cost is not allocated properly across the components. We are still finding the root cause. We will do the correction and update root cause by tomorrow(3/27).  Thanks, Jyoti A. cc: Amruta Lohiya , Vinayak Kulkarni  
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Debbie Kulling,

            Below are 3C's: 
            Concern : The EHCW admin fee has self-insured components, but the total premium is being allocated to the EHCW provider on the provider-wise file.

            Cause : On changing self Insured component from non billable to billable , the component was not updated to billable in self Insured cost tracking table.

            Here, When components of EHCW admin fee was made billable, this change not was not updated properly in cost tracking table. So, component was still considered non-billable and billed rate was pulled in invoice. This entire cost was getting allocated to the benefit provider i.e ,EHCW. Since providerwise file pulls data as per data in invoice, it showed all cost allocated to EHCW.

            Correction : This issue was already fixed in WT-11007. The code check-in was missed in new build. We will deploy it in new environment ASAP.

            For now we have done the data correction in Kittitas county main company. Please regenerate invoice to see the changes in providerwise file.
            Please note : Components were made billable from non-billable and this was effective from 01/01/2018. Therefore, April invoice will return all cost to EHCW which was taken in earlier month invoices and new cost will be allocated across the components. Due to this you will see adjustments from Jan-March in April invoice for enrollments in EHCW Admin. But the aggregate cost will make no difference as credits and bills are same.

            Thanks,

            Jyoti Agrawal

            cc: Amruta Lohiya,Vinayak Kulkarni,Kira Hamilton

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Debbie Kulling , Below are 3C's:  Concern : The EHCW admin fee has self-insured components, but the total premium is being allocated to the EHCW provider on the provider-wise file. Cause : On changing self Insured component from non billable to billable , the component was not updated to billable in self Insured cost tracking table. Here, When components of EHCW admin fee was made billable, this change not was not updated properly in cost tracking table. So, component was still considered non-billable and billed rate was pulled in invoice. This entire cost was getting allocated to the benefit provider i.e ,EHCW. Since providerwise file pulls data as per data in invoice, it showed all cost allocated to EHCW. Correction : This issue was already fixed in WT-11007 . The code check-in was missed in new build. We will deploy it in new environment ASAP. For now we have done the data correction in Kittitas county main company. Please regenerate invoice to see the changes in providerwise file. Please note : Components were made billable from non-billable and this was effective from 01/01/2018. Therefore, April invoice will return all cost to EHCW which was taken in earlier month invoices and new cost will be allocated across the components. Due to this you will see adjustments from Jan-March in April invoice for enrollments in EHCW Admin. But the aggregate cost will make no difference as credits and bills are same. Thanks, Jyoti Agrawal cc: Amruta Lohiya , Vinayak Kulkarni , Kira Hamilton
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 27/Mar/18 06:05 AM
            • Time Spent:
              5h
               

              Root cause finding

              Data correction

              Internal discussion

              Invoice verification

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 1.75h [ 6300 ] 3.75h [ 13500 ]
            Worklog Id 110356 [ 110356 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 3.75h [ 13500 ] 8.75h [ 31500 ]
            Worklog Id 110375 [ 110375 ]
            Hide
            dkulling Debbie Kulling added a comment -

            BCC has confirmed that the correction for Kittitas.  Please notify me when the fix is release to production

            Show
            dkulling Debbie Kulling added a comment - BCC has confirmed that the correction for Kittitas.  Please notify me when the fix is release to production
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue relates to WT-11007 [ WT-11007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Caused by UI Refresh Yes [ 18590 ]
            Root Cause Deployment [ 18428 ]
            Original Estimate 0h [ 0 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Status In Development [ 10007 ] In LB Testing [ 10200 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 03/Apr/18 06:14 AM
            • Time Spent:
              0.5h
               

              Code deployment in LB and Pre Prod

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Status In LB Testing [ 10200 ] IN Pre-prod Testing [ 11500 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 8.75h [ 31500 ] 9.25h [ 33300 ]
            Worklog Id 111399 [ 111399 ]
            Hide
            dkulling Debbie Kulling added a comment -

            when will this be release to production

            Show
            dkulling Debbie Kulling added a comment - when will this be release to production
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 05/Apr/18 04:27 AM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            I have tested this fix on Codemap and Preprod. Please could you look into the below issue :- 

            Created a Self Insured rate with 3 billable components. Cost for each component is 50$. Now mapped this rate to a Self Insured Plan. Next enrolled an EE in this plan with effective date as 04/01/2018. Generated an Invoice of July 2018 considering the above plan . Observe the Billing Details and Adjustment details for this EE. Invoice displays correct Adjustment details for April,May,June as 150 $ and Billing details as 150$. Now make one billable component as Non-Billable. Generate the Invoice for August 2018. We observe that the new sum up of billable components is correctly charged on the August Invoice and also credits of 150 $ is given back to the EE as Adjustment but new amount is not charged to the EE as adjustment for April,May,June,July 2018 months.

            Sachin Hingole

            REOPEN

            Thanks,

            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , I have tested this fix on Codemap and Preprod. Please could you look into the below issue :-  Created a Self Insured rate with 3 billable components. Cost for each component is 50$. Now mapped this rate to a Self Insured Plan. Next enrolled an EE in this plan with effective date as 04/01/2018. Generated an Invoice of July 2018 considering the above plan . Observe the Billing Details and Adjustment details for this EE. Invoice displays correct Adjustment details for April,May,June as 150 $ and Billing details as 150$. Now make one billable component as Non-Billable. Generate the Invoice for August 2018. We observe that the new sum up of billable components is correctly charged on the August Invoice and also credits of 150 $ is given back to the EE as Adjustment but new amount is not charged to the EE as adjustment for April,May,June,July 2018 months. Sachin Hingole REOPEN Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Jyoti Agrawal [ jyoti.agrawal ]
            Status IN Pre-prod Testing [ 11500 ] In Development [ 10007 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 9.25h [ 33300 ] 11.25h [ 40500 ]
            Worklog Id 111490 [ 111490 ]
            satyap Satya made changes -
            Sprint Carry Over from Sprint 45 [ 108 ]
            satyap Satya made changes -
            Rank Ranked higher
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - - edited

            Hi Venkatesh Pujari,

            The issue you have mentioned above is already logged in WT-12838. We will be considering this on upcoming sprint or restructuring.

            In this Jira we have resolved issue for non-billable to billable. Please check this scenario

            Thanks,

            Jyoti A.

            cc:Amruta Lohiya

             

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - - edited Hi Venkatesh Pujari , The issue you have mentioned above is already logged in  WT-12838 . We will be considering this on upcoming sprint or restructuring. In this Jira we have resolved issue for non-billable to billable. Please check this scenario Thanks, Jyoti A. cc: Amruta Lohiya  
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Venkatesh Pujari [ venkatesh.pujari ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 2203 WB: Bugs Project Management Workflow [ 66973 ] 0604 Issues Management Workflow [ 68247 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] LB Deployed [ 11600 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status LB Deployed [ 11600 ] In LB Testing [ 10200 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In LB Testing [ 10200 ] Ready for Pre-Prod [ 11615 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Ready for Pre-Prod [ 11615 ] Pre-Prod Deployed [ 11601 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pre-Prod Deployed [ 11601 ] IN Pre-prod Testing [ 11500 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status IN Pre-prod Testing [ 11500 ] Ready for Production [ 10024 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 06/Apr/18 04:46 AM - edited
            • Time Spent:
              3h
               
              <No comment>
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified your fix on Preprod. The system is displaying correct adjustments for changing a component from Non-Billable to Billable. This is good to be deployed on Production.

            Sachin Hingole

            Thanks,

            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified your fix on Preprod. The system is displaying correct adjustments for changing a component from Non-Billable to Billable. This is good to be deployed on Production. Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 11.25h [ 40500 ] 13.75h [ 49500 ]
            Worklog Id 111595 [ 111595 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 06/Apr/18 05:46 AM
            • Time Spent:
              1.5h
               

              Issue analysis

              Code check-in in prod

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 13.75h [ 49500 ] 15.25h [ 54900 ]
            Worklog Id 111625 [ 111625 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 15.25h [ 54900 ] 15.75h [ 56700 ]
            Worklog Id 111595 [ 111595 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Status Ready for Production [ 10024 ] Production Deployed [ 10025 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Deployed [ 10025 ] In Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status In Production Testing [ 10202 ] In Production Review [ 11501 ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified your fix on Production. The system is displaying correct adjustments for changing a component from Non-Billable to Billable.

            Sachin Hingole

            Thanks,

            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified your fix on Production. The system is displaying correct adjustments for changing a component from Non-Billable to Billable. Sachin Hingole Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Kira Hamilton,

            The issue has been resolved and also verified on Production. Please could you verify and close this ticket.

            Sachin Hingole

            Thanks,

            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Kira Hamilton , The issue has been resolved and also verified on Production. Please could you verify and close this ticket. Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Kira Hamilton [ kira.hamilton ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 09/Apr/18 12:35 AM
            • Time Spent:
              0.5h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 15.75h [ 56700 ] 16.25h [ 58500 ]
            Worklog Id 111735 [ 111735 ]
            Hide
            Kira.Hamilton Kira Hamilton (Inactive) added a comment -

            Hi Venkatesh Pujari,

            Per BCC: I posted the May invoice for Kittitas today and the providerwise appears to be all good in production

             

            Thank you,

            Kira Hamilton

            Debbie Kulling

            Show
            Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hi Venkatesh Pujari , Per BCC:  I posted the May invoice for Kittitas today and the providerwise appears to be all good in production   Thank you, Kira Hamilton Debbie Kulling
            Kira.Hamilton Kira Hamilton (Inactive) made changes -
            Status In Production Review [ 11501 ] Closed [ 6 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint Carry Over from Sprint 46 [ 113 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Rank Ranked higher
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint WB - Sprint 50 [ 116 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint WB - Sprint 50 [ 116 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Root Cause Deployment [ 18428 ] Coding Error [ 19002 ]
            Transition Time In Source Status Execution Times
            Jyoti Agrawal (Inactive) made transition -
            Open In Development
            7d 11h 3m 1
            Khandu Kshirsagar (Inactive) made transition -
            In Development In LB Testing
            6d 22h 28m 1
            Khandu Kshirsagar (Inactive) made transition -
            In LB Testing IN Pre-prod Testing
            20h 53m 1
            Venkatesh Pujari (Inactive) made transition -
            IN Pre-prod Testing In Development
            1d 3h 48m 1
            Venkatesh Pujari (Inactive) made transition -
            In Development LB Deployed
            1d 16m 1
            Venkatesh Pujari (Inactive) made transition -
            LB Deployed In LB Testing
            19s 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Ready for Pre-Prod
            4s 1
            Venkatesh Pujari (Inactive) made transition -
            Ready for Pre-Prod Pre-Prod Deployed
            3s 1
            Venkatesh Pujari (Inactive) made transition -
            Pre-Prod Deployed IN Pre-prod Testing
            4s 1
            Venkatesh Pujari (Inactive) made transition -
            IN Pre-prod Testing Ready for Production
            7s 1
            Khandu Kshirsagar (Inactive) made transition -
            Ready for Production Production Deployed
            2d 17h 49m 1
            Venkatesh Pujari (Inactive) made transition -
            Production Deployed In Production Testing
            1h 12m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing In Production Review
            46m 15s 1
            Kira Hamilton (Inactive) made transition -
            In Production Review Closed
            4d 12h 47m 1

              People

              Assignee:
              Kira.Hamilton Kira Hamilton (Inactive)
              Reporter:
              Kira.Hamilton Kira Hamilton (Inactive)
              Account Executive:
              Debbie Kulling
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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