lcchapman
commented
5 years ago I have figured out how to do competency factoring. The factor itself will need to be calculated offline for each competency level for each occupation. I can do this in the Master table or in a separate table for each occupation. The salary total each year will be the product of the Tenure factor times the Occupation Factor times the Early Career salary based on which competency level is selected. The format would be something like this using "ten_yrs" (number of years in the occupation):
Total Salary: For Low competency: Tenure_Factor(ten_yrs) L_Occ_Fac(ten_yrs) Low_Early_Career_Sal For Avg competency: Tenure_Factor(ten_yrs) A_Occ_Fac(ten_yrs) A_Early_Career_Sal For Hi competency: Tenure_Factor(ten_yrs) H_Occ_Fac(ten_yrs) H_Early_Career_Sal
The Tenure_Factor is based on the following equation: ((0.000004(tenure)^3-0.0012(tenure)^2+0.0738*(tenure)+0.9727)/0.9727) Where "Tenure" = the number of years in that occupation.
The Occupation Factor is based on the following equation: Occ_Fac ^ (tenure) Where "Tenure" = the number of years in that occupation.
We need to be able to have three levels of competency that will drive the salary model:
Each of these will use a different "early stage" and "late stage" salary for a given occupation as follows:
Competency Level Early Stage %tile Late Stage %tile Average 17% 83% Above Average 25% 90% Below Average 10% 75%
The level of competency should be selectable as a sub-tab to the Salary slider bar.