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

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

Environment

Release : All versions

 

Resolution

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.