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

          Hide
          khandu.kshirsagar Khandu Kshirsagar (Inactive) added a comment -

          Hi Prasad Pise,

          We have moved "FDU" company from production to stage by overwriting their current copy.
          Please check the below mentioned points for the moved company:

          1. Make proper company module mapping
          2. Save EDS and theme
          3. Log in to the site with Partner/Broker/Employee role and make sure all pages are displayed

          Please let me know if you need any information related to this, or any errors.

          Attaching Company migration checklist used in migration with mail. WT-895_Company Migration Production To Stage.xls
          QA Testing is in Progress.
          CC: Vijay Siddha,Samir,Satya,shyam sharma,Ashwin Wankhede,Rakesh Roy,Indraprakash Tiwari

          Show
          khandu.kshirsagar Khandu Kshirsagar (Inactive) added a comment - Hi Prasad Pise , We have moved "FDU" company from production to stage by overwriting their current copy. Please check the below mentioned points for the moved company: 1. Make proper company module mapping 2. Save EDS and theme 3. Log in to the site with Partner/Broker/Employee role and make sure all pages are displayed Please let me know if you need any information related to this, or any errors. Attaching Company migration checklist used in migration with mail. WT-895_Company Migration Production To Stage.xls QA Testing is in Progress. CC: Vijay Siddha , Samir , Satya , shyam sharma , Ashwin Wankhede , Rakesh Roy , Indraprakash Tiwari
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Rajendra Pawar and Prajakta Belhe , Please work on this and get export setup done on refreshed FDU company.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Rajendra Pawar and Prajakta Belhe , Please work on this and get export setup done on refreshed FDU company.
          Hide
          prasadp Prasad Pise (Inactive) added a comment -

          For company move testing, I have created new ticket WT-8559 and assigned to Jayshree.

          Show
          prasadp Prasad Pise (Inactive) added a comment - For company move testing, I have created new ticket WT-8559 and assigned to Jayshree.
          Hide
          prasadp Prasad Pise (Inactive) added a comment -
          Show
          prasadp Prasad Pise (Inactive) added a comment - CC: Prajakta Belhe
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Jennifer Leugers

          Stage FDU is refreshed with Production copy, also all export work done on stage is retained. Please check, Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jennifer Leugers Stage FDU is refreshed with Production copy, also all export work done on stage is retained. Please check, Thanks.

            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