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

FDU Payroll file testing results

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Stage
    • Reported by:
      Support
    • Company:
      FDU
    • Module:
      BenAdmin - Export

      Description

      HI all – could you please tell me if we ever made the changes to the templates per the original request? If not, what do we need from UHC to get that done?

      Hi Jen,
      As per our call, the two file templates that I am using for the test payroll files are in Stage under the global templates named:
      FDU Payroll (this is the medical payroll file)
      FDU Other (this is the payroll file that contains all of the other benefits)

      Please have the file updated to include the logic updates that will correct the below items. Please let me know if you need any other information.

      Medical Test file
      1. Domestic Partner - Thomas Test in SM 9 month with a DP
      a. the DP line is pulling a DPSP12 benefit plan code and it should be DPSP09
      b. the DP line is missing participation code of E
      c. Coverage Code is showing 1 and should be DPS9
      2. Waiver plan is termed - Joyce Skinner (Terminated status which termed the Waiver plan
      a. Benefit plan should be a single ~ instead of a double ~ ~
      b. The Participation Code should just be a W with no ~
      3. Medical plan is termed – Rosemary Murphy (Terminated status which termed Medical plan)
      a. Benefit Plan code should be ~ instead of the code (EEONLY)
      b. Participation code should be a W and not E~

      Other Payroll Test file:
      1. Terminations – Tilde needs to be removed from the Deduction code and place by itself in the ded amount column
      2. “File Number” header should be named “Employee ID”
      3. The deductions should pull Per pay period, currently pulling monthly
      4. Missing the following benefits from this file:
      a. Child Life
      b. Child AD&D
      c. Met Law

        Attachments

        1. Benefit Salary Eligibilty.png
          Benefit Salary Eligibilty.png
          65 kB
        2. Code_sheet_snap.png
          Code_sheet_snap.png
          38 kB
        3. Company_Payrollschedules.png
          Company_Payrollschedules.png
          16 kB
        4. Employees_payrollschedule.PNG
          Employees_payrollschedule.PNG
          69 kB
        5. FDU_Backend - Plan Class Tier Codes.xls
          386 kB
        6. FDU - Codes ID'S Sheet_Effective_16.xls
          363 kB
        7. FDU medical payroll Data_Needed_Format.xls
          48 kB
        8. FDU medical payroll Data_Needed_Format.xlsx
          19 kB
        9. FDU Medical payroll structure 111616.xlsx
          37 kB
        10. Old and New Codes Comparison.xls
          111 kB
        11. Randy Test_DP.JPG
          Randy Test_DP.JPG
          18 kB
        12. Randy Test_Enrollment.JPG
          Randy Test_Enrollment.JPG
          20 kB
        13. screenshot-1.png
          screenshot-1.png
          16 kB
        14. screenshot-2.png
          screenshot-2.png
          17 kB
        15. screenshot-3.png
          screenshot-3.png
          40 kB
        16. screenshot-4.png
          screenshot-4.png
          14 kB
        17. WT-895_Company Migration Production To Stage.xls
          12 kB

          Activity

            People

            Assignee:
            jennifer.leugers Jennifer Leugers
            Reporter:
            rajendra.pawar Rajendra Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 7h Original Estimate - 7h
                7h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 48.2h
                48.2h