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

Import - Marital Status is not updated Properly

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      LB QA - In Testing
    • Issue Importance:
      Must Have

      Description

      Replication Steps :
      1) Create one Spouse [ Dependent ] import template with mandatory field
      2) Create import file with mandatory fields of dependent
      3) Import Spouse Data

      NOTE : Spouse data is imported successfully but Marital Status on Demographics Page is not updated properly.
      CC - Sachin Hingole

        Attachments

          Activity

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

          Hi Ankur Deshpande,

          Verified on LB
          Company - City of durham

          Martial status is not updated on demographics when spouse is imported.
          Hence Re-opening this jira

          Thanks
          Jayshree

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Ankur Deshpande , Verified on LB Company - City of durham Martial status is not updated on demographics when spouse is imported. Hence Re-opening this jira Thanks Jayshree
          Hide
          ankur.deshpande Ankur Deshpande (Inactive) added a comment -

          Concern : Import - Marital Status is not updated Properly.
          Cause : The MaritialStatusID was NULL in Employee table, due to this where clause was getting failed.
          Correction : Modified where clause for the same.

          Show
          ankur.deshpande Ankur Deshpande (Inactive) added a comment - Concern : Import - Marital Status is not updated Properly. Cause : The MaritialStatusID was NULL in Employee table, due to this where clause was getting failed. Correction : Modified where clause for the same.
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi Ankur Deshpande,

          Verified on LB
          Company - City of Durham

          Verified below scenario :
          1)Spouse Data Imported successfully , Marital Status is updated as "Married" on Demographics Page of Employee for newly added spouse(Spouse relationship status - Spouse)
          2)Verified for Spouse import When Spouse Relationship status are Ex-spouse, Domestic Partner,Common law spouse - Not updating Martial status, it will remains blank (working as As per UI)
          2)Verified for spouse import when effective date is ~, Blank - Import done successfully
          3)Verified Updating of Martial status through import from Martial to single - Pass(verified through Demographics import->Mapped Martial status field)

          Also verified impact testing which is not working as its not implemented under this jira
          1)Updating Relationship Status Ex-Spouse to Spouse -> Martial status must update from blank to Married (As per UI)
          2)Updating Martial Status from Married to Divorced - Spouse Relation status must update from Spouse to Ex-spouse
          Will create separate jira for this issues

          Will move this jira Ahead ready for stage as its implemented functionality is working properly.

          Thanks,
          Jayshree

          CC : Rakesh Roy Prasad Pise

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Ankur Deshpande , Verified on LB Company - City of Durham Verified below scenario : 1)Spouse Data Imported successfully , Marital Status is updated as "Married" on Demographics Page of Employee for newly added spouse(Spouse relationship status - Spouse) 2)Verified for Spouse import When Spouse Relationship status are Ex-spouse, Domestic Partner,Common law spouse - Not updating Martial status, it will remains blank (working as As per UI) 2)Verified for spouse import when effective date is ~, Blank - Import done successfully 3)Verified Updating of Martial status through import from Martial to single - Pass(verified through Demographics import->Mapped Martial status field) Also verified impact testing which is not working as its not implemented under this jira 1)Updating Relationship Status Ex-Spouse to Spouse -> Martial status must update from blank to Married (As per UI) 2)Updating Martial Status from Married to Divorced - Spouse Relation status must update from Spouse to Ex-spouse Will create separate jira for this issues Will move this jira Ahead ready for stage as its implemented functionality is working properly. Thanks, Jayshree CC : Rakesh Roy Prasad Pise
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Verified on Stage
          Company - Caiso for hspl

          Verified below scenario : - Working as expected

          1)Spouse Data Imported successfully , Marital Status is updated as "Married" on Demographics Page of Employee for newly added spouse(Spouse relationship status - Spouse)
          2)Verified for Spouse import When Spouse Relationship status are Ex-spouse, Domestic Partner,Common law spouse - Not updating Martial status, it will remains blank (working as As per UI)
          2)Verified for spouse import when effective date is ~, Blank - Import done successfully
          3)Verified Updating of Martial status through import from Martial to single - Pass(verified through Demographics import->Mapped Martial status field)

          Marking item state as Ready for production

          Thanks,
          Jayshree

          Cc : Rakesh Roy Prasad Pise

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage Company - Caiso for hspl Verified below scenario : - Working as expected 1)Spouse Data Imported successfully , Marital Status is updated as "Married" on Demographics Page of Employee for newly added spouse(Spouse relationship status - Spouse) 2)Verified for Spouse import When Spouse Relationship status are Ex-spouse, Domestic Partner,Common law spouse - Not updating Martial status, it will remains blank (working as As per UI) 2)Verified for spouse import when effective date is ~, Blank - Import done successfully 3)Verified Updating of Martial status through import from Martial to single - Pass(verified through Demographics import->Mapped Martial status field) Marking item state as Ready for production Thanks, Jayshree Cc : Rakesh Roy Prasad Pise
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Verified on Production
          Company - Caiso for hspl

          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 - Verified on Production Company - Caiso for hspl Working as expected Marking item state as production complete Thanks, Jayshree CC; Rakesh Roy Prasad Pise

            People

            Assignee:
            jayshree.nagpure Jayshree Nagpure (Inactive)
            Reporter:
            meghana.joshi Meghana Joshi (Inactive)
            Developer:
            Ankur Deshpande (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

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

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 37.75h
                37.75h