Hi Amit Thorve

As discussed, we have updated leading values for monthly amount field as Space (' ') for all 2018 templates. Please check and let us know if error still persist. Thanks.

Vinayak Kulkarni, Ganesh Sadawarte, Rajendra Pawar

Thanks for running the script. I am able to run the file now.

I have few points which needs to be checked ASAP.

1. The Start date came out as blank for 75% of the records. The start date column is mapped to “Pay period date for election effective date”.
2. For around 22-25% records the start date is in 2016.
3. For around 190 records the start date is in 2017.

Hi Amit,

We have checked this, This field populates from back-end table in which there was no entry for year 2018. We have added entries for year 2018 now.
Please check and let us know if you face any other issues with this file.

Back-end table name: SBMPayrollDateMatrixForExport
Attached BackEndEffectiveDateForCOB.xls file contains all entries, Entries which are highlighted yellow are added for year 2018. Please check.

Thanks,
Vinayak

Ganesh Sadawarte and Vinayak Kulkarni Thanks for updating this table.

Can you please tell me why the 2016 effective dates and 2017 dates (other than 12/16/2017) with different values are rolling out on the file?

Hi Amit Thorve,

As discussed there were some enrollment effective for ex(12/01/2017, 11/01/2017) and rates also effective from same date with 12/31/2018 termination date. So as per SBM table date it populated on file.

CC-Vinayak Kulkarni

Thanks
Ganesh