Details

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

      Description

      NA

        Attachments

        1. ACA 1095C Correction Import Template 2.8.18.zip
          0.9 kB
        2. IRS 1095-C JE Dunn-Checklist.xls
          9 kB
        3. screenshot-1.png
          screenshot-1.png
          77 kB
        4. TOC_ACA1095CCodeComparison.xls
          16 kB
        5. TOC.zip
          2 kB
        6. TownOfCary_Jack_Frazier.PNG
          TownOfCary_Jack_Frazier.PNG
          32 kB
        7. Winfield_Hunter_Enrollment.JPG
          Winfield_Hunter_Enrollment.JPG
          80 kB

          Issue Links

            Activity

            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones WT-12484 [ WT-12484 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ] Town of Cary [ 10538 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Description All companies are linked to this Jira which will get processed for IRS submission in year 2018
            smita.pawar Smita Pawar (Inactive) made changes -
            Account Executive Kevin Walker [ kwalker ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Kumar Chhajed [ kumar.chhajed ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Report 1095C for TOC is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Report 1095C for TOC is ready to run. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 08/Dec/17 08:30 AM
            • Time Spent:
              0.75h
               

              Analysis and discussion with Smita

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 95268 [ 95268 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have RUN 1095-C report on Town of Cary company.
            Please refer run of Run date as of '12/7/2017 9:40:36 PM'.
            Attaching QA verification check list for additional information.

            Please refer Jira:WT-6315. Last year TOC has suggested EE Cost changes.
            Let us know, if any such changes are needs to be done this year also.
            We need to do some code changes to incorporate such changes.
            It will be very helpful if we get such information in advance.

            Thanks,

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have RUN 1095-C report on Town of Cary company. Please refer run of Run date as of '12/7/2017 9:40:36 PM'. Attaching QA verification check list for additional information. Please refer Jira: WT-6315 . Last year TOC has suggested EE Cost changes. Let us know, if any such changes are needs to be done this year also. We need to do some code changes to incorporate such changes. It will be very helpful if we get such information in advance. Thanks,
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment IRS 1095-C JE Dunn-Checklist.xls [ 69698 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            smita.pawar Smita Pawar (Inactive) logged work - 08/Dec/17 01:56 PM - edited
            • Time Spent:
              1h 25m
               

              Analysis
              Discussion
              Draft
              Jira updates

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 0.75h [ 2700 ] 2h 10m [ 7800 ]
            Worklog Id 99065 [ 99065 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 99065 [ 99065 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment - - edited

            Hi all - confirmed with the client that we need to enter the cost changes. Cary’s employee only monthly premium contribution without any reward for wellness is $176.59 from January 2017 – June 2017 and $192.29 from July 2017 – December 2017. The plan is Health Plan. Please make the changes requested and re-run the forms tonight if at all possible. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - - edited Hi all - confirmed with the client that we need to enter the cost changes. Cary’s employee only monthly premium contribution without any reward for wellness is $176.59 from January 2017 – June 2017 and $192.29 from July 2017 – December 2017. The plan is Health Plan. Please make the changes requested and re-run the forms tonight if at all possible. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Kumar Chhajed [ kumar.chhajed ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            kumar.chhajed Kumar Chhajed (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have re-run the report. Please refer run date 1/3/2018 9:29:59 PM for verification.
            We have created two class wise configuration for rule 1095c Rule New, one from Jan 2017 to June 2017 with cost $176.59 & another from July 2017 to Dec 2017 with cost $192.29 with a change in back-end for Health Plan.

            Show
            kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Jennifer Leugers , We have re-run the report. Please refer run date 1/3/2018 9:29:59 PM for verification. We have created two class wise configuration for rule 1095c Rule New , one from Jan 2017 to June 2017 with cost $176.59 & another from July 2017 to Dec 2017 with cost $192.29 with a change in back-end for Health Plan.
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 04/Jan/18 07:51 AM
            • Time Spent:
              0.25h
               

              Discussion with Kumar

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 2h 10m [ 7800 ] 2h 25m [ 8700 ]
            Worklog Id 99290 [ 99290 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 2h 25m [ 8700 ] 3h 55m [ 14100 ]
            Worklog Id 99379 [ 99379 ]
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 04/Jan/18 02:06 PM
            • Time Spent:
              1.5h
               

              Run Reports
              Draft reply
              Internal Discussion

            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - thanks for re-running the forms but there are still about 30 individuals in the RETIREE OR RETLAW Class 1 and 8888-RETIREES in Class 2 that are still showing a 1A for a month. Could you please check into this and advise as to why? Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - thanks for re-running the forms but there are still about 30 individuals in the RETIREE OR RETLAW Class 1 and 8888-RETIREES in Class 2 that are still showing a 1A for a month. Could you please check into this and advise as to why? Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Kumar Chhajed [ kumar.chhajed ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Attachment TownOfCary_Jack_Frazier.PNG [ 71332 ]
            Hide
            kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            The employees which are getting 1A for certain month are those employees which are not Enrolled/Offered under Health Plan for that particular month. In your earlier comment you have mentioned the cost change only for Health Plan.
            We have verified this on HSPL company by raising the qualifying event for the month which the employees are getting 1A.
            Example - JACK FRAZIER is marked 1A for month 03/01/2017, so we raised a qualifying event for the same and he is enrolled/offered under Retiree Health Plan & Retiree Supplemental. Refer

            Show
            kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited Hi Jennifer Leugers , The employees which are getting 1A for certain month are those employees which are not Enrolled/Offered under Health Plan for that particular month. In your earlier comment you have mentioned the cost change only for Health Plan . We have verified this on HSPL company by raising the qualifying event for the month which the employees are getting 1A. Example - JACK FRAZIER is marked 1A for month 03/01/2017, so we raised a qualifying event for the same and he is enrolled/offered under Retiree Health Plan & Retiree Supplemental . Refer
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 3h 55m [ 14100 ] 5h 55m [ 21300 ]
            Worklog Id 99467 [ 99467 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
            Time Spent 5h 55m [ 21300 ] 4h 55m [ 17700 ]
            Worklog Id 99467 [ 99467 ]
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 05/Jan/18 02:11 PM - edited
            • Time Spent:
              1h
               

              Query Analysis
              Draft reply
              Internal Discussion with ramya

            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            I'm not following. The employee in your example was set to Retired in February so why would we be showing coverage at all? Shouldn't that be a 1H/2A since they are "Retiree" and not Active?

            Show
            jennifer.leugers Jennifer Leugers added a comment - I'm not following. The employee in your example was set to Retired in February so why would we be showing coverage at all? Shouldn't that be a 1H/2A since they are "Retiree" and not Active?
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Kumar Chhajed [ kumar.chhajed ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 09/Jan/18 12:17 PM
            • Time Spent:
              1h
               

              Analysis
              Draft reply

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

            Hi Jennifer Leugers,

            As per the current system implementation,We mark the employee part time from the following month.i.e if employee was retired/terminated from 2/3/2017 then we mark employee part time from 3/1/2017.For the month of Feb,his status is not changed.So codes get generated accordingly.
            For this employee,he is retired in Feb and as we mark him part time from March,codes are furnished for Feb month as per offers applicable.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , As per the current system implementation,We mark the employee part time from the following month.i.e if employee was retired/terminated from 2/3/2017 then we mark employee part time from 3/1/2017.For the month of Feb,his status is not changed.So codes get generated accordingly. For this employee,he is retired in Feb and as we mark him part time from March,codes are furnished for Feb month as per offers applicable.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Time Spent 4h 55m [ 17700 ] 5h 55m [ 21300 ]
            Worklog Id 99770 [ 99770 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Shouldn't the cost be 1E/2B as per the others that the client requested?

            Show
            jennifer.leugers Jennifer Leugers added a comment - Shouldn't the cost be 1E/2B as per the others that the client requested?
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            As per my earlier comment,Employee is full time in the month he is terminated and he had offer of a plan for the whole month whose cost is $0.So 1A-2C is generated. 2B will not come as 2B will come only when full time employee termination causes coverage to terminate.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , As per my earlier comment,Employee is full time in the month he is terminated and he had offer of a plan for the whole month whose cost is $0.So 1A-2C is generated. 2B will not come as 2B will come only when full time employee termination causes coverage to terminate.
            ramya.tantry Ramya Tantry (Inactive) logged work - 10/Jan/18 10:00 AM
            • Time Spent:
              2h
               

              Analysis and discussion
              Draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 5h 55m [ 21300 ] 7h 55m [ 28500 ]
            Worklog Id 99854 [ 99854 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Attachment TOC_ACA1095CCodeComparison.xls [ 71567 ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have made some changes in the code to reflect 1H/2A in the month of their termination if they were terminated on 1st day of the month.We have re-run the report and compared it with previous run.Please find attached excel sheet TOC_ACA1095CCodeComparison.xls .Password is as per the convention communicated.
            Comparison shows 34 records whose codes are changed from 1A/2C to 1H/2A. Run1 in the report is the previous run and Run 2 is the latest run dated "01/10/2018".
            Please let us know in case you have any queries.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have made some changes in the code to reflect 1H/2A in the month of their termination if they were terminated on 1st day of the month.We have re-run the report and compared it with previous run.Please find attached excel sheet TOC_ACA1095CCodeComparison.xls .Password is as per the convention communicated. Comparison shows 34 records whose codes are changed from 1A/2C to 1H/2A. Run1 in the report is the previous run and Run 2 is the latest run dated "01/10/2018". Please let us know in case you have any queries.
            ramya.tantry Ramya Tantry (Inactive) logged work - 10/Jan/18 12:41 PM
            • Time Spent:
              1h
               

              Code changes and testing
              Draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 7h 55m [ 28500 ] 8h 55m [ 32100 ]
            Worklog Id 99867 [ 99867 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - I uploaded some corrections via the UI. Please re-run the forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - I uploaded some corrections via the UI. Please re-run the forms. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Progress [ 3 ] On Hold [ 10507 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            We have rerun the '1095C for TOC'.
            Please refer latest run '2/11/2018 10:44:03 PM' to download.

            Tested scenarios are as follows.
            1.Valid codes are reflecting on report.
            2.MEC indicator is Marked as YES for all 12 months.
            3.Tested corrected sample employees are as follows.
            LUN RCOM
            DONNA TORRISI
            GAIL TAYLOR
            JUNE NEMETZ

            Thanks

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Jennifer Leugers , We have rerun the '1095C for TOC'. Please refer latest run '2/11/2018 10:44:03 PM' to download. Tested scenarios are as follows. 1.Valid codes are reflecting on report. 2.MEC indicator is Marked as YES for all 12 months. 3.Tested corrected sample employees are as follows. LUN RCOM DONNA TORRISI GAIL TAYLOR JUNE NEMETZ Thanks
            smita.pawar Smita Pawar (Inactive) made changes -
            Status On Hold [ 10507 ] In Progress [ 3 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            smita.pawar Smita Pawar (Inactive) logged work - 12/Feb/18 01:14 PM
            • Time Spent:
              2.25h
               

              Analysis
              Internal communication
              Verification
              Draft
              Jira updates

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 8h 55m [ 32100 ] 11h 10m [ 40200 ]
            Worklog Id 104198 [ 104198 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - some of the changes did not "work" again - they defaulted back to 1G. Please upload the attached and verify the codes are all uploaded including those that are currently 1G.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - some of the changes did not "work" again - they defaulted back to 1G. Please upload the attached and verify the codes are all uploaded including those that are currently 1G.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            jennifer.leugers Jennifer Leugers made changes -
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Hi Jennifer Leugers

            We have rerun the '1095C for TOC'.
            Please download the latest run '2/19/2018 10:51:50 PM' to download.

            Tested scenarios are as follows.
            1.Valid codes are reflecting on the report.
            2Tested corrected sample employees are as follows.
            TAYLOR GAIL
            NEMETZ JUNE
            HINSON HOUSTON
            RCOM LUN
            FOSTER CLAUDE

            Please review and let me know for any correction.

            Mahendra

            CC- Sachin Hingole Rakesh Roy Smita Pawar Ramya Tantry

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Hi Jennifer Leugers We have rerun the '1095C for TOC'. Please download the latest run '2/19/2018 10:51:50 PM' to download. Tested scenarios are as follows. 1.Valid codes are reflecting on the report. 2Tested corrected sample employees are as follows. TAYLOR GAIL NEMETZ JUNE HINSON HOUSTON RCOM LUN FOSTER CLAUDE Please review and let me know for any correction. Mahendra CC- Sachin Hingole Rakesh Roy Smita Pawar Ramya Tantry
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 20/Feb/18 12:38 PM
            • Time Spent:
              0.5h
               

              Discussion with Mahendra

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 11h 10m [ 40200 ] 11h 40m [ 42000 ]
            Worklog Id 105345 [ 105345 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - we made additional changes and when I re-ran the forms, they defaulted back again. Please fix and re-run.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - we made additional changes and when I re-ran the forms, they defaulted back again. Please fix and re-run.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Mahendra Mungase [ mahendra.mungase ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Ramya Tantry [ ramya.tantry ]
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 21/Feb/18 06:47 AM
            • Time Spent:
              2.5h
               

              ACA support

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

            Hi Jennifer Leugers,

            Below employee's correction were made yesterday.The correction codes given for these employees where 1G.

            1. WINFIELD HUNTER
            2. RICKY DANTZLER
            3. DONALD DANIELS
            4. JAMES CONDER
            5. JACK SMITH
            6. DON FRANTZ
            7. ROBERT BENFIELD

            On comparing with Yesterday's run('2/19/2018 10:51:50 PM') and latest run('2/20/2018 10.41.03 AM') only difference is these employees who have been added with code 1G.

            Can you please let us know which employees defaulted back.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Below employee's correction were made yesterday.The correction codes given for these employees where 1G. WINFIELD HUNTER RICKY DANTZLER DONALD DANIELS JAMES CONDER JACK SMITH DON FRANTZ ROBERT BENFIELD On comparing with Yesterday's run('2/19/2018 10:51:50 PM') and latest run('2/20/2018 10.41.03 AM') only difference is these employees who have been added with code 1G. Can you please let us know which employees defaulted back.
            ramya.tantry Ramya Tantry (Inactive) logged work - 21/Feb/18 11:13 AM
            • Time Spent:
              2h
               

              Analysis and verification
              Comparison report part 3 analysis
              draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 11h 40m [ 42000 ] 13h 40m [ 49200 ]
            Worklog Id 105429 [ 105429 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All - we need the previously attached file to be uploaded again and the forms to be re-run (and please verify they do not default back to 1G). Also, within the attached, one individual has 1H/2A for all 12 months BUT they were on the client's plan at some point in 2017 so they want a form for them and want the boxes checked for those months under Section III (even though we know we can't use the 1G code for partial months so the codes will remain 1H/2A). So for employee Winfield Hunger, we need Section III checked for Jan-Sep.

            Show
            jennifer.leugers Jennifer Leugers added a comment - All - we need the previously attached file to be uploaded again and the forms to be re-run (and please verify they do not default back to 1G). Also, within the attached, one individual has 1H/2A for all 12 months BUT they were on the client's plan at some point in 2017 so they want a form for them and want the boxes checked for those months under Section III (even though we know we can't use the 1G code for partial months so the codes will remain 1H/2A). So for employee Winfield Hunger, we need Section III checked for Jan-Sep.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Attachment Winfield_Hunter_Enrollment.JPG [ 73694 ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Hi Jennifer Leugers

            We have imported the previous attached sheet ACA 1095C Correction Import Template 2.8.18.zip and re-run the report.
            For employee "Winfield Hunger" we have specifically excluded him from deletion as his correction codes are 1H/2A.Also we have made his Part III correction to show Jan-Sep marked for him and his spouse.

            Please refer run dated "2/21/2018 11:08:58 PM" for verification. We have verified all employees provided in correction sheet.No one had defaulted back to 1G and it will not happen hence forth for any run,unless the correction codes provided are 1G.

            However,looking at the data of employee "Winfield Hunger", we think that this employee should get 1G as he is retired employee with benefits in 2017.This employee's enrollment data shows that this employee is enrolled with spouse in ACA Plan from Jan-Sept and from Oct,only employee is enrolled.

            So his should be 1G for whole year with Part 3 marked as EE will be marked for all 12 months and his spouse will be marked from Jan-Sept.
            It might happen that this employee gets rejected during IRS submission as his codes are 1H/2A with part 3 marked.
            Please let us know your views on this.

            NOTE: There is discrepancy related to Last name.Please refer last tab of Analysis report for more details.Please get them corrected before IRS submission.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Hi Jennifer Leugers We have imported the previous attached sheet ACA 1095C Correction Import Template 2.8.18.zip and re-run the report. For employee "Winfield Hunger" we have specifically excluded him from deletion as his correction codes are 1H/2A.Also we have made his Part III correction to show Jan-Sep marked for him and his spouse. Please refer run dated "2/21/2018 11:08:58 PM" for verification. We have verified all employees provided in correction sheet.No one had defaulted back to 1G and it will not happen hence forth for any run,unless the correction codes provided are 1G. However,looking at the data of employee "Winfield Hunger", we think that this employee should get 1G as he is retired employee with benefits in 2017.This employee's enrollment data shows that this employee is enrolled with spouse in ACA Plan from Jan-Sept and from Oct,only employee is enrolled. So his should be 1G for whole year with Part 3 marked as EE will be marked for all 12 months and his spouse will be marked from Jan-Sept. It might happen that this employee gets rejected during IRS submission as his codes are 1H/2A with part 3 marked. Please let us know your views on this. NOTE : There is discrepancy related to Last name.Please refer last tab of Analysis report for more details.Please get them corrected before IRS submission.
            ramya.tantry Ramya Tantry (Inactive) logged work - 22/Feb/18 09:06 AM
            • Time Spent:
              3h
               

              Analysis and discussion with Nandkumar
              Code changes to exclude employee
              Report run
              verification
              draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 13h 40m [ 49200 ] 16h 40m [ 60000 ]
            Worklog Id 105566 [ 105566 ]
            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 ]
            jennifer.leugers Jennifer Leugers made changes -
            Attachment screenshot-1.png [ 73727 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - getting a server error when trying to load the new Part III file. Please load tonight and verify those individuals with a 1H / 2A but where the clients have months checked under Part III are showing (and make sure they are not showing as 1G). I've already loaded Part III but am attaching both herein for your review. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - getting a server error when trying to load the new Part III file. Please load tonight and verify those individuals with a 1H / 2A but where the clients have months checked under Part III are showing (and make sure they are not showing as 1G). I've already loaded Part III but am attaching both herein for your review. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            jennifer.leugers Jennifer Leugers made changes -
            Attachment TOC.zip [ 73728 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Ramya Tantry [ ramya.tantry ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            Due to null value in month start date,it was throwing an error.We have noted this in our learning and will work on it after execution.

            We have imported the files and re-run the forms.
            As per system implementation, Part III data is combined from system and correction data.So system does not unmark the check box(if checkbox is marked as per system enrollment data),if month value is 0.
            While checking the file,there were records where spouse was marked for months where employee is not marked.

            We have re-run the report.Please refer latest run "2/23/2018 4:39:53 AM" for verification.
            However in case if you require Part III marked considering only correction data and not combination of system + correction, then refer run dated "2/23/2018 3:45:27 AM".In this run,system generated part III is not considered.

            We have checked all employees with 1H/2A and correction data.No employee has defaulted to 1G.

            CC:Smita Pawar,Nandkumar Prabhakar Karlekar

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Due to null value in month start date,it was throwing an error.We have noted this in our learning and will work on it after execution. We have imported the files and re-run the forms. As per system implementation, Part III data is combined from system and correction data.So system does not unmark the check box(if checkbox is marked as per system enrollment data),if month value is 0. While checking the file,there were records where spouse was marked for months where employee is not marked. We have re-run the report. Please refer latest run "2/23/2018 4:39:53 AM" for verification. However in case if you require Part III marked considering only correction data and not combination of system + correction, then refer run dated "2/23/2018 3:45:27 AM".In this run,system generated part III is not considered. We have checked all employees with 1H/2A and correction data.No employee has defaulted to 1G. CC: Smita Pawar , Nandkumar Prabhakar Karlekar
            ramya.tantry Ramya Tantry (Inactive) logged work - 23/Feb/18 01:28 PM
            • Time Spent:
              3.5h
               

              Analysis
              Discussion with Revan
              report re-run
              verification
              draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 16h 40m [ 60000 ] 20h 10m [ 72600 ]
            Worklog Id 106115 [ 106115 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Time Spent 20h 10m [ 72600 ] 22h 40m [ 81600 ]
            Worklog Id 106205 [ 106205 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Component/s ACA [ 10004 ]
            Description NA
            Key WT-12493 WB-74
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 59160 ] WB - Workterra BenAdmin Support workflow [ 64868 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WB-74 WT-13553
            Project Workterra BenAdmin [ 11501 ] WORKTERRA [ 10000 ]
            Workflow WB - Workterra BenAdmin Support workflow [ 64868 ] WT_Support [ 65305 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WT-13553 WB-386
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 65305 ] WB - Workterra BenAdmin Support workflow [ 65429 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status In Development [ 10007 ] Waiting for Input [ 11502 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow WB - Workterra BenAdmin Support workflow [ 65429 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 65981 ]
            Monika.Demla Monika Demla (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Waiting for Input [ 11502 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Smita Pawar (Inactive) made transition -
            In Progress Waiting for Customer Input
            7s 1
            Smita Pawar (Inactive) made transition -
            Open In Progress
            7d 2h 33m 3
            Smita Pawar (Inactive) made transition -
            In Progress On Hold
            3h 12m 1
            Smita Pawar (Inactive) made transition -
            On Hold In Progress
            3h 34m 1
            Ramya Tantry (Inactive) made transition -
            Waiting for Customer Input In Progress
            40d 7h 6m 3
            Ramya Tantry (Inactive) made transition -
            In Progress Open
            10h 2m 5
            Ramya Tantry (Inactive) made transition -
            Open Waiting for Customer Input
            1d 4h 15m 4
            Prashant Samal (Inactive) made transition -
            Waiting for Customer Input Open
            45d 15h 47m 2
            Prashant Samal (Inactive) made transition -
            Open In Development
            2m 26s 1
            Prashant Samal (Inactive) made transition -
            In Development Waiting for Input
            1m 59s 1
            Monika Demla (Inactive) made transition -
            Waiting for Input Closed
            71d 9h 16m 1

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Account Executive:
              Kevin Walker (Inactive)
              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 - 22h 40m
                  22h 40m