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

Wacker - COBRA and Payroll discrepancies - Mary Machacek

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      Wacker Neuson Corporation
    • Module:
      BenAdmin - Report
    • Severity:
      Simple

      Description

      Hello team,

      I am having difficulty trying to figure out the issue that the client is having and also which COBRA and payroll files she should've exported on.

      Cobra Term Report Weekly - this may be the report that the client is referring to. Ashley Marra, can you confirm?

      Payroll - Amit Thorve, can you find out which payroll file this employee should've exported on?

      Per client:
      Mary Machacek – She termed from Wacker on 12/13/17. She came across the payroll files terming the Supp Life and Vol. AD&D effective 12/13/17 however, she never came across on the payroll files terming the Medical, Dental, and vision (eff. 12/31/17). Typically all of the terms would come across on the same file. The even more peculiar thing about Mary is that she never came over on the COBRA report Becky B. receives. Can you please look into her termination and make sure this isn’t something that would happen again?

        Attachments

        1. cobra term report.png
          cobra term report.png
          7 kB
        2. Download report.png
          Download report.png
          15 kB
        3. export to excel.png
          export to excel.png
          22 kB
        4. Failed schedule.png
          Failed schedule.png
          159 kB
        5. Schedule Configurations.png
          Schedule Configurations.png
          15 kB
        6. view Report.png
          view Report.png
          11 kB

          Issue Links

            Activity

            Van.Nguyen Van Nguyen (Inactive) created issue -
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Please take this ahead.

            You can include Kanchan from EDI Team in investigation.

            Thanks,
            S Prashant
            ___________________________________________________
            Satya Kanchan Jalgaonkar

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Please take this ahead. You can include Kanchan from EDI Team in investigation. Thanks, S Prashant ___________________________________________________ Satya Kanchan Jalgaonkar
            Prashant.samal Prashant Samal (Inactive) made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Vinayak Kulkarni [ vinayak.kulkarni ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rajendra Pawar [ rajendra.pawar ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Link This issue relates to WT-12964 [ WT-12964 ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Van,

            For payroll file issue, we have all details under WT-12964.

            And for cobra report, yes its Cobra Term Report Weekly and our report team will give more details for this. Thanks.

            [~parmeshwar.jumbade] as discussed, check Cobra report issue. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Van, For payroll file issue, we have all details under WT-12964 . And for cobra report, yes its Cobra Term Report Weekly and our report team will give more details for this. Thanks. [~parmeshwar.jumbade] as discussed, check Cobra report issue. Thanks.
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Rajendra Pawar [ rajendra.pawar ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 31/Jan/18 10:20 AM
            • Time Spent:
              2h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ]
            Original Estimate 6h [ 21600 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 4h [ 14400 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 102836 [ 102836 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment view Report.png [ 72695 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment Download report.png [ 72696 ]
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi Van Nguyen,

            We have scanned data for Mary Machacek employee and it seems everything is okay.

            While scanning already delivered report it observe that Mary Machacek records delivered in a report which was delivered on the date 2017-12-19. Please ask Becky B. to verify attached zip file in email which was delivered on 2017-12-19 with email subject "Wacker COBRA Term Report Weekly".

            If still not found delivered report in email inbox then please download delivered report from clicking on Schedule report> View Schedule report > Download. Attached screenshots for more details.

            If require additional details please let us know.

            CC: Amruta Lohiya Gaurav Sodani Vinayak Kulkarni

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi Van Nguyen , We have scanned data for Mary Machacek employee and it seems everything is okay. While scanning already delivered report it observe that Mary Machacek records delivered in a report which was delivered on the date 2017-12-19. Please ask Becky B. to verify attached zip file in email which was delivered on 2017-12-19 with email subject "Wacker COBRA Term Report Weekly". If still not found delivered report in email inbox then please download delivered report from clicking on Schedule report> View Schedule report > Download . Attached screenshots for more details. If require additional details please let us know. CC: Amruta Lohiya Gaurav Sodani Vinayak Kulkarni
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Van Nguyen [ van.nguyen ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            Hide
            Van.Nguyen Van Nguyen (Inactive) added a comment -

            Hi Ashley Marra,

            If these are the explanations you need to provide to the client, can you close the ticket? Thank you.

            Show
            Van.Nguyen Van Nguyen (Inactive) added a comment - Hi Ashley Marra , If these are the explanations you need to provide to the client, can you close the ticket? Thank you.
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Assignee Van Nguyen [ van.nguyen ] Ashley Marra [ amarra ]
            amarra Ashley Marra (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
            amarra Ashley Marra (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Open [ 1 ] Closed [ 6 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 02/Feb/18 05:51 AM
            • Time Spent:
              6h
               

              Issue analysis - Scan data and delivered scheduled
              Internal discussion
              JIRA update

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Closed [ 6 ] Reopen [ 4 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 2h [ 7200 ] 8h [ 28800 ]
            Worklog Id 103179 [ 103179 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Reopen [ 4 ] Closed [ 6 ]
            Hide
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment -

            Reopening ticket to update module

            Show
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment - Reopening ticket to update module
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Closed [ 6 ] Reopen [ 4 ]
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            Van Nguyen Is there a way to see if anyone else was missed?

            Show
            amarra Ashley Marra (Inactive) added a comment - Van Nguyen Is there a way to see if anyone else was missed?
            Hide
            Van.Nguyen Van Nguyen (Inactive) added a comment -

            Hi [~parmeshwar.jumbade],

            Can you check to see if anyone else was missed on these files?

            Show
            Van.Nguyen Van Nguyen (Inactive) added a comment - Hi [~parmeshwar.jumbade] , Can you check to see if anyone else was missed on these files?
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Assignee Ashley Marra [ amarra ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            Hi Van Nguyen,

            We have started our analysis to scan if any employees missed on Cobra schedule file but have not finished yet. This will get complete by 13th Feb 2018.

            CC: Amruta Lohiya Gaurav Sodani

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited Hi Van Nguyen , We have started our analysis to scan if any employees missed on Cobra schedule file but have not finished yet. This will get complete by 13th Feb 2018. CC: Amruta Lohiya Gaurav Sodani
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Reopen [ 4 ] In Progress [ 3 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 12/Feb/18 01:43 PM
            • Time Spent:
              5h
               

              Scan schedules
              Check Cobra term employees and missed files
              Internal discussion with Vinayak
              JIRA update

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment Failed schedule.png [ 73310 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment Schedule Configurations.png [ 73311 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment cobra term report.png [ 73313 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment export to excel.png [ 73314 ]
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            Hi Van Nguyen,

            We have checked Cobra Term Report schedules into system for this company and we found that 2 schedules failed for same report. Please refer screenshot:

            Below are the 3C's:
            Concern: Cobra Term Report schedule 2 files not delivered for date-range 2017-11-21 to 2017-12-05.
            Cause: These schedules failed due to for deployment issue with scheduler service on production which is already resolved in WT-12622.
            Correction: If need to pull-out missed files for date-range 2017-11-21 to 2017-12-05. (i.e. Which were expected to deliver through scheduler on the date 2017-12-05 & 2017-11-28) then we can achieve this with pulling report with specifying date-range. While pull this report (in preview mode) need to specify date-range 2017-11-21 as From-Date and 2017-12-05 as To-Date so it will pull all Cobra Term employees report (i.e. missed to deliver) into one file with saving it into Export to excel.
            Please refer screenshot:

            Hope this information will fine. Please let us know if more details required.

            CC: Amruta Lohiya Gaurav Sodani Satya

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited Hi Van Nguyen , We have checked Cobra Term Report schedules into system for this company and we found that 2 schedules failed for same report. Please refer screenshot: Below are the 3C's : Concern : Cobra Term Report schedule 2 files not delivered for date-range 2017-11-21 to 2017-12-05. Cause : These schedules failed due to for deployment issue with scheduler service on production which is already resolved in WT-12622 . Correction : If need to pull-out missed files for date-range 2017-11-21 to 2017-12-05. (i.e. Which were expected to deliver through scheduler on the date 2017-12-05 & 2017-11-28) then we can achieve this with pulling report with specifying date-range. While pull this report (in preview mode) need to specify date-range 2017-11-21 as From-Date and 2017-12-05 as To-Date so it will pull all Cobra Term employees report (i.e. missed to deliver) into one file with saving it into Export to excel. Please refer screenshot: Hope this information will fine. Please let us know if more details required. CC: Amruta Lohiya Gaurav Sodani Satya
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 13/Feb/18 01:44 PM
            • Time Spent:
              3h
               

              Scan schedules
              Internal discussion and JIRA update

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 8h [ 28800 ] 13h [ 46800 ]
            Worklog Id 104420 [ 104420 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 13h [ 46800 ] 16h [ 57600 ]
            Worklog Id 104421 [ 104421 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Van Nguyen [ van.nguyen ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            Hide
            Van.Nguyen Van Nguyen (Inactive) added a comment -

            Hi Ashley Marra,

            Please see Parmashwar's comment above.

            Show
            Van.Nguyen Van Nguyen (Inactive) added a comment - Hi Ashley Marra , Please see Parmashwar's comment above.
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Assignee Van Nguyen [ van.nguyen ] Ashley Marra [ amarra ]
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            Van Nguyen Hey Van, I can't really tell if there are others missed. Are they saying that 2 files failed and all on those files were not sent? Were they then sent in Jan? I just need to let the client know if anyone else was missed.

            Show
            amarra Ashley Marra (Inactive) added a comment - Van Nguyen Hey Van, I can't really tell if there are others missed. Are they saying that 2 files failed and all on those files were not sent? Were they then sent in Jan? I just need to let the client know if anyone else was missed.
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            Hi Ashley Marra,

            Yes, As mentioned only two times report file not delivered due to issue was with scheduler service other than that all files (i.e. including Jan & months) sent through report schedule (i.e. Cobra Term Report weekly).

            Please let us know if more details required.

            CC: Gaurav Sodani Amruta Lohiya Satya

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited Hi Ashley Marra , Yes, As mentioned only two times report file not delivered due to issue was with scheduler service other than that all files (i.e. including Jan & months) sent through report schedule (i.e. Cobra Term Report weekly ). Please let us know if more details required. CC: Gaurav Sodani Amruta Lohiya Satya
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 16h [ 57600 ] 16.5h [ 59400 ]
            Worklog Id 104676 [ 104676 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 16/Feb/18 07:16 AM
            • Time Spent:
              0.5h
               

              Scan Jan and Feb Months schedule files delivery

            abhay.patil Abhay Patil (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            As explained it was the failure of scheduled reports that caused the problem.

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - As explained it was the failure of scheduled reports that caused the problem.
            abhay.patil Abhay Patil (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            Transition Time In Source Status Execution Times
            Parmeshwar Jumbad (Inactive) made transition -
            Open In Progress
            1d 12h 9m 1
            Ashley Marra (Inactive) made transition -
            Waiting for Customer Input Open
            5h 19m 1
            Ashley Marra (Inactive) made transition -
            Open Closed
            8s 1
            Parmeshwar Jumbad (Inactive) made transition -
            Reopen Closed
            1m 7s 1
            Sumeet.Kolge (Inactive) made transition -
            Closed Reopen
            5d 11h 24m 2
            Parmeshwar Jumbad (Inactive) made transition -
            Reopen In Progress
            5d 5h 38m 1
            Parmeshwar Jumbad (Inactive) made transition -
            In Progress Waiting for Customer Input
            1d 2h 30m 2
            Abhay Patil (Inactive) made transition -
            Waiting for Customer Input In Progress
            9d 10h 48m 1
            Abhay Patil (Inactive) made transition -
            In Progress Resolved
            1m 26s 1

              People

              Assignee:
              amarra Ashley Marra (Inactive)
              Reporter:
              Van.Nguyen Van Nguyen (Inactive)
              Account Executive:
              Ashley Marra (Inactive)
              EDI Analyst 1:
              Van Nguyen (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 6h Original Estimate - 6h
                  6h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 16.5h
                  16.5h