This workbook investigates the training success ratio for external learners (students not employed by the organization running the training). 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 Company
By Company and Year
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 Canceled.
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 (External Students) Analysis workbook calculates the following:
Hours Delivered
The total number of training hours of all the relevant classes multiplied by the number of places filled by students on these 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.
Success Rate Percentage
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 success of training hours delivered to external students for a company. You can investigate this for a business group and year.
What is the student success ratio for a particular company (or customer)?
Which company has the highest training success ratio?
This worksheet has no parameters.
This worksheet enables you to analyze the success of training hours delivered to external students for a company, for different years. You can investigate this for a business group and each company.
In which training year did a particular customer have the highest student success ratio?
This worksheet has no parameters.