Use the Skills (Detailed by User) Report to gather detailed information about each rated skill for each user including the skill type, the date the user followed the skill, and the skill ratings.
Required Permission: Manage In-App Reporting
Results include one row for each user, for each rated skill, and for each skill rating action.
Example
On March 1st, Marissa added the skill "Leadership" to her profile. She self-rated the skill with a level 2. As her knowledge of the skill grew, she updated the self-rating 3 times:
- On May 1st she changed the self-rating to a 4.
- On June 1st she changed the self-rating to a 5.
- On July 16th, she changed the rating to a 7.
Additionally, on July 15th, Marissa's manager rated her Leadership skill with a manager rating of 6.
On July 31st, you generate the Skill (Detailed by User) report. The results for Marissa show a row for each action performed on the Leadership skill:
- Row 2 shows the results for when Marissa began following the skill, or added it to her profile.
- Rows 3 - 6 show the results for each time Marissa changed the self-rating for the skill.
- Row 7 shows the results for when her manager gave a manager rating for the skill.
Direct Data Connector table name: Skills_Details_SkillsByUser
| Column Name | Column Description | Enabled by Default | Direct Data Connector Field Name | Data Type |
| Skill Followed Date | The date the user followed the skill, or added it to the profile. | Y | SKILLFOLLOWEDDATE | DATE |
| Employee ID | The unique user identifier for your Degreed site. This may be an email address or a different piece of employee information, such as an SSO username. | Y | EMPLOYEEID | VARCHAR(16777216) |
| User Name | The user's full name. | Y | USERNAME | VARCHAR(16777216) |
| User First Name | The user's first name. | Y | USERFIRSTNAME | VARCHAR(16777216) |
| User Last Name | The user's last name. | Y | USERLASTNAME | VARCHAR(16777216) |
| User Email | The user’s work email address. | Y | USEREMAIL | VARCHAR(16777216) |
| Skill Name | The name of the skill the user is following. | Y | SKILLNAME | VARCHAR(16777216) |
| Skill Rating Type |
The type of rating for the skill, if any. Values can include
|
Y |
SKILLRATINGTYPE | VARCHAR(16777216) |
| Skill Rating | The skill rating level. | Y | SKILLRATING | VARCHAR(16777216) |
| Skill Rated Date |
The date the skill was rated. This is the date range column located on the Filter dialog. The column is included in the report results. |
Y | SKILLRATEDDATE | DATE |
| Skill is Focused |
Indicates if the user has the skill set as a Focus Skill. Values include: Y: Yes N: No, or unknown. |
Y |
SKILLISFOCUSED | VARCHAR(1) |
| Skill Focused Date | The date the user set the skill as a Focus Skill. | Y | SKILLFOCUSEDDATE | DATE |
| Skill Rating Privacy | Indicates the privacy setting for the skill rating is Private or Public. | Y | SKILLRATINGPRIVACY | VARCHAR(7) |
| Custom Attributes 1-50 | If your organization uses custom attributes, the top 50 fields are displayed in individual columns at the end of the report and listed in order from oldest to newest. | N |