WORKTERRAProject Type: software

WORKTERRA

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

ACA - ACA reporting files for Wheaton (Tango)

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Below are the details from Email with subject line : "ACA reporting files for Wheaton"

      Attached is the new file specification for the Wheaton ACA files. I have confirmed that we are only building the “Demographic File (DEM)” page 6 and the “Dependent File (DEP) page 12. Can you please provide the number of hours it will take to complete and an approximate completion date.

        Attachments

        1. Watch_List.jpg
          Watch_List.jpg
          65 kB
        2. Test_Case_WT4419_TANGO.xls
          20 kB
        3. Tango File Specs.pdf
          330 kB
        4. Tango File Specs.pdf
          330 kB
        5. Tango Export Mapping File.xls
          19 kB
        6. TangoACAEmployee11102016.png
          TangoACAEmployee11102016.png
          15 kB
        7. Tango ACA Concierge File Specifications 2-1-6.pdf
          420 kB
        8. TANGO_Wheton_Production_Medical_PlanList.xls
          19 kB
        9. screenshot-2.png
          screenshot-2.png
          4 kB
        10. screenshot-1.png
          screenshot-1.png
          77 kB
        11. Plan IDs for Tango.msg
          86 kB
        12. Plan IDs 11.11.2016.xlsx
          9 kB
        13. Non Self Insured Plans Enrolled Employees List 11102016.xls
          17 kB
        14. Medical_Plan_List.xls
          15 kB
        15. image015.png
          image015.png
          0.7 kB
        16. image015.png
          image015.png
          0.7 kB
        17. image014.jpg
          image014.jpg
          2 kB
        18. image014.jpg
          image014.jpg
          2 kB
        19. image013.jpg
          image013.jpg
          2 kB
        20. image013.jpg
          image013.jpg
          2 kB
        21. image005.jpg
          image005.jpg
          64 kB
        22. image005.jpg
          image005.jpg
          64 kB
        23. image004.png
          image004.png
          5 kB
        24. image004.png
          image004.png
          5 kB
        25. image003.png
          image003.png
          1 kB
        26. image003.png
          image003.png
          1 kB
        27. image002.jpg
          image002.jpg
          1 kB
        28. image002.jpg
          image002.jpg
          1 kB
        29. image001.jpg
          image001.jpg
          1.0 kB
        30. image001.jpg
          image001.jpg
          1.0 kB
        31. FW Wheaton Tango - ACA Weekly Meeting.msg
          256 kB
        32. Ascension Wisconsin analaysis doc.xls
          9 kB
        33. Ascension Wisconsin analaysis doc.xls
          37 kB
        34. Analysis_Document_23Sep16.doc
          172 kB

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-4900 TANGO - Incorrect benefit termination display in file

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4901 TANGO - Incorrect Plan ID display in export file

          • Low - Minor problem or easily worked around.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-6488 ACA - Future (FEB or onwards) date enrollment are coming on JAN file

          • High - Serious problem that could block progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-8884 2017 ACA - ACA reporting files for Wheaton (Tango)

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            126 older comments
            Hide
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited

            Van Nguyen

            Following is the Requirement understanding from our side. we will analyze how to implement this and let you know.

            If Employee is Enrolled in PPO plan and "UDF 2017 Medical Subsidy" then Employee will get Cost as per table.

            UDF 2017 Medical Subsidy ACA Min value PPO
            25% 94.25
            50% 62.83
            75% 31.42
            100% 0

            All other employees will get minimum EE cost as per the salary band in the table.

            Salary Band ACA Min valueHDHP
            1 80.17
            2 112.67
            3 147.33
            4 179.83
            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited Van Nguyen Following is the Requirement understanding from our side. we will analyze how to implement this and let you know. If Employee is Enrolled in PPO plan and "UDF 2017 Medical Subsidy" then Employee will get Cost as per table. UDF 2017 Medical Subsidy ACA Min value PPO 25% 94.25 50% 62.83 75% 31.42 100% 0 All other employees will get minimum EE cost as per the salary band in the table. Salary Band ACA Min valueHDHP 1 80.17 2 112.67 3 147.33 4 179.83
            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Van Nguyen,

            We are furnishing the file on 30 March 2017 by considering the above requirement .

            Regards,
            Revan
            Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Van Nguyen , We are furnishing the file on 30 March 2017 by considering the above requirement . Regards, Revan Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar
            Hide
            Permalink
            Van.Nguyen Van Nguyen (Inactive) added a comment - - edited

            Hi Smita Pawar, Sachin Hingole, Mahendra Mungase, Nandkumar Prabhakar Karlekar,

            [~chimane@ebsbenefits.com] is requesting if the files can be ready before March 30. If not, then it is okay, but if there's any way that the files can be ready before then, it would please the client. Please let us know by Monday, 3/13/2017, if that would be possible and provide the new proposed date of when the files may be available.

            Also, can you please reopen this ticket for tracking purposes? I'm not able to reopen it. Thank you.

            Show
            Van.Nguyen Van Nguyen (Inactive) added a comment - - edited Hi Smita Pawar , Sachin Hingole , Mahendra Mungase , Nandkumar Prabhakar Karlekar , [~chimane@ebsbenefits.com] is requesting if the files can be ready before March 30. If not, then it is okay, but if there's any way that the files can be ready before then, it would please the client. Please let us know by Monday, 3/13/2017, if that would be possible and provide the new proposed date of when the files may be available. Also, can you please reopen this ticket for tracking purposes? I'm not able to reopen it. Thank you.
            Hide
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Van Nguyen,

            We will try to deliver these files ASAP but we are not in position to commit any date before 30 March because currently we have very limited bandwidth available for ACA and also we are executing ACA e-submissions.

            Definitely, we will try to deliver these file ASAP.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Van Nguyen , We will try to deliver these files ASAP but we are not in position to commit any date before 30 March because currently we have very limited bandwidth available for ACA and also we are executing ACA e-submissions. Definitely, we will try to deliver these file ASAP.
            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            New JIRA ID- WT-8884

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited New JIRA ID- WT-8884

              People

              Assignee:
              revansiddha.gaur Revansiddha Gaur (Inactive)
              Reporter:
              sachin.hingole Sachin Hingole (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Yogesh Chaudhari (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 105h Original Estimate - 105h
                  105h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 491h 5m
                  491h 5m