Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-7353

Export fields. city of walnut Creek.

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Client
    • Company:
      City of Walnut Creek
    • Module:
      BenAdmin

      Description

      hi Experts
      Vijay Siddha

      Client Request: Any advise is appreciated.

      Hi Debbie,

      We ran a Providerwise Export file template called “Providerwise Extract File” on group “City of Walnut Creek” for the January, 2017 invoice that’s been finalized, but it’s not picking up the self-funded components Provider Number (which contains our internal provider vendor number). It’s picking up the Benefit Provider on the plan instead of the various self-funded components providers on the rates. For example, the “Blue Shield HMO-Medical-Blue Shield” plan is passing the Blue Shield benefit provider number of 06547-0008 instead of the various providers listed in the self-funded components. I originally mapped “BillingDataFields Providerwise Vendor Number”, but when I save it & come back into the template, it switches the name to “Enrollment Providerwise Vendor Number”. I don’t know if that makes a difference, but there isn’t another vendor number to choose from in the list, so I’m assuming it’s the one we’re supposed to be using, but it’s not using the self-funded components vendor(s) when the benefit plan is self-funded. We really need to get the January bill set up in our accounting system – is there any way we can get someone to look at it & see if it can be fixed in live pretty quickly?

      Thanks,

      Scott DeRousse | AVP, IT Engineering

        Attachments

          Issue Links

            Activity

            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Monika Demla,

            We have checked this from our side and below are the 3Cs

            Concern : Provider Wise export file not picking up the self-funded components Provider Number. It’s picking up the Benefit Provider on the plan instead of the various self-funded components providers on the rates.

            Cause : For Provider Wise Export , all data picked up from invoice details including self insured cost & respective self insured provider. But currently invoice saves only plan providers. Due to that only plan providers exporting on file.

            Correction : For this we need code changes for Invoice to store provider id from self insured components.

            Also, The field names BillingDataFields Providerwise Vendor Number and 'Enrollment Providerwise Vendor Number' are same. Field names changing doesn't have any impact on data getting exported on file. We have created WT-7374 for this UI issue and will be deployed on production as per patch process.

            Thanks,
            Aniruddha Dev

            CC – Vinayak Kulkarni , Ganesh Sadawarte , Rakesh Shahane , Rohan J Khandave
            , Prasanna Karlekar , Aditya Vishwakarma Hrishikesh Deshpande

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Monika Demla , We have checked this from our side and below are the 3Cs Concern : Provider Wise export file not picking up the self-funded components Provider Number. It’s picking up the Benefit Provider on the plan instead of the various self-funded components providers on the rates. Cause : For Provider Wise Export , all data picked up from invoice details including self insured cost & respective self insured provider. But currently invoice saves only plan providers. Due to that only plan providers exporting on file. Correction : For this we need code changes for Invoice to store provider id from self insured components. Also, The field names BillingDataFields Providerwise Vendor Number and ' Enrollment Providerwise Vendor Number ' are same. Field names changing doesn't have any impact on data getting exported on file. We have created WT-7374 for this UI issue and will be deployed on production as per patch process. Thanks, Aniruddha Dev CC – Vinayak Kulkarni , Ganesh Sadawarte , Rakesh Shahane , Rohan J Khandave , Prasanna Karlekar , Aditya Vishwakarma Hrishikesh Deshpande
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Monika Demla,

            Currently while generating invoice, for self insured components, plan provider is getting saved.
            We will be modifying the logic to save the provider as per the self Insured component. Changing and deploying this will take 2-3 days. As of now, we can correct the data in Invoice table. After which, cost will appear as per the component provider and not the plan provider.

            Please let us know, if we can do the correction.

            cc: Rohan J Khandave, Aniruddha Dev, Vinayak Kulkarni, Rakesh Shahane, Alankar Chavan

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Monika Demla , Currently while generating invoice, for self insured components, plan provider is getting saved. We will be modifying the logic to save the provider as per the self Insured component. Changing and deploying this will take 2-3 days. As of now, we can correct the data in Invoice table. After which, cost will appear as per the component provider and not the plan provider. Please let us know, if we can do the correction. cc: Rohan J Khandave , Aniruddha Dev , Vinayak Kulkarni , Rakesh Shahane , Alankar Chavan
            Hide
            Monika.Demla Monika Demla (Inactive) added a comment -

            Hi Prasanna Karlekar
            Getting Approval from Client. I will get back to you soon.

            Show
            Monika.Demla Monika Demla (Inactive) added a comment - Hi Prasanna Karlekar Getting Approval from Client. I will get back to you soon.
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Monika Demla,

            As per our discussion with Debbie Kulling yesterday. We have done correction for Self Insured Component and verified on Provider Wise export templates on City of Walnut Creek and Community Development Commission companies on Production.

            Files are now exporting with respective providers.

            Please let us know in case of any queries.

            CC: Debbie KullingGanesh SadawarteRohan J KhandaveVinayak KulkarniRakesh ShahaneHrishikesh Deshpande

            Thanks & Regards,
            Aniruddha Dev

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Monika Demla , As per our discussion with Debbie Kulling yesterday. We have done correction for Self Insured Component and verified on Provider Wise export templates on City of Walnut Creek and Community Development Commission companies on Production. Files are now exporting with respective providers. Please let us know in case of any queries. CC: Debbie Kulling Ganesh Sadawarte Rohan J Khandave Vinayak Kulkarni Rakesh Shahane Hrishikesh Deshpande Thanks & Regards, Aniruddha Dev
            Hide
            Monika.Demla Monika Demla (Inactive) added a comment -

            Thank you so much, I have informed Scott about it.

            Show
            Monika.Demla Monika Demla (Inactive) added a comment - Thank you so much, I have informed Scott about it.

              People

              Assignee:
              Monika.Demla Monika Demla (Inactive)
              Reporter:
              Monika.Demla Monika Demla (Inactive)
              Account Executive:
              Vijay Siddha (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 6.5h
                  6.5h