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

Incorrect SSN order in comparison report

    Details

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

      Description

      Report Name- 1095C Class AC

      Company - ACAAutomation

      Run 1- 10/18/2016 1:57:27 PM
      Run 2 - 10/18/2016 1:58:15 PM

      Screen Shot - No_Continuous_12records_For_Single_SSN.jpg

      Step:-
      1.Import employee of same name with different SSN
      2.Run 1095C without Eligibility Rule for Multi Employer
      3.Run 1095C with Eligibility Rule for Multi Employer
      4.Navigate to Benadmin > ACA >
      ACA Customization > ACA 1095C Comparison
      5.“Select 1095C report” drop down
      6.Select Run 1 & 2 and click on Show Report

      Expected - There should be continuous 12 row for same SSN

      Actual - It display mixed SSN in comparison report

        Attachments

          Issue Links

            Activity

            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have regressed this issue and observed that it's working as expected.Hence marking ready for stage.

            Abhijeet Khandagale - Can you please add 3C?

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have regressed this issue and observed that it's working as expected.Hence marking ready for stage. Abhijeet Khandagale - Can you please add 3C?
            Hide
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

            Please find 3 C's for mentioned issue below,

            Concern: Incorrect SSN order in comparison report

            Cause: We used to sort records as per EmployeeName, EmployeeType, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in in creasing order as given below,
            Davim Davim- 300000041
            Davim Davim- 300000041
            Davim Davim- 300000041

            Show
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Please find 3 C's for mentioned issue below, Concern: Incorrect SSN order in comparison report Cause: We used to sort records as per EmployeeName, EmployeeType, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in in creasing order as given below, Davim Davim- 300000041 Davim Davim- 300000041 Davim Davim- 300000041
            Hide
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - - edited

            Please find 3 C's for mentioned issue below,

            Concern: Incorrect SSN order in comparison report

            Cause: We used to sort records as per EmployeeName, Member Type, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in increasing order as given below,

            1. Davim Davim- 300000041
            2. Davim Davim- 300000042
            3. Davim Davim- 300000043
            4. Davim Davim- 300000044
              Which is rarest scenario, No company will have employee with same name and sequential SSN. Although we have changed ordering condition in SP.

            Correction: We have changed ordering condition in SP. Now, employees are sorted in order of Name, SSN and Month.

            Show
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - - edited Please find 3 C's for mentioned issue below, Concern: Incorrect SSN order in comparison report Cause: We used to sort records as per EmployeeName, Member Type, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in increasing order as given below, Davim Davim- 300000041 Davim Davim- 300000042 Davim Davim- 300000043 Davim Davim- 300000044 Which is rarest scenario, No company will have employee with same name and sequential SSN. Although we have changed ordering condition in SP. Correction: We have changed ordering condition in SP. Now, employees are sorted in order of Name, SSN and Month.
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have regressed this issue and observed that it's working as expected.Hence marking ready for Production.

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have regressed this issue and observed that it's working as expected.Hence marking ready for Production.
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on production, working fine.

            Now employee are ordered correctly on SSN.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production, working fine. Now employee are ordered correctly on SSN.

              People

              Assignee:
              mahendra.mungase Mahendra Mungase (Inactive)
              Reporter:
              mahendra.mungase Mahendra Mungase (Inactive)
              Developer:
              Abhijeet Khandagale (Inactive)
              QA:
              Mahendra Mungase (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: