search cancel

Skills - Where is it Stored for a Resource/Role?


Article ID: 200709


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Where is the skill information of the Resource/Role in the project team stored in the database?


Release : All versions



If any skill is added to Resource/Role in project team, the record will be created in RSM_SKILLS_ASSOCIATIONS table.
The following are the example.

Example 1

Add skills to Resource/Role.
Go to Home->Resources->Skills tab and add skills.

For Resource,

For Role,

Add these Resource and Role to the project team.
The records are created in RSM_SKILLS_ASSOCIATIONS table. (object_code = "resource")

Example 2

Go To Home->Projects->Team-> and click Properties icon of Role.

Add skill to this Role in Skills tab.

After that, the record is created in RSM_SKILLS_ASSOCIATIONS table. (object_code = "team")

The Role has 2 types of Skills.
One is Resource Skills, and other is Staff Member Skills.