Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA Data Audit
    • Environment:
      Production
    • Reported by:
      Client
    • Module:
      BenAdmin

      Description

      Please see attached spreadsheet to load corrected codes for the ADS 1095c forms. Please note - Each employee should be 1A/2C for the entire year (2015)

      Password to be emailed

        Attachments

          Activity

          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Let me know if I need to separate ssn data by company EIN.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Let me know if I need to separate ssn data by company EIN.
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Ramya Tantry

          After completion of this task please review the same.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Ramya Tantry After completion of this task please review the same.
          Hide
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

          Chris Finocchio Code changes for mentioned employees are done on ADS - production.
          Please download latest run of report named "1095C". Refer,

          Nandkumar Prabhakar Karlekar[~chimane@ebsbenefits.com]

          Show
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Chris Finocchio Code changes for mentioned employees are done on ADS - production. Please download latest run of report named "1095C". Refer, Nandkumar Prabhakar Karlekar [~chimane@ebsbenefits.com]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Ramya Tantry
          Amannda Johnson

          The revised forms you produced look correct, 1G has been replaced with 1A/2C. However the new forms produced have field 8 in Part I blank (Employee Identification Number). We revised the EIN Class Mapping and Eligibility Rule to reflect 6 separate EIN numbers. We also went back and assigned the corrected EIN to each employee. With corrections you have put in place how do I need to re-run the forms to keep your corrections with correct EIN numbers for each employee in Part 1 Field 8? Can I just re-run the forms by Eligibility Group?

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Ramya Tantry Amannda Johnson The revised forms you produced look correct, 1G has been replaced with 1A/2C. However the new forms produced have field 8 in Part I blank (Employee Identification Number). We revised the EIN Class Mapping and Eligibility Rule to reflect 6 separate EIN numbers. We also went back and assigned the corrected EIN to each employee. With corrections you have put in place how do I need to re-run the forms to keep your corrections with correct EIN numbers for each employee in Part 1 Field 8? Can I just re-run the forms by Eligibility Group?
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Ramya Tantry

          Please Advice I think only need to re run the reports.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Ramya Tantry Please Advice I think only need to re run the reports.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          You are correct. Once I re-ran the reports the problem resolved itself. Thanks

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - You are correct. Once I re-ran the reports the problem resolved itself. Thanks
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Chris Finocchio
          Amannda Johnson

          The reports need to be re-run to reflect the EIN changes.
          Corrections will also be reflected in new run also. No extra changes /work need to be done to reflect the corrections.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Nandkumar Prabhakar Karlekar Chris Finocchio Amannda Johnson The reports need to be re-run to reflect the EIN changes. Corrections will also be reflected in new run also. No extra changes /work need to be done to reflect the corrections.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar

          Last remaining ADS updates. Please see new spreadsheet dated 7.27.16. Password to be sent in separate email.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Last remaining ADS updates. Please see new spreadsheet dated 7.27.16. Password to be sent in separate email.
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Please look into this

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Please look into this
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Chris Finocchio,Nandkumar Prabhakar Karlekar

          Due to other tasks,could not look into this. Will update you on this soon.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Chris Finocchio , Nandkumar Prabhakar Karlekar Due to other tasks,could not look into this. Will update you on this soon.
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Chris Finocchio,Nandkumar Prabhakar Karlekar

          The requested corrections are done.
          We have re-run reports "1095C" and "1095c ADS 510105665".
          Please refer latest run dated 05/31/2016 of both reports.

          Note : For EE Delbert Barton,the requested codes are 1A-2A.This is invalid combination.We have not populated 1A-2A.
          Currently 1H-2A is populated where 1A-2A is requested.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Chris Finocchio , Nandkumar Prabhakar Karlekar The requested corrections are done. We have re-run reports "1095C" and "1095c ADS 510105665". Please refer latest run dated 05/31/2016 of both reports. Note : For EE Delbert Barton,the requested codes are 1A-2A.This is invalid combination.We have not populated 1A-2A. Currently 1H-2A is populated where 1A-2A is requested.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar

          Client requesting additional corrections - only 7. Please see new spreadsheet.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Client requesting additional corrections - only 7. Please see new spreadsheet.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Arlette Johnson

          Last 7 corrections to 1095c forms for ADS

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Arlette Johnson Last 7 corrections to 1095c forms for ADS
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Spreadsheet password remains the same.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Spreadsheet password remains the same.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar

          Can we expedite the fix, the customer mentioned that 4 of the changes she's requesting were for forms that were correct prior to the last run. I'm not quite sure what would have caused it but if you have any thoughts I'd be interested to hear.

          Regards,

          Chris

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Can we expedite the fix, the customer mentioned that 4 of the changes she's requesting were for forms that were correct prior to the last run. I'm not quite sure what would have caused it but if you have any thoughts I'd be interested to hear. Regards, Chris
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Chris Finocchio,
          FYI Nandkumar Prabhakar Karlekar

          The requested corrections are done.
          We have re-run reports "1095C" and "1095c ADS 510105665".
          Please refer latest run dated 6/6/2016 of both reports.

          The issues occurred due to EIN changes of some employees.Some employees are falling in two reports.This causes EIN/division change. Please make sure to delete the EIN from Company information if that EIN is not in use.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Chris Finocchio , FYI Nandkumar Prabhakar Karlekar The requested corrections are done. We have re-run reports "1095C" and "1095c ADS 510105665". Please refer latest run dated 6/6/2016 of both reports. The issues occurred due to EIN changes of some employees.Some employees are falling in two reports.This causes EIN/division change. Please make sure to delete the EIN from Company information if that EIN is not in use.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Ramya Tantry
          Nandkumar Prabhakar Karlekar

          Do you know which EIN has duplicate employee's w/510105665?

          Regards,

          Chris

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Ramya Tantry Nandkumar Prabhakar Karlekar Do you know which EIN has duplicate employee's w/510105665? Regards, Chris
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Chris Finocchio
          Nandkumar Prabhakar Karlekar

          Report "1095C" has rule set as "FullTime Only" i.e all active employees are processed in this rule. This rule is not mapped to any EIN.
          Report "1095c ADS 510105665" has rule set to "ADS 510105665" i.e all employees with EIN-510105665 are processed in this rule. Some of the employees fall under EIN as per effective date.So they will show 1H-2A for the months they were not under that EIN.

          Employees fall under both these reports.

          For eg. Matt E Robb

          As per his demographic details,his EIN is set to nothing effective 7/1/2015 and again EIN is set effective 10/31/2015.
          Refer screenshot.

          So the Employee does not fall under EIN 510105665 from 7/1/2015 till 10/31/2015. So 1H-2A is displayed.

          This employee also falls under report named "1095C". Here, there is no criteria of EIN set on this report's rule.So the employee will show codes as per enrollment in the system.i.e 1E-2C for the months 7/1/2015 to 10/31/2015.
          This resulted in the confusion in employee codes as same employee have different codes in different reports.

          If any of the report is not in use please delete the same to avoid confusion so that we can refer to the same report to resolve any issues.Also if any EIN is not in use,please delete it.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Chris Finocchio Nandkumar Prabhakar Karlekar Report "1095C" has rule set as "FullTime Only" i.e all active employees are processed in this rule. This rule is not mapped to any EIN. Report "1095c ADS 510105665" has rule set to "ADS 510105665" i.e all employees with EIN-510105665 are processed in this rule. Some of the employees fall under EIN as per effective date.So they will show 1H-2A for the months they were not under that EIN. Employees fall under both these reports. For eg. Matt E Robb As per his demographic details,his EIN is set to nothing effective 7/1/2015 and again EIN is set effective 10/31/2015. Refer screenshot. So the Employee does not fall under EIN 510105665 from 7/1/2015 till 10/31/2015. So 1H-2A is displayed. This employee also falls under report named "1095C". Here, there is no criteria of EIN set on this report's rule.So the employee will show codes as per enrollment in the system.i.e 1E-2C for the months 7/1/2015 to 10/31/2015. This resulted in the confusion in employee codes as same employee have different codes in different reports. If any of the report is not in use please delete the same to avoid confusion so that we can refer to the same report to resolve any issues.Also if any EIN is not in use,please delete it.

            People

            Assignee:
            cfinocchio Chris Finocchio (Inactive)
            Reporter:
            cfinocchio Chris Finocchio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: