Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Company:
      FRMC-Alecto
    • 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 -
            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 -
            Company All Clients/Multiple Clients [ 18434 ] Alecto Healthcare [ 10406 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Account Executive Kevin Walker [ kwalker ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            1095C for FRMC is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - 1095C for FRMC is ready to run. Thanks!
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Sachin Hingole [ sachin.hingole ]
            Status Open [ 1 ] In Progress [ 3 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Attachment IRS 1095-C_FRMC_Checklist.xls [ 70747 ]
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            We have run "1095C for FRMC" 1095C report, find attached check list IRS 1095-C_FRMC_Checklist.xls for more details.
            Please refer latest run of "1095C for FRMC" report for verification.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - We have run "1095C for FRMC" 1095C report, find attached check list IRS 1095-C_FRMC_Checklist.xls for more details. Please refer latest run of "1095C for FRMC" report for verification.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Jennifer Leugers [ jennifer.leugers ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            sachin.hingole Sachin Hingole (Inactive) logged work - 26/Dec/17 12:58 PM
            • Time Spent:
              0.5h
               
              <No comment>
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ]
            Original Estimate 16h [ 57600 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 15.5h [ 55800 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 97874 [ 97874 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - why is this group getting 1Ks? Example would be Jeremy Aloe who doesn't even have a spouse in the system.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - why is this group getting 1Ks? Example would be Jeremy Aloe who doesn't even have a spouse in the system.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 16/Jan/18 07:23 AM
            • Time Spent:
              1h
               

              Discussion with Nandkumar
              Analysis
              Draft reply

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

            Hi Jennifer Leugers,

            As per current system implementation,we are not checking spouse /dependent eligibility on a plan for showing 1K/1J.
            We have provided a drop down against each plan in ACA Customization and based on this flag, EE will get 1E/1D or 1K/1J.
            If EE without spouse is eligible for a plan with conditional offer(flag is set on ACA Customization),he will get 1K/1J as per code priority.

            CC:Nandkumar Prabhakar Karlekar,Smita Pawar,Revansiddha Gaur

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , As per current system implementation,we are not checking spouse /dependent eligibility on a plan for showing 1K/1J. We have provided a drop down against each plan in ACA Customization and based on this flag, EE will get 1E/1D or 1K/1J. If EE without spouse is eligible for a plan with conditional offer(flag is set on ACA Customization),he will get 1K/1J as per code priority. CC: Nandkumar Prabhakar Karlekar , Smita Pawar , Revansiddha Gaur
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 15.5h [ 55800 ] 14.5h [ 52200 ]
            Time Spent 0.5h [ 1800 ] 1.5h [ 5400 ]
            Worklog Id 100538 [ 100538 ]
            sachin.hingole Sachin Hingole (Inactive) logged work - 16/Jan/18 04:19 PM
            • Time Spent:
              40m
               
              <No comment>
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Updated customization (is there anyway you can tell me when it was changed to show conditional value and by whom?). Please re-run their forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Updated customization (is there anyway you can tell me when it was changed to show conditional value and by whom?). Please re-run their forms. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Jennifer Leugers

            We don't have history of "ACA customization" tab to identify who changed this customization.

            We re-run "1095C for FRMC" report from FRMC production.
            Please refer latest run (Run Date - 1/16/2018 9:04:33 AM) for review.

            NOTE -
            1. MEC indicator is Yes only for May, June and July and No for remaining months.
            2. There are some discrepancy in analysis report against this run. Need to correct those discrepancy for successful XML generation for IRS submission.

            Thanks,
            Sachin Hingole

            Revansiddha Gaur Nandkumar Prabhakar Karlekar Ramya Tantry Smita Pawar

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers We don't have history of "ACA customization" tab to identify who changed this customization. We re-run "1095C for FRMC" report from FRMC production. Please refer latest run (Run Date - 1/16/2018 9:04:33 AM) for review. NOTE - 1. MEC indicator is Yes only for May, June and July and No for remaining months. 2. There are some discrepancy in analysis report against this run. Need to correct those discrepancy for successful XML generation for IRS submission. Thanks, Sachin Hingole Revansiddha Gaur Nandkumar Prabhakar Karlekar Ramya Tantry Smita Pawar
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            HI all - I think the history of changing the ACA Customization is something we need to think about tracking going forward. There have been quite a few clients that are showing with a conditional value selected and I haven't changed them so they are getting wrong forms.

            Show
            jennifer.leugers Jennifer Leugers added a comment - HI all - I think the history of changing the ACA Customization is something we need to think about tracking going forward. There have been quite a few clients that are showing with a conditional value selected and I haven't changed them so they are getting wrong forms.
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have noted this point in our learning. We will consider this for development in future.

            Thanks,
            Sachin Hingole

            Nandkumar Prabhakar Karlekar Rakesh Roy Revansiddha Gaur Ramya Tantry Smita Pawar

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers , We have noted this point in our learning. We will consider this for development in future. Thanks, Sachin Hingole Nandkumar Prabhakar Karlekar Rakesh Roy Revansiddha Gaur Ramya Tantry Smita Pawar
            ramya.tantry Ramya Tantry (Inactive) logged work - 17/Jan/18 07:07 AM
            • Time Spent:
              0.75h
               

              Discussion
              Script to identify user
              draft reply

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

            Hi Jennifer Leugers,

            Currently, there is no way to show history of changes to ACA Customization on UI.
            However, we can identify it from backend.
            For this company, the changes to show conditional value was done by user "jleugers" on "11/17/2016 01.12PM"

            We have added this in our learning and if approved,we will take up development of this after ACA Execution.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Currently, there is no way to show history of changes to ACA Customization on UI. However, we can identify it from backend. For this company, the changes to show conditional value was done by user " jleugers " on " 11/17/2016 01.12PM " We have added this in our learning and if approved,we will take up development of this after ACA Execution.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 14.5h [ 52200 ] 13.75h [ 49500 ]
            Time Spent 1.5h [ 5400 ] 2.25h [ 8100 ]
            Worklog Id 100707 [ 100707 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Company Alecto Healthcare [ 10406 ] FRMC-Alecto [ 13532 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 13.75h [ 49500 ] 13.5h [ 48600 ]
            Time Spent 2.25h [ 8100 ] 2.5h [ 9000 ]
            Worklog Id 100824 [ 100824 ]
            smita.pawar Smita Pawar (Inactive) logged work - 17/Jan/18 01:40 PM
            • Time Spent:
              0.25h
               

              Internal discussion with Ramya

            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 100824 [ 100824 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 13.5h [ 48600 ] 13.75h [ 49500 ]
            Time Spent 2.5h [ 9000 ] 2.25h [ 8100 ]
            Worklog Id 100824 [ 100824 ]
            Worklog Time Spent 0.25h [ 900 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 13.75h [ 49500 ] 13.5h [ 48600 ]
            Time Spent 2.25h [ 8100 ] 2.5h [ 9000 ]
            Worklog Id 100826 [ 100826 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 13.5h [ 48600 ] 12h 50m [ 46200 ]
            Time Spent 2.5h [ 9000 ] 3h 10m [ 11400 ]
            Worklog Id 100865 [ 100865 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Component/s ACA [ 10004 ]
            Description NA
            Key WT-12566 WB-143
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 59250 ] WB - Workterra BenAdmin Support workflow [ 64937 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WB-143 WT-13621
            Project Workterra BenAdmin [ 11501 ] WORKTERRA [ 10000 ]
            Workflow WB - Workterra BenAdmin Support workflow [ 64937 ] WT_Support [ 65373 ]
            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-13621 WB-455
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 65373 ] WB - Workterra BenAdmin Support workflow [ 65498 ]
            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 [ 65498 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 66002 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - could you please load the attached import files for the 1095C corrections and re-run the forms?  I'm still unable to do so through the new UI.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - could you please load the attached import files for the 1095C corrections and re-run the forms?  I'm still unable to do so through the new UI.
            jennifer.leugers Jennifer Leugers made changes -
            Attachment FRMC.zip [ 75430 ]
            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 Smita Pawar,

            Please look into this and advise.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Smita Pawar , Please look into this and advise.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 28/Mar/18 06:18 AM
            • Time Spent:
              3h
               

              Analysis and discussion with Smita

              Import code verification

               

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 12h 50m [ 46200 ] 9h 50m [ 35400 ]
            Time Spent 3h 10m [ 11400 ] 6h 10m [ 22200 ]
            Worklog Id 110413 [ 110413 ]
            smita.pawar Smita Pawar (Inactive) logged work - 28/Mar/18 07:02 AM
            • Time Spent:
              5.25h
               

              Analysis

              code correction , import and Verification 

              Draft 

              Jira updates 

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

            Hi Jennifer Leugers,

            We have imported corrected codes into the system for FRMC.
            We have rerun the 1095-C report with Apply User Correction 'Yes'.
            Please refer latest run '3/28/2018 6:18:55 AM' for verification.

            Verified employees are as follows.
            1.Joshua Clark – Newly added employee as per code correction sheet 'FRMC PART II all other JL'
            2.Sarah Harris – Newly added employee as per code correction sheet 'FRMC PART II all other JL'
            3.John McIntire – New Hire employee
            4.Dawn Stark – New Hire employee

            As of now, we have fixed UI freezing issue of Import Export screen  on production which occurs after clicking 'Bulk Import Correction' from  ACA 1095-C Corrections Screen.

            Corresponding Patch will move to all environment as per regular patch processing.

            Let us know, if you need any additional information.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have imported corrected codes into the system for FRMC. We have rerun the 1095-C report with Apply User Correction 'Yes'. Please refer latest run '3/28/2018 6:18:55 AM' for verification. Verified employees are as follows. 1.Joshua Clark – Newly added employee as per code correction sheet 'FRMC PART II all other JL' 2.Sarah Harris – Newly added employee as per code correction sheet 'FRMC PART II all other JL' 3.John McIntire – New Hire employee 4.Dawn Stark – New Hire employee As of now, we have fixed UI freezing issue of Import Export screen  on production which occurs after clicking 'Bulk Import Correction' from  ACA 1095-C Corrections Screen. Corresponding Patch will move to all environment as per regular patch processing. Let us know, if you need any additional information. Thanks!
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 9h 50m [ 35400 ] 4h 35m [ 16500 ]
            Time Spent 6h 10m [ 22200 ] 11h 25m [ 41100 ]
            Worklog Id 110438 [ 110438 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - the IRS submission for FRMC rejected but I don't see why on the error report.  Please see attached.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - the IRS submission for FRMC rejected but I don't see why on the error report.  Please see attached.
            jennifer.leugers Jennifer Leugers made changes -
            jennifer.leugers Jennifer Leugers made changes -
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 4h 35m [ 16500 ] 1h 35m [ 5700 ]
            Time Spent 11h 25m [ 41100 ] 14h 25m [ 51900 ]
            Worklog Id 111117 [ 111117 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have verified ack file for FRMC and observed that this submission got rejected due duplicate file and duplicate UUID. As per this acknowledgement file, we analysed that previous original submission is done against receipt Id 1094C-18-00376848
            Now again one more original submision is getting submitted for same employer which is currently updated in the system on IRS submission for FRMC IRS SUB screen.

            This Ack file is stating that please check the status of previous submission with receipt ID 1094C-18-00376848 and then decide the further course of action.

            It will be good if we get the status of submission for Receipt Id 1094C-18-00376848 then we can decide whether we need to do correction or replacement.

            Let us know, if you need any additional information.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have verified ack file for FRMC and observed that this submission got rejected due duplicate file and duplicate UUID. As per this acknowledgement file, we analysed that previous original submission is done against receipt Id 1094C-18-00376848 Now again one more original submision is getting submitted for same employer which is currently updated in the system on IRS submission for FRMC IRS SUB screen. This Ack file is stating that please check the status of previous submission with receipt ID 1094C-18-00376848 and then decide the further course of action. It will be good if we get the status of submission for Receipt Id 1094C-18-00376848 then we can decide whether we need to do correction or replacement. Let us know, if you need any additional information. Thanks!
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            smita.pawar Smita Pawar (Inactive) logged work - 31/Mar/18 03:34 AM
            • Time Spent:
              4h
               

              Analysis
              discussion
              draft
              Jira update

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 1h 35m [ 5700 ] 0h [ 0 ]
            Time Spent 14h 25m [ 51900 ] 18h 25m [ 66300 ]
            Worklog Id 111118 [ 111118 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 31/Mar/18 02:00 PM
            • Time Spent:
              3h
               

              Analysis for rejected irs submission file cause and help for query resolution to Smita.

               

            smita.pawar Smita Pawar (Inactive) logged work - 02/Apr/18 10:46 PM
            • Time Spent:
              0.75h
               

              Template creation
              test data preparation for reproving issue

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 18h 25m [ 66300 ] 19h 10m [ 69000 ]
            Worklog Id 111234 [ 111234 ]
            smita.pawar Smita Pawar (Inactive) logged work - 03/Apr/18 06:33 AM
            • Time Spent:
              1h
               

              Issue Repro

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 19h 10m [ 69000 ] 20h 10m [ 72600 ]
            Worklog Id 111544 [ 111544 ]
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Closing this ticket

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Closing this ticket
            Prashant.samal Prashant Samal (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Waiting for Input [ 11502 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Sachin Hingole (Inactive) made transition -
            Open In Progress
            24d 23h 50m 1
            Sachin Hingole (Inactive) made transition -
            Waiting for Customer Input In Progress
            21d 4h 44m 1
            Sachin Hingole (Inactive) made transition -
            In Progress Waiting for Customer Input
            20m 15s 2
            Prashant Samal (Inactive) made transition -
            Waiting for Customer Input Open
            48d 13h 55m 1
            Prashant Samal (Inactive) made transition -
            Open In Development
            2m 27s 1
            Prashant Samal (Inactive) made transition -
            In Development Waiting for Input
            1m 59s 1
            Prashant Samal (Inactive) made transition -
            Waiting for Input Closed
            48d 22h 13m 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 - 16h Original Estimate - 16h
                  16h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20h 10m
                  20h 10m