Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Company:
      US Shale
    • 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-12559 [ WT-12559 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-12484 [ WT-12484 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            1095 C Ritter is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - 1095 C Ritter is ready to run. Thanks!
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            Status Open [ 1 ] In Progress [ 3 ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            This group has been run. Please refer latest run dated "12/26/2017 3:10:56 AM" for verification.

            Note: In analysis report,for some of the months, MEC indicator is blank as EE count for those months is 0.
            Eligibility rule selected on report and EIN mapping were different.On report "Rit_Construct_All Employee Rule1" was selected.I have changed the rule to the rule selected in EIN mapping for this company.i.e Rule_29

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , This group has been run. Please refer latest run dated "12/26/2017 3:10:56 AM" for verification. Note : In analysis report,for some of the months, MEC indicator is blank as EE count for those months is 0. Eligibility rule selected on report and EIN mapping were different.On report "Rit_Construct_All Employee Rule1" was selected.I have changed the rule to the rule selected in EIN mapping for this company.i.e Rule_29
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 26/Dec/17 12:52 PM
            • Time Spent:
              0.5h
               

              ACA Customization verification
              Report run
              Sample PDF Verification
              Analysis report verification

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 97859 [ 97859 ]
            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 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Client has approved their drafts; please run their final forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Client has approved their drafts; please run their final forms. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            smita.pawar Smita Pawar (Inactive) logged work - 09/Jan/18 09:36 AM
            • Time Spent:
              25m
               

              Jira update
              Codes verifcaton

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

            Hi Jennifer Leugers,

            We have run '1095 C Ritter' report.
            Please refer latest run '1/9/2018 12:36:25 AM' to downlaod.

            Thanks!!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have run '1095 C Ritter' report. Please refer latest run '1/9/2018 12:36:25 AM' to downlaod. Thanks!!
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 0.5h [ 1800 ] 55m [ 3300 ]
            Worklog Id 99730 [ 99730 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Component/s ACA [ 10004 ]
            Description NA
            Key WT-12560 WB-132
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 59244 ] WB - Workterra BenAdmin Support workflow [ 64926 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WB-132 WT-13611
            Project Workterra BenAdmin [ 11501 ] WORKTERRA [ 10000 ]
            Workflow WB - Workterra BenAdmin Support workflow [ 64926 ] WT_Support [ 65363 ]
            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-13611 WB-444
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 65363 ] WB - Workterra BenAdmin Support workflow [ 65487 ]
            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 [ 65487 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 65946 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - the Ritter file came back Accepted with Errors from the IRS but one of the errors I"m not sure what it is.  It says - If Form 1094C checkbox 'AuthoritativeTransmittalInd' is checked and not all of the 'MinEssentialCvrOffrCd' (within JanALEMonthlyInfoGrp through DecALEMonthlyInfoGrp) have a choice of "Yes" or "No" indicated, then 'MinEssentialCvrOffrCd' (within 'YearlyALEMemberDetail') must have a choice of "Yes" or "No" indicated.  But when I check their 1094C form, I don't see this issue.  Please advise.  Thanks.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - the Ritter file came back Accepted with Errors from the IRS but one of the errors I"m not sure what it is.  It says - If Form 1094C checkbox 'AuthoritativeTransmittalInd' is checked and not all of the 'MinEssentialCvrOffrCd' (within JanALEMonthlyInfoGrp through DecALEMonthlyInfoGrp) have a choice of "Yes" or "No" indicated, then 'MinEssentialCvrOffrCd' (within 'YearlyALEMemberDetail') must have a choice of "Yes" or "No" indicated.  But when I check their 1094C form, I don't see this issue.  Please advise.  Thanks.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 27/Mar/18 02:06 AM
            • Time Spent:
              3h
               

              Analysis of the error code

              Discussion with Nandkumar and SMita

              changes to 1094C code for marking yes column

              report verification after re-run

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

            Hi Jennifer Leugers,

            We have encountered such scenario first time for business rules '1094C-038-03' & '1094C-041-02'.
            In US Shale - 'Ritter 1094-C' report, 'Minimum Essential Coverage offer Indicator' is neither marked 'YES' nor 'NO' for
            Feb, Mar, Apr, May, June and Dec month because Total Employee Count for ALE Member and full time employee count is 0.

            As per current system implementation, if 'Total Employee Count for ALE Member' and 'full time employee count' is 0 for a month, then system does not
            mark anything on Minimum Essential Coverage offer Indicator on 1094-C report.

            As per our understanding, we think if Total Employee Count for ALE Member and full time employee count is 0 for a month
            then 'Minimum Essential Coverage offer Indicator' should not get marked.

            However we have marked 'Minimum Essential Coverage offer Indicator' for those months from '1094-C Correction Screen'.

            We have rerun 'Ritter 1094C' report. Please refer latest run '3/27/2018 3:14:05 AM' for your verification. If it is applicable, please finalize 1094-C report and generate IRS submission.

            Let us know your views on how this scenario should get handle so that we can get some information for our further analysis and development changes.

            Rest of the errors are TIN validation errors in Error analysis report.

            Let us know, if you need any other additional information.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Jennifer Leugers , We have encountered such scenario first time for business rules '1094C-038-03' & '1094C-041-02'. In US Shale - 'Ritter 1094-C' report, 'Minimum Essential Coverage offer Indicator' is neither marked 'YES' nor 'NO' for Feb, Mar, Apr, May, June and Dec month because Total Employee Count for ALE Member and full time employee count is 0. As per current system implementation, if 'Total Employee Count for ALE Member' and 'full time employee count' is 0 for a month, then system does not mark anything on Minimum Essential Coverage offer Indicator on 1094-C report. As per our understanding, we think if Total Employee Count for ALE Member and full time employee count is 0 for a month then 'Minimum Essential Coverage offer Indicator' should not get marked. However we have marked 'Minimum Essential Coverage offer Indicator' for those months from '1094-C Correction Screen'. We have rerun 'Ritter 1094C' report. Please refer latest run '3/27/2018 3:14:05 AM' for your verification. If it is applicable, please finalize 1094-C report and generate IRS submission. Let us know your views on how this scenario should get handle so that we can get some information for our further analysis and development changes. Rest of the errors are TIN validation errors in Error analysis report. Let us know, if you need any other 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 - 27/Mar/18 07:13 AM - edited
            • Time Spent:
              4.5h
               

              Internal discussion
              Correction 1094-C
              Testing
              Jira updates
              Draft
              Analysis

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 55m [ 3300 ] 3h 55m [ 14100 ]
            Worklog Id 110176 [ 110176 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 3h 55m [ 14100 ] 8h 25m [ 30300 ]
            Worklog Id 111060 [ 111060 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 111060 [ 111060 ]
            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
            Ramya Tantry (Inactive) made transition -
            Open In Progress
            24d 23h 47m 1
            Ramya Tantry (Inactive) made transition -
            In Progress Open
            22m 9s 1
            Ramya Tantry (Inactive) made transition -
            Open Waiting for Customer Input
            34m 29s 1
            Prashant Samal (Inactive) made transition -
            Waiting for Customer Input Open
            69d 18h 21m 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:
              peggy fiedler (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 - 8h 25m
                  8h 25m