WORKTERRAProject Type: software

WORKTERRA

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

Northbrook: ACA 1095 analysis

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Support
    • Company:
      IPBC- Village of Northbrook
    • Module:
      BenAdmin
    • Issue Importance:
      Must Have

      Description

      Hi all:

      The 1095 c analysis report is not working correctly.

      The Village’s data show all or most folks having HMO coverage for the first six months and PPO coverage for the last six months. That is not the case. Initial reports from Workterra showed this problem.

      The data shows Greg Van dahm with HMO coverage January through June. Greg shoudlhave PPO for all 12 months.

      Could I get a new analysis that shows the correct coverage plan description by tomorrow?

      Thank you,
      Sam

        Attachments

        1. ACA1095C (40).xls
          1.21 MB
          sam lindberg
        2. Newly added rate impact .xlsx
          13 kB
          Nandkumar Prabhakar Karlekar

          Activity

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

          Hi sam lindberg

          Please refer the below run we have completed the Same.

          Village of Northbrook
          Rundate: 6/16/2016 4:53

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi sam lindberg Please refer the below run we have completed the Same. Village of Northbrook Rundate: 6/16/2016 4:53
          Hide
          Permalink
          sam.lindberg@ebsbenefits.com sam lindberg (Inactive) added a comment -

          This is systemic issue. There are many more that are liek this. Please look at this one as an example 249533469.

          Greg van dahm is fixed.

          Please reassess.I have attached the pivot table that shows the affect population. There could be more. ACA1095C (40).xls

          Thank you,
          Sam

          Show
          sam.lindberg@ebsbenefits.com sam lindberg (Inactive) added a comment - This is systemic issue. There are many more that are liek this. Please look at this one as an example 249533469. Greg van dahm is fixed. Please reassess.I have attached the pivot table that shows the affect population. There could be more. ACA1095C (40).xls Thank you, Sam
          Hide
          Permalink
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Plan : BCBS - Medical HMO - Active has 91.55 EE cost on ACA Configrution for complete year,So Plan BCBS - Medical PPO- Active has more then 100 cost for Jan to June.

          so the majority of employee is getting the cost "BCBS - Medical HMO - Active" plan as lowest cost from jan to june and after that "BCBS - Medical PPO- Active"

          I have verifed your employees and analyzed the same .If you have still any specific question let me know

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Plan : BCBS - Medical HMO - Active has 91.55 EE cost on ACA Configrution for complete year,So Plan BCBS - Medical PPO- Active has more then 100 cost for Jan to June. so the majority of employee is getting the cost "BCBS - Medical HMO - Active" plan as lowest cost from jan to june and after that "BCBS - Medical PPO- Active" I have verifed your employees and analyzed the same .If you have still any specific question let me know
          Hide
          Permalink
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited

          [^New added rate impact.xlsx]

          Hi sam lindberg

          Concern : EE lowest cost plan is not correct on Analysis report.
          Cause: This rate is added for 2015 year in 2016 and this is causing this issue,
          Correction : we have fixed and updated the SP on Production affected Companies,
          Corrected the Report and Audited the 1095 c report there is no any major impact found on 1095 c delivered PDF of last finilized run.

          Please find the Attached excel for more Analysis and impact and let me know any more action is needed from our side.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited [^New added rate impact.xlsx] Hi sam lindberg Concern : EE lowest cost plan is not correct on Analysis report. Cause: This rate is added for 2015 year in 2016 and this is causing this issue, Correction : we have fixed and updated the SP on Production affected Companies, Corrected the Report and Audited the 1095 c report there is no any major impact found on 1095 c delivered PDF of last finilized run. Please find the Attached excel for more Analysis and impact and let me know any more action is needed from our side.
          Hide
          Permalink
          sam.lindberg@ebsbenefits.com sam lindberg (Inactive) added a comment -

          Thank you very much!!!!!!

          Sam

          Show
          sam.lindberg@ebsbenefits.com sam lindberg (Inactive) added a comment - Thank you very much!!!!!! Sam

            People

            Assignee:
            nandkumar Nandkumar Prabhakar Karlekar (Inactive)
            Reporter:
            sam.lindberg@ebsbenefits.com sam lindberg (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: