Hi Jennifer,

Can we export this files for Jan 2016 and Feb 20 16 in the first week of march . Is this ok,
if you need files before that please specify ,we can export this data any time within 2 days.

Jennifer JohnsonPlease update.

I am checking with the client to see when they need them.

Jenni

Hi Rakesh Roy,

We will need these to be posted to the FTP site (file name /users/equifax/outbound ) in the 1st week after each month. We will need the next file for March to be posted during the 1st week of April.

Let me know if this is possible.

Jenni

Nandkumar Prabhakar KarlekarVinayak KulkarniPlease update.

Hi Rakesh,

I wish I knew as I have no idea about 2016 EQUIFAX files.

Ok Vinayak Kulkarni thought you are aware.No problem, Nandkumar will update.

Sujit Chopade,Sachin Khandge

Please send the regular file of prime.

Every month first week this task should be done with reminder.

Hi Dev -

They have come back to say that the FEIN numbers are still missing. Can you research this? I need this looked at as soon as possible.

Thanks

Jenni

Hi Jennifer ,
I was looking at Jan 2016 (Employee File)
There are records with EmployerFEIN as null,Can you please provide us more details for those employee
Like which EmployerFEIN should be appeared and which classes are mapped for that EIN eligibility rule.
Need few records to test.

Thanks
Sujit

Hi Jennifer,

Can you please help us with more information.
As per our analysis there is no mapping present on EIN classes mapping page for some classes
Prime with Space - Saint Marys General Hospital,North Vista Hospital
Prime Without space - Lake Huron, Suburban Community

Please confirm that customization is present for employee records for which "EmployerFEIN" is NULL
Alos please check for other classes that EIN eligibility is mapped.

Jennifer Johnson

Can you please provide information on previous comments.

Sachin Khandge Nandkumar Prabhakar Karlekar

We are not getting update on this,this will delay the deadline committed to this task.
Please do the necessary thing

Gentle Reminder!

Sachin Khandge Nandkumar Prabhakar Karlekar Pradeep Kanojia [X]

We are Not getting any update on this ticket.
Unable to process the file this month(Prime).

Hi Jennifer Johnson
Please confirm that customization is present on both prime company(With and without space)
please check respective EIN eligibility is mapped to classes.

Thanks
Sujit

Hi David Rhodes,

Yes, we are only sending the files of 2016.

We will add these FEIN in to the respective Prime Companies and rerun these files from both prime companies for Jan,Feb, and March 2016.
We will resend these files ASAP.
Fw FEIN.msg

Sujit Chopade Please refer the Mail for the EIN.

Hi Jennifer,

we have asked for four FEINs and we have got only 2 FEIN ,there are still 2 FEIN are missing .

Missing EIN
Prime Without space Lake Huron,Suburban Community

Can you please provide the 2 remaining FEINS so we can start running the files.

Note : “NORTH VISTA MEDICAL GROUP” group is not configured in WORKTERRA.

Hi Nandkumar Prabhakar Karlekar Sujit Chopade Sachin Hingole

We have created below EIN's on Prime with Space (Production).
1.NORTH VISTA HOSPITAL - 200470861
3.Saint Marys General Hospital - 463499370.

Thanks,
Mahendra

Hi Jennifer Johnson
As per discussion in mail Mail Discussion.xls ,we do not have clear understanding ,Because the exact name of the provided EIN is not present in Workterra system(For both prime company).

Its better if you do customization at your end,to reduce confusion.

Please update the ticket with your response,and please let us know if we are ready to generate(run) the file.

Thanks
Sujit

Hi Nandkumar Prabhakar Karlekar Sujit Chopade Sachin Hingole Sachin Khandge Rakesh Roy

As we had discussed on EIN class mapping - We have deleted EIN who have none value selected in Eligibility Rule from EIN classes mapping (Prime without space company).
Please find attached list of deleted EIN."Prime_WithoutSpace_Healthcare.xls"

Thanks,
Mahendra

Hi all,
Nandkumar Prabhakar Karlekar, Sachin HingoleMahendra Mungase

As we had discussed We have verified EIN who have Eligibility Rules from EIN classes mapping (Prime with space company).

No any EIN found with None criteria

Hi Sachin Hingole

Have we completed the testing, Please deliver these files on priority.

Mahendra Mungase Smita Pawar
As discussed please verify prime files shared by Sujit.
Once done with testing please share your observations with Sujit.

Hi Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

Company Name - PrimeHealthcare For HSPL

Month - Jan 16

At the initial level testing for Employee - Wendy Hogan , Irma L Torres- Employer Cost, Employee cost and Benefit Type accepted is incorrect in shared sheet when compared with employee data in application. Please review the same and let us know.

Thanks,
Mahendra

Hi,
Sujit Chopade,Sachin HingoleMahendra Mungase, Nandkumar Prabhakar Karlekar

We have verified employees from Prime space Hspl, there is an issue in ER cost in below mentioned employees.

1.MARIE J MCILVAIN
2.Courtney Landman
3.Kelley Louden — Here is EE cost related issue also

All employees are verified from Feb 2016 Employee file.
Request you to please look into this.

Hi Sachin Hingole Mahendra Mungase Smita Pawar

Please verify the files from mail.

Hi Nandkumar Prabhakar Karlekar Sachin Hingole

We have verified below employee list on Prime without space and observed that cost are correct.

In Other observation we found that- BenefitsDecisionDate , Benefit Offer Date - Values are incorrect

For Jan
Wendy Hogan
Marko Chisnel
KACIE HANSCHU

