Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-8485

Town of Cary Payroll - unexpected records exporting on file

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Support
    • Company:
      Town of Cary
    • Item State:
      Production Complete - Closed

      Description

      Hi,

      Attached is the original payroll file exported from the global template called _Town of Cary Payroll Export.and the correct payroll file based on the enrollments in Workterra.

      There are records exporting on the file that are unexpected. I have highlighted in yellow these records and added comments.

      Thanks!
      Cindy

        Attachments

          Issue Links

            Activity

            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Cindy,

            Please find below details,

            Concern: Unexpected records populated on file.

            Cause: As we checked, all highlighted unexpected records are from plan Vision and Basic Dependent Life. Both of this plans are forced plan. Vision is forced contingent upon medical and Basic Dependent Life is force contingent on Medical, dental,vision and Basic life.

            There is an issue in enrollment system due to which these force contingent enrollments are getting updated by employee data change and there is no actual change in enrollment, it is just updating enrollment date-time stamp.

            As there is no actual change in enrollment data, it is not showing up on view history screens but export change file tracks date-time of enrollment which is updated due to above said error and records are populating on file.

            Correction: We have assigned this to enrollment team and they will check this issue further.
            let us know if you have any questions on this.

            Jyoti Mayne Hi Jyoti, please check this, as this is high priority and can cause errors at payroll vendors for any client.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Cindy, Please find below details, Concern: Unexpected records populated on file. Cause: As we checked, all highlighted unexpected records are from plan Vision and Basic Dependent Life. Both of this plans are forced plan. Vision is forced contingent upon medical and Basic Dependent Life is force contingent on Medical, dental,vision and Basic life. There is an issue in enrollment system due to which these force contingent enrollments are getting updated by employee data change and there is no actual change in enrollment, it is just updating enrollment date-time stamp. As there is no actual change in enrollment data, it is not showing up on view history screens but export change file tracks date-time of enrollment which is updated due to above said error and records are populating on file. Correction: We have assigned this to enrollment team and they will check this issue further. let us know if you have any questions on this. Jyoti Mayne Hi Jyoti, please check this, as this is high priority and can cause errors at payroll vendors for any client.
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Thank you!

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Thank you!
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hello Cindy Wibbing,

            Due to short of bandwidth, we were unable to work on this task. We will update you once we schedule it.

            Cc: Satya, Jaideep Vinchurkar

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hello Cindy Wibbing , Due to short of bandwidth, we were unable to work on this task. We will update you once we schedule it. Cc: Satya , Jaideep Vinchurkar
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Hi,
            I have attached additional examples of files. Do you have an ETA on this. Currently this is a manual process.
            Thanks!
            Cindy

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Hi, I have attached additional examples of files. Do you have an ETA on this. Currently this is a manual process. Thanks! Cindy
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hi Cindy Wibbing,

            We will schedule this in Sprint 26 (Staring from 3/27- end on 4/7).

            Cc: Satya

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi Cindy Wibbing , We will schedule this in Sprint 26 (Staring from 3/27- end on 4/7). Cc: Satya
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Thank you!

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Thank you!
            Hide
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Hi Prasad Pise,

            Please find 3Cs given by Vinayak Kulkarni above. We have done code fix for this issue. Please find affected areas below :

            • Enroll Now scenarios for Force Contingency.
            • Pending Queue scenarios for parent and child plans.
            • Demographic changes while elections are pended/approved.

            Thanks and Regards,
            :: Umesh Kadam

            CC : Jyoti Mayne, Vinayak Kulkarni

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Prasad Pise , Please find 3Cs given by Vinayak Kulkarni above. We have done code fix for this issue. Please find affected areas below : Enroll Now scenarios for Force Contingency. Pending Queue scenarios for parent and child plans. Demographic changes while elections are pended/approved. Thanks and Regards, :: Umesh Kadam CC : Jyoti Mayne , Vinayak Kulkarni
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Please get me the refreshed copy of Town of Cary from production to LB for testing.

            The company which is existing on the LB is too old and doesn't have new plans as well for proper testing, also as per my discussion with Umesh, we don't know whether the correction script has been executed on LB company or not.
            So, please get the refreshed company down on LB for testing.

            Thanks,
            Prashant
            -----------------------------------------------
            Mandar Kulkarni Umesh Kadam

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Hi Hrishikesh Deshpande , Please get me the refreshed copy of Town of Cary from production to LB for testing. The company which is existing on the LB is too old and doesn't have new plans as well for proper testing, also as per my discussion with Umesh, we don't know whether the correction script has been executed on LB company or not. So, please get the refreshed company down on LB for testing. Thanks, Prashant ----------------------------------------------- Mandar Kulkarni Umesh Kadam
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment - - edited

            Testing of all the scenarios is in progress,
            current scenarios tested :

            !Scenarios Tested Till Now : Current Scenarios tested.xls

            Thanks,
            Prashant

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - - edited Testing of all the scenarios is in progress, current scenarios tested : !Scenarios Tested Till Now : Current Scenarios tested.xls Thanks, Prashant
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Please find scenarios tested : Scenarios tested.xls

            Thanks,
            Prashant

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Hi Hrishikesh Deshpande , Please find scenarios tested : Scenarios tested.xls Thanks, Prashant
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This is working as expected on Stage. Ready for Production.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This is working as expected on Stage. Ready for Production.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Cindy Wibbing,

            This issue is fixed on Production. You can take it for UAT.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Cindy Wibbing , This issue is fixed on Production. You can take it for UAT. Thanks, Hrishikesh.
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Hrishikesh Deshpande
            This is still an issue. Please see latest file TOC Payroll201705101648_06943235650.xls under group template _Town of Cary Payroll Export

            Past enrollments records are still pulling on payroll file.

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Hrishikesh Deshpande This is still an issue. Please see latest file TOC Payroll201705101648_06943235650.xls under group template _Town of Cary Payroll Export Past enrollments records are still pulling on payroll file.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Umesh Kadam,

            Can you check this issue?

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Umesh Kadam , Can you check this issue? Thanks, Hrishikesh.
            Hide
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Hi Vinayak Kulkarni,

            Could you please look into this?

            Please check if it is still persist.

            Thanks and Regards,
            :: Umesh Kadam

            CC : Jyoti Mayne, Hrishikesh Deshpande

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Vinayak Kulkarni , Could you please look into this? Please check if it is still persist. Thanks and Regards, :: Umesh Kadam CC : Jyoti Mayne , Hrishikesh Deshpande
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Please take this forward.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Please take this forward.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Cindy Wibbing,

            We have verified this issue and observe that there is no issue in file. Can you please confirm the issue if still exist. also let us know sample records in case of issue.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Cindy Wibbing , We have verified this issue and observe that there is no issue in file. Can you please confirm the issue if still exist. also let us know sample records in case of issue. Thanks, Hrishikesh.

              People

              Assignee:
              Cindy.Wibbing Cindy Wibbing (Inactive)
              Reporter:
              Cindy.Wibbing Cindy Wibbing (Inactive)
              Developer:
              Umesh Kadam (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 24h 55m
                  24h 55m