WORKTERRAProject Type: software

WORKTERRA

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

Dependent Import - Validation For unique fields

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 26

      Description

      If necessary Unique fields are not mapped as IsUnique for Dependent import, Import is failed.
      We should have a validation here which will show error for uniqueness and not start the import if unique fields are not marked.

      Following are the necessary unique fields for dependent Import:

      • Employee SSN
      • Dependent First Name
      • Dependent Last Name
      • Relationship Type
      • Gender
      • Dependent Date of Birth

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-10303 Ledcor Beneficiary Load - Trust record

          • Medium - Has the potential to affect progress.
          • Production Complete
          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-9259 Import Fail when Dependent effective date is marked as "Unique"

          • Low - Minor problem or easily worked around.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            suraj.sokasane Suraj Sokasane (Inactive) created issue -
            satyap Satya made changes -
            Field Original Value New Value
            Sprint Enhancements: March-June 2017 [ 48 ]
            satyap Satya made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Suraj Sokasane [ suraj.sokasane ]
            satyap Satya made changes -
            Sprint Enhancements: March-June 2017 [ 48 ] WT Sprint 25 [ 46 ]
            satyap Satya made changes -
            Sprint WT Sprint 25 [ 46 ] Enhancements: March-June 2017 [ 48 ]
            satyap Satya made changes -
            Sprint Enhancements: March-June 2017 [ 48 ] WT Sprint 26 [ 49 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 30/Mar/17 09:58 AM
            • Time Spent:
              3h
               

              Analysis and Coding.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 8h [ 28800 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 34984 [ 34984 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 5h [ 18000 ]
            Time Spent 4h [ 14400 ] 7h [ 25200 ]
            Worklog Id 35497 [ 35497 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 31/Mar/17 02:32 PM - edited
            • Time Spent:
              4h
               

              Analysis and Coding

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Dev Due Date 05/Apr/2017
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Worklog Id 34984 [ 34984 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 03/Apr/17 04:37 PM
            • Time Spent:
              1h
               

              Discussion with Jayshree and analysis.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 4h [ 14400 ]
            Time Spent 7h [ 25200 ] 8h [ 28800 ]
            Worklog Id 35840 [ 35840 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 03/Apr/17 04:47 PM
            • Time Spent:
              3.5h
               

              analysis and coding

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0.5h [ 1800 ]
            Time Spent 8h [ 28800 ] 11.5h [ 41400 ]
            Worklog Id 35843 [ 35843 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 04/Apr/17 01:33 PM
            • Time Spent:
              5h
               
              <No comment>
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 05/Apr/17 01:34 PM
            • Time Spent:
              0.5h
               

              discussion with Amit

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 11.5h [ 41400 ] 12h [ 43200 ]
            Worklog Id 36328 [ 36328 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 05/Apr/17 03:27 PM
            • Time Spent:
              7h
               

              Coding, Unit testing, Discussion with Amit and Jaideep.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 12h [ 43200 ] 19h [ 68400 ]
            Worklog Id 36372 [ 36372 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Dev Due Date 05/Apr/2017 06/Apr/2017
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 06/Apr/17 01:39 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 07/Apr/17 09:57 AM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 19h [ 68400 ] 19.5h [ 70200 ]
            Worklog Id 36803 [ 36803 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Developer Suraj Sokasane [ suraj.sokasane ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            The analysis document is not ready as the approach was not fixed. It was fixed after discussion with Amit on Wednesday. We'll attach the document soon.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - The analysis document is not ready as the approach was not fixed. It was fixed after discussion with Amit on Wednesday. We'll attach the document soon.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Prasad Pise [ prasadp ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Attachment Affected Files.txt [ 44766 ]
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Affected Files: Affected Files.txt

            Impacted areas :

            • Employee Import Uniqueness
            • Spouse Import Existinng / New
            • Child Import Existing / New

            only data import is affected and not the back end routines.

            Unit Testing Done:

            1. Child Import new Child with DOB not given
            2. Child Import new Child with DOB given
            3. Spouse Import new Child with DOB not given
            4. Spouse Import new Child with DOB given
            5. Child Import existing Child with DOB not given
            6. Child Import existing Child with DOB given
            7. Spouse Import existing Child with DOB not given
            8. Spouse Import existing Child with DOB given
            9. Spouse / Child Import with no unique field / one unique field / multiple unique fields
            10. Employee Import with no unique field / one unique field / multiple unique fields
            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Affected Files : Affected Files.txt Impacted areas : Employee Import Uniqueness Spouse Import Existinng / New Child Import Existing / New only data import is affected and not the back end routines. Unit Testing Done: Child Import new Child with DOB not given Child Import new Child with DOB given Spouse Import new Child with DOB not given Spouse Import new Child with DOB given Child Import existing Child with DOB not given Child Import existing Child with DOB given Spouse Import existing Child with DOB not given Spouse Import existing Child with DOB given Spouse / Child Import with no unique field / one unique field / multiple unique fields Employee Import with no unique field / one unique field / multiple unique fields
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 07/Apr/17 02:15 PM
            • Time Spent:
              3h
               

              Unit Testing, Coding, Code Review.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 19.5h [ 70200 ] 22.5h [ 81000 ]
            Worklog Id 36964 [ 36964 ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Jayshree Nagpure [ jayshree.nagpure ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment WT-7755 TestCases.xls [ 44901 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 10/Apr/17 01:16 PM
            • Time Spent:
              1h
               

              Analysis and Internal discussion

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 22.5h [ 81000 ] 23.5h [ 84600 ]
            Worklog Id 37229 [ 37229 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 11/Apr/17 01:27 PM
            • Time Spent:
              0.5h
               

              Internal discusion with dev team

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 23.5h [ 84600 ] 24h [ 86400 ]
            Worklog Id 37544 [ 37544 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 11/Apr/17 01:38 PM
            • Time Spent:
              0.75h
               

              Discussion with Jayshree

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 24h [ 86400 ] 24.75h [ 89100 ]
            Worklog Id 37558 [ 37558 ]
            jayshree.nagpure Jayshree Nagpure (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)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Priya Dhamande [ priya.dhamande ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 12/Apr/17 12:53 PM - edited
            • Time Spent:
              2h
               

              Scenario verification on LB on symphony company for Employee
              Scenario explain to Priya

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 24.75h [ 89100 ] 26.25h [ 94500 ]
            Worklog Id 37762 [ 37762 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment WT-7755 TestCases_Scenarios.xls [ 45268 ]
            Hide
            Permalink
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Environment: LB
            Company: Symphony
            Login: Partner
            Template: spouse Effective and Child Effective

            Scenarios covered are attached with jira along with updated Test cases

            All scenarios worked as expected. So, moving jira on Stage.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: LB Company: Symphony Login: Partner Template: spouse Effective and Child Effective Scenarios covered are attached with jira along with updated Test cases All scenarios worked as expected. So, moving jira on Stage.
            priya.dhamande Priya Dhamande (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)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 26.25h [ 94500 ] 26.75h [ 96300 ]
            Worklog Id 37762 [ 37762 ]
            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)
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Jayshree Nagpure [ jayshree.nagpure ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment WT-7755 TestCases.xls [ 44901 ]
            jayshree.nagpure Jayshree Nagpure (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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment WT-7755 TestCases_ScenariosUpdated.xls [ 45832 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Link This issue relates to WT-9259 [ WT-9259 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 19/Apr/17 12:59 PM
            • Time Spent:
              4h
               

              Stage testing and internal discussion

            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Hi Suraj Sokasane,

            Verified on Stage
            Company- Caiso for hspl

            Verified all the scenarios mentioned in Testcases_ScenariosUpdated document.
            Working fine as expected.
            But during testing we have encountered an issue of import fail when dependent effective date is marked as unique.
            Please refer linked jira for the same.

            Other scenarios are working well.
            Marking item state as stage on hold till WT-9259 issue fixes.

            Thanks,
            Jayshree

            CC: Rakesh Roy Prasad Pise Priya Dhamande Hrishikesh Deshpande

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Hi Suraj Sokasane , Verified on Stage Company- Caiso for hspl Verified all the scenarios mentioned in Testcases_ScenariosUpdated document. Working fine as expected. But during testing we have encountered an issue of import fail when dependent effective date is marked as unique. Please refer linked jira for the same. Other scenarios are working well. Marking item state as stage on hold till WT-9259 issue fixes. Thanks, Jayshree CC: Rakesh Roy Prasad Pise Priya Dhamande Hrishikesh Deshpande
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 26.75h [ 96300 ] 30.75h [ 110700 ]
            Worklog Id 39370 [ 39370 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 30.75h [ 110700 ] 35.75h [ 128700 ]
            Worklog Id 42440 [ 42440 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 35.75h [ 128700 ] 37.75h [ 135900 ]
            Worklog Id 42447 [ 42447 ]
            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)
            jayshree.nagpure Jayshree Nagpure (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)
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Suraj Sokasane,

            Verified on Production
            Company - Long for hspl
            Verified all the scenario
            Working as expected.
            Marking item state as production complete.

            Thanks,
            Jayshree

            CC: Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Suraj Sokasane , Verified on Production Company - Long for hspl Verified all the scenario Working as expected. Marking item state as production complete. Thanks, Jayshree CC: Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 03/May/17 12:40 PM - edited
            • Time Spent:
              1.5h
               

              Production testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 37.75h [ 135900 ] 38.75h [ 139500 ]
            Worklog Id 42916 [ 42916 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 38.75h [ 139500 ] 39.25h [ 141300 ]
            Worklog Id 42916 [ 42916 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Link This issue causes WT-10303 [ WT-10303 ]
            Transition Time In Source Status Execution Times
            Suraj Sokasane (Inactive) made transition -
            New Request Pending for Approval
            		80d 22h 45m 1
            Suraj Sokasane (Inactive) made transition -
            Pending for Approval Approved for Development
            		2s 1
            Suraj Sokasane (Inactive) made transition -
            Approved for Development In Development
            		1s 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            		6d 1h 39m 1
            Priya Dhamande (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		2d 6h 28m 1
            Priya Dhamande (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		4s 1
            Jayshree Nagpure (Inactive) made transition -
            Approved for Stage Stage Testing
            		6d 19h 23m 1
            Jayshree Nagpure (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		14d 4h 1
            Jayshree Nagpure (Inactive) made transition -
            Pending for Production Approval Approved for production
            		5s 1
            Jayshree Nagpure (Inactive) made transition -
            Approved for production In Production Testing
            		2m 21s 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            		13h 55m 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              suraj.sokasane Suraj Sokasane (Inactive)
              Developer:
              Suraj Sokasane (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 12h Original Estimate - 12h
                  12h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 39.25h
                  39.25h