Workterra BenAdminProject Type: business

Workterra BenAdmin

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

ACA_2018_Suburban Electric

    Details

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

      Description

      NA

        Attachments

          Issue Links

          relates to

          Support Activity - Support Activity WB-418 ACA Execution 2018

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            jennifer.leugers Jennifer Leugers created issue -
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100) Parent values: ACA(10104)Level 1 values: 2018(18472)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Satya [ ID10004 ] Smita Pawar [ smita.pawar ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Sachin Hingole [ sachin.hingole ]
            Status Open [ 1 ] In Progress [ 3 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Attachment IRS 1095-C_SuburbanEle_Checklist.xls [ 70754 ]
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

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

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - We have run "2017 ACA 1095 C" 1095C report, find attached check list IRS 1095-C_SuburbanEle_Checklist.xls for more details. Please refer latest run of "2017 ACA 1095 C" 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 ]
            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 26/Dec/17 01:03 PM
            • Time Spent:
              0.75h
               
              <No comment>
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 97881 [ 97881 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-12484 [ WT-12484 ]
            Hide
            Permalink
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - here is another one that doesn't have the templates for me to upload. Please upload the attached changes (two tabs). Password is standard.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - here is another one that doesn't have the templates for me to upload. Please upload the attached changes (two tabs). Password is standard.
            jennifer.leugers Jennifer Leugers made changes -
            Attachment 1095 correction import template.zip [ 72808 ]
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Sachin Hingole [ sachin.hingole ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            We have rerun '2017 ACA 1095 C' report.
            Please refer latest run '2/5/2018 2:53:38 AM' to download files.

            Tested scenarios are as follows

            1.Valid codes are reflecting on file
            2.MEC indicator is marked as 'Yes' for all 12 months.

            But while importing Part III corrections, 15 records went into bad file. The reason for Bad record is 'Invalid Record: Member doesn't exist.'

            Part III correction import summary

            Template used – ACA Correction 1095 C Part III SSN
            Imported Records--129
            Bad records--15
            Total reords--144
            Bad File--Bad_ACA1095CCorrectionImportTemplate-Part III02_05_2018 01_40_38 AM.csv
            Reason for bad records-- Invalid Record: Member doesn't exist.

            Please refer Bad file for further analysis. We have uploaded bad file on EBS FTP.

            URL: https://ftpsecure.ebsbenefits.com
            Path:/users/workterraaca/_Tax Year 2017/Suburban Electric
            File name: Bad_ACA1095CCorrectionImportTemplate-Part III02_05_2018 01_40_38 AM.csv

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Jennifer Leugers , We have rerun '2017 ACA 1095 C' report. Please refer latest run '2/5/2018 2:53:38 AM' to download files. Tested scenarios are as follows 1.Valid codes are reflecting on file 2.MEC indicator is marked as 'Yes' for all 12 months. But while importing Part III corrections, 15 records went into bad file. The reason for Bad record is 'Invalid Record: Member doesn't exist.' Part III correction import summary Template used – ACA Correction 1095 C Part III SSN Imported Records--129 Bad records--15 Total reords--144 Bad File--Bad_ACA1095CCorrectionImportTemplate-Part III02_05_2018 01_40_38 AM.csv Reason for bad records-- Invalid Record: Member doesn't exist. Please refer Bad file for further analysis. We have uploaded bad file on EBS FTP. URL: https://ftpsecure.ebsbenefits.com Path:/users/workterraaca/_Tax Year 2017/Suburban Electric File name: Bad_ACA1095CCorrectionImportTemplate-Part III02_05_2018 01_40_38 AM.csv Thanks!
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 05/Feb/18 11:06 AM
            • Time Spent:
              3h
               

              Analysis
              Correction import
              Report rerun
              Verification
              Jira updates
              Draft

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 0.75h [ 2700 ] 3.75h [ 13500 ]
            Worklog Id 103371 [ 103371 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            Hide
            Permalink
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - there are more than just issues with those 15 corrections. The very first employee listed on row 5/6 are not showing correctly (doesn't look like either month was updated when I look at the corrections from the UI). Please look into this. Thanks.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - there are more than just issues with those 15 corrections. The very first employee listed on row 5/6 are not showing correctly (doesn't look like either month was updated when I look at the corrections from the UI). Please look into this. Thanks.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 06/Feb/18 08:48 AM
            • Time Spent:
              0.5h
               

              Discussion with Smita

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 3.75h [ 13500 ] 4.25h [ 15300 ]
            Worklog Id 103517 [ 103517 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 06/Feb/18 01:31 PM - edited
            • Time Spent:
              4.5h
               

              Analysis
              Code import
              Internal discussion
              Verification
              draft
              Jira updates

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

            Hi Jennifer Leugers,

            Please allow me to apologize for Yesterday's comment.
            We have rerun '2017 ACA 1095 C' report by changing flag 'Is correction applied' set to 'Yes'.

            Employees verified from code correction document which are as follows

            1.MATTHEW TREMBLE
            2.BENJAMIN RETZAK KRUMP
            3.FUE XIONG
            4.DEREK GERNER J

            Let us know, if you need any additional information.

            Thanks!!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , Please allow me to apologize for Yesterday's comment. We have rerun '2017 ACA 1095 C' report by changing flag 'Is correction applied' set to 'Yes'. Employees verified from code correction document which are as follows 1.MATTHEW TREMBLE 2.BENJAMIN RETZAK KRUMP 3.FUE XIONG 4.DEREK GERNER J Let us know, if you need any additional information. Thanks!!
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 4.25h [ 15300 ] 9.75h [ 35100 ]
            Worklog Id 103579 [ 103579 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            Hide
            Permalink
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - client made additional changes; please re-run the forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - client made additional changes; please re-run the forms. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
            Time Spent 9.75h [ 35100 ] 8.75h [ 31500 ]
            Worklog Id 103579 [ 103579 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Progress [ 3 ] On Hold [ 10507 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi @Jennifer,

            We have rerun the '2017 ACA 1095 C' report.
            Please refer latest run '2/7/2018 9:50:29 PM' to download the report.

            Note: We didn't found any difference after comparing previous and latest run.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi @Jennifer, We have rerun the '2017 ACA 1095 C' report. Please refer latest run '2/7/2018 9:50:29 PM' to download the report. Note: We didn't found any difference after comparing previous and latest run. Thanks!
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 08/Feb/18 10:31 AM
            • Time Spent:
              1h
               

              Report rerun
              verification
              Jira updates
              Draft

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Time Spent 8.75h [ 31500 ] 9.75h [ 35100 ]
            Worklog Id 103829 [ 103829 ]
            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 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Description 2017 ACA 1095 C is ready to run (new group added). Thanks! NA
            Key WT-12879 WB-69
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 60598 ] WB - Workterra BenAdmin Support workflow [ 64863 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WB-69 WT-13548
            Project Workterra BenAdmin [ 11501 ] WORKTERRA [ 10000 ]
            Workflow WB - Workterra BenAdmin Support workflow [ 64863 ] WT_Support [ 65300 ]
            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-13548 WB-381
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 65300 ] WB - Workterra BenAdmin Support workflow [ 65424 ]
            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 [ 65424 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 65920 ]
            Monika.Demla Monika Demla (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
            		3d 19h 30m 1
            Sachin Hingole (Inactive) made transition -
            In Progress Waiting for Customer Input
            		1m 39s 1
            Smita Pawar (Inactive) made transition -
            Waiting for Customer Input In Progress
            		43d 4h 15m 3
            Smita Pawar (Inactive) made transition -
            In Progress On Hold
            		36m 53s 1
            Smita Pawar (Inactive) made transition -
            On Hold In Progress
            		6h 53m 1
            Smita Pawar (Inactive) made transition -
            In Progress Open
            		12h 12m 3
            Smita Pawar (Inactive) made transition -
            Open Waiting for Customer Input
            		32s 3
            Prashant Samal (Inactive) made transition -
            Waiting for Customer Input Open
            		25d 18h 36m 1
            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
            		50d 5h 9m 1

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              jennifer.leugers Jennifer Leugers
              Votes:
              0 Vote for this issue
              Watchers:
              5 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 - 9.75h
                  9.75h