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

95C Part III check box is check for Blank Dependent Record

    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
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Company Name- ACAAutomation

      Pre-requisite -
      1.Add Employee SSN - 300000177
      2.Add child – SSN – 300000195
      3.ACA Plan should be self insured
      4.Create file with Month value = “1” and other valid value for other fields
      5.Update same file Month value = “0” and other valid value for other fields
      6.Import Template - ACA Correction 1095 C Part III EmpID Dependent
      Screen Shot - Part3_CheckBox_Is_Check_For_Blank_Covered_Individuals.jpg
      7.95C Report Name - 1095C 28Dec16 1114

      Step To Repro -
      1.Login to application
      2.Navigate to Import/Export > Manual Import/Export > Select Import radio button.
      3.Select template from drop down and browse file.
      4.Click on Import
      5.Run 95C with "Apply User Correction" - Yes
      6.Download the file

      Actual - 95C Part III check box is check

      Expected - 95C Part III check box is uncheck for Blank Record

        Attachments

          Issue Links

            Activity

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

            Concern: 95C Part III check box is check for Blank Dependent Record
            Cause:As per earlier implementation, we have considered total 18 covered individual.But we changed this implementation as we were not able to maintain sequence number while importing and also we removed the blank records from covered individual table.Due to the earlier implementation,we considered the condition of 18 dependents for unchecking the check box on Part 3.
            Correction: We are now deleting the blank records in covered individual table and grouping the employees for checking/unchecking the check box on Part 3.

            Please verify the same scenario from ACA 1095C corrections screen

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : 95C Part III check box is check for Blank Dependent Record Cause :As per earlier implementation, we have considered total 18 covered individual.But we changed this implementation as we were not able to maintain sequence number while importing and also we removed the blank records from covered individual table.Due to the earlier implementation,we considered the condition of 18 dependents for unchecking the check box on Part 3. Correction : We are now deleting the blank records in covered individual table and grouping the employees for checking/unchecking the check box on Part 3. Please verify the same scenario from ACA 1095C corrections screen
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected:

            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_Get_ACAIRS1095CData.StoredProcedure.sql
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB [ACA Automation].
            Its working fine,
            Now Part III check box is not checked for Blank Dependent Record.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB [ACA Automation] . Its working fine, Now Part III check box is not checked for Blank Dependent Record.

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h
                  8h
                  Remaining:
                  Time Spent - 3.25h Remaining Estimate - 4.75h
                  4.75h
                  Logged:
                  Time Spent - 3.25h Remaining Estimate - 4.75h
                  3.25h