I need assistance regarding training need analysis as follow:
1. Table HR_ORG_STR_TRAINING – holds information regarding the organizational structure (ORG_ID) and training needed for the position (TRAINING_PLAN_ID)
2. Table TRAINING_EMPLOYEE - holds information on employee (EMPLOYEE_ID) and the training that employee has completed (TRAINING_ID)
3. Table HR_EMPLOMENT_HYSTORY holds information for the position of employee (ORGANISATIONAL_STRUCTURE_
ID) and the employee ID (EMPLOYEE_ID) and condition POSITION_DATE_TO is null (current position of employee)
I need view that will show training need analysis according the position that employee is assigned… Approx. 1700 employees!
TX in advance,