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

ACA_New Changes_1H & 2D code not reflecting on 1095-C report.[Rule of Parity]

    Details

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

      Description

      1.Login to LB with partner.
      2.Edit company say 'ACA Automation'.
      3.Add employee.
      4.Import a time sheet of an employee.
      January- Part time
      February to August - No Data
      September to December-Full time
      5.Create 1095-C report
      6.Run the report
      7.Verify report.

      Actual: 1B & 2F code not reflected for the month of September
      Expected: 1H & 2D code should get reflected for the month of September

      [Please refer test employee having SSN 011111120, Screenshot is added for additional information]

        Attachments

        1. 011111120.png
          011111120.png
          72 kB
        2. 011111120-Verified.png
          011111120-Verified.png
          106 kB
        3. 011111150.png
          011111150.png
          124 kB

          Issue Links

            Activity

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

            Files Affected:

            Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_InsertEmployeeData.StoredProcedure.sql
            Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_InsertEmployeeData.StoredProcedure.sql Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Smita Pawar,Sachin Hingole

            This is just for your information that we were not considering rule of parity hire date in the last execution of 1095/4 reports. We had commented that code. So above issue occurred.
            However,after discussion with Nandkumar, we are going to keep the code commented on all companies. We will un-comment the code only in those companies where timesheet is proper and are using timesheet to determine eligibility status.

            If the timesheet is not proper, rule of parity will make employees new hire and un-expected codes may come up on reports.

            So,in case of testing,first let us know the companies so that we can un comment the code.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Smita Pawar , Sachin Hingole This is just for your information that we were not considering rule of parity hire date in the last execution of 1095/4 reports. We had commented that code. So above issue occurred. However,after discussion with Nandkumar, we are going to keep the code commented on all companies. We will un-comment the code only in those companies where timesheet is proper and are using timesheet to determine eligibility status. If the timesheet is not proper, rule of parity will make employees new hire and un-expected codes may come up on reports. So,in case of testing,first let us know the companies so that we can un comment the code.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern: 1H & 2D code not reflecting on 1095-C report.[Rule of Parity]
            Cause: Rule of parity code was commented.Refer above comment for more justification
            Correction: We will un-comment the code from backend of some selected companies where timesheet is proper and are using timesheet to determine eligibility status.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : 1H & 2D code not reflecting on 1095-C report. [Rule of Parity] Cause : Rule of parity code was commented.Refer above comment for more justification Correction : We will un-comment the code from backend of some selected companies where timesheet is proper and are using timesheet to determine eligibility status.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine.

            We have observed that time sheet report is displaying stable working hours as 40.
            PFA screen shot for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine. We have observed that time sheet report is displaying stable working hours as 40. PFA screen shot for additional information.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Smita Pawar

            Timesheet will be displaying 40 as stable working hours because as per data in system,employee is full time.He was neither terminated nor his leave was imported.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Smita Pawar Timesheet will be displaying 40 as stable working hours because as per data in system,employee is full time.He was neither terminated nor his leave was imported.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Stage [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine.
            PFA screen shot for additional information.

            This fix is ready for Production but we will move to production with enhancement WT-2629.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine. PFA screen shot for additional information. This fix is ready for Production but we will move to production with enhancement WT-2629 .

              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 - 16h
                  16h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 9.25h Time Not Required
                  9.25h