WORKTERRAProject Type: software

WORKTERRA

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

          causes

          Enhancement - An improvement or enhancement to an existing feature or task. WT-4579 Import Corrected 1095C Code into system

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            mahendra.mungase Mahendra Mungase (Inactive) created issue -
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Field Original Value New Value
            Link This issue causes WT-4579 [ WT-4579 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Summary 95C Part III check box is check for Blank Record 95C Part III check box is check for Blank Dependent Record
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Ramya Tantry [ ramya.tantry ]
            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 02/Jan/17 12:19 PM
            • Time Spent:
              2h
               

              analysis
              coding
              Testing

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ]
            Original Estimate 8h [ 28800 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 6h [ 21600 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 16646 [ 16646 ]
            Hide
            Permalink
            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
            Permalink
            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
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            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)
            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 ] Mahendra Mungase [ mahendra.mungase ]
            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 04/Jan/17 11:21 AM
            • Time Spent:
              0.25h
               

              testing and LB checkin

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 5.75h [ 20700 ]
            Time Spent 2h [ 7200 ] 2.25h [ 8100 ]
            Worklog Id 17131 [ 17131 ]
            Hide
            Permalink
            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.
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Lb Retesting 300000177.png [ 36611 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 04/Jan/17 01:44 PM
            • Time Spent:
              1h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 5.75h [ 20700 ] 4.75h [ 17100 ]
            Time Spent 2.25h [ 8100 ] 3.25h [ 11700 ]
            Worklog Id 17207 [ 17207 ]
            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)
            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Mahendra Mungase [ mahendra.mungase ]
            smita.pawar Smita Pawar (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)
            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: Ready for Production(10217)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Code Reviewed By Nandkumar Karlekar [ 11904 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            		7d 4h 49m 1
            Smita Pawar (Inactive) made transition -
            In Development In LB Testing
            		1h 27m 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Stage Testing
            		2d 46m 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing In Production Testing
            		5d 23h 57m 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            		15s 1
            Smita Pawar (Inactive) made transition -
            Production Complete Closed
            		2m 28s 1

              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