Hi Debbie Kulling,

Could you please let us know is this relates to report or export?

Thanks,
Ganesh

This is the providerwise export that goes with the new invoice management for BCC

Hi Aniruddha Dev,
Could you please verify this from your end?, if anything required please let us know.

CC-Rohan J Khandave, Vinayak Kulkarni, Ganesh Sadawarte, Hrishikesh Deshpande

Hi Debbie Kulling,

We checked Providerwise Extract File Template on City of Walnut Creek and Community Development Commission companies on Production and below are our findings

1) We have checked Invoice Amount and Total Billed Amount exported on Provider Wise Export file . Both are matching ($414005.34)
Self Insured Component amounts will not export separately on provider wise file . It gets combined with Total Amount and export provider wise for specific benefit types.

2) We also found that Data Transformation for 'Benefit Type' field was not proper on both these companies. (PFA screenshots for Original DTS) so file was getting exported with improper benefit type names against total amounts.
we have corrected these data transformations for 'Benefit Type' field on Providerwise Extract File Template of City of Walnut Creek and Community Development Commission companies on Production . Now file will export with proper benefit type names (PFA screenshots for Corrected DTS on both companies)

3) We have pulled Providerwise Extract File from City of Walnut Creek TEST company on Production. (PFA Providerwise Extract File_CWC_HSPL.xls ) . Please go through the same and let us know in case of any queries.

Note:

• Data Transformations on Billing Data Type export templates should be checked always when these templates are cloned from one company to another.
• Also Provider Name will not export on file as Providerwise Benefit Provider Name field is not mapped on subtemplate

CC: Rohan J Khandave Hrishikesh Deshpande Vinayak Kulkarni Ganesh Sadawarte Rakesh Shahane

Thanks & Regards,
Aniruddha Dev

This is a HUGE issue. The whole point of the provider wise export was for the self insured components to export on that file. It does no good for the export to only show by benefit type

Hi Debbie Kulling,

This issue is similar to WT-7353.

Concern:
The self-insured components are not exporting on the provider wise export. It is just showing the amounts by benefit type.

Cause:
Currently while generating invoice, for self insured components, plan provider is getting saved in database. While exporting, provider value from database is getting referred which is currently of plan provider.

Correction:
We are working on the fix to save the self insured component providers in database wherever required. This fix will need a day or two to get tested and deployed on Production.

There are following solutions:

• After fix getting deployed, regeneration of invoices will be required.
• Making change in export logic to fetch the respective self insured component provider. Same way as we do while editing cost on UI.
• Doing corrections for already generated invoices. This will avoid regeneration of invoices and change in export logic as this issue will get fixed in 1-2 days. We have correction script ready which will set the proper provider value for self insured components.

Have replied the same to Monika and we are waiting for the approval on corrections. Will do the corrections immediately after getting the approval.Please let us know which solution works for you.

cc: Monika Demla, Ganesh Sadawarte, Rohan J Khandave, Vinayak Kulkarni, Aniruddha Dev, Rakesh Shahane, Hrishikesh Deshpande

Hi Debbie Kulling,

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:Monika DemlaGanesh SadawarteRohan J KhandaveVinayak KulkarniRakesh ShahaneHrishikesh Deshpande

Thanks & Regards,
Aniruddha Dev

Hi Debbie Kulling,

We are also working on the fix to save proper provider while generating the invoice.
It will get deployed on Stage by 3rd Jan 2017.

cc: Alankar Chavan, Hrishikesh Deshpande

Hi Hrishikesh Deshpande,

We have given the fix to save proper providers for Self Insured Components while generating the invoice.

cc: Aniruddha Dev

Hi Aniruddha Dev,

Provider name for following scenarios needs to be verified for past and future date:

• Invoice with Self Insured Component (Component Provider)
• Invoice with Billed rate (Plan Provider)
• Non Health Benefit Invoice (Plan Provider)

Verified this fix on LB on Test Company for Health and Life plans for past and future dates for following

1) Invoice with Self Insured Component (Component Provider) - Vision plan
2) Invoice with Billed rate (Plan Provider) - Medical
3) Non Health Benefit Invoice (Plan Provider) - Life and AD&D Plans

Providerwise export Files have proper provider names on the file for the respective finalized invoices .
Working as expected . Ready for Stage

CC: Prasanna Karlekar Hrishikesh DeshpandeRakesh ShahaneRohan J KhandaveVinayak Kulkarni

Verified the fix on stage 'City of Walnut creek for HSPL' by generating and finalizing invoice January 2017 and running Providerwise Export manually for below benefit types.

• Admin
• Dental
• Medical
• vision

Files are now exporting with respective providers along with proper amount. Ready for production.

CC : Prasanna Karlekar

Hi Debbie Kulling,

We have deployed and verified the fix to save proper providers while generating the invoice on Production . Files are now exporting with respective providers along with proper amount for the finalized inovoice.

Please check this at your end and close this JIRA.

Let us know in case of any queries.

Regards,
Aniruddha Dev

CC:Prasanna Karlekar Hrishikesh Deshpande Vinayak Kulkarni Rohan J Khandave Ganesh Sadawarte Rakesh Shahane