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.

Data Granularity

Provides one row per employee per assigned skill.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns

Employee Skills Display Names All skills assigned to an employee providing the Display Name SCH_PEOPLE_SKILL_DISPLAY_NAMES_CONCATENATED String No
Employee Skills Employee Skill Names (Concatenated) SCH_PEOPLE_SKILL_NAMES_COMMA_SEPARATED String No
Skill Display Name Display name of the employee's assigned skill SCH_PEOPLE_SKILL_DISPLAY_NAME String No
Skill Effective Date Effective date of the employee's assigned skill SCH_PEOPLE_SKILL_EFF_DATE Date No
Skill Name Name of the employee's assigned skill SCH_PEOPLE_SKILL_NAME String No
Skill Proficiency Level Proficiency level of the employee's assigned skill SCH_PEOPLE_SKILL_PROFICIENCY_LEVEL_NAME String No
Skill Status Status of the employee's assigned skill SCH_PEOPLE_SKILL_STATUS String No
Skills Details All skills assigned to employee with name, proficiency level and effective date SCH_PEOPLE_SKILL_NAMES_FULL_DETAILS String No

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many