Learner Organization Queries
This appendix lists PeopleSoft delivered queries for learner groups. You can create additional queries to meet your mass enrollment or reporting needs using PeopleSoft Query Analyzer. Delivered queries are presented in the following parameter categories:
Learner organization queries.
Learner job code queries.
Learner catalog item queries.
Learner missing training queries.
Learner program queries.
Note. All criteria are joined by an “and” operator.
Learner Organization Queries
The following table lists all queries and criteria with learner organization parameters.
|
Query Name |
Criteria |
Description |
|
LM_LG_A_LEARNER_ORGANIZATION |
Department ID, Business Unit, Region, State, Learning Environment, Preferred Language |
Group learners by department, region, state, within a learning environment and language preference |
|
LM_LG_A_LRNR_ORGANIZATION_1 |
Department ID, Business Unit, Region |
Group learners by department and regulatory region. |
|
LM_LG_A_LRNR_ORGANIZATION_2 |
Region, Learning Environment |
Group learners by regulatory region, and learning environment. |
|
LM_LG_A_LRNR_ORGANIZATION_3 |
Department ID, Business Unit |
Group learners by department. For department reporting. |
|
LM_LG_A_LRNR_ORGANIZATION_4 |
Department ID, Business Unit, State |
Group learners by department and state. |
|
LM_LG_A_LRNR_ORGANIZATION_5 |
Organization ID, State |
Group learners by organization/customer and state. For customer reporting. |
|
LM_LG_A_LEARNER_LE |
Learning Environment |
Group learners by learning environment |
Learner Job Code Queries
The following table lists all queries and criteria with learner learning environment parameters.
|
Query Name |
Criteria |
Description |
|
LM_LG_A_JOB_CODE |
Learner Job Code |
Group learners by job code |
|
LM_LG_A_JOB_CODE_1 |
Job Code, Region |
Group learners by job code and regulatory region |
|
LM_LG_A_JOB_CODE_2 |
Job Code, State |
Group learners by job code and state |
|
LM_LG_A_JOB_CODE_3 |
Job Code, Learning Environment |
Group learners by job code within a learning environment |
Learner Catalog Item Queries
The following table lists all queries and criteria with learner catalog item parameters.
|
Query Name |
Criteria |
Description |
|
LM_LG_A_CATALOG_ITEM_1 |
Department, Business Unit, Course Code, Enrollment Status, Start Date, End Date |
Group learners in a department and business unit with specific enrollment status in an activity (course code) in a given start date range. |
|
LM_LG_A_CATALOG_ITEM_2 |
Course Code, Learning Environment, Enrollment Status, Start Date, End Date |
Group learners in a learning environment with specific enrollment status in an activity (course code) in a given start date range. |
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 catalog item 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 activity (catalog item) 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 activity (catalog item) in a date range, belonging to a department. |
Learner Program Queries
The following table lists all queries and criteria with learner program parameters.
|
Query Name |
Criteria |
Description |
|
LM_LG_A_PROGRAM |
Program ID, Status, Registered Date From, Registered Date To, Learning Environment |
Learners in a particular learning environment who have a certain status for a program, and who were registered within the date range you specify. |
|
LM_LG_A_MISSING_PROGRAM |
Program ID, Business Unit, Department, Learning Environment, Completed Date From, Completed Date To |
Learners in a particular learning environment, department, and business unit who have not completed a program within the date range you specify. |