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

            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
            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.
            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
            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.

              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