Details

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

      Description

      NA

        Attachments

          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 ] Merced County [ 10498 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Account Executive Jennifer Philp [ jphi ]
            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
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            1095-C Merced County is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - 1095-C Merced County is ready to run. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) logged work - 14/Dec/17 01:10 PM
            • Time Spent:
              1.25h
               

              Report RUN
              Report Verification and Check list verification
              Jira updates

            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have run 1095C report on 'Merced County' company.
            Please refer '12/14/2017 3:32:26 AM' latest run to download report. 12/14/2017 3:32:26 AM

            Attaching QA verification check list for additional information.

            Observation: Eligibility Rule set on EIN Class mapping and Eligibility Rule set on 1095-C report are different.
            PFA screen shot for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have run 1095C report on 'Merced County' company. Please refer '12/14/2017 3:32:26 AM' latest run to download report. 12/14/2017 3:32:26 AM Attaching QA verification check list for additional information. Observation: Eligibility Rule set on EIN Class mapping and Eligibility Rule set on 1095-C report are different. PFA screen shot for additional information.
            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 -
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ]
            Original Estimate 2h [ 7200 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0.75h [ 2700 ]
            Time Spent 1.25h [ 4500 ]
            Worklog Id 96189 [ 96189 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Merced County.png [ 70068 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - on Helms, the employee's coverage terminated on 10.27.17 and her Part II looks correct but I'm trying to figure out why October is marked under Part III. Do we mark that even if there is only coverage for part of the month?

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - on Helms, the employee's coverage terminated on 10.27.17 and her Part II looks correct but I'm trying to figure out why October is marked under Part III. Do we mark that even if there is only coverage for part of the month?
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 12/Jan/18 04:04 AM
            • Time Spent:
              0.5h
               

              Analysis
              Draft reply

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

            Hi Jennifer Leugers,

            Yes, Part III will be marked even if coverage was present for single day of the month.

            From IRS 1095C Instruction:
            Part III—Covered Individuals (Lines 17–22)
            Column (d). Check this box if the individual was covered for at least one day per month for all 12 months of the calendar year.
            Column (e). If the individual was not covered for all 12 months of the calendar year, check the applicable box(es) for the month(s) in which the individual was covered for at least one day in the month.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Yes, Part III will be marked even if coverage was present for single day of the month. From IRS 1095C Instruction: Part III—Covered Individuals (Lines 17–22) Column (d). Check this box if the individual was covered for at least one day per month for all 12 months of the calendar year. Column (e). If the individual was not covered for all 12 months of the calendar year, check the applicable box(es) for the month(s) in which the individual was covered for at least one day in the month .
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 0.75h [ 2700 ] 0.25h [ 900 ]
            Time Spent 1.25h [ 4500 ] 1.75h [ 6300 ]
            Worklog Id 100134 [ 100134 ]
            jennifer.leugers Jennifer Leugers made changes -
            Attachment screenshot-1.png [ 73722 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Getting a server error when trying to load the Part III from the UI / bulk correction. Please load and re-run the forms tonight. Thanks.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Getting a server error when trying to load the Part III from the UI / bulk correction. Please load and re-run the forms tonight. Thanks.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            jennifer.leugers Jennifer Leugers made changes -
            Attachment Corrections 022218 Part III.zip [ 73723 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            This group has been re-run by applying correction. Please find the below run details for verification.

            Report Name Run details
            1095-C Merced County 2/23/2018 4:40:16 AM

            CONCERN: Import failed
            CAUSE: When correction are made through ui for part3, in such scenario corrections by import, giving an issue since UI corrections are inserting a separate record of an null value in 'MonthStartDate field' whenever all 12 months marked.

            CORRECTION: Noted in our learning ticket to resolve an issue.

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , This group has been re-run by applying correction. Please find the below run details for verification. Report Name Run details 1095-C Merced County 2/23/2018 4:40:16 AM CONCERN: Import failed CAUSE: When correction are made through ui for part3, in such scenario corrections by import, giving an issue since UI corrections are inserting a separate record of an null value in 'MonthStartDate field' whenever all 12 months marked. CORRECTION: Noted in our learning ticket to resolve an issue. Thanks, Revan
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
            Time Spent 1.75h [ 6300 ] 9.75h [ 35100 ]
            Worklog Id 106084 [ 106084 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 23/Feb/18 04:36 PM
            • Time Spent:
              0.5h
               

              Discussion with Revan

            Hide
            jennifer.leugers Jennifer Leugers added a comment - - edited

            All - doesn't look like anyone checked the forms as the months in which the client wanted to be unmarked are still showing. I just tried to do the same from the UI and it does not "take" either. I had to correct the forms manually but need this updated and validate so we can make sure the right information is given to the IRS.

            Show
            jennifer.leugers Jennifer Leugers added a comment - - edited All - doesn't look like anyone checked the forms as the months in which the client wanted to be unmarked are still showing. I just tried to do the same from the UI and it does not "take" either. I had to correct the forms manually but need this updated and validate so we can make sure the right information is given to the IRS.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 23/Feb/18 10:00 PM
            • Time Spent:
              8h
               

              Debugging of import failed on locally, manual correction,report re-run,draft reply.

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 9.75h [ 35100 ] 10.25h [ 36900 ]
            Worklog Id 106147 [ 106147 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Ramya Tantry [ ramya.tantry ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Comment [ ~revansiddha.gaur ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 26/Feb/18 12:33 PM
            • Time Spent:
              4h
               

              Analysis
              Code changes
              report run
              verification
              draft reply

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

            Hi Jennifer Leugers,

            As per implementation, system does not unmark the box for system generated Part III. If month value is zero,then system ignores it and provides system generated value for it. It has been implemented in this way so that,system generated codes are not overwritten if user wants to change some month's data.

            However, to accommodate client's request to unmark Part III,we made some changes in the backend.
            Please refer latest run dated "2/26/2018 3:24:35 AM" for verification.

            Note: There are some discrepancy related to Member last name and SSN. Please correct them before IRS submission.

            Also we would like your input on how Part III correction should be processed so that we can make this change in system for next year execution. Should we consider that if month value is 0,then system generated Part III should be overwritten and in case if some months data(1 or 0) is provided,then only that month's data should be overwritten,Rest month's data will be system generated.

            CC:Nandkumar Prabhakar Karlekar,Smita Pawar

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , As per implementation, system does not unmark the box for system generated Part III. If month value is zero,then system ignores it and provides system generated value for it. It has been implemented in this way so that,system generated codes are not overwritten if user wants to change some month's data. However, to accommodate client's request to unmark Part III,we made some changes in the backend. Please refer latest run dated " 2/26/2018 3:24:35 AM " for verification. Note : There are some discrepancy related to Member last name and SSN. Please correct them before IRS submission. Also we would like your input on how Part III correction should be processed so that we can make this change in system for next year execution. Should we consider that if month value is 0,then system generated Part III should be overwritten and in case if some months data(1 or 0) is provided,then only that month's data should be overwritten,Rest month's data will be system generated. CC: Nandkumar Prabhakar Karlekar , Smita Pawar
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 10.25h [ 36900 ] 14.25h [ 51300 ]
            Worklog Id 106293 [ 106293 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Component/s ACA [ 10004 ]
            Description NA
            Key WT-12513 WB-46
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 59185 ] WB - Workterra BenAdmin Support workflow [ 64840 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WB-46 WT-13525
            Project Workterra BenAdmin [ 11501 ] WORKTERRA [ 10000 ]
            Workflow WB - Workterra BenAdmin Support workflow [ 64840 ] WT_Support [ 65277 ]
            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-13525 WB-358
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 65277 ] WB - Workterra BenAdmin Support workflow [ 65401 ]
            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 [ 65401 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 66020 ]
            Monika.Demla Monika Demla (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Waiting for Input [ 11502 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Revansiddha Gaur (Inactive) made transition -
            Waiting for Customer Input In Progress
            70d 15h 32m 1
            Revansiddha Gaur (Inactive) made transition -
            In Progress Waiting for Customer Input
            8h 8m 2
            Ramya Tantry (Inactive) made transition -
            Open In Progress
            13d 4h 39m 2
            Ramya Tantry (Inactive) made transition -
            In Progress Open
            6h 30m 1
            Ramya Tantry (Inactive) made transition -
            Open Waiting for Customer Input
            17s 1
            Prashant Samal (Inactive) made transition -
            Waiting for Customer Input Open
            10d 10h 39m 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 17m 1

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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