Learning Statistics for Talent Management/Organizational Management 
Query: 0LSO_MP03_Q0001
With this query, you can display the learning activities of employees in a talent group, functional area, or job family. The course duration and course costs are also displayed.
Currency conversion
The following apply for the currency in which the course costs are displayed:
In the standard system, the Course Costs query, which is stored in different currencies in the back-end system, displays these different currencies in the output.
If you want to compare course costs that are stored in different currencies in the back-end system, you can also display these course costs in a common currency (confgured currency).
For more information, see the documentation on the services.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Course Group |
0TRAINGROUP |
|
| Calendar Year/Month |
0CALMONTH |
Object Type | Name | Technical Name |
|---|---|---|
| Learner |
0LEARNER |
| Employee |
0EMPLOYEE |
| Organizational Unit |
0ORGUNIT |
| Personnel Area |
0PERS_AREA |
| Course Canceled Indicator |
0TRAINCANC |
| Followed Up Course Indicator |
0TRAINFLUP |
| Cost Center |
0COSTCENTER |
| Document Status |
0EVDOCSTAT |
| Receiving Cost Center |
0RECV_CCTR |
| Cancellation Reason |
0C_REASON |
| Language |
0PERSLANGU |
| Fees Indicator |
0EVCOSTINFO |
| Course Passed |
0PASSED |
| Personnel Subarea |
0PERS_SAREA |
| Course |
0TRAINING |
| Calendar Year/Month |
0CALMONTH |
| Position |
0HRPOSITION |
| Job |
0JOB |
| Master Cost Center |
0MAST_CCTR |
| Functional Area (TM) |
0FUNCAREA |
| Job Family |
0JOBFAMILY |
| Career Type |
0CAREERTYPE |
| Career Type Level |
0CAREERVL |
| Nationality |
0NATION |
| Course Type |
0TRAINTYPE |
| Delivery Method |
0TRAINFORM |
| Course Group |
0TRAINGROUP |
| Course Location |
0TRAINLOCA |
| Functional Area (TM) |
0FUNCAREA |
| Object Type of Learner |
0LEARNERTYP |
Object Type | Name | Technical Name |
|---|---|---|
| Currency |
0CURR |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Talent Group for Talent Management |
0TALENTGRP |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of Employees with at Least One Course |
0LSO_MP03_RK001 |
— |
| Number of Employees |
0LSO_MP03_CK001 |
|
| Number of Employees Without Courses |
0LSO_MP03_CK002 |
|
| Number of Booked Course Types |
0LSO_MP03_CK003 |
|
| Number of Bookings |
0LSO_MP03_CK004 |
|
| Total Course Duration in Hours |
0LSO_MP03_CK011 |
|
| Total Course Duration in Days |
0LSO_MP03_CK018 |
|
| Total Course Costs |
0LSO_MP03_CK025 |
|
| Total Attendance Fee |
0LSO_MP03_CK032 |
|
| Total Cancellation Fee |
0LSO_MP03_CK039 |
|
| Course Duration in Hours per Employee |
0LSO_MP03_CK040 |
|
| Course Duration in Days per Employee |
0LSO_MP03_CK041 |
|
| Total Booking Fee |
0LSO_MP03_CK042 |
|
| Average Booking Fee |
0LSO_MP03_CK043 |
|
| Average Course Costs |
0LSO_MP03_CK044 |