Functional Description
Purpose
The purpose of this function is to update an employee competency level everywhere it appears in the
Gap Analysis Cache. This will also update the Job Competency levels in the cache as well as
recalculate the Overall level, which may change as a result of the change to the employee competency level.
Setup Notes and Prerequisites
Special Logic
Technical Specification
Go through the cache to find all instances of the employee competency that is
being changed.
When the employee competency is found in the current Job Competency, incriment the Count of Employee
Competencies updated for the current Job Competency.
Calculate the percentage achieved for each cache record of the employee competency found
Update the employee competency record with the new level, level description, and percent achieved.
To Calculate for the Option:
Get the option with highest percent for this job competency before the new employee competency level.
The highest option percent determines the Job Competency Code Percentage Achieved. When the new
option percent is calculated, if it changes the highest option percent, then the Job Competency needs to
be updated with the new highest Option Percent.
Update the Job Competency record in the cache with the new highest percent, new level, and new level
description. Incriment the number of Job Comps with changed levels
Calculate for the Overall Apraisal Rating
Calculate the new Percent Achieved for the overall appraisal
Continue fetching the next record with this employee competency code
D0800223 - Update Employee Competency In Performance Appraisal Cache
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnJobNumberGapAnalysisCache | JOBS | MATH_NUMERIC | REQ | INPUT |
Job Number Gap Analysis Cache - The unique number identifying records in the
| ||||
| szGapAnalysisCacheName | PID | char | REQ | INPUT |
Gap Analysis Cache Name - Get this value by converting the Job Number Gap
| ||||
| szOptionCacheName | PID | char | REQ | INPUT |
Option Cache Name - The unique string identifying the B0800222 cache. Usually
| ||||
| szCompentencyType | CMPE | char | REQ | INPUT |
Competency Type - The competency type where the level is being updated.
| ||||
| szCompentencyCode | CMPC | char | REQ | INPUT |
Competency Code - The competency code where the level is being updated.
| ||||
| mnChangedCompetencyLevel | CMPV | MATH_NUMERIC | REQ | INPUT |
Changed Competency Level- The new competency level.
| ||||
| szChangedCompLevelDesc | CCMPDS | char | REQ | INPUT |
Changed Competency Level Description - The new competency level description.
| ||||
| mnOverallLevel | CMPV | MATH_NUMERIC | OPT | BOTH |
Overall Level - The overall performance appraisal level. This new level will be
| ||||
| szOverallLevelDescription | CCMPDS | char | OPT | BOTH |
Overall Level Description - The overall performance appraisal level description.
| ||||
| mnOverallPercentAchieved | JCPCTRQD | MATH_NUMERIC | REQ | BOTH |
Overall Percent Achieved - The overall percent achieved (the overall level
| ||||
| mnOverallRequiredLevel | REQL | MATH_NUMERIC | OPT | INPUT |
Overall Required Level - The required level for the appraisal.
| ||||
| szOverallScale | SCLE | char | OPT | INPUT |
Overall Scale - The scale used to edit the overall level.
| ||||
| cErrorCode | ERRC | char | OPT | OUTPUT |
Error Code - Not used at this time.
| ||||
| szCurrentJobCompetencyCode | JCC | char | OPT | INPUT |
Current Job Competency Code - The job competency code where the employee
| ||||
| mnNumTimesEmpCompInCurJCC | MATH01 | MATH_NUMERIC | OPT | OUTPUT |
Num Times Emp Comp In Current JCC - Returns the number of times the updated
| ||||
| mnCountJCCLevelsChanged | MATH01 | MATH_NUMERIC | OPT | OUTPUT |
Count JCC Levels Changed - Returns the number of job competency levels that
| ||||
| None |
| None |