Feb 16
JOAN PASTERNAK
SHAISTA KHURSHEED
CASEY TAYLOR

March 16
Ansamma Antony
CHANNON SMITH
CAROL TORNETTA

We have attached result sheet - "Prime_WithoutSpace.xls"

Thanks,
Mahendra

Hi
Nandkumar Prabhakar Karlekar,Sachin Hingole,Sujit Chopade

We have verified Prime with space files and are proper.

But Below are our observations.

1.We have verified EE and ER cost for Employee Tier
2. Benefit decision date is displayed in format 0:00:00
3.Benefit offered date is displayed in format 0:00:00
4.AcceptedPlanIsSelfInsured is displayed as 0 and NULL
5.Dependents & Employees SSN's are not appended with 0.

Employees verified for Prime with Space company
1.Mar: MICHELLE R LARAMEE
EULALIA M RODRIGUES
MARIA GABOT

2.Feb: TERESA BANAS
AMY B WELLNITZ
MICHELLE TONINI

3.Jan: GLENROY WAYNE WITTER
ALBERTO H SMITH DIAZ
ROSA SANTILLAN
CAROLYN BIPPUS

Note: These observations are same for Prime without Space company also.

I have formatted Prime Equifax files, Please download the files.

Jennifer Johnson

FTP Location
/users/workterraaca/Prime

Hi Sujit,

Please use the PlandesignIDs paramater value as all IsACA =1 Plans.

Abhijeet Khandagale
Can you push the 1095c sp patch as per the process for Employer cost dumping in ACA_1095 c .

Hi Nandkumar Prabhakar Karlekar
Thanks for the information.

Jennifer Johnson
Please find the files at FTP Location
/users/workterraaca/Prime

Hi Sujit Chopade,

Please upload the files on using the following for next time:

https://ftpsecure.ebsbenefits.com
equifax

Password in the mail

Please test the login and let me know.

Hi Sachin Hingole

Please make sure the Dates are in the MM/DD/YYYY format.

Thanks
Nandkumar

HI Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

We have verified Employee data using shared sheet.Please find my observation for Prime Without space

1. Employee Name - THOMAS WILDER - Incorrect Plan - PlanCodeOfferedEmployeeOnly (Excel Column) - 2016 SJ Value Plan KS but in application Plan name displayed as - "SJ Value Plan KS". Hence Plan name in excel is incorrect.
2.Employee Name - Jennifer Reutlinger - Values are correct
3.Employee Name - MELISSA DOUBLES -

PlanCodeOfferedEmployeeOnly - Value (Bronze) Plan - MonthlyCostEmployer - 675.54 - 311.78 Bi Weekly (Base On Excel)
MonthlyCostEmployeeOnly - 184.78 - 85.28 Bi Weekly (Base On Excel)

But in Application - Value (Bronze) Plan - Employer Cost - 155.89 and Employee Cost 42.64 Bi-weekly. Hence Excel costing for this plan is incorrect.
4.Employee Name - Reabecka Romero - Values are correct

=======================================================

Prime With Space
1.KERI MCGEE
2.JULIE C BRENMAN
3.CESAR VELASQUEZ

Also I have attached Result sheet for both companies.

Please let us know for more info.

Thanks,
Mahendra

Hi Sujit Chopade and Abhijeet Khandagale,

We have found that the Primewithoutspace customization Of Cobra plan is not proper. And because of that the Cobra offers are getting offered to all over the Prime.
After discussion with Jennifer F she done the customization properlt.
So we need to rerun the Jan feb,March,April files for only for the Primewithoutspace company..

Make sure that the
Primewithoutspace 4 files
With space April file

This means we need upload 5 files on the mentioned ftp in the same ticket.

This is in progress task

Please verify the shared files

Today we are busy in ACA production deployment testing. So we wont be able to verify it today.
We will start working on this on Monday (9 May 16)

Hi Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

Please find below analysis report for Jan to March. April is in progress

Jan 16

MELISSA DOUBLES - Issue fixing is in progress
KELLY I FORREST - Correct data
Terry Simmons - Correct data
Crystal Dill - Correct data

==============

Feb 16

1.Employee Name - Irma Torres - In sheet Employer Cost - 734.78 - 339.12 Bi-weekly Employee Cost -229.94 - 106.12 Bi-weekly
As per application Employee Cost - 13.85 Bi-weekly Employer Cost -208.78 Bi-weekly.Base on application - Incorrect Employee and

Employer cost in sheet.
2.Employee Name - Susan Beaver - The Employee cost for Plan - 2016 EPO Plan is Zero so this plan should be offer plan and plan cost should be populate into sheet but in sheet Plan - 2016 Value Plan values are populated.Please find attached screen shot - "FEB_Susan Beaver.jpg"
3.Employee Name - CHRISTINA MCCARRICK - Benefit Effective Date for Plan - Suburban EPO Medical - 02/01/2016 As per sheet but in Enrollment

details Report it is 01/01/2016.So Incorrect Plan effective date mentioned in excel sheet.
4.Employee Name - Catherine Chamberlain - Correct data

==============

Match 16

1.Employee Name - Leni Hillawi - Employer Inccorect cost populated into shared sheet - Plan Name- EPO Plan - 794.78 - 366.82 Bi Weekly.
It Should be 144.19 Bi-weekly / 312.41 Monthly in sheet.
2.Employee Name - Sara Piziali - Correct data
3.Employee Name - DIANE STRAHL - Correct data
4.Employee Name - RODNEY WARD - Correct data
5.Employee Name - Scott Thompson - 2016 EPO Plan is ACA plan and Employee Cost is Zero.So 2016 EPO Plan expected under column Name - PlanCodeOfferedEmployeeOnly instead of 2016 Value Plan.Please provide input on this point.Whether it is correct or not

