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

          Issue Links

            Activity

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 28/Nov/16 05:03 AM - edited
            • Time Spent:
              8h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 30/Nov/16 05:45 AM - edited
            • Time Spent:
              1h
               

              analysis and discussion with team

            sachin.hingole Sachin Hingole (Inactive) logged work - 30/Nov/16 09:59 AM
            • Time Spent:
              1.5h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 30/Nov/16 10:34 AM - edited
            • Time Spent:
              20m
               

              Internal Discussion.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 30/Nov/16 02:39 PM
            • Time Spent:
              1h
               

              analysis and diciussopn

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 30/Nov/16 05:20 PM
            • Time Spent:
              7h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 01/Dec/16 06:58 AM - edited
            • Time Spent:
              4h
               

              Internal Discussion & Analysis for not reflecting the termination date who's enrollment terminated dt is monthend.
              Needed code changes

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 01/Dec/16 11:09 AM - edited
            • Time Spent:
              0.75h
               

              Review customization

            sachin.hingole Sachin Hingole (Inactive) logged work - 01/Dec/16 01:26 PM
            • Time Spent:
              0.5h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 01/Dec/16 03:10 PM
            • Time Spent:
              8h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 02/Dec/16 12:52 PM
            • Time Spent:
              8h
               

              Exporting DEM file as per new specification

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 03/Dec/16 05:43 AM
            • Time Spent:
              2h
               

              Queried for Class specific employee details

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 05/Dec/16 12:18 PM
            • Time Spent:
              5.5h
               

              Working on file export

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 05/Dec/16 02:09 PM
            • Time Spent:
              1h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 05/Dec/16 02:20 PM
            • Time Spent:
              8h
               

              Debug

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Dec/16 05:57 AM
            • Time Spent:
              1h
               

              CLIENT CALL

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Dec/16 06:01 AM
            • Time Spent:
              7h
               

              Support for jan full file.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 06/Dec/16 12:18 PM
            • Time Spent:
              1h
               

              Analysis and Discussion with team for the tango issues reported by client.

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 06/Dec/16 05:31 PM
            • Time Spent:
              8h
               

              Export New template file and testing

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 07/Dec/16 12:34 PM
            • Time Spent:
              7h
               

              TANGO - Cobra file export and testing

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Dec/16 05:02 AM - edited
            • Time Spent:
              1h
               

              Internal discussion with team for incorrect waive plan set while processing the waive entried employees.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Dec/16 05:30 AM
            • Time Spent:
              2h
               

              Internal discussion for waive entries with team

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Dec/16 05:31 AM
            • Time Spent:
              0.5h
               

              waiting client call

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Dec/16 05:33 AM
            • Time Spent:
              5.5h
               

              waive entry, file export- active,cobra on hspl, exported waived details list out.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 08/Dec/16 02:34 PM
            • Time Spent:
              2h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 08/Dec/16 02:34 PM
            • Time Spent:
              1h
               

              Analysis and discussion with team. Work to update plandesignID of employee in Waive table.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 09/Dec/16 01:06 PM
            • Time Spent:
              7.5h
               

              Short Term Enrollments waive entry logic scripting.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 12/Dec/16 06:23 AM
            • Time Spent:
              6h
               

              Mid Term Waive entry functionality scripting..

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 12/Dec/16 12:40 PM
            • Time Spent:
              1.5h
               

              File testing for Benefit eligible date

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 13/Dec/16 05:33 AM
            • Time Spent:
              6.5h
               

              mid term waive functionality implementation

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Dec/16 10:00 PM - edited
            • Time Spent:
              0.5h
               

              Waive Script functionality review by Nandkumar

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 15/Dec/16 01:16 PM - edited
            • Time Spent:
              2h
               

              File export and testing

            sachin.hingole Sachin Hingole (Inactive) logged work - 29/Dec/16 02:07 PM
            • Time Spent:
              0.25h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 02/Jan/17 02:18 PM
            • Time Spent:
              4h
               

              Analysis of request for neither enrolled nor waive employee and reply

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 02/Jan/17 02:26 PM
            • Time Spent:
              0.5h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 02/Jan/17 10:00 PM
            • Time Spent:
              6h
               

              Analysis on JIRA comments,Internal discussion,reply.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 08/Jan/17 07:55 PM
            • Time Spent:
              11h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 09/Jan/17 10:00 AM
            • Time Spent:
              10h
               

              Client support & call

            sachin.hingole Sachin Hingole (Inactive) logged work - 09/Jan/17 12:25 PM
            • Time Spent:
              1.5h
               

              Call with Van and internal discussion with team.

            ramya.tantry Ramya Tantry (Inactive) logged work - 09/Jan/17 12:33 PM
            • Time Spent:
              4h
               

              Discussion
              Eligibility processing
              Eligibility changes.

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 09/Jan/17 12:43 PM - edited
            • Time Spent:
              10h
               

              File export , discussion and client call

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 09/Jan/17 01:28 PM
            • Time Spent:
              8h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 09/Jan/17 07:02 PM
            • Time Spent:
              8h
               

              Meeting with team to discuss issues in call.
              Working to expose new fields and analysis of data.
              Export files for the Tango.Call with onshore team.

            sachin.hingole Sachin Hingole (Inactive) logged work - 09/Jan/17 07:55 PM
            • Time Spent:
              0.75h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 09/Jan/17 07:57 PM
            • Time Spent:
              2h
               
              <No comment>
            sachin.hingole Sachin Hingole (Inactive) logged work - 10/Jan/17 05:49 AM - edited
            • Time Spent:
              0.5h
               

              Tango call with Van, Scott, Cindy

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 10/Jan/17 10:31 AM
            • Time Spent:
              2h
               

              export dependent files for tango and provide to client

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 10/Jan/17 12:47 PM - edited
            • Time Spent:
              10h
               

              Cobra files export , verification and client call

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 10/Jan/17 01:35 PM
            • Time Spent:
              4h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 10/Jan/17 10:00 PM - edited
            • Time Spent:
              3h
               

              Client Call & Client Support

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 10/Jan/17 10:00 PM
            • Time Spent:
              2h
               

              Scenario verified of Enrolled-Waived-Enrolled.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 14/Jan/17 12:36 AM
            • Time Spent:
              2h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 17/Jan/17 12:43 AM
            • Time Spent:
              6h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 18/Jan/17 12:43 AM
            • Time Spent:
              6h
               
              <No comment>
            ramya.tantry Ramya Tantry (Inactive) logged work - 18/Jan/17 12:46 PM
            • Time Spent:
              1.5h
               

              discussion
              analysis

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 18/Jan/17 12:57 PM
            • Time Spent:
              0.5h
               

              Discussion with team

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 18/Jan/17 01:28 PM
            • Time Spent:
              7h
               

              Analysis and discussion on feedback.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 18/Jan/17 10:00 PM
            • Time Spent:
              4.5h
               

              Analysis and internal discussion on feedback.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 19/Jan/17 12:44 AM
            • Time Spent:
              6h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 19/Jan/17 12:48 AM
            • Time Spent:
              6h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 19/Jan/17 08:33 AM - edited
            • Time Spent:
              10h
               

              Discussion , file exporting and testing

            ramya.tantry Ramya Tantry (Inactive) logged work - 19/Jan/17 12:44 PM
            • Time Spent:
              3.5h
               

              script creation
              analysis
              wef eligibility process

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 19/Jan/17 07:07 PM
            • Time Spent:
              7h
               

              Export files for tango unit testing, also written script for verification.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 19/Jan/17 10:00 PM
            • Time Spent:
              10h
               

              Client query resolution (in progress).

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 20/Jan/17 12:44 AM
            • Time Spent:
              6h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 20/Jan/17 08:39 AM
            • Time Spent:
              3h
               

              Worked on tango files to export

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 20/Jan/17 11:40 AM - edited
            • Time Spent:
              4h
               

              Worked on the tango files as per request.

            ramya.tantry Ramya Tantry (Inactive) logged work - 20/Jan/17 12:15 PM
            • Time Spent:
              2h
               

              Eligibility processing for active,cobra term
              filling monthly eligible plan

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 20/Jan/17 10:00 PM
            • Time Spent:
              14.5h
               

              Client Call,Worked on wheaton files.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 21/Jan/17 12:45 AM - edited
            • Time Spent:
              6h
               
              <No comment>
            sachin.hingole Sachin Hingole (Inactive) logged work - 21/Jan/17 05:57 AM - edited
            • Time Spent:
              2h
               

              attended call with BSG
              Worked on file

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 21/Jan/17 06:00 AM
            • Time Spent:
              10h
               

              Working on 12 month file and attend call

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 23/Jan/17 01:27 PM
            • Time Spent:
              1.5h
               

              Discussion and analysis

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 24/Jan/17 01:07 AM
            • Time Spent:
              2h
               
              <No comment>
            ramya.tantry Ramya Tantry (Inactive) logged work - 24/Jan/17 12:40 PM
            • Time Spent:
              3h
               

              internal discussion
              wef eligibility processing
              Employee monthly status

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 24/Jan/17 05:38 PM
            • Time Spent:
              9.5h
               

              Worked on Tango file export as per client request and call with client.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Jan/17 01:12 AM
            • Time Spent:
              4h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 25/Jan/17 04:57 AM - edited
            • Time Spent:
              9h
               

              File export and call

            ramya.tantry Ramya Tantry (Inactive) logged work - 25/Jan/17 12:12 PM
            • Time Spent:
              0.5h
               

              internal discussion

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 25/Jan/17 02:20 PM
            • Time Spent:
              2.5h
               

              File verification and discussion

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 25/Jan/17 02:20 PM
            • Time Spent:
              8h
               

              Analysis of files and difference in Aug and Sep Month files.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 25/Jan/17 10:00 PM
            • Time Spent:
              7h
               

              Verifying files.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 25/Jan/17 10:00 PM
            • Time Spent:
              7.5h
               

              File data analysis.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 26/Jan/17 01:13 AM - edited
            • Time Spent:
              8h
               

              ACA Files generation

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 27/Jan/17 10:17 AM
            • Time Spent:
              2h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 27/Jan/17 03:47 PM - edited
            • Time Spent:
              8h
               

              Files export and verification

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 27/Jan/17 10:00 PM - edited
            • Time Spent:
              6h
               

              File verification

            smita.pawar Smita Pawar (Inactive) logged work - 14/Feb/17 01:50 PM
            • Time Spent:
              0.5h
               

              Jira update

            smita.pawar Smita Pawar (Inactive) logged work - 20/Feb/17 02:23 PM
            • Time Spent:
              8h
               

              Analysis
              Document preparation
              Draft
              Test data preparation

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Feb/17 01:24 AM - edited
            • Time Spent:
              5h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) logged work - 27/Feb/17 11:26 AM - edited
            • Time Spent:
              1h
               

              Understanding

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 02/Mar/17 01:12 AM
            • Time Spent:
              4h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 07/Mar/17 01:46 PM
            • Time Spent:
              3h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Mar/17 10:00 PM
            • Time Spent:
              0.5h
               

              Internal discussion for the requirement.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 09/Mar/17 01:47 AM
            • Time Spent:
              3h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 13/Mar/17 09:00 PM
            • Time Spent:
              3h
               

              Internal discussion,requirement implementation.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 14/Mar/17 12:20 AM
            • Time Spent:
              4h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Mar/17 09:00 PM
            • Time Spent:
              2.5h
               

              file process.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 15/Mar/17 12:37 PM
            • Time Spent:
              2h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 15/Mar/17 09:00 PM
            • Time Spent:
              6h
               

              Verifying a file for the new requirement implementation.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 17/Mar/17 12:37 AM
            • Time Spent:
              1h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 06/Apr/17 12:39 AM
            • Time Spent:
              3.5h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 03/May/17 09:00 PM
            • Time Spent:
              5h
               

              Support for Tango files-Jan,Feb,Mar,April.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 04/May/17 01:16 AM
            • Time Spent:
              4h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 05/May/17 01:17 AM
            • Time Spent:
              4h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 05/May/17 09:00 PM
            • Time Spent:
              5.5h
               

              Working on files.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/May/17 09:00 PM
            • Time Spent:
              8.5h
               

              Waive Entries & unit testing.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/May/17 09:00 PM
            • Time Spent:
              1h
               

              internal discussion.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 09/May/17 01:18 AM
            • Time Spent:
              8h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 10/May/17 01:19 AM
            • Time Spent:
              8h
               
              <No comment>

              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