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
    • Module:
      ACA

      Description

      Please find the attached nail for the same.

        Attachments

        1. Bad_ElectionFile04_17_2016 11_52_19 PM.txt
          0.4 kB
        2. Election and offer.xlsx
          13 kB
        3. Election File.txt
          2 kB
        4. Ossur_Observations.xls
          73 kB
        5. Ossur_Observations.xls
          28 kB
        6. ossur correction.xlsx
          10 kB
        7. RE question on OSSUR.msg
          144 kB

          Activity

          nandkumar Nandkumar Prabhakar Karlekar (Inactive) created issue -
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Field Original Value New Value
          Summary Ossar 1095c Question Ossur 1095c Question
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Attachment Election and offer.xlsx [ 15756 ]
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi Yogesh Chaudhari

          Please import the attached 2015 election and offer file on Ossur company Production.

          There are different plans for same year before 08/01 and after 08/01 so please replace the Plan codes respectively.
          Let me know any other question.

          Election and offer.xlsx

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Yogesh Chaudhari Please import the attached 2015 election and offer file on Ossur company Production. There are different plans for same year before 08/01 and after 08/01 so please replace the Plan codes respectively. Let me know any other question. Election and offer.xlsx
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Chimane Rhodes [ chimane@ebsbenefits.com ] Yogesh Chaudhari [ yogesh.chaudhari ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

          HI Nandkumar Prabhakar Karlekar
          I have imported attached election and offer data for Ossur company on Production.

          There are 3 election records goes into bad, please find the attached bad file Bad_ElectionFile04_17_2016 11_52_19 PM.txt for more information.

          I have imported offer data in POS plan. As Eligibility Credit Amount and Self only Employee Cost for offer data is not provided , I have consider both as zero and data imported .

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited HI Nandkumar Prabhakar Karlekar I have imported attached election and offer data for Ossur company on Production. There are 3 election records goes into bad, please find the attached bad file Bad_ElectionFile04_17_2016 11_52_19 PM.txt for more information. I have imported offer data in POS plan. As Eligibility Credit Amount and Self only Employee Cost for offer data is not provided , I have consider both as zero and data imported .
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Nandkumar [ satyap ]
          Hide
          chimane Chimane Rhodes (Inactive) added a comment -

          i reviewed the updated forms and all are incorrect. Not one is correct. I have forwarded the spreadsheet with details to Nandu.

          Show
          chimane Chimane Rhodes (Inactive) added a comment - i reviewed the updated forms and all are incorrect. Not one is correct. I have forwarded the spreadsheet with details to Nandu.
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi [~chimane@ebsbenefits.com]

          To proceed with this correction i need some discussion on the same.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi [~chimane@ebsbenefits.com] To proceed with this correction i need some discussion on the same.
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Attachment ossur correction.xlsx [ 15942 ]
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi Yogesh Chaudhari

          1. Delete all imported 2015 enrollment and re enrolled as per the new file
          2.Employee termination date need to be updated as per the file
          not only in main table but also overwrite the history data.
          3. Assign the classes as per the main table for all history records.
          4. check the 1095 c are coming as per the mentioned in the file.
          5. if some employee has no class in the main table also then put this employee in the ossur class.

          see the attached
          ossur correction.xlsx

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Yogesh Chaudhari 1. Delete all imported 2015 enrollment and re enrolled as per the new file 2.Employee termination date need to be updated as per the file not only in main table but also overwrite the history data. 3. Assign the classes as per the main table for all history records. 4. check the 1095 c are coming as per the mentioned in the file. 5. if some employee has no class in the main table also then put this employee in the ossur class. see the attached ossur correction.xlsx
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Yogesh Chaudhari [ yogesh.chaudhari ]
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi Sachin Hingole

          Please check the 18 complete employee forms and make sure that the Codes are coming as per the excel sheet attached above.

          File name for codes.
          ossur correction.xlsx

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Sachin Hingole Please check the 18 complete employee forms and make sure that the Codes are coming as per the excel sheet attached above. File name for codes. ossur correction.xlsx
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Environment Production [ 10005 ]
          Issue Type Enhancement [ 4 ] Support Activity [ 10301 ]
          Status New Request [ 10029 ] Open [ 1 ]
          Support Task Type Data Correction [ 11203 ]
          Workflow WT_Features [ 15169 ] WT_Support [ 15427 ]
          Hide
          chimane Chimane Rhodes (Inactive) added a comment -

          I checked those and agree those are correct

          Show
          chimane Chimane Rhodes (Inactive) added a comment - I checked those and agree those are correct
          Hide
          chimane Chimane Rhodes (Inactive) added a comment -

          Adding to my comment i reviewed the attached spreadsheet and verified the dates for the 2c code as being what we need for the forms to be correct. The forms need to match this spreadsheet.

          Show
          chimane Chimane Rhodes (Inactive) added a comment - Adding to my comment i reviewed the attached spreadsheet and verified the dates for the 2c code as being what we need for the forms to be correct. The forms need to match this spreadsheet.
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Attachment Election File.txt [ 15978 ]
          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

          Hi Sachin Hingole Nandkumar Prabhakar Karlekar

          I have deleted all the enrollment data for 2015 which I had imported and re enrolled election data of attached new file. I have updated termination date and classes of employee in main and history table as well.

          Also cost has not get any of the imported enrollment data. Nandkumar Prabhakar Karlekar Can you pls check this? Please find the attached election file imported on company Election File.txt .

          Employee Jonathan L. Wibbenmeyer whose spouse is not exists in the system. I could not import enrollment for his spouse.

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Sachin Hingole Nandkumar Prabhakar Karlekar I have deleted all the enrollment data for 2015 which I had imported and re enrolled election data of attached new file. I have updated termination date and classes of employee in main and history table as well. Also cost has not get any of the imported enrollment data. Nandkumar Prabhakar Karlekar Can you pls check this? Please find the attached election file imported on company Election File.txt . Employee Jonathan L. Wibbenmeyer whose spouse is not exists in the system. I could not import enrollment for his spouse.
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Attachment Ossur_Observations.xls [ 15994 ]
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Hi Nandkumar Prabhakar Karlekar, Yogesh Chaudhari

          We re-run 1095C report on Ossur from production and verified PDF, There are
          wrong codes displayed on line 16. Please refer attached excel Ossur_Observations.xls.

          Let us know if you need any other details.

          Thanks,
          Sachin Hingole

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , Yogesh Chaudhari We re-run 1095C report on Ossur from production and verified PDF, There are wrong codes displayed on line 16. Please refer attached excel Ossur_Observations.xls . Let us know if you need any other details. Thanks, Sachin Hingole
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Nandkumar [ satyap ]
          Hide
          chimane Chimane Rhodes (Inactive) added a comment -

          The January 2nd start date is incorrect it should be january 1st for all of these employees that are indicated as a Jan. 2nd start date.

          Show
          chimane Chimane Rhodes (Inactive) added a comment - The January 2nd start date is incorrect it should be january 1st for all of these employees that are indicated as a Jan. 2nd start date.
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          [~chimane@ebsbenefits.com]

          I am working on the same. I will update you on the same today itself.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - [~chimane@ebsbenefits.com] I am working on the same. I will update you on the same today itself.
          Hide
          chimane Chimane Rhodes (Inactive) added a comment -

          why a 1G for Mylet? Was active and then terminated was enrolled on the POS plan Jan. 1 - Jan 31.

          Show
          chimane Chimane Rhodes (Inactive) added a comment - why a 1G for Mylet? Was active and then terminated was enrolled on the POS plan Jan. 1 - Jan 31.
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          [~chimane@ebsbenefits.com]

          I am working on the same. I will update you on the same today itself. I will test all record and solve each and every problem.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - [~chimane@ebsbenefits.com] I am working on the same. I will update you on the same today itself. I will test all record and solve each and every problem.
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Attachment Ossur_Observations.xls [ 16047 ]
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi [~chimane@ebsbenefits.com]

          Mylet Jeffrey R This employee is hired in December 14 so The Jan month displaying the 2D which is correct but you have requested the 2 C.

          below 2 employee have waived the coverage.

          Shin Elizabeth
          HannStacey
          So the terminated month are Showing the 2H instated of 2B.

          Rest all employees are correct.Please see the attached excel where the requirement and what 1095 c coded are Produced by WORKTERRA.
          Ossur_Observations.xls

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi [~chimane@ebsbenefits.com] Mylet Jeffrey R This employee is hired in December 14 so The Jan month displaying the 2D which is correct but you have requested the 2 C. below 2 employee have waived the coverage. Shin Elizabeth HannStacey So the terminated month are Showing the 2H instated of 2B. Rest all employees are correct.Please see the attached excel where the requirement and what 1095 c coded are Produced by WORKTERRA. Ossur_Observations.xls
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Nandkumar Prabhakar Karlekar (Inactive) made transition -
          New Request Open
          8d 15m 1
          Nandkumar Prabhakar Karlekar (Inactive) made transition -
          Open Resolved
          20d 11h 52m 1
          Nandkumar Prabhakar Karlekar (Inactive) made transition -
          Resolved Closed
          5s 1

            People

            Assignee:
            nandkumar Nandkumar Prabhakar Karlekar (Inactive)
            Reporter:
            nandkumar Nandkumar Prabhakar Karlekar (Inactive)
            Account Executive:
            Chimane Rhodes (Inactive)
            Developer:
            Nandkumar Prabhakar Karlekar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: