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

ACA - 2017 : Citrus Valley Health Partners (CVHP) 1095C Reports

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Reported by:
      Support
    • Company:
      CVHP
    • Module:
      ACA - 2017

      Attachments

        Activity

        ramya.tantry Ramya Tantry (Inactive) created issue -
        ramya.tantry Ramya Tantry (Inactive) logged work - 23/Nov/16 12:53 PM
        • Time Spent:
          0.5h
           

          Check ACA Customization.
          Time sheet analysis

        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,

        We observed that measurement and stability rules are set on this company and timesheet for 2015 is also loaded.
        But as per measurement and stability rules,
        Measurement period is divided into 11/1/2014-10/31/2015 and 11/1/2015-10/31/2016 and
        stability period for 2016 year is divided into 2 parts i.e 11/1/2015-10/31/2016 and 11/1/2016-10/31/2017. For measurement period 11/1/2015-10/31/2016, time sheet is not present for the year 2016, so employees are coming up as part time for months Nov and Dec of year 2016 as only Nov and Dec 2015 timesheet data is present. So codes of part time will be displayed.

        Please verify the measurement and stability rules and import 2016 timesheet of employees.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We observed that measurement and stability rules are set on this company and timesheet for 2015 is also loaded. But as per measurement and stability rules, Measurement period is divided into 11/1/2014-10/31/2015 and 11/1/2015-10/31/2016 and stability period for 2016 year is divided into 2 parts i.e 11/1/2015-10/31/2016 and 11/1/2016-10/31/2017. For measurement period 11/1/2015-10/31/2016, time sheet is not present for the year 2016, so employees are coming up as part time for months Nov and Dec of year 2016 as only Nov and Dec 2015 timesheet data is present. So codes of part time will be displayed. Please verify the measurement and stability rules and import 2016 timesheet of employees. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Field Original Value New Value
        Remaining Estimate 2h [ 7200 ]
        Original Estimate 2h [ 7200 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 2h [ 7200 ] 1.5h [ 5400 ]
        Time Spent 0.5h [ 1800 ]
        Worklog Id 10297 [ 10297 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Ramya - we won't know the # of hours for those months until they are worked. We will make sure the client knows November and December will be updated once hours are loaded. Please run 2016 1095C for CVHP

        Show
        jennifer.leugers Jennifer Leugers added a comment - Ramya - we won't know the # of hours for those months until they are worked. We will make sure the client knows November and December will be updated once hours are loaded. Please run 2016 1095C for CVHP
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,

        We have re-run "2016 1095C for CVHP" with existing customization. Please refer latest run for verification.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have re-run "2016 1095C for CVHP" with existing customization. Please refer latest run for verification. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 1.5h [ 5400 ] 0.5h [ 1800 ]
        Time Spent 0.5h [ 1800 ] 1.5h [ 5400 ]
        Worklog Id 12241 [ 12241 ]
        ramya.tantry Ramya Tantry (Inactive) logged work - 09/Dec/16 06:32 PM
        • Time Spent:
          1h
           

          Check ACA Customization.
          Save Measurement and stability rules.
          Furnish 1095C report.
          verify Sample pdf
          verify Analysis report.

        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        All - questions for the CVHP run

        It does not seem that the waiting periods are showing correctly. Example employee Ryan Wool - hired 1.25.16 and has benefits effective 3.1.16 but February is showing 1A / 2F. Shouldn't it be showing 2D? Employee Nicci West hired date was 3.9.16 and has benefits effective 5.1.16 but April is showing 2F instead of 2D.

        Another question - David Victor Mojica was an employee in 2015 but termed before 2016. He did however go on his Mother's benefits from 1.1.16 - 6.30.16 (employee Margie Mojica). He aged out and thus went into COBRA and is in WORKTERRA under a COBRA status from 7.1.16 forward. As he was not an employee at anytime in 2016, I do not believe he should get a 1095C form. Please confirm this is your understanding as well.

        Show
        jennifer.leugers Jennifer Leugers added a comment - All - questions for the CVHP run It does not seem that the waiting periods are showing correctly. Example employee Ryan Wool - hired 1.25.16 and has benefits effective 3.1.16 but February is showing 1A / 2F. Shouldn't it be showing 2D? Employee Nicci West hired date was 3.9.16 and has benefits effective 5.1.16 but April is showing 2F instead of 2D. Another question - David Victor Mojica was an employee in 2015 but termed before 2016. He did however go on his Mother's benefits from 1.1.16 - 6.30.16 (employee Margie Mojica). He aged out and thus went into COBRA and is in WORKTERRA under a COBRA status from 7.1.16 forward. As he was not an employee at anytime in 2016, I do not believe he should get a 1095C form. Please confirm this is your understanding as well.
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 05/Jan/17 10:26 AM
        • Time Spent:
          0.5h
           
          <No comment>
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
        Time Spent 1.5h [ 5400 ] 2h [ 7200 ]
        Worklog Id 17415 [ 17415 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Attachment CVHP_Mojica.png [ 36714 ]
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,

        #1: The waiting periods were not showing correctly as we were considering today's date in populating effective date. We have resolved this. Please refer latest run for verification.

        #2: Employee David Victor Mojica termed on 01/15/2016.As he was employed for the first 15 days in the month of Jan, he got a 1095C form.
        Please refer screenshot:

        Our observation is that by using timesheet data, most of the employees codes are not coming properly. This may be due incomplete timesheet data.
        We have not considered timesheet data in the latest run. We have considered employee type set on Demographics page.
        Please let us know if timesheet data is to be considered. If yes, please ensure that the loaded data is proper.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole,Smita Pawar

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , #1: The waiting periods were not showing correctly as we were considering today's date in populating effective date. We have resolved this. Please refer latest run for verification. #2: Employee David Victor Mojica termed on 01/15/2016.As he was employed for the first 15 days in the month of Jan, he got a 1095C form. Please refer screenshot: Our observation is that by using timesheet data, most of the employees codes are not coming properly. This may be due incomplete timesheet data. We have not considered timesheet data in the latest run. We have considered employee type set on Demographics page. Please let us know if timesheet data is to be considered. If yes, please ensure that the loaded data is proper. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole , Smita Pawar
        ramya.tantry Ramya Tantry (Inactive) logged work - 05/Jan/17 12:42 PM
        • Time Spent:
          4h
           

          Analysis of the query
          Report re-reun
          verify analysis report
          verify pdf
          draft reply

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 2h [ 7200 ] 6h [ 21600 ]
        Worklog Id 17497 [ 17497 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223)
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
        Hide
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

        Hello,
        Feel free to reopen in case any further action required on this. Thank you.

        Show
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hello, Feel free to reopen in case any further action required on this. Thank you.
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Resolution Done [ 10000 ]
        Status In Progress [ 3 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times
        Ramya Tantry (Inactive) made transition -
        Open Waiting for Customer Input
        4h 2m 1
        Nandkumar Prabhakar Karlekar (Inactive) made transition -
        Waiting for Customer Input In Progress
        307d 17h 16m 1
        Nandkumar Prabhakar Karlekar (Inactive) made transition -
        In Progress Closed
        3m 51s 1

          People

          Assignee:
          jennifer.leugers Jennifer Leugers
          Reporter:
          ramya.tantry Ramya Tantry (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          4 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Production Due Date:

              Time Tracking

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