Tomorrow we will share more details.

Please review the same and let us know.

Thanks,
Mahendra

HI Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

Please find below analysis report for April Month

1.TONI SARAGUSA-SCOTT - Correct data
2.Michael Ross - On Enroll Now Page- Plan - 2016 SJ EPO12 Plan populated with Zero cost for Employer and Employee.
Offer and Accepted Plan Name - 2016 SJ EPO12 Plan as per sheet.So Incorrect Employer and Employee cost populated in shared sheet.
3.SAMUEL SISCOE - Correct data
4.Tammy Thomas - Correct data
5. JOANNA COX - Correct data

Note- In ACA Customization safe harbor does not selected for some ACA plans.

Also we have attached pass and fail result for month wise.- "Prime_WithoutSpace_09May16.xls"

Thanks,
Mahendra

Hi Mahendra,

We are working on this for incorrect data analysis,we will deliver correct file in this week.

Hi Mahendra,
Please verify the files from mail.

Hi Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

I have review the Jan To March 16 files shared by Sujit. I found some data disturbance which i mentioned in attached - sheet - "Analysis_16May16.xls." Please review the same and update the ticket.

Below employee is reviewed.

Jan
1.DOUGLAS FELL
2.SUSAN REYNOLDS
3.MELISSA BARLOW
4. Harmeet Brar

Feb
1.JOYCE HEUER
2.HEMA JONNALAGADDA
3.MANJU GUPTA
4.DAGNY KEYES
5.Jayme Barnes

March
1.Ashley Randel
2.SHANAY BAKER
3.Valerie Lamborn
4.Malisa Moss

April 16 file review process is in progress.

Thanks,
Mahendra.

Hi Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

We have verified April 16 file for below employee and observed that file data are correct.

1.TONI SARAGUSA-SCOTT
2.Tammy Thomas
3.SAMUEL SISCOE
4.JOANNA COX

Also we have review the previously added issue and final issue list attached File name- ""Analysis_16May16.xls."

Thanks,
Mahendra

Hi Mahendra Mungase

We verified the issues you reported.Please find the new excel for inline developers comments. Analysis_16May16-Updated.xls and attached screen-shot for the same

Check latest file shared from mail.

Hi Jennifer Johnson

We have verified files for Prime Without Space and observed that it is as per expected. We will upload this files on FTP location. Sujit will update same ticket with files location.

We have attached final verified issues list with comments- "Analysis_20May16_Verified.xls"

Sujit Chopade - Please upload files on FTP server and shared path in same ticket.

Sachin Hingole Nandkumar Prabhakar Karlekar Sachin Khandge

Thanks,
Mahendra

Hi Jennifer Johnson , Mahendra Mungase
Please find the files at FTP Location
/users/workterraaca/Prime

File Name : Prime-ACA 20May2016.zip

CC : Nandkumar Prabhakar Karlekar Sachin Hingole Sachin Khandge

Working on May 2016 Prime file.(That's why reopened)

Thanks!

Hi Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

We have reviewed the Prime Without space file for May 2016 for below employee and observed that data are correct

1. SHANNON HERTLE
2. SALINA THOMAS
3. Paul Forbis
4. Sheila Johnson
5. DAWN CARRIER

Also, we have observed that - below employee enrolled in "2016 SJ EPO 12 Plan" ACA plan still, it's Plan Code accepted column is Blank

1. ANGELA BLOCK

Please review the above employee data and update the same ticket

Thanks,
Mahendra

Hi Sujit Chopade

We have attached Excel sheet- "Review_Prime_Withoutspace_08Jun16.xls" for more details.

Thanks,
Mahendra

Please verify the Prime May2016 files from mail
Files for below company

• Prime With Space May 2016 (Employee and dependent)
• Prime Without Space May 2016 (Employee and dependent)
• Prime CHMC May 2016 (Employee and dependent)

Hi Sujit Chopade Nandkumar Prabhakar Karlekar Sachin Hingole

We have reviewed the Prime CHMC file for May 2016 for below employee and observed that data are correct

1. CATHY GARVEY
2. KARINA RODRIGUEZ CASTILLO
3. FELICITAS ERIGUE
4. TANESHA JACKSON
5. AHMAD QUDAIESAT
6. PAMORNLAT JAREONTUMNUKIT
7. DALISA JOHNSON

Below employees have an issue.For more details find attachment - "Review_Prime_CHMC_09June16.xls"

1. JOMA SEBASTIAN
2. MARLINDA BRADLEY
3. NAE KIM

Please review the same and update the same

Thanks,
Mahendra

Hi Sujit Chopade

We have verified May month's file for Prime with Space company.

Issues found are as follows
1.Er cost was displaying '0' for below mentioned employees.
a.SUSAN NINAL
b.ROSALINDA A GULMAHAMAD
c.BARBARA J GONZALEZ
d.ALEXANDRA ABDELSAYED
2.In Excel File some of the employees Employer FEIN displayed as Null

Both the issues are resolved and file is as expected and verified whether

Similarly verified other employees mentioned below.
Alvin McCarthy
STEFFAN Y WALKER
SARAH RUDNIK
Quincey R Widdice

Hi Sujit Chopade

We have verified below employee for reported issue on Prime without space and observed that it's fixed.

1. RAYMOND GOSTKOWSKI
2. ANGELA BLOCK
3. CASEY TAYLOR
4. RAYMOND GOSTKOWSKI

Thanks,
Mahendra

Hi Mahendra Mungase

Please verify the provided files.

Hi Jennifer JohnsonSujit Chopade Sachin Hingole Nandkumar Prabhakar Karlekar

We have reviewed the issues for Prime CHMC on production and observed that it does not exist.Hence marking ticket status - Resolve.

Sujit Chopade - Please share files with Jenntfer.

Please let us know for any query.

Thanks,
Mahendra

Hi Jennifer Johnson

We found some issues in Prime - CHMC company,we are working on this.
This will delay completion date,we will update you soon.

Thanks,
Sujit

Thank you

Hi Jennifer Johnson , Mahendra Mungase
Please find the files at FTP Location
/users/workterraaca/Prime
File Name : Prime ACA - 20Jun2016.zip

CC : Nandkumar Prabhakar Karlekar Sachin Hingole Sachin Khandge

Thanks
Sujit

Hi All -

We had a call today to go over the outstanding concerns. We need to test with a January file and once they sign off we can send the rest.

#1 - All dates should read MM/DD/YYYY - Please update all columns with dates

#2 - COCODE should always be 5 digits - please add the leading zero's

#3 - For column I (JAN2016_EMP (005) file) they do not need NULL listed

#4 - For column R (JAN2016_EMP (005) file) all "0" should be coded to "1"

#5 - For column Q (JAN2016_EMP (005) file) if the plan is Waived, the field should be blank - no NULL's

#6 - For column U (JAN2016_EMP (005) file) - Can you add the header "Invalid" - no data is needed they just need the header

#7 - For column K (JAN2016_EMP (005) file) - They need the date the employee outed out; this should not read NULL - Also please be aware that there is no waive button but a waived plan so you can base this off the waive plans.

It also looks like the plans are not pulling the rates correctly. We need to have the rates based on PT or FT. This would be based on the rates in WT. You can also not include Suburban or Lake Huron to any files.

There are additional items that I will share with you all tomorrow.

We also need to review and possibly update some of the FEIN's - I will have those tomorrow.

Jenni
Nandkumar Prabhakar Karlekar
Jennifer Leugers

Please see comment above

JAN2016_Emp (005).xls

Working on Jan2016 File for below company
Companies to Process
Prime With Space
Prime Without Space
CHMC
Dallas Medical Center

Companies to ignore
Suburban
Lake Huron

We have received 8 files for for 4 companies of prime (Prime wit space, Prime without space, CHMC and DMC) Jan 2016 files for testing from Sujit.
We will provide more details on these files by 7th Jul.

Please note 6th July is holiday.

Hi Sujit Chopade

CC - Sachin Hingole Nandkumar Prabhakar Karlekar

We have verified Jan Files for Prime With Space and found some issues.Please download - "Verified_Employee_List_PrimeWithSpace_07July16.xls"

Please let us know once you done with fix.

Thanks,
Mahendra

FYI Nandkumar Prabhakar Karlekar, Sachin Hingole

Hi Sujit Chopade,

Below mentioned are the issues when verified file for Prime_Without_Space

1.For column R (JAN2016_EMP (005) file) all "0" should be coded to "1":but actually on file its displaying as '0'.
2.Employee SSN is printed wrongly in Dependent file of Jan-363926854-----II6II926854, Dependent SSN: II84177024, benefit decision date is also displayed as 10/1II/2015.
3.Employee ID is displayed as NULL---We need to display it as blank if its not in system.
4.Dependent suffix id displaying as Null values
5.Similarly here for this employee, "Jill Andrews"-- Workterra system displayed employee is
enrolled in Delete value plan [2015 plan] but on other hand ACA offer plan is not eligible to
employee.

Note: Same errors may be present in Prime with Space file.

Employees verified on screen are as follows and no issue observed for below mentioned employees

Genevieve H Hinks
Floriane Nendzou Fodjo
Nour Baalbaki
LARA WHETSTONE
Linda Leith
Carol Bielaniec
Angilique Lambert
Lynette Droge
MELISSA HULTMAN

Thanks,
Smita

Hi Sujit Chopade

We have verified CHMC Jan file and found some issues. Please download - "CHMC_Issues.xls" file for more details.

Thanks,
Mahendra.

FYI Nandkumar Prabhakar Karlekar, Sachin Hingole

HI Sujit Chopade,

Issues found during testing of file for "Dellas Med Center" are in line below.
1.Employee Id displayed as Null.
2.'DependentSuffix' displayed as Null in the Dependent file.
3.BenefitsTypeOffered displayed as E but actually plan was offering coverage to EDS 161701335
4.Cocod should be 5 digit.
Employees verified on screen and on file are as follows and correct
1.SHAYAN L ANDFIELD
2.SHARON L JAMES
3.Christine Fuller
4.LYNN ASAD
5.Rosemae Jones
6.Jose Macias
7.Glenisha Coleman
8.EILA RENTERIA
9.NYANUT KUETHPINY
10.Portia Long
11.Lisy Montano-Brea

Thanks,,
Smita

They are asking for a full list of the Prime 2016 Benefit plans – Can you assist with this?

Hi All

Any update on the other items listed?

Jenni

Hi Jennifer Johnson

CC - Sachin Hingole Nandkumar Prabhakar Karlekar

We have verify below EE on Prime with sapce and obsered that it's is correct.
1.REBECCA SPEIGHT
2.TERESA CHAVEZ
3.RONNIE MEEKS
4.MARY C NIEDERMAN
5.ASHMI DESAI
6.TERESA CHAVEZ
7.LEROY G CAIN
8.MARY C NIEDERMAN
9.MARY C NIEDERMAN

Sujit Chopade - Please share the Prime with space files with Jennifer.

Also we have verified below points with shared sheet and observed that it's satisfy the below mentioned points.

#1 - All dates should read MM/DD/YYYY - Please update all columns with dates

#2 - COCODE should always be 5 digits - please add the leading zero's

#3 - For column I (JAN2016_EMP (005) file) they do not need NULL listed

#4 - For column R (JAN2016_EMP (005) file) all "0" should be coded to "1"

#5 - For column Q (JAN2016_EMP (005) file) if the plan is Waived, the field should be blank - No NULL's

#6 - For column U (JAN2016_EMP (005) file) - Can you add the header "Invalid" - no data is needed they just need the header

#7 - For column K (JAN2016_EMP (005) file) - They need the date the employee outed out; this should not read NULL - Also please be aware that there is no waive button but a waived plan so you can base this off the waive plans.

It also looks like the plans are not pulling the rates correctly. We need to have the rates based on PT or FT. This would be based on the rates in WT. You can also not include Suburban or Lake Huron to any files.

Please let us know for any query.

Thanks,
Mahendra

Hi Jennifer Johnson,

Can you please send the specification or description of file format and column data requirement so we can proceed.

Hi Sachin Hingole

Please verify the file for the Jennifer Johnson - Prime Benefit plan 2016.xls
(Request : Full list of the Prime 2016 Benefit plans)

Hi Jennifer Johnson, We Uploaded the Jan 2016 Files
Please find the files at FTP Location
/users/workterraaca/Prime
File Name : Prime With Space Jan 2016(15Jul) Files.zip

Nandkumar Prabhakar Karlekar

Testing of file Prime Benefit plan 2016.xls shared by Sujit is in progress. We will share more updates on this by Monday.
Till now we found below issues from Non Nicotine tab of excel.

1] Employee cost is shown wrong in excel for Amal Sobh employee, This employee is from Class 1 = Garden City HGC and Class 2 = Part Time Employees.
EE Pre Tax cost on excel is 169.94 but it should be zero.

2] EPO 1 Plan (CVHM RNs) is shown in excel for Desert Valley Hospital and Part Time Employees classes but eligibility on plan in workterra is not set for these classes

Sujit Chopade, request you to look into above issues.

Jennifer Johnson Please review the prime benefit plans file and let us know if you need any additional changes.

Nandkumar Prabhakar Karlekar shyam sharma Sujit Chopade Rakesh Roy

Hi Jennifer Johnson

Please find attached excel Prime Benefit plan 2016 - 21Jul2016.xls for 2016 benefit plans from prime with and without space companies.

This excel has two spread sheets named "Prim With Space - Non Nicotine", "Prim Without Space-Non Nicotine".

We have randamoly picked plans and verified plans and cost from both workbooks.
Below are the plan names which we have verified and they are correct.

Prime With Space - Non Nicotine
Plan Names
1] Comprehensive PPO Plan
2] Plan Name - Value Plan PA (Lower Bucks Union)
3] Value Plan (SMGH)

Prime Without space - Non Nicotine
Plan Name
1] 2016 SJ EPO 12 Plan
2] Value (Bronze) Plan ECH
3] Suburban Value Plan

Thanks,
Sachin Hingole

Jennifer Johnson

During last call we discussed below points.

1] Please check and confirm the EIN classes mapping for all prime companies from production, (6 classes which needs to be removed and some needs to be updated)
2] Please confirm that client needs ACA prime file for all split companies in single excel or in separate excel for each company.

So could you please let us know, are the EIN classes updated and did you received any update from client on 2nd point.

Jennifer Johnson

Any updates on above queries?

Jennifer Johnson

Any updates on above queries?

Jennifer Leugers

Hi Jennifer Johnson,

Can you please provide updates on above queries.
We are waiting for your inputs to run files.

Thanks,
Sachin Hingole

Hi All - I am waiting on the response from the client on #2 -

I have attached the updated the FEIN list. Those in orange have been changed. Please update. Copy of WorkTerra FEIN.xlsx

Hi Jennifer Johnson
Thanks for update,we seen the FEIN from orange are updated.

Please let us know what about the other FEIN in yellow and white.
What update you are expecting from our side?

Hi All -

Not sure where we are with the files that we need to be re-ran. I have updated the list of FEIN's - those in Yellow are not in WT. For the others, they are there for reference.

We would like to get a Jan test file back out from the changes that have been made. Can you give me an ETA on that?

Updated WorkTerra FEIN.xlsx

Nandkumar Prabhakar Karlekar Sujit Chopade Yogesh Chaudhari Rakesh Roy shyam sharma

Hi Jennifer Johnson,

We will be providing Jan files for "Prime with Space" company from production by tomorrow (11-Aug-16).
Please let us know if you need Jan files for all other split companies and Prime without space company too.

Thanks,
Sachin Hingole

Hi Jennifer Johnson

CC - Nandkumar Prabhakar Karlekar Sachin Hingole Rakesh Roy

We have started testing on Prime with space for Jan16.We have loaded latest file on given path - /users/workterraaca/Prime/Prime_Space_Jan16.Password in separate mail

Still we have verified below employee

Below EE data are correct

RHODORA CRISOSTOMO
ANNA SORIANO
LAURA YOUNG

Below Employee data are incorrect

ISAAC AJIBOYE - Incorrect Benefit Effective date. Expected - 03/01/2016
FAZAL RAHMAN - Incorrect EE and ER cost
Employee enrolled into " EPO13 Plan " is ACA and Minimum value plan.This plan cost is low as compared to Value Plan KS and TX.Hence EPO13 Plan EE and ER cost should display in file. Currently it is showing "Value Plan KS and TX" plan cost in sheet.

We will continue with testing and let you know.

Thanks,
Mahendra

As we have review again ISAAC AJIBOYE demographics - observed that he was enrolled in Dallas Regional Medical Center Employee Medical Plan with effective date 03/01/2015.He is continue with plan.Hence excel showing correct BenefitsEffectiveDate - 01/01/2016.

Hi All -

I just got off the phone with the client and i just want to reiterate what is needed -

Column O -
1. If I am a full time employee (regardless of my tier) the rate should show EE only full time rate
2. If I am a part time employee (regardless of my tier) the rate should show EE only part time rate
3. If I am a part time employee with the "Apply full time rate" flag selected, I should receive the full time EE only rate.

The PT rates are in WT and are pulled based on class 2. Please let me know if you need to know which classes are considered PT.

Jenni

1) OK Column A- Wrong Company Code should be 00145 CORRECTED
2) OK Column H- The dates are coming over in an incorrect format days and months are being transposed CORRECTED
3) Column I- No nulls accepted, All the cells with nulls need to have effective dates populated. PARTIALLY CORRECTED; NULLS VALUE REMOVED, DATES NOT POPULATED.
4) Column K-No nulls accepted, All the cells with nulls need to have the same effective date that is in column H ( with the correct date format) PARTIALLY CORRECTED; NULLS VALUE REMOVED, DATES NOT POPULATED
5) OK Column L – The dates are coming over in the incorrect format and this is for plan terminations only. No nulls accepted, All the null data should be blank. CORRECTED
6) OK Column O – All employees with plans should have the Employee only monthly cost, this is not populating for the part time employees CORRECTED
7) OK Column Q- No nulls accepted any opt outs should be blank CORRECTED
8) Column R- No zeros and no nulls accepted, all rows should be all 1 as we are self-funded. PARTIALLY CORRECTED; OPT OUT NOT POPULATED WITH 1
9) OK Column U- Not coming over at all should be posted with a header name of “Invalid” CORRECTED

All - Please see the ones in red above - These need to be corrected asap.

David Rhodes

Jenni

3) Column I- No nulls accepted, All the cells with nulls need to have effective dates
populated. PARTIALLY CORRECTED; NULLS VALUE REMOVED, DATES NOT POPULATED.

"BenefitsEffectiveDate"
IF the employee is nither enrolled nor waive the plan then what should be this date.
There are 6000 records affected from this issue.

4) Column K-No nulls accepted, All the cells with nulls need to have the same
effective date that is in column H ( with the correct date format) PARTIALLY
CORRECTED; NULLS VALUE REMOVED, DATES NOT POPULATED

Fixed completely.

8) Column R- No zeros and no nulls accepted, all rows should be all 1 as we are self-funded.
PARTIALLY CORRECTED; OPT OUT NOT POPULATED WITH 1.

Fixed completely.

Nandkumar Prabhakar Karlekar Rakesh Roy shyam sharma Yogesh Chaudhari

Hi Jennifer Johnson,

We have uploaded JAN files for Prime with space company on EBS FTP.
Below are the details
FTP URL - https://ftpsecure.ebsbenefits.com/
FOLDER PATH - /users/workterraaca/Prime/Prime with Space - 12 Aug 2016
FILE NAME - Prime files with space jan (08122016).zip

Please let us know once you get response from client on prime test files.

Thanks,
Sachin Hingole

Hi Dev -

262128507 ENCINO HOSPITAL MEDICAL CENTER and 262583411 GARDEN GROVE HOSPITAL MEDICAL CENTER.

These two facilities are missing from the file.

Jenni

Hi Jennifer Johnson

Below class split to New company.

Class Name New Company
1.ENCINO HOSPITAL MEDICAL CENTER EHMC
2.GARDEN GROVE HOSPITAL MEDICAL CENTER Garden Grove Hospital

Hence they did not get on file.

Do you have any updates on Prime?

We will provide all primes files once we received approval from Prime.

Note- Around 1 week required Prime all files.it would be helpful if we get the request prior 1 week for all files

Thanks,
Mahendra

All - They would like to review all data - Are you able to provide those 2 facilities? and if so when? - You can pull the data from the prime group if possible as all of the changes from 1/1/16 should all be there.

Things all seem to be great in formatting - We just need them to review the data for Jan. The sooner those files the better.

Jenni

Jennifer Johnson

Please provide the Employee and EIN numbers as per the mail "Prime - FEIN - File Feeds" and Client feed back for already send files so we will process the complete final ACA Prime files.

If we process this files right now then there are more chances to do rework because we have no data for Employee and EIN which need to be processes separate.
also we need the test file comment to deliver the quality out put.

So Please provide the Employee/EIN and jan test file review comments of not only format but also data,

shyam sharma

All - We need to have those 2 named facilities above. They are reviewing data and will provide what they can but I need you to run those 2 facilities (listed) asap.

We will work on the splits but for now I need what you have on the 2 listed facilities.
Jenni

Nandkumar Prabhakar Karlekar Rakesh Roy Mahendra Mungase Yogesh Chaudhari shyam sharma

Hi Jennifer Johnson

As per email (subject line - RE: JAN2016_Test file), development team has shared "JAN 2016" files for requested facilities.
Testing is in progress, We will share files for these facilities by 24th Aug 2016.

