Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Company:
      El Dorado
    • Categories:
      ACA
    • Reported by:
      Client

      Description

      NA

        Attachments

          Issue Links

            Activity

            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            Last year, we had done some customization changes in El Dorado ACA company and run 1095-C report
            from same company.Please let us know, such changes needs to be done in this year also.

            Please refer Jira WT-6323 for additional information.

            Thanks,
            Smita

            FYI Ramya Tantry, Revansiddha Gaur, Sachin Hingole

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Jennifer Leugers , Last year, we had done some customization changes in El Dorado ACA company and run 1095-C report from same company.Please let us know, such changes needs to be done in this year also. Please refer Jira WT-6323 for additional information. Thanks, Smita FYI Ramya Tantry , Revansiddha Gaur , Sachin Hingole
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - this year the lowest cost plan is the same for everyone so I don't think we need to run the forms on El Dorado ACA. I've put the lowest cost plan of $91.32 in the customization for plan Blue Shield PPO ABHP High. Please run El Dorado 1095C Report under El Dorado. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - this year the lowest cost plan is the same for everyone so I don't think we need to run the forms on El Dorado ACA. I've put the lowest cost plan of $91.32 in the customization for plan Blue Shield PPO ABHP High. Please run El Dorado 1095C Report under El Dorado. Thanks!
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited

            Hi Jennifer Leugers

            We have run 1095-C report on El Dorado.
            Please refer run '12/21/2017 1:31:12 AM' to download.
            MEC indicator is marked as NO for all 12 months.
            PFA QA verification list.
            Thanks!!

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited Hi Jennifer Leugers We have run 1095-C report on El Dorado. Please refer run '12/21/2017 1:31:12 AM' to download. MEC indicator is marked as NO for all 12 months. PFA QA verification list. Thanks!!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Could you please share the calculations we can use in order to get to the MEC #s that we show on the analysis?

            Show
            jennifer.leugers Jennifer Leugers added a comment - Could you please share the calculations we can use in order to get to the MEC #s that we show on the analysis?
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            To mark MEC as YES for month, employer must have to give offer to 95% of employees otherwise it will be marked as NO.
            In analysis report, filters can be applied to ACA 1095C Codes sheet to get the below count details.

            Total EE Count:Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2A.

            EE Count with Offer to Dependents: Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2A and 2D and Line 14 contains 1A,1E,1K and 1C as these codes represent offer to EE and dependents.

            Looking at data analysis report 16.24% employees are ineligible to medical plan. If those employees will get offer
            then it will come 95.24% percent.

            Note: While doing MEC calculations, system is not considering combination of 1F and 2C code combination.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , To mark MEC as YES for month, employer must have to give offer to 95% of employees otherwise it will be marked as NO. In analysis report, filters can be applied to ACA 1095C Codes sheet to get the below count details. Total EE Count:Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2A. EE Count with Offer to Dependents: Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2A and 2D and Line 14 contains 1A,1E,1K and 1C as these codes represent offer to EE and dependents. Looking at data analysis report 16.24% employees are ineligible to medical plan. If those employees will get offer then it will come 95.24% percent. Note: While doing MEC calculations, system is not considering combination of 1F and 2C code combination. Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - if an employee answers C on the Enrollment Starts Here form, they are showing as "not eligible" for El Dorado benefits because they've chosen to enroll. We need to make sure they are showing as eligible on the 1095Cs. A few examples -

            Daniel Evans

            Gina Coppa

            John Conley

            Hillary Crawford

            Charles Harrell

            Robert Schroeder

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - if an employee answers C on the Enrollment Starts Here form, they are showing as "not eligible" for El Dorado benefits because they've chosen to enroll. We need to make sure they are showing as eligible on the 1095Cs. A few examples - Daniel Evans Gina Coppa John Conley Hillary Crawford Charles Harrell Robert Schroeder
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            We will provide an update on this by tomorrow.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We will provide an update on this by tomorrow.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            On initial analysis based on your request,we have set up a new company "El Dorado ACA" which is a copy of El Dorado main company as plan eligibility rules were to be changed to satisfy employees who have chosen option C.
            Request you to provide us the list of plans that are eligible for employees who have chosen option C so that we can do the further analysis on the offers if required or please do the customization changes on "El Dorado ACA" company and let us know.

            CC:Nandkumar Prabhakar Karlekar,Smita Pawar

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , On initial analysis based on your request,we have set up a new company " El Dorado ACA " which is a copy of El Dorado main company as plan eligibility rules were to be changed to satisfy employees who have chosen option C. Request you to provide us the list of plans that are eligible for employees who have chosen option C so that we can do the further analysis on the offers if required or please do the customization changes on " El Dorado ACA " company and let us know. CC: Nandkumar Prabhakar Karlekar , Smita Pawar
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            Do you have any updates on same.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , Do you have any updates on same. Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - everyone in Class 1 is eligible for the ACA plan which has an EE only contribution of $91.32.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - everyone in Class 1 is eligible for the ACA plan which has an EE only contribution of $91.32.
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Jennifer Leugers

            The above answer is not sufficient to proceed , Please provide the exists answer of Ramya's Question.

            1. If employee chooses option C then what Plan design he is eligible with what cost.
            2. If everyone from class one is eligible for ACA plan with $91.32 so can we over right all ACA plan EE only cost to $91.32.

            Please provide you reply for each ASAP.

            Revansiddha Gaur

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Jennifer Leugers The above answer is not sufficient to proceed , Please provide the exists answer of Ramya's Question. 1. If employee chooses option C then what Plan design he is eligible with what cost. 2. If everyone from class one is eligible for ACA plan with $91.32 so can we over right all ACA plan EE only cost to $91.32. Please provide you reply for each ASAP. Revansiddha Gaur
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Yes #2 is correct. Everyone that is eligible for benefits is eligible for the ACA plan that meets the FPL.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Yes #2 is correct. Everyone that is eligible for benefits is eligible for the ACA plan that meets the FPL.
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Jennifer Leugers

            Thank you for #2 Answer.

            Can you please provide the Answer of #1 question.
            1. If employee chooses option C then what Plan design he is eligible .

            Revansiddha Gaur Ramya Tantry

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Jennifer Leugers Thank you for #2 Answer. Can you please provide the Answer of #1 question. 1. If employee chooses option C then what Plan design he is eligible . Revansiddha Gaur Ramya Tantry
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Then they aren't eligible for any plan design because answer C is that they are waiving their enrollment opportunity so the system is going to show no plans available even though they waived Medical based on that answer ... which is what caused the initial issue with the forms showing no offer.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Then they aren't eligible for any plan design because answer C is that they are waiving their enrollment opportunity so the system is going to show no plans available even though they waived Medical based on that answer ... which is what caused the initial issue with the forms showing no offer.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - do you think I'll be able to download the forms in the morning? I have a call with the client at 9 AM PST tomorrow.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - do you think I'll be able to download the forms in the morning? I have a call with the client at 9 AM PST tomorrow.
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            As per our understanding, we will do the customization such a way that C's employee will get the benefits of normal employees & furnish the 1095 C report till today EOD.

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , As per our understanding, we will do the customization such a way that C's employee will get the benefits of normal employees & furnish the 1095 C report till today EOD. Thanks, Revan
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have rerun report 'El Dorado 1095C Report' on 'El Dorado ACA' company.
            We have added separate plan mentioned below for employees who have selected option C on 'Your enrollment starts here' form.

            1.Plan name:-ACA_Option C-Blue Shield PPO ABHP Low
            2.Eligibility Rule:- Option-C_ Rule

            All below mentioned employees are available in latest run '1/16/2018 2:04:00 AM' and having valid code on line 14 as 1A and on line 16 as 2G.

            Daniel Evans
            Gina Coppa
            John Conley
            Hillary Crawford
            Charles Harrell
            Robert Schroeder

            Please let us know if you need any additional information on this.
            Note: Refer Analysis Report against the run for Discrepancy report-Need to correct the discrepancy to generate the xml files successfully for IRS Submission.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have rerun report 'El Dorado 1095C Report' on 'El Dorado ACA' company. We have added separate plan mentioned below for employees who have selected option C on 'Your enrollment starts here' form. 1.Plan name:-ACA_Option C-Blue Shield PPO ABHP Low 2.Eligibility Rule:- Option-C_ Rule All below mentioned employees are available in latest run '1/16/2018 2:04:00 AM' and having valid code on line 14 as 1A and on line 16 as 2G. Daniel Evans Gina Coppa John Conley Hillary Crawford Charles Harrell Robert Schroeder Please let us know if you need any additional information on this. Note: Refer Analysis Report against the run for Discrepancy report-Need to correct the discrepancy to generate the xml files successfully for IRS Submission. Thanks!
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            We have observed that eligibility rule set on 'EIN class mapping' and on '1095-C' reports were different.
            Currently we have changed rule, rerun 'El Dorado 1095C Report' and finalized latest run '2/28/2018 8:44:51 PM'.

            Tested scenarios
            1.Valid codes are reflecting on PDF.
            2.MEC indicator is marked as 'NO' for all 12 months.
            3.Employer name and EIN are displaying correctly on report.

            Let us know, if you need any additional information.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Jennifer Leugers , We have observed that eligibility rule set on 'EIN class mapping' and on '1095-C' reports were different. Currently we have changed rule, rerun 'El Dorado 1095C Report' and finalized latest run '2/28/2018 8:44:51 PM'. Tested scenarios 1.Valid codes are reflecting on PDF. 2.MEC indicator is marked as 'NO' for all 12 months. 3.Employer name and EIN are displaying correctly on report. Let us know, if you need any additional information. Thanks!
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Closing this ticket

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Closing this ticket
            Hide
            Monika.Demla Monika Demla (Inactive) added a comment -

            Prashant Samal

            Please re-open this, it shouldn't be close.

            Show
            Monika.Demla Monika Demla (Inactive) added a comment - Prashant Samal Please re-open this, it shouldn't be close.
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Monika Demla, Jennifer Leugers : Should we close the ticket now?

            Satya

             

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Monika Demla , Jennifer Leugers : Should we close the ticket now? Satya  
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Monika Demla Jennifer Leugers : Should we close the ticket now , please update.

            Satya

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Monika Demla Jennifer Leugers : Should we close the ticket now , please update. Satya
            Hide
            Monika.Demla Monika Demla (Inactive) added a comment -

            hi Jennifer Leugers I am closing this ticket . Hope its okay.

            Show
            Monika.Demla Monika Demla (Inactive) added a comment - hi Jennifer Leugers I am closing this ticket . Hope its okay.

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Account Executive:
              Christina Karnes (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 6h Original Estimate - 6h
                  6h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20.5h
                  20.5h