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

"covered all 12 months" check box is not checked if "00" month index is imported into system

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • 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

      Pre-requisite -
      1.Add Employee SSN - 300000179
      2.Add child – SSN – 300000197
      3.ACA Plan should be self insured
      4.Create file with Month Index = “00” and other valid value for other fields
      5.Import Tempate - ACA Correction 1095 C Part III EmpID Dependent
      6.95C Report Name - 1095C 28 Dec16 437

      Screen Shot - 300000179_AllMonth_Check_Box_Did_Not_Check.jpg

      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- Only Jan month check box is checked

      Expected - It should check "covered all 12 months" checkbox

        Attachments

        1. 300000179_AllMonth_Check_Box_Did_Not_Check.jpg
          300000179_AllMonth_Check_Box_Did_Not_Check.jpg
          142 kB
        2. 7421.png
          7421.png
          159 kB
        3. 7421-Prod.png
          7421-Prod.png
          171 kB
        4. Import.txt
          0.1 kB

          Issue Links

            Activity

            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 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Ramya Tantry [ ramya.tantry ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            This Issue is valid but customization is not valid.
            Please ensure that dependents alone are not enrolled in a plan without employee.
            Please maintain this while importing correction data also.

            *Files affected: *
            Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - This Issue is valid but customization is not valid. Please ensure that dependents alone are not enrolled in a plan without employee. Please maintain this while importing correction data also. *Files affected: * Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ]
            Original Estimate 4h [ 14400 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 28/Dec/16 12:25 PM
            • Time Spent:
              0.5h
               
              <No comment>
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3.5h [ 12600 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 15952 [ 15952 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            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 -
            Assignee Ramya Tantry [ ramya.tantry ] Mahendra Mungase [ mahendra.mungase ]
            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB company [ACA Automation].
            Its working fine.
            PFA screen shot of verified employee.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB company [ACA Automation] . Its working fine. PFA screen shot of verified employee.
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment 7421.png [ 36713 ]
            smita.pawar Smita Pawar (Inactive) logged work - 05/Jan/17 01:12 PM
            • Time Spent:
              0.75h
               

              LB testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 2.75h [ 9900 ]
            Time Spent 0.5h [ 1800 ] 1.25h [ 4500 ]
            Worklog Id 17527 [ 17527 ]
            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)
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern: "covered all 12 months" check box is not checked if "00" month index is imported into system
            Cause: For import related changes, we removed sequence number. As there was sequence number mismatch, data did not get updated.
            Correction: We have removed sequence number from the table and are updating the sequence number on the Final table of covered individual

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : "covered all 12 months" check box is not checked if "00" month index is imported into system Cause : For import related changes, we removed sequence number. As there was sequence number mismatch, data did not get updated. Correction : We have removed sequence number from the table and are updating the sequence number on the Final table of covered individual
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 2.75h [ 9900 ] 2.5h [ 9000 ]
            Time Spent 1.25h [ 4500 ] 1.5h [ 5400 ]
            Worklog Id 17659 [ 17659 ]
            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)
            ramya.tantry Ramya Tantry (Inactive) logged work - 06/Jan/17 05:23 PM
            • Time Spent:
              0.25h
               

              3C's Update

            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Production company [Marquette For HSPL].
            Its working fine.
            PFA screen shot of verified employee.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production company [Marquette For HSPL] . Its working fine. PFA screen shot of verified employee.
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) logged work - 11/Jan/17 01:53 PM - edited
            • Time Spent:
              1h
               

              Production testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment 7421-Prod.png [ 37122 ]
            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 2.5h [ 9000 ] 1.75h [ 6300 ]
            Time Spent 1.5h [ 5400 ] 2.25h [ 8100 ]
            Worklog Id 18500 [ 18500 ]
            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 1.75h [ 6300 ] 1.5h [ 5400 ]
            Time Spent 2.25h [ 8100 ] 2.5h [ 9000 ]
            Worklog Id 18500 [ 18500 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            1h 19m 1
            Smita Pawar (Inactive) made transition -
            In Development In LB Testing
            7d 23h 16m 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Stage Testing
            1d 1h 44m 1
            Smita Pawar (Inactive) made transition -
            Stage Testing In Production Testing
            5d 16m 1
            Smita Pawar (Inactive) made transition -
            In Production Testing Production Complete
            6m 5s 1
            Smita Pawar (Inactive) made transition -
            Production Complete Closed
            46s 1

              People

              Assignee:
              smita.pawar Smita Pawar (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 - 4h
                  4h
                  Remaining:
                  Time Spent - 2.5h Remaining Estimate - 1.5h
                  1.5h
                  Logged:
                  Time Spent - 2.5h Remaining Estimate - 1.5h
                  2.5h