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

            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]
            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?
            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
            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
            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
            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
            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
            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  
            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
            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
            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

              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