WORKTERRAProject Type: software

WORKTERRA

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

ACA TIN Validation error report.

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Good To Have

      Attachments

        Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. WT-8173 ACA_TIN Validation_Employee who has Waived election is not coming on TIN validation Report.

        • High - Serious problem that could block progress.
        • Production Complete

          Activity

          Ascending order - Click to sort in descending order
          Permalink
          abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 22/Dec/16 08:00 AM
          • Time Spent:
            3h
             

            Analysis and requirement gathering.

          abhijeet.khandagale Abhijeet Khandagale (Inactive) created issue -
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 40h [ 144000 ] 37h [ 133200 ]
          Time Spent 3h [ 10800 ]
          Worklog Id 15140 [ 15140 ]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          Permalink
          abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 23/Dec/16 12:47 PM
          • Time Spent:
            4.5h
             

            Analysis.

          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Remaining Estimate 37h [ 133200 ] 32.5h [ 117000 ]
          Time Spent 3h [ 10800 ] 7.5h [ 27000 ]
          Worklog Id 15269 [ 15269 ]
          Permalink
          abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 26/Dec/16 08:00 AM
          • Time Spent:
            7h
             

            Changes in Stored procedure.

          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Attachment WT-7342 Analysis document.doc [ 35918 ]
          Hide
          Permalink
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

          Sachin Hingole,

          Please go through attached analysis document, WT-7342 Analysis document.doc .

          Add your views if I missed anything.

          Thanks,
          Abhijeet

          Show
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Sachin Hingole , Please go through attached analysis document, WT-7342 Analysis document.doc . Add your views if I missed anything. Thanks, Abhijeet
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Remaining Estimate 32.5h [ 117000 ] 25.5h [ 91800 ]
          Time Spent 7.5h [ 27000 ] 14.5h [ 52200 ]
          Worklog Id 15675 [ 15675 ]
          Permalink
          abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 27/Dec/16 08:30 AM
          • Time Spent:
            4h
             

            Stored procedure changes and started with RDL changes.

          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Remaining Estimate 25.5h [ 91800 ] 21.5h [ 77400 ]
          Time Spent 14.5h [ 52200 ] 18.5h [ 66600 ]
          Worklog Id 15860 [ 15860 ]
          Permalink
          abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 28/Dec/16 08:00 AM
          • Time Spent:
            6h
             

            Creating SSRS report.

          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Remaining Estimate 21.5h [ 77400 ] 15.5h [ 55800 ]
          Time Spent 18.5h [ 66600 ] 24.5h [ 88200 ]
          Worklog Id 16071 [ 16071 ]
          Permalink
          abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 29/Dec/16 08:16 AM
          • Time Spent:
            4h
             

            Unit Testing.

          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Remaining Estimate 15.5h [ 55800 ] 11.5h [ 41400 ]
          Time Spent 24.5h [ 88200 ] 28.5h [ 102600 ]
          Worklog Id 16089 [ 16089 ]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Assignee Abhijeet Khandagale [ abhijeet.khandagale ] Kumar Chhajed [ kumar.chhajed ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 29/Dec/16 11:11 AM
          • Time Spent:
            4h
             

            Coding
            Internal discussion with abhijeet
            Unit testing

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 11.5h [ 41400 ] 7.5h [ 27000 ]
          Time Spent 28.5h [ 102600 ] 32.5h [ 117000 ]
          Worklog Id 16153 [ 16153 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Sachin Hingole [ sachin.hingole ]
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 02/Jan/17 02:34 PM
          • Time Spent:
            2h 40m
             

            Unit testing
            Review request and changes
            Local and LB check-ins

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 7.5h [ 27000 ] 4h 50m [ 17400 ]
          Time Spent 32.5h [ 117000 ] 35h 10m [ 126600 ]
          Worklog Id 16752 [ 16752 ]
          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 02/Jan/17 10:00 PM - edited
          • Time Spent:
            20m
             

            Code Review

          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Remaining Estimate 4h 50m [ 17400 ] 4.5h [ 16200 ]
          Time Spent 35h 10m [ 126600 ] 35.5h [ 127800 ]
          Worklog Id 16779 [ 16779 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Worklog Id 16779 [ 16779 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          sachin.hingole Sachin Hingole (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)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Smita Pawar [ smita.pawar ]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Developer Abhijeet Khandagale [ abhijeet.khandagale ] Kumar Chhajed [ kumar.chhajed ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment - - edited

          We could not start working on this due to Code import Functionality Enhancement testing

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - - edited We could not start working on this due to Code import Functionality Enhancement testing
          smita.pawar Smita Pawar (Inactive) made changes -
          Production Due Date 07/Feb/2017
          Stage Due Date 1/Feb/17 [ 2017-02-01 ]
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 31/Jan/17 05:13 AM
          • Time Spent:
            4h
             
            <No comment>
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 4.5h [ 16200 ] 0.5h [ 1800 ]
          Time Spent 35.5h [ 127800 ] 39.5h [ 142200 ]
          Worklog Id 21765 [ 21765 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Link This issue relates to WT-8173 [ WT-8173 ]
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 01/Feb/17 01:32 PM
          • Time Spent:
            0.5h
             

            Internal discussion

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
          Time Spent 39.5h [ 142200 ] 40h [ 144000 ]
          Worklog Id 22441 [ 22441 ]
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 02/Feb/17 06:52 AM
          • Time Spent:
            4h
             
            <No comment>
          smita.pawar Smita Pawar (Inactive) made changes -
          Description Tested scenarios are as follows.

          1.Checked whether dependent's data is getting displayed correctly when TIN validation error is received for
             EE+FAMILY
          2.Checked whether EE & Dependent data is getting displayed correctly when Employee enrolled in plan when TIN validation error is received for EE+SP health tier
          3.Checked whether EE & Dependent data is getting displayed correctly when Employee waived plan when TIN validation error is received for EE+SP health tier
          4.Checked whether plan terminated date is getting displayed correctly when Employee switches plan.
          5.Checked whether plan terminated date is getting displayed correctly when only dependent is terminated from plan
          smita.pawar Smita Pawar (Inactive) made changes -
          Original Estimate 40h [ 144000 ] 50h [ 180000 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 40h [ 144000 ] 44h [ 158400 ]
          Worklog Id 22543 [ 22543 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 44h [ 158400 ] 46h [ 165600 ]
          Worklog Id 22544 [ 22544 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          Tested scenarios are as follows.

          1.Checked whether dependent's data is getting displayed correctly when TIN validation error is received for
          EE+FAMILY
          2.Checked whether EE & Dependent data is getting displayed correctly when Employee enrolled in plan when TIN validation error is received for EE+SP health tier
          3.Checked whether EE & Dependent data is getting displayed correctly when Employee waived plan when TIN validation error is received for EE+SP health tier
          4.Checked whether plan terminated date is getting displayed correctly when Employee switches plan.
          5.Checked whether plan terminated date is getting displayed correctly when only dependent is terminated from plan

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Tested scenarios are as follows. 1.Checked whether dependent's data is getting displayed correctly when TIN validation error is received for EE+FAMILY 2.Checked whether EE & Dependent data is getting displayed correctly when Employee enrolled in plan when TIN validation error is received for EE+SP health tier 3.Checked whether EE & Dependent data is getting displayed correctly when Employee waived plan when TIN validation error is received for EE+SP health tier 4.Checked whether plan terminated date is getting displayed correctly when Employee switches plan. 5.Checked whether plan terminated date is getting displayed correctly when only dependent is terminated from plan
          smita.pawar Smita Pawar (Inactive) made changes -
          Description Tested scenarios are as follows.

          1.Checked whether dependent's data is getting displayed correctly when TIN validation error is received for
             EE+FAMILY
          2.Checked whether EE & Dependent data is getting displayed correctly when Employee enrolled in plan when TIN validation error is received for EE+SP health tier
          3.Checked whether EE & Dependent data is getting displayed correctly when Employee waived plan when TIN validation error is received for EE+SP health tier
          4.Checked whether plan terminated date is getting displayed correctly when Employee switches plan.
          5.Checked whether plan terminated date is getting displayed correctly when only dependent is terminated from plan
          smita.pawar Smita Pawar (Inactive) made changes -
          Worklog Id 22544 [ 22544 ]
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 03/Feb/17 06:53 AM - edited
          • Time Spent:
            2h
             

            LB testing

          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 03/Feb/17 09:05 AM
          • Time Spent:
            2.5h
             

            LB testing

          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 46h [ 165600 ] 48.5h [ 174600 ]
          Worklog Id 23143 [ 23143 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Description
          Production Due Date 07/Feb/2017 09/Feb/2017
          Stage Due Date 1/Feb/17 [ 2017-02-01 ] 8/Feb/17 [ 2017-02-08 ]
          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 -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 16/Feb/17 02:08 PM - edited
          • Time Spent:
            0.75h
             

            stage testing

          smita.pawar Smita Pawar (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned enhancement on Stage company [ACA Automation].
          Its working fine.
          PFA screen shot for additional information.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned enhancement on Stage company [ACA Automation] . Its working fine. PFA screen shot for additional information.
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment Tin.png [ 39920 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          Hi Jennifer Leugers,

          We won't be able to deploy this patch on production today i.e on 17 Feb 2017.
          It will be available on production on 20 Feb 2017 [EOD].

          Thanks,
          Smita

          FYI Nandkumar Prabhakar Karlekar,Sachin Hingole

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We won't be able to deploy this patch on production today i.e on 17 Feb 2017. It will be available on production on 20 Feb 2017 [EOD] . Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Sachin Hingole
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 17/Feb/17 02:01 PM
          • Time Spent:
            1h
             

            Email communication
            Internal discussion
            Jira updates

          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 48.5h [ 174600 ] 49.5h [ 178200 ]
          Worklog Id 25932 [ 25932 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 49.5h [ 178200 ] 50.25h [ 180900 ]
          Worklog Id 25945 [ 25945 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Worklog Id 25945 [ 25945 ]
          smita.pawar Smita Pawar (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)
          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)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Code Reviewed By Revansiddha [ 13002 ]
          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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          rakeshr Rakesh Roy (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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          Transition Time In Source Status Execution Times
          Abhijeet Khandagale (Inactive) made transition -
          New Request Pending for Approval
          		2h 29m 1
          Abhijeet Khandagale (Inactive) made transition -
          Pending for Approval Approved for Development
          		3s 1
          Abhijeet Khandagale (Inactive) made transition -
          Approved for Development In Development
          		1s 1
          Sachin Hingole (Inactive) made transition -
          In Development In LB Testing
          		10d 23h 13m 1
          Smita Pawar (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          		43d 4h 45m 1
          Smita Pawar (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          		3s 1
          Smita Pawar (Inactive) made transition -
          Approved for Stage Stage Testing
          		1d 2h 4m 1
          Rakesh Roy (Inactive) made transition -
          Stage Testing Pending for Production Approval
          		10d 13h 38m 1
          Rakesh Roy (Inactive) made transition -
          Pending for Production Approval Approved for production
          		4s 1
          Rakesh Roy (Inactive) made transition -
          Approved for production In Production Testing
          		14s 1
          Rakesh Roy (Inactive) made transition -
          In Production Testing Production Complete
          		6s 1

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            abhijeet.khandagale Abhijeet Khandagale (Inactive)
            Developer:
            Kumar Chhajed (Inactive)
            QA:
            Sachin Hingole (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Pre-Prod Due Date:
              Production Due Date:

                Time Tracking

                Estimated:
                Original Estimate - 50h Original Estimate - 50h
                50h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 50.25h
                50.25h