Linking Employer Relationship end date to Employment History end date

When an end date is added to an Employee/Employer Relationship, the same end date should be automatically added to the related Employment History row. Currently, these two dates need to be maintained separately which introduces the possibility of the data being out of sync and adds an additional data processing step for staff. It's our opinion that an individual cannot be employed by an organization with which they no longer have a relationship with, thus necessitating the need to have these two end dates tied together.
  • Guest
  • Jun 29 2015
  • Shipped
  • Dec 1, 2020

    Admin response

    Released in SP26

  • Attach files
      Drop here to upload
    • Kelli Crispin commented
      February 11, 2021 19:09

      NOT at all impressed with the implementation of this in SP 26! You definitely didn't take my 2019 suggestion below to have it go the other way. You have a constraint if the edit comes from the relationship side, but edits on the job side can keep the dates out of sync. Additionally, since this is a new constraint, we have data already in the system that doesn't conform to the constraint. While QA-ing the SP, I discovered that a user could inadvertently update the job dates if they were editing the relationship for any reason. The user can also run up against an ugly constraint error if they edit the relationship and the end date is before the last job's start date. (This can occur due to prior unconstrained data or a user updating the job date without updating the relationship date.) This has created a great deal of work for us to compensate for this feature that is touted to help with our data integrity, including my QA time, as well as developer time to customize the job forms and try to clean up the old data accurately.

    • Admin
      Pat Conley commented
      December 01, 2020 16:23

      Released in SP26

    • Admin
      Pat Conley commented
      July 31, 2020 14:47

      Planned for SP26

    • Kelli Crispin commented
      September 10, 2019 13:45

      It would be nice if this went the other way around also... If the employer relationship already has an end date and you add a new job title, the relationship end date should be removed. There is a great deal of messy non-synced data in our system because of this, and I'm having difficulty finding easy ways to fix the errors programmatically, when this should be a system function.

    • Stephen Mally commented
      January 22, 2019 22:42

      Please add this functionality!

    • Liz Hackett commented
      January 22, 2019 22:29

      Agreed, this is a no brainer!

    • Becky Batman commented
      August 25, 2016 14:26

      Career level needs to be added to the Relationships section and not be a separate piece in Employment history.  Any step out of sync with the original process is easily forgotten by updaters. 

    • Stephanie Boyce commented
      July 27, 2016 18:52

      This is just a best practice issue, I don't know why this has not been set up before, this really needs to be set up. 

    • +18