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

            Activity

            Hide
            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.
            Hide
            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
            Hide
            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.
            Hide
            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
            Hide
            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

              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