Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Reported by:
      Client
    • Company:
      ASML
    • Module:
      BenAdmin - Export

      Description

      Please find inline comments.
      1. Mecozzi (491275)– I warned EBS about this record. We spoke about this also yesterday when I said this person is missing his medical and dental deductions. They were never sent on the OE file. We asked to do an analysis on who else in this same situation. I would have expected at minimum his start record would have been on the file. It was not, so I manually entered.

      Comments: We have already shared Missing list of employee's from OE file with you and Ashley. As per previous mail we have not included the missing employee's in 01/28 payroll file. Please find attached mail and let us know if any action needed from our side.

      2. Rodman (490071) – Record showed a change to code HSA to $100. However I don’t understand why. His election in WT is $110. I can’t see that an action was made so why did it change, and why does it show 2 different numbers? I haven’t changed this I am not sure which is right. See two different screen shots between system and ADP file.
      ASM 490071 HSA 100 1/1/2016

      Comments: We have checked in database elect per pay check is $100 but on view enrollment summery its showing $110. As per initial analysis we found rates table having wrong cost. We scanning other employees whose having same scenario and other company. Enrollment team will share root cause analysis for this by tomorrow.

      3. Mooij, 600084. In attached email we had similar error but it was for starts of HSA code. It appears when they fixed it they limited the fix to starts and did not include STOPS. Life event was made to change HSA election which would use the forward date logic that Samir describes in concern 2. Forward 8 days. However file did not contain stop election for Mooij record. I added manually.

      Comments: As we had considered 8 future days for HSA. Record was exported till 2/5 and this employee has continuous enrollment and its getting displayed in future enrollments. As per future implementation we had export latest enrollment on file, so only start record was exported on file and stop code was not exported.

      4. Lopez, 490121. Chris this is also someone we discussed yesterday. It is related to the above issue. The employee is changing his status from Expat to US. He is transitioning from International plan to Local plan effective 2/1/16. His new medical, dental rates are not included on this file as they are effective 2/1/16 which is for the next pay period. That part is correct. We will need to monitor to make sure the correct stop and start codes come across next week. However the issue is the logic above then allows the HSA code to start early when the plan hasn’t started. It is almost like this type of transaction should be treated like a new hire. The HSA code should wait to come across at the same time the BHP code comes across. This is the first time we have seen this scenario. We can discuss what options are, I am not sure what logic is possible for this situation that won’t interfere with the previous rule. File is only sending 1 Record for this employee.

      Comments: As discussed we consider 8 days for HSA so only one record was exported on file with is effective from 2/1 and for other we considered 3 future days. Please let us know if need any changes on this.

        Attachments

        1. 166 SST Term Records.xls
          25 kB
          Ganesh Sadawarte
        2. 495357 Enrollment Details.xls
          8 kB
          Ganesh Sadawarte
        3. 495357 Enrollment Details.xls
          8 kB
          Ganesh Sadawarte
        4. HSB_Option3_ASML.doc
          665 kB
          Ganesh Sadawarte
        5. Re_ ASML ADP File 01-28-2016.pdf
          168 kB
          Ganesh Sadawarte
        6. Re_ ASML ADP File 02-11-2016.pdf
          350 kB
          Ganesh Sadawarte
        7. Record for 490485.png
          10 kB
          Ganesh Sadawarte

          Activity

          deepalit Deepali Tidke (Inactive) created issue -
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment Re_ ASML ADP File 01-28-2016.pdf [ 11697 ]
          Attachment Re_ ASML ADP File 02-11-2016.pdf [ 11698 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          We have started enhancement for DPI stop code not send if continue in other benefit.
          Please provide update on 02/11/2016 payroll file & HSB file.

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - We have started enhancement for DPI stop code not send if continue in other benefit. Please provide update on 02/11/2016 payroll file & HSB file.
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Chris Ellenberger [ chris.ellenberger ]
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Heard back from Shannon that this needs to be finalized tomorrow, 2/17 in the AM CST. Please provide confirmation this complete and please provide a new full HSB file.

          email sent to all responsible Dev parties on 2/16/2016.

          Amit said to have followed up with Dev on this as well.

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Heard back from Shannon that this needs to be finalized tomorrow, 2/17 in the AM CST. Please provide confirmation this complete and please provide a new full HSB file. email sent to all responsible Dev parties on 2/16/2016. Amit said to have followed up with Dev on this as well.
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh SadawarteAshley Marra

          Hi Ganesh,

          We received positive feedback from Shannon regarding the HSB Option 3 gray out. Thank you for you for work on this.

          He had one concern that we need to prove works...I gave him of an example of an existing employee that the option 3 is blocked, but he wants to confirm this works for new hires as well.

          Can you please help us by testing this with a dummy new hire record on an HSPL copy? Please provide screen shots as well.

          We don't want to compromise production data.

          Need to have this confirmed for Shannon by AM tomorrow, 2/18.

          Please let me know if you have any questions or concerns.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Ashley Marra Hi Ganesh, We received positive feedback from Shannon regarding the HSB Option 3 gray out. Thank you for you for work on this. He had one concern that we need to prove works...I gave him of an example of an existing employee that the option 3 is blocked, but he wants to confirm this works for new hires as well. Can you please help us by testing this with a dummy new hire record on an HSPL copy? Please provide screen shots as well. We don't want to compromise production data. Need to have this confirmed for Shannon by AM tomorrow, 2/18. Please let me know if you have any questions or concerns. Thanks, Chris
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment HSB_Option3_ASML.doc [ 11944 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris,

          Adding - Rashmita Dudhe

          We have verified HSB option 3 for new hired and Qualifying event.

          Deduct A 1 Time Amount From My Profit Sharing, Commission Or Bonus Check field text box filed is Enabled or Disabled for employee as per the Deduction Pay Date.Please find HSB_Option3_ASML attachment of Scenarios for HSB option 3.

          Please let us now if you require more details.

          Thank,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris, Adding - Rashmita Dudhe We have verified HSB option 3 for new hired and Qualifying event. Deduct A 1 Time Amount From My Profit Sharing, Commission Or Bonus Check field text box filed is Enabled or Disabled for employee as per the Deduction Pay Date.Please find HSB_Option3_ASML attachment of Scenarios for HSB option 3. Please let us now if you require more details. Thank, Ganesh
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh SadawarteRashmita Dudhe

          Hi Ganesh,

          I just confirmed with Shannon that this option 3 HSB should be completed blocked for all employees (new hire or existing) for the remainder of 2016. This should only be re-opened at open enrollment 2016 until they close in Feb 2017.

          Please have this option 3 completely blocked for the remainder of 2016.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Rashmita Dudhe Hi Ganesh, I just confirmed with Shannon that this option 3 HSB should be completed blocked for all employees (new hire or existing) for the remainder of 2016. This should only be re-opened at open enrollment 2016 until they close in Feb 2017. Please have this option 3 completely blocked for the remainder of 2016. Thanks, Chris
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          @ganesh

          Hi Ganesh,

          I am following up regarding the DPI deduction stop issue. Please provide an update/ETA ASAP on this.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - @ganesh Hi Ganesh, I am following up regarding the DPI deduction stop issue. Please provide an update/ETA ASAP on this. Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris,

          This patch is deployed on production and this is under testing. We will update once testing is completed.
          We will provide test file on Monday with ASM 490370 DPI 419.37. Please conform this need to send on nex payroll file on not.

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris, This patch is deployed on production and this is under testing. We will update once testing is completed. We will provide test file on Monday with ASM 490370 DPI 419.37 . Please conform this need to send on nex payroll file on not. Thanks, Ganesh
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh Sadawarte
          Hi Ganesh,

          Thank you for your response. Yes, we will need the DPI deduction to appear on the next change file. The DP has been added back onto the vision coverage, so the full DPI amount (Medical,Dental and Vision) will need to appear.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Hi Ganesh, Thank you for your response. Yes, we will need the DPI deduction to appear on the next change file. The DP has been added back onto the vision coverage, so the full DPI amount (Medical,Dental and Vision) will need to appear. Thanks, Chris
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment ADP_ASML_Payroll02222016010113.zip [ 12100 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris.

          Please find attached test 02/25/2016 ASML Payroll file and below are details.

          • Changes considered from 2/11/2016 to 2/28/2016.
          • DPI record for 490370 exported amount for Medical,Dental and Vision as DP added back to vision.
          • HSA records considered till 3/04/2016 date.
          • Zero cost record are exported on file for HSA.
            ADP_ASML_Payroll02222016010113.zip

          Password: asml

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris. Please find attached test 02/25/2016 ASML Payroll file and below are details. Changes considered from 2/11/2016 to 2/28/2016. DPI record for 490370 exported amount for Medical,Dental and Vision as DP added back to vision. HSA records considered till 3/04/2016 date. Zero cost record are exported on file for HSA. ADP_ASML_Payroll02222016010113.zip Password: asml
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris,

          Chris Ellenberger,Rohan J Khandave

          If you have any update on this please share with us, so we take appropriate action.

          Thanks,
          Ganesh.

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris, Chris Ellenberger , Rohan J Khandave If you have any update on this please share with us, so we take appropriate action. Thanks, Ganesh.
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Hi Ganesh,

          So sorry for the late follow up. Shannon was thoroughly pleased with the test file. All expected changes were confirmed by him.

          He noted a salary change he made that populated the correct deduction changes on the test file.

          Shannon did advise that the next inbound file to workterra from ADP on 3/2/2016 will contain many salary changes so that is what to look out for on the payroll changes file due 3/10/2016.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Hi Ganesh, So sorry for the late follow up. Shannon was thoroughly pleased with the test file. All expected changes were confirmed by him. He noted a salary change he made that populated the correct deduction changes on the test file. Shannon did advise that the next inbound file to workterra from ADP on 3/2/2016 will contain many salary changes so that is what to look out for on the payroll changes file due 3/10/2016. Thanks, Chris
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment ADP_ASML_Payroll02252016054053.zip [ 12411 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris.

          Chris Ellenberger,Rohan J Khandave,Vinayak Kulkarni,Saurabh Sablaka

          Please find attached production 02/25/2016 ASML Payroll file ADP_ASML_Payroll02252016054053.zip and below are details.

          • Changes considered from 2/11/2016 to 2/28/2016.
          • DPI record for 490370 exported amount for Medical,Dental and Vision as DP added back to vision.
          • HSA records considered till 3/04/2016 date.
          • Zero cost record are exported on file for HSA.

          Password: asml

          Please provide delivery information if we need to schedule this for next payroll file.

          Thanks,
          Ganesh.

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris. Chris Ellenberger , Rohan J Khandave , Vinayak Kulkarni , Saurabh Sablaka Please find attached production 02/25/2016 ASML Payroll file ADP_ASML_Payroll02252016054053.zip and below are details. Changes considered from 2/11/2016 to 2/28/2016. DPI record for 490370 exported amount for Medical,Dental and Vision as DP added back to vision. HSA records considered till 3/04/2016 date. Zero cost record are exported on file for HSA. Password: asml Please provide delivery information if we need to schedule this for next payroll file. Thanks, Ganesh.
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh SadawarteRashmita Dudhe

          Hello,

          Following up on the option 3 HSB gray out. Has this been completed and in production?

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Rashmita Dudhe Hello, Following up on the option 3 HSB gray out. Has this been completed and in production? Thanks, Chris
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Chris Ellenberger

          Hi Chris,

          This Is deployed and verified on production.
          Refer Jira ticket:WT-756.

          Thanks & Regards,
          Rashmita

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Chris Ellenberger Hi Chris, This Is deployed and verified on production. Refer Jira ticket: WT-756 . Thanks & Regards, Rashmita
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Chris Ellenberger

          Hi Chris,

          Do you have any update on 02/25/2016 ASML Payroll file?

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Chris Ellenberger Hi Chris, Do you have any update on 02/25/2016 ASML Payroll file? Thanks, Ganesh
          Hide
          Chris.ellenberger Chris Ellenberger added a comment - - edited

          Ganesh Sadawarte

          Hi Ganesh,

          File on 2/25 was received and loaded with no errors per Shannon.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - - edited Ganesh Sadawarte Hi Ganesh, File on 2/25 was received and loaded with no errors per Shannon. Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Chris Ellenberger

          Hi Chris,

          Thanks for sharing details. Can we schedule this feed for next payroll file for this we need delivery information.

          Thanks
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Chris Ellenberger Hi Chris, Thanks for sharing details. Can we schedule this feed for next payroll file for this we need delivery information. Thanks Ganesh
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Chris Ellenberger

          Hi Chris,

          Following up of schedule of ASML payroll file. Do we need to schedule this payroll file or post manually?

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Chris Ellenberger Hi Chris, Following up of schedule of ASML payroll file. Do we need to schedule this payroll file or post manually? Thanks, Ganesh
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Cindy WibbingAshley MarraGanesh Sadawarte

          Hi Ganesh,

          We will need to continue the same manual process for at least this period. Will need a test file but was told a large salary update is to be done prior to running the ADP payroll file. Not sure if that is complete.

          Cindy/Ashley,

          Is the salary update for this period complete? Can Ganesh run an ADP payroll change file for Shannon's review?

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Cindy Wibbing Ashley Marra Ganesh Sadawarte Hi Ganesh, We will need to continue the same manual process for at least this period. Will need a test file but was told a large salary update is to be done prior to running the ADP payroll file. Not sure if that is complete. Cindy/Ashley, Is the salary update for this period complete? Can Ganesh run an ADP payroll change file for Shannon's review? Thanks, Chris
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh Sadawarte

          Hi Ganesh,

          It has been confirmed that this salary update has been completed. Should i just run the ADP changes file out of production tomorrow, 3/10/2016? Or will you be providing that to me?

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Hi Ganesh, It has been confirmed that this salary update has been completed. Should i just run the ADP changes file out of production tomorrow, 3/10/2016? Or will you be providing that to me? Thanks, Chris
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Chris Ellenberger

          Hi Chris,

          You can manually export *'ASML ADP Payroll Payforce' * Group Template from Production.

          Thanks & Regards,
          Aniruddha Dev

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Chris Ellenberger Hi Chris, You can manually export *'ASML ADP Payroll Payforce' * Group Template from Production. Thanks & Regards, Aniruddha Dev
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh SadawarteAniruddha DevAshley Marra

          Hello,

          We have an issue reported by the client where a person we changed from LOA to Active didn't appear on the file correctly. This was manual correction made in WT yesterday add the benefits back manually because they did term via inbound load.

          Add records for the codes below should have populated. Please find out what caused only the stop records to populate and what should have been done in WT to achieve the desired result.

          Message from Shannon Hildreth:

          1. This is a person who is on a LOA. We confirmed with Cindy yesterday that she was not to load LOA people because it would stop their records. We were told she was passing them as active. However this is cancelling all of his life and disability benefits while still keeping his medical/ dental active?
          ASM 495357 STD~
          ASM 495357 SST~
          ASM 495357 ADD~
          ASM 495357 SLF~
          ASM 495357 ADS~
          ASM 495357 DLF~
          ASM 495357 ADC~

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Aniruddha Dev Ashley Marra Hello, We have an issue reported by the client where a person we changed from LOA to Active didn't appear on the file correctly. This was manual correction made in WT yesterday add the benefits back manually because they did term via inbound load. Add records for the codes below should have populated. Please find out what caused only the stop records to populate and what should have been done in WT to achieve the desired result. Message from Shannon Hildreth: 1. This is a person who is on a LOA. We confirmed with Cindy yesterday that she was not to load LOA people because it would stop their records. We were told she was passing them as active. However this is cancelling all of his life and disability benefits while still keeping his medical/ dental active? ASM 495357 STD~ ASM 495357 SST~ ASM 495357 ADD~ ASM 495357 SLF~ ASM 495357 ADS~ ASM 495357 DLF~ ASM 495357 ADC~ Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris Ellenberger,

          As per analysis we have checked employee have active enrollment in medical and dental.
          Can we have call to discuss this. please let us know you availability,

          Thanks
          Ganesh.

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris Ellenberger , As per analysis we have checked employee have active enrollment in medical and dental. Can we have call to discuss this. please let us know you availability, Thanks Ganesh.
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh Sadawarte

          Hi Ganesh,

          Sorry for the late response. I am available until 5pm PST for a call today. Otherwise it will need to be over the weekend sometime.

          There is one more issue possible issue that was brought to our attention by Shannon.

          "There are 168 SST~ records. That seems extremely high for terms in that plan. I think something went wrong with the change file load that moved these records to term instead of recalc. Which is odd since there are also other recalc for the same code."

          We spot checked 5 records that had an "SST" stop deduction and could not see any reason why the benefits termed.

          Can all 168 records be analyzed?

          Shannon wants a new change file no later than monday morning, 3/14 with the issue previously addressed and this issue resolved.

          Thanks,

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Hi Ganesh, Sorry for the late response. I am available until 5pm PST for a call today. Otherwise it will need to be over the weekend sometime. There is one more issue possible issue that was brought to our attention by Shannon. "There are 168 SST~ records. That seems extremely high for terms in that plan. I think something went wrong with the change file load that moved these records to term instead of recalc. Which is odd since there are also other recalc for the same code." We spot checked 5 records that had an "SST" stop deduction and could not see any reason why the benefits termed. Can all 168 records be analyzed? Shannon wants a new change file no later than monday morning, 3/14 with the issue previously addressed and this issue resolved. Thanks,
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment 495357 Enrollment Details.xls [ 13812 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment 495357 Enrollment Details.xls [ 13813 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment 166 SST Term Records.xls [ 13814 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris Ellenberger,

          CC- Rohan J Khandave,Sachin Khandge

          We have check above issue. Please find below 3C'S.

          Concern: 495357 employee is cancelling all of his life and disability benefits while still keeping his medical/ dental active?

          Cause: We have checked for STD and SST we need template customization change on template setting need to select Send Dependent Termination to Yes. STD and SST deduction code now active record is exporting on file. for other codes are terminated as dead and does not have active enrollment so it will export termination for other deduction code. this change is done by Cindy please conform this. Please find attachment 495357 Enrollment Details.xls enrollment details for 495357 employee.

          Concern :There are 168 SST~ records. That seems extremely high for terms in that plan.

          Cause : As per analysis we found there are 166 SST record which set termination date on 2016-03-09 and it does not have active enrollments. Please find attachment 166 SST Term Records.xls 166 SST record details this change done by Cindy Please conform
          this.

          Please refer lasted export file of ASML ADP Payroll Payforce For HSPL group template. The SST record for 495357 and 496579 employees After changing template customization are exporting as active. for other 166 record we are not found any active enrollments.

          Please let us know if you require more details on this or need call to discuss this.

          Thanks,
          Ganesh.

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris Ellenberger , CC- Rohan J Khandave , Sachin Khandge We have check above issue. Please find below 3C'S. Concern : 495357 employee is cancelling all of his life and disability benefits while still keeping his medical/ dental active? Cause : We have checked for STD and SST we need template customization change on template setting need to select Send Dependent Termination to Yes . STD and SST deduction code now active record is exporting on file. for other codes are terminated as dead and does not have active enrollment so it will export termination for other deduction code. this change is done by Cindy please conform this. Please find attachment 495357 Enrollment Details.xls enrollment details for 495357 employee. Concern :There are 168 SST~ records. That seems extremely high for terms in that plan. Cause : As per analysis we found there are 166 SST record which set termination date on 2016-03-09 and it does not have active enrollments. Please find attachment 166 SST Term Records.xls 166 SST record details this change done by Cindy Please conform this. Please refer lasted export file of ASML ADP Payroll Payforce For HSPL group template. The SST record for 495357 and 496579 employees After changing template customization are exporting as active. for other 166 record we are not found any active enrollments. Please let us know if you require more details on this or need call to discuss this. Thanks, Ganesh.
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Cindy WibbingAshley MarraGanesh SadawarteAmit Thorve

          Hi Ganesh,

          We have gotten through the issues above. Cindy had to reload the SST enrollments back to WorkTerra. Can any further analysis be made to determine why those 166 SST enrollments terminated? Cindy, Ashley and I looked in WorkTerra and there is nothing eligibility wise that should have caused that to happen.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Cindy Wibbing Ashley Marra Ganesh Sadawarte Amit Thorve Hi Ganesh, We have gotten through the issues above. Cindy had to reload the SST enrollments back to WorkTerra. Can any further analysis be made to determine why those 166 SST enrollments terminated? Cindy, Ashley and I looked in WorkTerra and there is nothing eligibility wise that should have caused that to happen. Thanks, Chris
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh Sadawarte

          Hi Ganesh,

          A new issue has been reported by Shannon. It seems that the company template that controls Basic STD (Audit_ADP_ASML_STD) is not set up correctly for changes only records.

          New Hire/Open Enrollment Records (initial enrollments) – populate Goal Number, Goal Amount and Goal Start Date.

          Midyear Rate Changes – DO NOT populate Goal Number, Goal Amount and Goal Start Date.

          Currently Goal Number, Goal Amount and Goal Start Date are populating for all records on the file.

          Please let me know how we can achieve this? Shannon is hoping this can be implemented in time for next week's payroll changes file. Test file due 3/22/2016.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Hi Ganesh, A new issue has been reported by Shannon. It seems that the company template that controls Basic STD (Audit_ADP_ASML_STD) is not set up correctly for changes only records. New Hire/Open Enrollment Records (initial enrollments) – populate Goal Number, Goal Amount and Goal Start Date. Midyear Rate Changes – DO NOT populate Goal Number, Goal Amount and Goal Start Date. Currently Goal Number, Goal Amount and Goal Start Date are populating for all records on the file. Please let me know how we can achieve this? Shannon is hoping this can be implemented in time for next week's payroll changes file. Test file due 3/22/2016. Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris Ellenberger,

          CC- Rohan J Khandave,Amit Thorve,Jaideep Vinchurkar,Vinayak Kulkarni, Saurabh Sablaka, Vijayendra Shinde

          Concern: Why those 166 SST enrollments terminated?

          Cause : As per analysis we have found that the data load interval time between imports are almost same due to this import routine was not properly executed.

          Correction : We have check new enrollment is added to system for SST by Cindy on 3/14. Please confirm this.


          Audit_ADP_ASML_STD is not set up correctly : As this feed was running from last 6 moths with same settings and it also approved by Shannon. Can we know what exactly changed on this 3/10 payroll file and why this required? As per current implementation we can not achieve this and also we are not aware about this requirement.

          Note: As this is new requirement we need to analyze change and also need Dev's approval for this change.

          Please let us know if you require more details.

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris Ellenberger , CC- Rohan J Khandave , Amit Thorve , Jaideep Vinchurkar , Vinayak Kulkarni , Saurabh Sablaka , Vijayendra Shinde Concern : Why those 166 SST enrollments terminated? Cause : As per analysis we have found that the data load interval time between imports are almost same due to this import routine was not properly executed. Correction : We have check new enrollment is added to system for SST by Cindy on 3/14. Please confirm this. Audit_ADP_ASML_STD is not set up correctly : As this feed was running from last 6 moths with same settings and it also approved by Shannon . Can we know what exactly changed on this 3/10 payroll file and why this required? As per current implementation we can not achieve this and also we are not aware about this requirement. Note : As this is new requirement we need to analyze change and also need Dev's approval for this change. Please let us know if you require more details. Thanks, Ganesh
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Hi Ganesh,

          Shannon stated that this requirement was not realized until now because there have been minimal changes for that deduction code since OE. Because this past changes file contained salary changes for the entire population, it became apparent when looking at this file. He is not asking us to correct what has been already sent, which is a good thing. He is asking for this to be handled going forward.

          Please provide your analysis of what needs to be done and an estimate of when this can be deployed. Our weekly call is on Thursday, 3/17.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Hi Ganesh, Shannon stated that this requirement was not realized until now because there have been minimal changes for that deduction code since OE. Because this past changes file contained salary changes for the entire population, it became apparent when looking at this file. He is not asking us to correct what has been already sent, which is a good thing. He is asking for this to be handled going forward. Please provide your analysis of what needs to be done and an estimate of when this can be deployed. Our weekly call is on Thursday, 3/17. Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris Ellenberger,

          Sorry for delay in response. We are finding way to achieve this scenario as currently we don't have anything that differ enrollment mode on file. We are analyzing this and share details with you soon.

          Please let me know do you have any other query?

          Thanks,
          Ganesh.

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris Ellenberger , Sorry for delay in response. We are finding way to achieve this scenario as currently we don't have anything that differ enrollment mode on file. We are analyzing this and share details with you soon. Please let me know do you have any other query? Thanks, Ganesh.
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Hi Ganesh Sadawarte,

          The only other query from Shannon has to do with the system. He mentioned that opening a QE for an employee to check prior HSA selections, then making no change to the record and not saving (keeping QE open), causes a $0 HSA deduction to appear on the file. Shannon could not give us an example of this, but wants to make sure this is not correct.

          Can this scenario be tested?

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Hi Ganesh Sadawarte , The only other query from Shannon has to do with the system. He mentioned that opening a QE for an employee to check prior HSA selections, then making no change to the record and not saving (keeping QE open), causes a $0 HSA deduction to appear on the file. Shannon could not give us an example of this, but wants to make sure this is not correct. Can this scenario be tested? Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Rashmita Dudhe,

          CC- Rohan J Khandave,Rakesh Roy, Hrishikesh Deshpande

          Could you please verify above scenario. After completing testing please update scenario result.

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Rashmita Dudhe , CC- Rohan J Khandave , Rakesh Roy , Hrishikesh Deshpande Could you please verify above scenario. After completing testing please update scenario result. Thanks, Ganesh
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Chris Ellenberger
          Hi Chris,

          CC:Ganesh SadawarteHrishikesh DeshpandeRohan J KhandaveRakesh Roy

          I have verified above scenario for prior HSA election By Initiating QE with no change to the records.
          Export file it is showing proper cost for HSA deduction.
          Verified for more than 5 employee it is working fine as expected.

          Thanks & Regards,
          Rashmita

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Chris Ellenberger Hi Chris, CC: Ganesh Sadawarte Hrishikesh Deshpande Rohan J Khandave Rakesh Roy I have verified above scenario for prior HSA election By Initiating QE with no change to the records. Export file it is showing proper cost for HSA deduction. Verified for more than 5 employee it is working fine as expected. Thanks & Regards, Rashmita
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh SadawarteAshley Marrasam lindberg

          Ganesh Sadawarte

          Hi Ganesh,

          Following up regarding the Basic STD template change we need. You last responded on 3/21 stating you were analyzing this.

          Template Name: Audit_ADP_ASML_STD

          New Hire/Open Enrollment Records (initial enrollments) – populate Goal Number, Goal Amount and Goal Start Date.

          Midyear Rate Changes – DO NOT populate Goal Number, Goal Amount and Goal Start Date.

          Currently Goal Number, Goal Amount and Goal Start Date are populating for all records on the file.

          Can you please advise when i can expect this to be achieved? I am currently manually manipulating this until a solution can deployed.

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte Ashley Marra sam lindberg Ganesh Sadawarte Hi Ganesh, Following up regarding the Basic STD template change we need. You last responded on 3/21 stating you were analyzing this. Template Name: Audit_ADP_ASML_STD New Hire/Open Enrollment Records (initial enrollments) – populate Goal Number, Goal Amount and Goal Start Date. Midyear Rate Changes – DO NOT populate Goal Number, Goal Amount and Goal Start Date. Currently Goal Number, Goal Amount and Goal Start Date are populating for all records on the file. Can you please advise when i can expect this to be achieved? I am currently manually manipulating this until a solution can deployed. Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

          Hi Chris Ellenberger,

          CC- Rohan J Khandave

          We have not schedule this yet we will include in to next sprint which started from 4/25/2016. This WT-41 will be include in next sprint which is for New Hire/Open Enrollment Records.

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi Chris Ellenberger , CC- Rohan J Khandave We have not schedule this yet we will include in to next sprint which started from 4/25/2016. This WT-41 will be include in next sprint which is for New Hire/Open Enrollment Records. Thanks, Ganesh
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Ganesh Sadawartesam lindbergAshley Marra

          Hi Ganesh,

          Shannon emailed this morning referencing an HSA stop deduction that didn't take place as it should have.

          Can this please be reviewed and let me know the findings so i can convey to Shannon?

          Email from Shannon:

          Can you look into why a stop action was not sent (HSA~) when the life event change was made for 2/1/16? We will need to make sure a stop is included on our next file so it stops as well.

          Unfortunately the employee did not notice until now and it has been running when it should not have been so it appears like it may have overfunded. Should the goal limit prevent that in WT system too?

          Employee is Remko Mooij EEID 600084

          Thanks,
          Chris

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Ganesh Sadawarte sam lindberg Ashley Marra Hi Ganesh, Shannon emailed this morning referencing an HSA stop deduction that didn't take place as it should have. Can this please be reviewed and let me know the findings so i can convey to Shannon? Email from Shannon: Can you look into why a stop action was not sent (HSA~) when the life event change was made for 2/1/16? We will need to make sure a stop is included on our next file so it stops as well. Unfortunately the employee did not notice until now and it has been running when it should not have been so it appears like it may have overfunded. Should the goal limit prevent that in WT system too? Employee is Remko Mooij EEID 600084 Thanks, Chris
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris Ellenberger

          CC- Rohan J Khandave

          We have check above issue. Please find below 3C'S.

          Concern: 600084 why a stop action was not sent (HSA~)

          Cause: As per implementation we are sending latest record on file which has active enrollment, so the only active enrollment was exported on file. If we need start and stop then we need to select Multiple record on template setting. On HSA template multiple record was not selected. due to this stop was not sent for 600084

          Correction: We have select multiple record on HSA template.

          We have verified this stop is exporting on file for 600084 please confirm this and let us know if you require more details

          Thanks,
          Ganesh.

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris Ellenberger CC- Rohan J Khandave We have check above issue. Please find below 3C'S. Concern : 600084 why a stop action was not sent (HSA~) Cause : As per implementation we are sending latest record on file which has active enrollment, so the only active enrollment was exported on file. If we need start and stop then we need to select Multiple record on template setting. On HSA template multiple record was not selected. due to this stop was not sent for 600084 Correction : We have select multiple record on HSA template. We have verified this stop is exporting on file for 600084 please confirm this and let us know if you require more details Thanks, Ganesh.
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Rohan J Khandave Ganesh Sadawarte sam lindberg

          Hello,

          New issue reported by Shannon:

          "Chris –

          The one thing that looks off is with the record of employee # 490485:

          It is showing both a stop code for B1P and a start code B1P. I think the stop code is off since it should be a “change” which would show the B1P $213.06 only. "

          I looked this up and was a class change from Expat to US with Most Recent Hire Date 5/1/2016. I am seeing the export is set to send multiple records for plan changes only.

          Can you please confirm why this was set like this? And how can we avoid getting this duplication without affecting other benefits on this template that may need multiple records?

          I really need a detailed answer by tomorrow, 5/5/2016. Scheduled meeting with client and would be nice to share the information then.

          Thanks,

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Rohan J Khandave Ganesh Sadawarte sam lindberg Hello, New issue reported by Shannon: "Chris – The one thing that looks off is with the record of employee # 490485: It is showing both a stop code for B1P and a start code B1P. I think the stop code is off since it should be a “change” which would show the B1P $213.06 only. " I looked this up and was a class change from Expat to US with Most Recent Hire Date 5/1/2016. I am seeing the export is set to send multiple records for plan changes only. Can you please confirm why this was set like this? And how can we avoid getting this duplication without affecting other benefits on this template that may need multiple records? I really need a detailed answer by tomorrow, 5/5/2016. Scheduled meeting with client and would be nice to share the information then. Thanks,
          Chris.ellenberger Chris Ellenberger made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Chris Ellenberger [ chris.ellenberger ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Status Reopened [ 4 ] In Progress [ 3 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Chris Ellenberger [ chris.ellenberger ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Comment [ Hello [~Chris.ellenberger],[~sam.lindberg@ebsbenefits.com]

          CC- [~rohan.khandave]

          Please find below details.

          *Concern*: It is showing both a stop code for B1P and a start code B1P. I think the stop code is off since it should be a “change” which would show the B1P $213.06 only. "

          *Cause*: Below record are exporting for employee 490485 on 05/04/2016 file. There are two B1P code exported on file for 490485. Stop code for *Cigna International(Cigna International Benefit)* plan which has terminated on *2016-04-30* and start code for *Cigna OAP(Medical Benefit)* plan with proper $213.06 cost according pay interval .This two plans are belong separate benefit but deduction code are same.


          Please let us know if you require more details.

          Thanks,
          Ganesh ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment Record for 490485.png [ 17000 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hello Chris Ellenberger,sam lindberg

          CC- Rohan J Khandave

          Please find below details.

          Concern: It is showing both a stop code for B1P and a start code B1P. I think the stop code is off since it should be a “change” which would show the B1P $213.06 only. "

          Cause: Below record are exporting for employee 490485 on 05/04/2016 file.

          There are two B1P code exported on file for 490485. Stop code for Cigna International(Cigna International Benefit) plan which has terminated on 2016-04-30 and start code for Cigna OAP(Medical Benefit) plan with proper $213.06 cost according pay interval .This two plans are belong separate benefit but deduction code are same.

          Please let us know if you require more details.

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hello Chris Ellenberger , sam lindberg CC- Rohan J Khandave Please find below details. Concern : It is showing both a stop code for B1P and a start code B1P. I think the stop code is off since it should be a “change” which would show the B1P $213.06 only. " Cause : Below record are exporting for employee 490485 on 05/04/2016 file. There are two B1P code exported on file for 490485. Stop code for Cigna International(Cigna International Benefit) plan which has terminated on 2016-04-30 and start code for Cigna OAP(Medical Benefit) plan with proper $213.06 cost according pay interval .This two plans are belong separate benefit but deduction code are same. Please let us know if you require more details. Thanks, Ganesh
          Chris.ellenberger Chris Ellenberger made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Chris Ellenberger made transition -
          Resolved Reopen
          66d 14h 45m 1
          Ganesh Sadawarte (Inactive) made transition -
          Reopen In Progress
          9h 7m 1
          Ganesh Sadawarte (Inactive) made transition -
          In Progress Open
          5m 43s 1
          Ganesh Sadawarte (Inactive) made transition -
          Open In Progress
          10d 21h 37m 2
          Ganesh Sadawarte (Inactive) made transition -
          In Progress Resolved
          13d 1h 27m 2
          Chris Ellenberger made transition -
          Resolved Closed
          105d 14h 9m 1

            People

            Assignee:
            Chris.ellenberger Chris Ellenberger
            Reporter:
            deepalit Deepali Tidke (Inactive)
            Account Executive:
            Chris Ellenberger
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: