Learning and Development

Views for the Learning Management System: courses, skills, qualifications, positions, profiles, and employee evaluations.

These views cover the full learning and development lifecycle in Maecos: from course catalogs and training delivery to skill management, qualification tracking, and employee evaluations. This is the largest view group with 24 views.

Domain	Description	Views
Courses	Course catalog, content modules, enrollments, approvals, classroom and on-the-job training	9
Skills, Profiles and Organization	Skills, qualifications, positions, profiles, teams, learning paths, and the skill matrix	13
Evaluations	Employee performance evaluations with scored answers	2

How these views relate

Courses train users on skills. Completing a course creates a qualification in lms_qualifications. The skill_matrix_need view computes which skills each user needs based on their position and profile. Comparing needs to qualifications gives you the skill gap. Evaluations provide a separate performance conversation layer linked to teams.

The skill gap analysis pattern (joining skill_matrix_need with lms_qualifications) is the most common cross-view query in this group. See Example Queries for ready-to-use SQL.