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

Linium ACA Data Load Customization Spread Sheet

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA Historical Data Load
    • Environment:
      Stage
    • Reported by:
      Support
    • Company:
      Linium
    • Module:
      ACA

      Description

      Hello

      Please review attached ACA customization spread sheet that needs to be loaded for linium 1095-C reporting.

        Attachments

        1. ACA Employee CensusACA Employee Census23260_2985.xls
          303 kB
        2. Additional Historical Data for Workterra_FINAL.xlsx
          42 kB
        3. Bad_Election.txt
          3 kB
        4. Copy of Additional Historical Data for Workterra_FINAL.xlsx
          42 kB
        5. Copy of Linium ACA Data Correction_Final.xlsx
          24 kB
        6. Copy of WORKTERRA ACAMP IRS Reporting Tool Configuration Data Files v2016-02-16 LK.xlsx
          869 kB
        7. Correction of 20710_Linium_Data.xls
          384 kB
        8. Employee_NotExists_RemainingLoad Sheet.xls
          7 kB
        9. Employee_NotExists.xls
          8 kB
        10. employee coding.xlsx
          55 kB
        11. History.png
          History.png
          78 kB
        12. image001.jpg
          image001.jpg
          1.0 kB
        13. image002.jpg
          image002.jpg
          1 kB
        14. image003.png
          image003.png
          1 kB
        15. image004.jpg
          image004.jpg
          1 kB
        16. image005.jpg
          image005.jpg
          64 kB
        17. image006.jpg
          image006.jpg
          2 kB
        18. image007.png
          image007.png
          5 kB
        19. image008.jpg
          image008.jpg
          2 kB
        20. image009.png
          image009.png
          0.7 kB
        21. Linium_ACA Spreadsheet.xls
          120 kB
        22. Linium_Data.xls
          341 kB
        23. Linium_DataRequired.xls
          97 kB
        24. Linium_Discrepancies.xls
          9 kB
        25. Linium_Employee_Not_Exists.xls
          8 kB
        26. lINIUM C&C 1095.zip
          500 kB
        27. Linium-EmployeeVerified.txt
          0.6 kB
        28. Linium-ET-881 Format.zip
          30 kB
        29. Qualifying_Event.png
          Qualifying_Event.png
          52 kB
        30. REVISED Linium ACA Data Correction_Final.xlsx
          29 kB
        31. screenshot-1.png
          screenshot-1.png
          90 kB
        32. screenshot-2.png
          screenshot-2.png
          68 kB
        33. screenshot-3.png
          screenshot-3.png
          8 kB
        34. screenshot-4.png
          screenshot-4.png
          97 kB
        35. WORKTERRA ACA Tool Configuration v2016-02-16 LK.xlsx
          32 kB

          Activity

          lisadavison lisa davison created issue -
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Field Original Value New Value
          Assignee Nandkumar [ satyap ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          Attachment image001.jpg [ 12197 ]
          Attachment image002.jpg [ 12198 ]
          Attachment image003.png [ 12199 ]
          Attachment image004.jpg [ 12200 ]
          Attachment image005.jpg [ 12201 ]
          Attachment image006.jpg [ 12202 ]
          Attachment image007.png [ 12203 ]
          Attachment image008.jpg [ 12204 ]
          Attachment image009.png [ 12205 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee lisa davison [ lisadavison ] Yogesh Chaudhari [ yogesh.chaudhari ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Attachment Linium_DataRequired.xls [ 12463 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] lisa davison [ lisadavison ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee lisa davison [ lisadavison ] Rakesh Roy [ rakeshr ]
          Status Open [ 1 ] In Progress [ 3 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          lisadavison lisa davison made changes -
          Attachment Linium_ACA Spreadsheet.xls [ 12934 ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Summary ACA Customization Spread Sheet Linium ACA Customization Spread Sheet
          admin01 admin made changes -
          Account Executive lisa davison [ lisadavison ]
          Developer Shubhankar Joshi [ shubhankar ]
          Support Task Type ACA Historical Data Load [ 11207 ]
          admin01 admin made changes -
          Module Parent values: BenAdmin(10100) Parent values: ACA(10104)
          admin01 admin made changes -
          Assignee Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ] Shubhankar Joshi [ shubhankar ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Shubhankar Joshi [ shubhankar ] Meghana Kulkarni [ meghana.kulkarni ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Assignee Meghana Kulkarni [ meghana.kulkarni ] Mandar Kulkarni [ mandark ]
          cfinocchio Chris Finocchio (Inactive) made changes -
          Assignee Mandar Kulkarni [ mandark ] Nandkumar [ satyap ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Environment Production [ 10005 ] Stage [ 10004 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Chris Finocchio [ cfinocchio ]
          admin01 admin made changes -
          Link This issue blocks WT-1205 [ WT-1205 ]
          admin01 admin made changes -
          Summary Linium ACA Customization Spread Sheet Linium ACA Data Load Customization Spread Sheet
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Status In Progress [ 3 ] In Test [ 10016 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Test [ 10016 ] Resolved [ 5 ]
          lisadavison lisa davison made changes -
          Attachment lINIUM C&C 1095.zip [ 14315 ]
          lisadavison lisa davison made changes -
          Assignee Chris Finocchio [ cfinocchio ] Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ]
          lisadavison lisa davison made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Assignee Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ] Nandkumar [ satyap ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Yogesh Chaudhari [ yogesh.chaudhari ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Attachment Bad_Election.txt [ 14468 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ]
          jennifer.leugers Jennifer Leugers made changes -
          Attachment screenshot-1.png [ 14539 ]
          jennifer.leugers Jennifer Leugers made changes -
          Attachment screenshot-2.png [ 14540 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ] Nandkumar [ satyap ]
          Status Reopened [ 4 ] In Progress [ 3 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ]
          jennifer.leugers Jennifer Leugers made changes -
          Attachment screenshot-3.png [ 14602 ]
          jennifer.leugers Jennifer Leugers made changes -
          Assignee Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ] Sachin Khandge [ skhandge ]
          jennifer.leugers Jennifer Leugers made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          jennifer.leugers Jennifer Leugers made changes -
          Priority High [ 2 ] Highest [ 1 ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Assignee Sachin Khandge [ skhandge ] Nandkumar [ satyap ]
          lisadavison lisa davison made changes -
          Assignee Nandkumar [ satyap ] Monika Demla [ monika.demla ]
          lisadavison lisa davison made changes -
          lisadavison lisa davison made changes -
          Assignee Monika Demla [ monika.demla ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Nandkumar [ satyap ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee lisa davison [ lisadavison ] Yogesh Chaudhari [ yogesh.chaudhari ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Attachment Employee_NotExists.xls [ 14905 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] lisa davison [ lisadavison ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Cindy Wibbing [ cindy.wibbing ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Open [ 1 ] Resolved [ 5 ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          lisadavison lisa davison made changes -
          Resolution Done [ 10000 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          lisadavison lisa davison made changes -
          Assignee Cindy Wibbing [ cindy.wibbing ] Nandkumar [ satyap ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee lisa davison [ lisadavison ] Yogesh Chaudhari [ yogesh.chaudhari ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Nandkumar [ satyap ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Attachment Linium_Employee_Not_Exists.xls [ 17809 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Smita Pawar [ smita.pawar ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Nandkumar [ satyap ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Nandkumar [ satyap ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Yogesh Chaudhari [ yogesh.chaudhari ]
          lisadavison lisa davison made changes -
          Comment [ Guys!!!! 1095 for Maureen Obrien is still not corrected. I need the following changes to the record:


          Maureen O’Brien -- Showing as 1H, although she waived coverage during the 2014-15 plan year, and then waived coverage again within the WT system for the 2015-2016 plan year.

           codeing should show as 1A for the entire 12 months as coverage was offered but waived.
          [~nandkumar]
          [~smita.pawar] ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Attachment Qualifying_Event.png [ 18154 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Attachment History.png [ 18155 ]
          jennifer.leugers Jennifer Leugers made changes -
          Attachment screenshot-4.png [ 18869 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] lisa davison [ lisadavison ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Comment [ Let us know if you need any additional information.

          Thanks,
          Smita ]
          lisadavison lisa davison made changes -
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Smita Pawar [ smita.pawar ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Chris Finocchio [ cfinocchio ]
          lisadavison lisa davison made changes -
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Assignee Chris Finocchio [ cfinocchio ] Ramya Tantry [ ramya.tantry ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Attachment Linium-ET-881 Format.zip [ 20100 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment Linium_Discrepancies.xls [ 20237 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment Linium_Discrepancies.xls [ 20237 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment Linium_Discrepancies.xls [ 20238 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Attachment Linium-EmployeeVerified.txt [ 20312 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] lisa davison [ lisadavison ]
          Resolution Done [ 10000 ]
          Status Open [ 1 ] Resolved [ 5 ]
          lisadavison lisa davison made changes -
          Attachment employee coding.xlsx [ 20448 ]
          lisadavison lisa davison made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Sachin Hingole [ sachin.hingole ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Amit Gude [ amitg ]
          amitg Amit Gude (Inactive) made changes -
          Assignee Amit Gude [ amitg ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] lisa davison [ lisadavison ]
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          lisadavison lisa davison made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] lisa davison [ lisadavison ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Sachin Hingole [ sachin.hingole ]
          lisadavison lisa davison made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Nandkumar [ satyap ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment Linium_Data.xls [ 20710 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          lisadavison lisa davison made changes -
          jennifer.leugers Jennifer Leugers made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee lisa davison [ lisadavison ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee lisa davison [ lisadavison ] Smita Pawar [ smita.pawar ]
          Status Reopened [ 4 ] In Progress [ 3 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          lisadavison lisa davison made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]

            People

            Assignee:
            lisadavison lisa davison
            Reporter:
            lisadavison lisa davison
            Account Executive:
            lisa davison
            Developer:
            Shubhankar Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            15 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: