WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6187

ACA new changes 2017_2B code is not reflecting correctly on 1095-C report.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      QA
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      1.Login to LB with Partner.
      2.Edit company say 'ACA Automation'.
      3.Add new employee.
      4.Make sure employee is eligible to ACA plan.
      5.Upload the time sheet of the employee [As for first 3 months as Full time and from April as Part time]
      6.Add Measurement & stability, New Hire rules.
      7.From UI change employee type to Part-time from 04/01/2016.
      8.Verify 1095-C report.

      Actual: 1J and 2B code reflected for entire year
      Expected:1J and 2F code should reflect for Jan, Feb and Mar and 1J and 2B code should reflect for rest of months.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-2629 ACA-2017 Providing limited assessment period scenario when Employees status is changed from part time to full time.

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

          Enhancement - An improvement or enhancement to an existing feature or task. WT-5809 ACA 2017 : New changes for Tax year 2016.

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

            Activity

            Ascending order - Click to sort in descending order
            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Assignee Nandkumar [ satyap ] Ramya Tantry [ ramya.tantry ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-5809 [ WT-5809 ]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected:

            Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_ACAEmployeeData.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_ACAEmployeeData.sql
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern: 2B code is not reflecting correctly on 1095-C report.
            Cause: When Measurement and stability rules are set and time sheet is also loaded,employee data is dumped in ACAEmployeeData Table.OES_UDF_ACAEmployeeData UDF gives data from ACAEmployeeData table if that employee is present or else it gives data from Employee table.Due to missing brackets between AND and OR, one condtion was getting overwritten. So the UDF was giving combined data of that employee from timesheet and demographics.
            Correction: Added brackets in the condition.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : 2B code is not reflecting correctly on 1095-C report. Cause : When Measurement and stability rules are set and time sheet is also loaded,employee data is dumped in ACAEmployeeData Table.OES_UDF_ACAEmployeeData UDF gives data from ACAEmployeeData table if that employee is present or else it gives data from Employee table.Due to missing brackets between AND and OR, one condtion was getting overwritten. So the UDF was giving combined data of that employee from timesheet and demographics. Correction : Added brackets in the condition.
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Smita Pawar

            Please verify.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Smita Pawar Please verify.
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB company [ACA Automation].
            Its working fine.

            Scenarios verified are as follows.
            1.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 3 Months
            2.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 12 Months.
            3.Checked Time sheet functionality is working correctly or not

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB company [ACA Automation] . Its working fine. Scenarios verified are as follows. 1.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 3 Months 2.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 12 Months. 3.Checked Time sheet functionality is working correctly or not
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-2629 [ WT-2629 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            This issue is due to enhancement WT_ 2629

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - This issue is due to enhancement WT_ 2629
            smita.pawar Smita Pawar (Inactive) made changes -
            Environment LB [ 10800 ]
            Remaining Estimate 5h [ 18000 ]
            Original Estimate 5h [ 18000 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 05/Dec/16 12:08 PM
            • Time Spent:
              1h
               

              Reverification

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 4h [ 14400 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 11554 [ 11554 ]
            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 05/Dec/16 12:35 PM
            • Time Spent:
              0.25h
               

              analysis

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3.75h [ 13500 ]
            Time Spent 1h [ 3600 ] 1.25h [ 4500 ]
            Worklog Id 11570 [ 11570 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Ramya Tantry [ ramya.tantry ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Stage company [ACA Automation],
            Attaching scree shot of verified employee.

            Fix is ready for production but we will move this fix with enhancement WT-2629

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage company [ACA Automation] , Attaching scree shot of verified employee. Fix is ready for production but we will move this fix with enhancement WT-2629
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment 011111160.png [ 35454 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 20/Dec/16 01:34 PM
            • Time Spent:
              1.5h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3.75h [ 13500 ] 2.25h [ 8100 ]
            Time Spent 1.25h [ 4500 ] 2.75h [ 9900 ]
            Worklog Id 14555 [ 14555 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment 000000113-Prod.png [ 36231 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Production [For ACA BSG Test ACAAutomation].
            Its working fine.
            PFA screen shot for additional information

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production [For ACA BSG Test ACAAutomation] . Its working fine. PFA screen shot for additional information
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 29/Dec/16 02:30 PM
            • Time Spent:
              2h
               

              Production testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 2.25h [ 8100 ] 0.25h [ 900 ]
            Time Spent 2.75h [ 9900 ] 4.75h [ 17100 ]
            Worklog Id 16205 [ 16205 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            		17h 23m 1
            Smita Pawar (Inactive) made transition -
            In Development In LB Testing
            		2d 5h 13m 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            		28d 21h 15m 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing In Production Testing
            		14d 21h 40m 1
            Smita Pawar (Inactive) made transition -
            In Production Testing Production Complete
            		2d 8h 4m 1
            Smita Pawar (Inactive) made transition -
            Production Complete Closed
            		3s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Developer:
              Ramya Tantry (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 5h
                  5h
                  Remaining:
                  Time Spent - 4.75h Remaining Estimate - 0.25h
                  0.25h
                  Logged:
                  Time Spent - 4.75h Remaining Estimate - 0.25h
                  4.75h