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

City of Ripon Historical Load - Kaiser employees

    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:
      ACA Historical Data Load
    • Reported by:
      Support
    • Company:
      SDRMA
    • Module:
      BenAdmin

      Description

      City of Ripon ACA spread sheet uploaded to FTP site

        Attachments

          Activity

          cfinocchio Chris Finocchio (Inactive) created issue -
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Field Original Value New Value
          Assignee Nandkumar [ satyap ] Yogesh Chaudhari [ yogesh.chaudhari ]
          Hide
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

          Loaded the employee demographics data on Production. Sent email to Jenni Fernandes regarding Kaiser plan setup. I created a Kaiser HMO 20 plan in production with the benefit provider of Kaiser. There was an old Kaiser plan but it had PPO as the type and the Benefit Provider selected was Healthnet. Ready to load the Elections with dates of 1/1/2015 to 12/31/2015 but want to confirm the plan to use first.
          Do we only need to load the election data or is there more that needs to be loaded for ACA reporting?

          Show
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Loaded the employee demographics data on Production. Sent email to Jenni Fernandes regarding Kaiser plan setup. I created a Kaiser HMO 20 plan in production with the benefit provider of Kaiser. There was an old Kaiser plan but it had PPO as the type and the Benefit Provider selected was Healthnet. Ready to load the Elections with dates of 1/1/2015 to 12/31/2015 but want to confirm the plan to use first. Do we only need to load the election data or is there more that needs to be loaded for ACA reporting?
          Hide
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

          Loaded all data except the Benefit Elections. Sent email with load file to Elena and Chris. No cost amount was included in data. Need to know what value(s) need to be loaded.

          Thanks

          Show
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Loaded all data except the Benefit Elections. Sent email with load file to Elena and Chris. No cost amount was included in data. Need to know what value(s) need to be loaded. Thanks
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Nandkumar [ satyap ]
          Hide
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

          Chris FinocchioLena KantemirovaLoaded Benefit data without cost. Can you please let me know if you need anything else.
          Thanks

          Show
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Chris Finocchio Lena Kantemirova Loaded Benefit data without cost. Can you please let me know if you need anything else. Thanks
          cfinocchio Chris Finocchio (Inactive) made changes -
          Attachment Copy of WORKTERRA ACAMP IRS Reporting Tool Configuration Data Files v2016-02-16 LK Ripon.xlsx [ 13916 ]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Cindy Wibbing Nandkumar Prabhakar Karlekar

          Added lowest cost plan value to customization (142.80)

          Ready to run eligibility. 3/18/16 12:27pm

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Cindy Wibbing Nandkumar Prabhakar Karlekar Added lowest cost plan value to customization (142.80) Ready to run eligibility. 3/18/16 12:27pm
          Hide
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment -

          This client is under SDRMA - please run eligibility after your current project

          Show
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment - This client is under SDRMA - please run eligibility after your current project
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Updating JIRA 795 on my review of their ACA report.

          Show
          jennifer.leugers Jennifer Leugers added a comment - Updating JIRA 795 on my review of their ACA report.
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Process eligibility completed

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Process eligibility completed
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ] Rakesh Roy [ rakeshr ]
          Status Open [ 1 ] In Progress [ 3 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ]
          Hide
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment -

          ready to run

          Show
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment - ready to run
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Assignee Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ] Jennifer Leugers [ jennifer.leugers ]
          Hide
          sallison Steve Allison (Inactive) added a comment -

          So who is running them and delivering to Lisa Farrell and the client??? Lena, I just cc'd you on an email from the client. They were expecting this to go to them first thing this morning so need to get that done. Can you do it? Does Nandu?

          Show
          sallison Steve Allison (Inactive) added a comment - So who is running them and delivering to Lisa Farrell and the client??? Lena, I just cc'd you on an email from the client. They were expecting this to go to them first thing this morning so need to get that done. Can you do it? Does Nandu?
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          All - There is a question with the reports:

          James Bell is showing a 2C in Jan and a 2G with Feb going forward. Ripon believes this should be a 2G in Jan. Can you help explain this?

          Jenni

          Lena Kantemirova

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - All - There is a question with the reports: James Bell is showing a 2C in Jan and a 2G with Feb going forward. Ripon believes this should be a 2G in Jan. Can you help explain this? Jenni Lena Kantemirova
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Cindy Wibbing

          We need Kaiser history reloaded to reflect plan start date of 01/01/2015

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Cindy Wibbing We need Kaiser history reloaded to reflect plan start date of 01/01/2015
          cfinocchio Chris Finocchio (Inactive) made changes -
          Assignee Jennifer Leugers [ jennifer.leugers ] Cindy Wibbing [ cindy.wibbing ]
          cfinocchio Chris Finocchio (Inactive) made changes -
          Attachment ACA Enrollment Load Updated.txt [ 14333 ]
          Attachment ACA Enrollment Load Updated.xlsx [ 14334 ]
          Attachment ACA Enrollment Load.xlsx [ 14335 ]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Cindy Wibbing

          Please reload/replace Kaiser (ACA Enrollment xls) with Enrollment Termination Date set to 12-31-2015 instead of 01-31-2015 unless different date than 01-31-15. let me know if you have any questions - Chris

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Cindy Wibbing Please reload/replace Kaiser (ACA Enrollment xls) with Enrollment Termination Date set to 12-31-2015 instead of 01-31-2015 unless different date than 01-31-15. let me know if you have any questions - Chris
          Hide
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

          Chris Finocchio
          Hi Chris,
          The elections have been reloaded as per your instructions.
          Let me know if you need anything else.

          Show
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Chris Finocchio Hi Chris, The elections have been reloaded as per your instructions. Let me know if you need anything else.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar

          Cindy Wibbing re-loaded City of Ripon historical data. Please run eligibility file.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Cindy Wibbing re-loaded City of Ripon historical data. Please run eligibility file.
          cfinocchio Chris Finocchio (Inactive) made changes -
          Assignee Cindy Wibbing [ cindy.wibbing ] Nandkumar [ satyap ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ]
          Hide
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment -

          Would you confirm if we need to rerun historical data for this?

          Show
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment - Would you confirm if we need to rerun historical data for this?
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Assignee Lena Kantemirova [ elena.kantemirova@ebsbenefits.com ] Nandkumar [ satyap ]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Jennifer Johnson

          The City of Ripon 1095c forms have been re-run with corrected historical load and eligibility re-run. Forms ready for customer review.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Jennifer Johnson The City of Ripon 1095c forms have been re-run with corrected historical load and eligibility re-run. Forms ready for customer review.
          cfinocchio Chris Finocchio (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Jennifer Fernandes [ jjsassy99 ]
          Hide
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment -

          additional issues are tracked here: Y:\ACA Reporting\ACA Data Issues

          Show
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment - additional issues are tracked here: Y:\ACA Reporting\ACA Data Issues
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Rakesh Roy (Inactive) made transition -
          Open In Progress
          4d 4h 8m 1
          Lena Kantemirova (Inactive) made transition -
          In Progress Resolved
          22d 16h 20m 1
          Lena Kantemirova (Inactive) made transition -
          Resolved Closed
          2s 1

            People

            Assignee:
            jjsassy99 Jennifer Johnson (Inactive)
            Reporter:
            cfinocchio Chris Finocchio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: