Learner Missing Training Queries

The following table lists all queries and criteria with learner missing training (by course code or program code) parameters. These queries identify learners who have not completed a particular training item. That is, the course is not on the learner's plan, or if it is on the learner's plan, it has a status other than completed.

Query Name

Criteria

Description

LM_LG_A_MISSING_TRAINING_1

Course Code, Start Date From, Start Date To, Learning Environment, State

Group learners who have not enrolled or planned a particular class (course) in a date range, belonging to a learning environment and state.

LM_LG_A_MISSING_TRAINING_2

Course Code, Start Date From, Start Date To, Department, Business Unit, Learning Environment

Group learners who have not enrolled or planned a particular class (course) in a date range, belonging to a department.