This workbook investigates the training success ratio for internal students (students employed by the organization running the training).
Success ratio is calculated as the number of successful training hours delivered to internal students divided by the total number of training hours delivered to internal students. The number of successful training hours per class is the number of successful internal students enrolled for a class, multiplied by the course duration in days for that class.
The total number of training hours delivered to internal students for a class is the total number of internal students enrolled for a class, multiplied by the course duration in days for that class.
If the SUCCESSFUL_ATTENDANCE_FLAG column of the OTA_DELEGATE_BOOKING table in the OTA schema is set to Yes, that enrollment is considered successful.
This workbook includes the following worksheets:
By Organization and Year
By Location and Year
By Job Category and Year
By Job and Year
Attendance Summary
These worksheets use classes to calculate success. For a class to be included it must:
Have an end date prior to the present date.
Have a status of Normal or Closed, if the class is scheduled.
Not be Cancelled.
The hours of a class are calculated using a predefined Oracle FastFormula. Depending on how you record the duration of classes, you may need to customize this formula. See Setting Up and Customizing Training Hours
In addition to displaying information you have set up in OLM and HRMS, the Student Training Success (Internal Students) Analysis workbook calculates the following:
Hours Offered
The total number of training hours for all relevant classes multiplied by the number of places available in all relevant classes.
Hours Delivered
The total number of training hours of all the relevant classes multiplied by the number of places filled by students in these classes.
Hours Received
The total number of training hours employees have attended for all relevant training classes.
Successful Hours
If a student is recorded as successfully having attended the class, then the employee's hours for this class are recorded as successful hours.
In the workbook, the successful hours are the total number of successful hours for all relevant classes.
Utilization %
The total hours delivered as a percentage of the hours offered. For example, if 5 hours were delivered, and 10 hours were offered, then the utilization percentage would be 50%.
Success Rate %
Successful hours delivered as a percentage of the total hours delivered. For example, if 10 hours were delivered, and 8 hours were successful, the success rate would be 80%.
This worksheet enables you to analyze the number of training hours delivered to internal students each year, and the success of these hours. You can investigate student success rates for a business group and organization within your enterprise.
What is the training success rate of an organization over a given period of time?
In which year did an organization have highest training success rate?
This worksheet has no parameters.
This worksheet enables you to analyze the number of training hours delivered to internal students for a location each year, and the success of these hours. You can investigate student success rates for a business group and organization within your enterprise.
What is the training success rate for a training location over a given period of time?
In which training year did a particular training location have the highest training success rate?
This worksheet has no parameters.
This worksheet enables you to analyze the number of training hours delivered to internal students each year for a job by category, and the success of these hours. You can investigate student success rates for a Business Group and organization within your enterprise.
What is the training success rate for a job category over a given period of time?
In which training year was the success rate highest for a particular job category?
This worksheet has no parameters.
This worksheet enables you to analyze the number of training hours delivered to internal students for a job by year, and the success of these hours. You can investigate student success rates for a business group and organization within your enterprise.
What is the training success rate for a job over a given period of time?
In which year did a job have the highest training success rate?
This worksheet has no parameters.
This worksheet enables you to analyze the number of internal students attending training classes. You can view internal student attendance by activity type, analyze success rates and information about failures.
How successful are my courses?
This worksheet has no parameters.