Employee Skill Assignment
The Employee Skill Assignment entity provides data columns that allow the creation of Dataviews and Report Data Objects that provide information on all skills that are assigned to employees.
This entity is purely for reporting on the skills assigned to each employee. It is not intended to be used with transactional data.
Supported Dataview Types
|
Employee Dataview |
Business Structure Dataview |
Employee Time Series Dataview |
Business Structure Time Series Dataview |
|---|---|---|---|
|
X |
X |
X |
Data granularity
Provides one row per employee per assigned skill.
Columns
|
Label |
Description |
Key |
|---|---|---|
|
Employee Skills Display Names |
All skills assigned to an employee providing the Display Name. |
SCH_PEOPLE_SKILL_DISPLAY_NAMES_CONCATENATED |
|
Employee Skills |
Employee Skill Names (Concatenated) |
SCH_PEOPLE_SKILL_NAMES_COMMA_SEPARATED |
|
Skill Display Name |
Display name of the employee's assigned skill. |
SCH_PEOPLE_SKILL_DISPLAY_NAME |
|
Skill Effective Date |
Effective date of the employee's assigned skill. |
SCH_PEOPLE_SKILL_EFF_DATE |
|
Skill Name |
Name of the employee's assigned skill. |
SCH_PEOPLE_SKILL_NAME |
|
Skill Proficiency Level |
Proficiency level of the employee's assigned skill. |
SCH_PEOPLE_SKILL_PROFICIENCY_LEVEL_NAME |
|
Skill Status |
Status of the employee's assigned skill. |
SCH_PEOPLE_SKILL_STATUS |
|
Skills Details |
All skills assigned to employee with name, proficiency level and effective date |
SCH_PEOPLE_SKILL_NAMES_FULL_DETAILS |
Related entities
Core entity
|
Employee |
Organization |
Day |
Organizational Job |
Paycode |
Labor Category |
Activity |
|---|---|---|---|---|---|---|
|
X |
Relationship
|
One-to-One |
One-to-Many |
|---|---|
|
X |