Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-384

ACA_2018_Citrus Valley Health Partners (CVHP)

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Company:
      CVHP
    • Categories:
      ACA
    • Reported by:
      Client

      Description

      NA

        Attachments

          Issue Links

            Activity

            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            1095C for CVHP is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - 1095C for CVHP is ready to run. Thanks!
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have observed that timesheet is updated till 18th Nov 2017.
            Measurement & stability periods are configured such a way that the employees are falling under part time for the months of Nov & Dec 17.So we haven't considered the timesheet to run the 1095C report.

            Please refer latest run date-time 12/14/2017 1:19:41 AM for verification.

            Thanks,
            Revan

            CC- Ramya Tantry, Kumar Chhajed, Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , We have observed that timesheet is updated till 18th Nov 2017. Measurement & stability periods are configured such a way that the employees are falling under part time for the months of Nov & Dec 17.So we haven't considered the timesheet to run the 1095C report. Please refer latest run date-time 12/14/2017 1:19:41 AM for verification. Thanks, Revan CC- Ramya Tantry , Kumar Chhajed , Nandkumar Prabhakar Karlekar
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - I've updated some codes through the UI; please re-run their forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - I've updated some codes through the UI; please re-run their forms. Thanks!
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Ramya Tantry,

            We re-run "1095C for CVHP" report on CVHP production, but found that invalid code combination (1H/2C) is displayed for Nov and Dec month for "MARTHA A. MIER ANDRADE" employee. Also confirmed that this employee record is not correct.

            Can you please look into this.

            Thanks,
            Sachin Hingole

            Smita Pawar Nandkumar Prabhakar Karlekar

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Ramya Tantry , We re-run "1095C for CVHP" report on CVHP production, but found that invalid code combination (1H/2C) is displayed for Nov and Dec month for "MARTHA A. MIER ANDRADE" employee. Also confirmed that this employee record is not correct. Can you please look into this. Thanks, Sachin Hingole Smita Pawar Nandkumar Prabhakar Karlekar
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            As Measurement and stability periods are set up on this company, time-sheet data is referred to calculate Employee eligibility status.
            Measurement and stability periods are configured as below:

            Measurement Period Stability Period
            11/01/2015 - 10/31/2016 11/01/2016 - 10/31/2017
            11/01/2016 - 10/31/2017 11/01/2017 - 10/31/2018

            So for stability of whole 2017 tax year, above measurement period time sheet is used.
            On scanning dates of time-sheet, time-sheet data of 8/27/2017 - 9/23/2017 and 10/8/2017 - 11/04/2017 periods are missing.These are required for the calculating eligibility status of employee for the months of Nov and Dec.

            However,if time- sheet is data is considered,some of the employees are coming up as part time and they are enrolled in ACA medical plan.So line16 shows 2C, but as none of the 1 Series code apply to such scenario,1H is shown which leads to 1H/2C codes.

            As for now,we haven't considered time-sheet data and re-run the report.Please refer latest run for verification.
            Please confirm whether time-sheet data is to be used for the report.

            CC: Sachin Hingole,Smita Pawar,Revansiddha Gaur

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , As Measurement and stability periods are set up on this company, time-sheet data is referred to calculate Employee eligibility status. Measurement and stability periods are configured as below: Measurement Period Stability Period 11/01/2015 - 10/31/2016 11/01/2016 - 10/31/2017 11/01/2016 - 10/31/2017 11/01/2017 - 10/31/2018 So for stability of whole 2017 tax year, above measurement period time sheet is used. On scanning dates of time-sheet, time-sheet data of 8/27/2017 - 9/23/2017 and 10/8/2017 - 11/04/2017 periods are missing.These are required for the calculating eligibility status of employee for the months of Nov and Dec. However,if time- sheet is data is considered,some of the employees are coming up as part time and they are enrolled in ACA medical plan.So line16 shows 2C, but as none of the 1 Series code apply to such scenario,1H is shown which leads to 1H/2C codes. As for now, we haven't considered time-sheet data and re-run the report. Please refer latest run for verification. Please confirm whether time-sheet data is to be used for the report. CC: Sachin Hingole , Smita Pawar , Revansiddha Gaur
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - timesheets have been loaded; please re-run their forms. I also split the run up so please run both reports - 1095C for CVHP and 1095C for Foothill (first time running the Foothill report).

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - timesheets have been loaded; please re-run their forms. I also split the run up so please run both reports - 1095C for CVHP and 1095C for Foothill (first time running the Foothill report).
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            Both Reports are run but found 1H/2C codes which are invalid. I am looking into that.

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , Both Reports are run but found 1H/2C codes which are invalid. I am looking into that. Thanks, Revan
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            Here I am posting my analysis for one of the employee RACHEL ABEJO as below

            Measurement Period Stability Period Stable Working Hours Present
            11/01/2015 - 10/31/2016 11/01/2016 - 10/31/2017 23.7 (Less than 30h not eligible for Full Time)
            11/01/2016 - 10/31/2017 11/01/2017 - 10/31/2018 36.33 (Full time)

            As per stability period & stable working hours shown in above table which is present in the system, the employee has got 1H/2C for all the months except Nov & Dec month.

            So I hope this information may help to you to correct the issue.

            Please let us know If this information is not sufficient, we will let you know on Monday for more details.

            Thanks,
            Revan

            CC-Ramya Tantry, Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , Here I am posting my analysis for one of the employee RACHEL ABEJO as below Measurement Period Stability Period Stable Working Hours Present 11/01/2015 - 10/31/2016 11/01/2016 - 10/31/2017 23.7 (Less than 30h not eligible for Full Time) 11/01/2016 - 10/31/2017 11/01/2017 - 10/31/2018 36.33 (Full time) As per stability period & stable working hours shown in above table which is present in the system, the employee has got 1H/2C for all the months except Nov & Dec month. So I hope this information may help to you to correct the issue. Please let us know If this information is not sufficient, we will let you know on Monday for more details. Thanks, Revan CC- Ramya Tantry , Nandkumar Prabhakar Karlekar
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            As timesheet data is considered for reports, some of the employees were getting 1H/2C codes because they are enrolled in ACA medical plan.So line16 shows 2C, but as none of the 1 Series code apply to such scenario,1H is shown.

            We have fixed this from back-end. Now employees who are part time and enrolled in ACA plan will get 1E codes.
            We have re-run both the reports.Please refer latest run for verification.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , As timesheet data is considered for reports, some of the employees were getting 1H/2C codes because they are enrolled in ACA medical plan.So line16 shows 2C, but as none of the 1 Series code apply to such scenario,1H is shown. We have fixed this from back-end. Now employees who are part time and enrolled in ACA plan will get 1E codes. We have re-run both the reports.Please refer latest run for verification.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - I've been trying to re-run the Foothill forms for close to the last 20 minutes and it seems stuck on batch one of six. Is there an issue?

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - I've been trying to re-run the Foothill forms for close to the last 20 minutes and it seems stuck on batch one of six. Is there an issue?
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            I cancelled it and was able to re-run. Please disregard.

            Show
            jennifer.leugers Jennifer Leugers added a comment - I cancelled it and was able to re-run. Please disregard.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            HI all - could you please add the socials that are attached to the runs for CVHP and for Foothill? They are in the PD class was eliminated from the run but I need them to be included. Password on file is same convention as we've been using.

            Show
            jennifer.leugers Jennifer Leugers added a comment - HI all - could you please add the socials that are attached to the runs for CVHP and for Foothill? They are in the PD class was eliminated from the run but I need them to be included. Password on file is same convention as we've been using.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            There were 27 socials that were attached. Out of those
            1)19 Employees are already present under the CVHP Report
            2)6 Employees are terminated effective 2016 year and they do not have any enrollment hence they cannot be furnished under the report for year 2017.
            3)2 Employees are added under the Foothill Rule by adding additional criteria.
            Please refer latest of 1095C for Foothill Report. We have created new jira for Foothill EIN (WT-13172)
            Please refer attachment for details WT-12495.xls. Password is as per the convention set.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , There were 27 socials that were attached. Out of those 1)19 Employees are already present under the CVHP Report 2)6 Employees are terminated effective 2016 year and they do not have any enrollment hence they cannot be furnished under the report for year 2017. 3)2 Employees are added under the Foothill Rule by adding additional criteria. Please refer latest of 1095C for Foothill Report . We have created new jira for Foothill EIN ( WT-13172 ) Please refer attachment for details WT-12495.xls . Password is as per the convention set.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - could you please load the attached corrections as the client has blanks that they want loaded. After, please re-run this group and the Foothill group (WT-13172). The password on the file once you unzip it is cvhp

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - could you please load the attached corrections as the client has blanks that they want loaded. After, please re-run this group and the Foothill group ( WT-13172 ). The password on the file once you unzip it is cvhp
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have imported code correction on CVHP.
            We have rerun reports on same company.
            Please refer below mentioned latest run to download the report.

            1. 1095C for CVHP---- Run date 2/6/2018 3:51:24 AM
            2. 1095C for Foothill----Run date 2/6/2018 4:20:13 AM

            Tested scenarios are as follows
            1. Valid codes are reflecting
            2. MEC indicator is marked as Yes for all 12 months.
            3. Verified employees from CVHP
            ERMELINDA OLAGUE CUEVAS
            EMMANUEL APOLINARIO
            MYLENE CULATA ALLADO
            MISTIE COURTNEY BRO MONROY

            Details of Code correction import

            Import template: ACA Correction 1095 C Part II SSN
            Navigate to Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> View Bad File
            Download bad file: named as Bad_CVHP Part II load02_06_2018 03_48_00 AM.csv

            Note: While importing the code correction for employee 'MISTIE COURTNEY BRO MONROY', in code correction document Invalid code combination was observed.
            Currently we have refereed his last run's code for this employee and corrected codes. One employee went in Bad file due to Member doesn't exist.

            Thanks!!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have imported code correction on CVHP. We have rerun reports on same company. Please refer below mentioned latest run to download the report. 1. 1095C for CVHP---- Run date 2/6/2018 3:51:24 AM 2. 1095C for Foothill----Run date 2/6/2018 4:20:13 AM Tested scenarios are as follows 1. Valid codes are reflecting 2. MEC indicator is marked as Yes for all 12 months. 3. Verified employees from CVHP ERMELINDA OLAGUE CUEVAS EMMANUEL APOLINARIO MYLENE CULATA ALLADO MISTIE COURTNEY BRO MONROY Details of Code correction import Import template: ACA Correction 1095 C Part II SSN Navigate to Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> View Bad File Download bad file: named as Bad_CVHP Part II load02_06_2018 03_48_00 AM.csv Note: While importing the code correction for employee 'MISTIE COURTNEY BRO MONROY', in code correction document Invalid code combination was observed. Currently we have refereed his last run's code for this employee and corrected codes. One employee went in Bad file due to Member doesn't exist. Thanks!!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - I made corrections through the UI. Please apply corrections and re-run forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - I made corrections through the UI. Please apply corrections and re-run forms. Thanks!
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have rerun '1095C for CVHP' report on production by setting flag Apply User Correction to 'YES'.
            Please refer latest run '2/8/2018 9:40:10 PM' to download the report.
            We have verified corrected code for employee PETER ABLE KERSTEN.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have rerun '1095C for CVHP' report on production by setting flag Apply User Correction to 'YES'. Please refer latest run '2/8/2018 9:40:10 PM' to download the report. We have verified corrected code for employee PETER ABLE KERSTEN. Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - additional corrections for this client are attached (same password convention). I'm asking that you load the file as where they left line 16 blank, they want to overwrite the current codes to the blank. Please load and re-run this group and the Foothill group. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - additional corrections for this client are attached (same password convention). I'm asking that you load the file as where they left line 16 blank, they want to overwrite the current codes to the blank. Please load and re-run this group and the Foothill group. Thanks!
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            We have re-run '1095C for CVHP' report with flag 'Apply User Correction' set to Yes after importing corrections.
            Please refer latest run '2/15/2018 11:15:12 PM' to download report.

            Tested scenarios are as follows.
            1.Valid codes are reflecting of file.
            2.MEC indicator is marked as 'YES' for all 12 months.
            3.Tested sample employees are as follows.
            1.PEDRO A.MERCADO JR

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Jennifer Leugers , We have re-run '1095C for CVHP' report with flag 'Apply User Correction' set to Yes after importing corrections. Please refer latest run '2/15/2018 11:15:12 PM' to download report. Tested scenarios are as follows. 1.Valid codes are reflecting of file. 2.MEC indicator is marked as 'YES' for all 12 months. 3.Tested sample employees are as follows. 1.PEDRO A.MERCADO JR Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            HI all - how do we get all of the years for the 1095C forms to show up on the employees' records? Some clients show two years, some only show one. In particular, CVHP is showing 2015 and 2017 (example employee Ruby Jane Layugan Acdan). I would like to know how to show all years for all clients. Thanks.

            Show
            jennifer.leugers Jennifer Leugers added a comment - HI all - how do we get all of the years for the 1095C forms to show up on the employees' records? Some clients show two years, some only show one. In particular, CVHP is showing 2015 and 2017 (example employee Ruby Jane Layugan Acdan). I would like to know how to show all years for all clients. Thanks.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            The runs which is finalized for that year will get displayed to employee.
            In case of CVHP, runs for years 2015 & 2017 are finalized and avilable for employee.
            To show all years runs, we need to have or create year wise sepearte 1095-C reports and finalize them.

            Thanks,
            Smita

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , The runs which is finalized for that year will get displayed to employee. In case of CVHP, runs for years 2015 & 2017 are finalized and avilable for employee. To show all years runs, we need to have or create year wise sepearte 1095-C reports and finalize them. Thanks, Smita
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            So really it should be best practice to have each year as a separate run. That is going to get pretty messy especially with those companies that have multiple EINs (i.e. if they have six, there are going to be 12 per year so they could have 36 already just for 15-17). Do you think we could have a previous tab within the ACA IRS Reporting and an Active which would only be for current year?

            Show
            jennifer.leugers Jennifer Leugers added a comment - So really it should be best practice to have each year as a separate run. That is going to get pretty messy especially with those companies that have multiple EINs (i.e. if they have six, there are going to be 12 per year so they could have 36 already just for 15-17). Do you think we could have a previous tab within the ACA IRS Reporting and an Active which would only be for current year?
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Ramya Tantry,

             

            Could you check please development changes for request suggested by Jennifer.

             

            Thanks,

            Smita

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Ramya Tantry ,   Could you check please development changes for request suggested by Jennifer.   Thanks, Smita
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

             

            We could change the view of "Show Runs" to show year wise tabs.

            All report run related to a year will be shown on that tab.e.g : 2016 reports runs will be shown under 2016 tab. 2017 runs under 2017 tab.

            This way, multiple year wise finalized run can be saved and same can be view by employees too.

            Please let us know your views/suggestion on this approach so that we can provide tentative estimates for approval.

            CC:Nandkumar Prabhakar Karlekar,Smita Pawar

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers ,   We could change the view of "Show Runs" to show year wise tabs. All report run related to a year will be shown on that tab.e.g : 2016 reports runs will be shown under 2016 tab. 2017 runs under 2017 tab. This way, multiple year wise finalized run can be saved and same can be view by employees too. Please let us know your views/suggestion on this approach so that we can provide tentative estimates for approval. CC: Nandkumar Prabhakar Karlekar , Smita Pawar
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Closing this ticket

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Closing this ticket

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              QA:
              Olivea Carter (Inactive)
              Account Executive:
              lisa davison
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 31.25h
                  31.25h