Thanks,
Sachin Hingole

Hi All -

Just want to make sure we have the files tomorrow. I am working on the FEIN for those kickouts.

Jenni

Hi Jennifer Johnson

CC - Sachin Hingole Nandkumar Prabhakar Karlekar shyam sharma Rakesh Roy Yogesh Chaudhari

We have uploaded Prime files for below split facilities of Prime on EBS FTP.

1.GARDEN GROVE HOSPITAL MEDICAL CENTER
2.Shasta Regional Medical Group
3.Dallas Med
4.EHMC

FTP URL - https://ftpsecure.ebsbenefits.com/
FOLDER PATH - /users/workterraaca/Prime/Prime_Facility_08242016
FILE NAME – Prime_Facility_Jan16_08242016.zip

Below is our observation -
1.Shasta Regional Medical Group –
We observed that JORDAN A RIENSTRA employee has FEIN – 297060 which is less than 9 digit so please check and update with correct FEIN in file and system as well.

Hi all - please include me and Amber Love Jones on the JIRA updates going forward. thanks!

Hi all - please see the below comments from the client and advise on priority. Thanks!

Amber Love-Jones
Jennifer Johnson

I see that you sent several files yesterday, Shasta EMP/DEP, EHMC EMP/DEP, DMC EMP/DEP and EMP/DEP(which is only Garden Grove). Can you send a complete test file with all facilities on it, I would like to verify that we are capturing all Workterra facilities. Once we buy off on the changes that is the way the file should come over, not broken down by facility. We should have 1 Employee file and 1 dependent file which should include all facilities.

Jordan A. Rienstra's ssn is 519398693

From: Denise Fleury
Sent: Friday, August 26, 2016 8:35 AM
To: 'Jennifer Fernandes' <jennifer.fernandes@ebsbenefits.com>
Cc: Ramon Torres (PHS) <RTorres@primehealthcare.com>
Subject: FW: JAN2016_Test file

Can we please get one complete file to test with all facilities so we can make sure everything is correct. Since we had a lot of facilities come on board in February maybe we should test a June file?

Thank you Denise

Nandkumar Prabhakar Karlekar - Can we please have this file by tomorrow? Either the June file or a full Jan file all in one.

Jenni

Hi Jennifer Johnson Amber Love-Jones

We have upload Prime file for June 16 on FTP.

FTP URL - https://ftpsecure.ebsbenefits.com/
FOLDER PATH - /users/workterraaca/Prime/Prime_Facility_08302016
FILE NAME – Prime_Facility_08302016.zip

We are continue with testing on same file.

We have attached incorrect FEIN employee list of 10 employee - "Incorrect_FEIN_Employee_List.xls"
Please update the correct FEIN on demographics

EMPLOYEE FILE
A) FEIN# 472361878 (Lake Huron) remove effective 5/1/16 on LAWSON Please run months Jan-April then remove from May forward
B) FEIN# 472819044 (Suburban Community Hospital) remove effective 5/1/16 on LAWSON Please run months Jan-April then remove from May forward
C) FEIN# 300885567 (Southern Regional) not on file and should be effective 2/1/16. This is the only facility that we are missing from the file effective 02/01/2016
D) Column E (Employer FEIN) line 2127,3423,14665,14832,19666,19715,20002,20645,23469 highlighted in yellow have incorrect FEIN #’s Please make correction to these 10 lines

DEPENDENT FILE
A) Column E (Employer FEIN) Line 446,447,448,490,491,13757,13758,15749 highlighted in yellow have incorrect FEIN #’S.
Please make correction to these 8 lines

Hi Dev - Please see above - I have uploaded the files to the FTP site -

If you can correct these above and run out another June file, if approved, we should be good to go going forward.

Jenni

Hi Jennifer Johnson Amber Love-Jones

Please find in line comments
EMPLOYEE FILE
A) FEIN# 472361878 (Lake Huron) remove effective 5/1/16 on LAWSON Please run months Jan-April then remove from May forward
[Mahendra] - We have removed this FEIN from June 16 file
B) FEIN# 472819044 (Suburban Community Hospital) remove effective 5/1/16 on LAWSON Please run months Jan-April then remove from May forward
[Mahendra] - We have removed this FEIN from June 16 file
C) FEIN# 300885567 (Southern Regional) not on file and should be effective 2/1/16. This is the only facility that we are missing from the file effective 02/01/2016
[Mahendra] - We have added this FEIN in file
D) Column E (Employer FEIN) line 2127,3423,14665,14832,19666,19715,20002,20645,23469 highlighted in yellow have incorrect FEIN #’s Please make correction to these 10 lines
[Mahendra] - We have updated employee FEIN.Details in attached sheet
File name- Updated_FEIN_Employee_List.xls

DEPENDENT FILE
A) Column E (Employer FEIN) Line 446,447,448,490,491,13757,13758,15749 highlighted in yellow have incorrect FEIN #’S.
Please make correction to these 8 lines
[Mahendra] - We have updated employee FEIN
We have uploaded file on below FTP path
FTP URL - https://ftpsecure.ebsbenefits.com/
FOLDER PATH -/users/workterraaca/Prime/Prime_Facility_08312016
FILE NAME – Prime_Facility_08312016.zip

Observation- We have found duplicate employee which is present in PrimeHealthcare ,
Prime Healthcare.Please be advice on same.
Yogesh Chaudhari - Please upload file on FTP and share path in same ticket.

Jennifer Johnson Nandkumar Prabhakar Karlekar

While doing testing QA team has found multiple records for some employee in above uploaded file for all the facilities (Prime_Facility_08312016.zip).
After doing analysis we have found that, there are almost 3868 employees those are exists in both PrimeHealthcare (without space) and Prime HealthCare (with space) company with same Socialsecurityno. I have uploaded list of such duplicate employees on FTP on below path
FTP URL - https://ftpsecure.ebsbenefits.com/
FOLDER PATH - /users/workterraaca/Prime/Prime_Facility_08312016
FILE NAME – Duplicate_Employee_List.xls

Please let us know which employee is belongs to which company.

From: Denise Fleury DFleury@primehealthcare.com
Sent: Thursday, September 01, 2016 2:03 PM
To: Jennifer Fernandes; Sue Kile (PHS) (Payroll)
Cc: Amber Love-Jones; Jennifer Leugers; Ramon Torres (PHS)
Subject: RE: JAN2016_Test file

Jennifer

Lehigh is on Lawson please disregard this facility for WT

Thank you, Denise

Hi Jennifer Johnson

Do you have any feed back on Prime files?

Hi Jennifer Johnson Amber Love-Jones

Do you have any feed back on Prime files? also please let us know when client is expecting files for all facilities for all months.

Thanks,
Mahendra

From: Denise Fleury DFleury@primehealthcare.com
Sent: Friday, September 9, 2016 3:06 PM
To: Sue Kile (PHS) (Payroll); Jennifer Fernandes; Amber Love-Jones; David Rhodes
Cc: Nicole Bozeman; Ramon Torres (PHS)
Subject: RE: JAN2016_Test file

Sue, Thank you for reviewing the file!

Jennifer it looks like we are VERY close to having the correct file format except for the one error below.

Can we please fix Column J and then run all the files by month for 2016 I believe Sue sent a list of FEINs by month to make it easier on whom ever runs the reports for Jan-August I have attached again just in case.

Jennifer “I truly appreciate all your hard work” to get this file in the format needed. Now that we have it in the correct format with the correct data I believe it will be a smooth process from here on out.

Please let us know when you have corrected column J and posted the first non-test file (assuming Jan2016) for us to review.

Have a great weekend,

Denise

Hi Amber Love-Jones

Could you please let us know what is expected in column J?
Also let us know is it for employee or dependents file?

Once we get inputs on this we will provided all files (16 files - 8 months file for employee and dependent) for all facilities?

Thanks,
Sachin Hingole

Nandkumar Prabhakar Karlekar Rakesh Roy shyam sharma Jennifer Johnson Mahendra Mungase

Hello,

Client advises that Column J is for “Benefits Type Accepted” and it is only on the Employee file where they are missing data.

Thanks,
Amber

Nandkumar Prabhakar Karlekar Rakesh Roy shyam sharma Jennifer Johnson {~mahendra mungase]

Hi All -

there are a ton of blanks in Column J for the EE file - Once this is corrected, you can start to run out the monthly files.

Jenni

Hi Jennifer Johnson, Amber Love-Jones,

We will be showing "No" in "Benefits Type Accepted" column wherever column J is blank.
We will share all months (JAN - AUG 2016) files for all facilities in next week by 22nd Sept 2016.

Please let us know if you need any other details.

Thanks,
Sachin Hingole

Nandkumar Prabhakar Karlekar Yogesh Chaudhari Rakesh Roy shyam sharma Mahendra Mungase

Jenni – did you see Sue Kile’s response? Should we direct DEV to do something else? I don’t understand the codes she listed in her email. Thank you!

Amber,

There must be something in column J (E,ED,ES, EDS, NO), if there is a termination date in column L there must be only (E,ED,ES, EDS). If you have No in column J that means that the employee OPTED OUT

Thank you.

Sue Kile | Corporate Payroll Supervisor
3300 E. Guasti Road | Ontario, CA 91761 | T 909.638.0010<tel:>
Skile@primehealthcare.com<mailto:>

[PrimeMasterLogo_w_Tagline_rgb (3)]<http://www.primehealthcare.com/>

Amber Love-Jones | Account Executive
Employee Benefit Specialists, Inc.
PO Box 11657, Pleasanton, CA 94588
PH: 925-621-5257 | FAX: 925-460-3920 | amber.lovejones@ebsbenefits.com<amber.lovejones@ebsbenefits.com>
[Description: Description: Description: Description: Description: twitter]<http://twitter.com/#!/workterra> [Description: Description: Description: Description: Description: linkedin-tiny-square2] <http://www.linkedin.com/company/workterra> [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] <http://www.facebook.com/workterra>

Hi All -

Please look at the above and let me know if this makes any sense to you. (Here it is again)

"There must be something in column J (E,ED,ES, EDS, NO), if there is a termination date in column L there must be only (E,ED,ES, EDS). If you have No in column J that means that the employee OPTED OUT"

Jenni
David Rhodes

Nandkumar Prabhakar Karlekar : Can you please look in to this ?

I provided client with completion date of 9/22/2016. Please confirm that the files will be ready as the client is asking for an update.

Amber
Jennifer Johnson
David Rhodes

Hi Amber Love-Jones

We have uploaded all 8 months files on below FTP location.

FTP URL - https://ftpsecure.ebsbenefits.com/
FOLDER PATH -/users/workterraaca/Prime/Prime_Facility_09222016
FILE NAME – Prime_Facility_09222016.zip

Note - If EE terminated from Opt Out plan in this scenario column L will populate "NO" value.

Please let me know fro any query

Sachin Hingole Nandkumar Prabhakar Karlekar Rakesh Royshyam sharma Smita PawarYogesh Chaudhari