Version 9.1.201 (15 December 2025)

Job Management

Add UserId to JobInherentConstraint entity (#142647)

Problem

Unable to set the status of a competency job inherent requirement if another user already has the requirement on the same job profile 

Solution

Updated the uniqueness constraints for the `JobCompetencyInherentRequirements` table to include the `UserId` field.

This change ensures that records are uniquely identified by a combination of `RulesetId`, `UserId`, `InherentRequirementsId`, and `JobProfileId`, rather than just by `RulesetId`, `InherentRequirementsId`, and `JobProfileId`.

This will help prevent duplicate entries for different users and improve data integrity in scenarios where multiple users interact with the same job competency requirements. 

---

Learning Management