-
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
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
- relates to
-
WT-7374 Export > Mapped field names get changed on Provideriwse Billing Data export template
-
- Production Complete
-
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
Hi Prasanna Karlekar
Getting Approval from Client. I will get back to you soon.
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
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
Thank you so much, I have informed Scott about it.