Employee Certification Assignment

The Employee Certification Assignment entity provides data columns that allow the creation of Dataviews and Report Data Objects that provide information on all certifications that are assigned to employees. This entity is purely for reporting on the certifications assigned to each employee. It is not intended to be used with transactional data.

Data Granularity

Provides one row per employee per assigned certification.

Supported Dataview/RDO Type

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

Columns
Certification Display Name Display name of the employee's assigned certification SCH_PEOPLE_CERTIFICATION_DISPLAY_NAME String No
Certification Expiration Date The Expiration Date of the certification assigned to the employee SCH_PEOPLE_CERTIFICATION_EXPIRATION_DATE Date No
Certification Expired Indicator Indicates if the employee's certification has expired SCH_PEOPLE_CERTIFICATION_IS_EXPIRED Boolean No
Certification Grant Date The Grant Date of the certification assigned to the employee SCH_PEOPLE_CERTIFICATION_GRANT_DATE Date No
Certification Name Name of the employee's assigned certification SCH_PEOPLE_CERTIFICATION_NAME String No
Certification Number The number of the certification assigned to the employee SCH_PEOPLE_CERTIFICATION_NUMBER String No
Certification Proficiency Level Proficiency level of the employee's assigned certification SCH_PEOPLE_CERTIFICATION_PROFICIENCY_LEVEL_NAME String No
Certifications Details All certifications assigned to employee with name, proficiency level and expiration date SCH_PEOPLE_CERTIFICATION_NAMES_FULL_DETAILS String No
Employee Certification Expiration Dates Employee Certification Expiration Dates (Concatenated) SCH_PEOPLE_CERTIFICATION_EXPIRATION_DATES_COMMA_SEPARATED String No
Employee Certifications Display Names All certifications assigned to an employee providing the Display Name SCH_PEOPLE_CERTIFICATION_DISPLAY_NAMES_CONCATENATED String No
Employee Certifications Employee Certification Names (Concatenated) SCH_PEOPLE_CERTIFICATION_NAMES_COMMA_SEPARATED String No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many