The Competence Match (Organization Hierarchy) Status Analytics workbook compares the competence requirements of a person's job with the person's competence proficiency levels.
This workbook helps you decide which applicants suit a vacancy, or which contingent worker suits an assignment. The workbook also highlights competence gaps in your enterprise, and so you can use it to gather training requirements.
How do the competencies of people in my enterprise match the competence requirements for jobs in my enterprise?
Before running the worksheets you must enter a value for the following parameters:
Organization Hierarchy
Top Organization
Rollup Organizations - Yes/No
Job
Person Assignment Type
This workbook has the following worksheets:
Compare to Minimum Proficiency
Compare to Range
By Organization and Location
By Person
By Person Graph
The Compare to Minimum Proficiency worksheet compares people's proficiency levels with the minimum proficiency requirement for each competence relevant to their job. The worksheet displays how many people have the required competencies, and compares people's proficiency levels to the required minimum.
The Compare to Minimum Proficiency worksheet contains the following columns:
Competence
The competencies you have defined for the job you selected in the Job parameter.
Min Required
The minimum level required for the competence.
Max Required
The maximum level required for the competence.
Without Competence
The number of people in the job who have no competence recorded.
Without Level
The number of people who have the competence, but no recorded level.
The worksheet has further columns that list the number of people whose ratings are above or below the minimum competence level required for the job.
The columns are as follows:
| Column Name | Rating |
|---|---|
| <-3 | More than three levels below the competence minimum level |
| -3 | Three levels below the competence minimum level |
| -2 | Two levels below the competence minimum level |
| -1 | One level below the competence minimum level |
| Exact Match (Min Required) | Matches the competence minimum level |
| +1 | One level above the competence minimum level |
| +2 | Two levels above the competence minimum level |
| +3 | Three levels above the competence minimum level |
| <+3 | More than three levels above the competence minimum level |
The Compare to Minimum Proficiency worksheet compares people's proficiency levels to the required proficiency range for each competence relevant to their job. The worksheet displays how many people have the required competencies, and compares people's proficiency levels to the required proficiency level range.
The Compare to Range worksheet contains the following columns:
Competence
The competencies you have defined for the job you selected in the Job parameter.
Min Required
The minimum level required for the competence.
Max Required
The maximum level required for the competence.
Without Competence
The number of people in the job who have no competence recorded.
Without Level
The number of people who have the competence, but no recorded level.
The worksheet has further columns that list the number of people whose ratings are above or below the minimum competence level required for the job.
The columns are as follows:
| Column Name | Rating |
|---|---|
| <-3 | More than three levels below the competence minimum level |
| -3 | Three levels below the competence minimum level |
| -2 | Two levels below the competence minimum level |
| -1 | One level below the competence minimum level |
| Exact Match (Min Required) | Matches the competence minimum level |
| +1 | One level above the competence minimum level |
| +2 | Two levels above the competence minimum level |
| +3 | Three levels above the competence minimum level |
| <+3 | More than three levels above the competence minimum level |
The by Organization and Location worksheet enables you to see each person's level of proficiency for the competencies for their job.
The by Organization and Location worksheet contains the following columns:
Location Name
Organization
The organizations within each location.
Competence
The competencies you have defined for the selected job, for each organization.
Person
The people in each organization who hold the selected job.
Required Proficiency Level
The minimum proficiency level required for the competence for the person's job.
Requirement Effective From
The date the proficiency level requirement began.
Requirement Essential
Whether the competence is essential for the job.
Attained Proficiency Level
The proficiency level attained by the person.
Date Attained
The date the person attained the proficiency level.
The by Person worksheet enables you to see individuals' proficiency levels.
You select an individual from the Person page item in the worksheet.
The worksheet contains the following columns:
Competence
The competencies you have defined for the selected job.
Requirement Effective From
The date the proficiency level requirement began.
Requirement Essential
Whether the competence is essential for the job.
Attained Proficiency Level
The proficiency level attained by the person.
Date Attained
The date the person attained the proficiency level.
The by Person Graph worksheet breaks down each competence relevant to the selected job into percentages below, within, and above the required proficiency ranges for the job. It shows how an individual's competencies map to the requirement range.
You select an individual from the Person page item in the worksheet.
The workbook shows the percentage of the proficiency range that is below the minimum requirement, the percentage that is within the requirement range, and the percentage that is above the maximum requirement range. It reports the individual's proficiency in a competence as a percentage.
The diagram below shows you how proficiency levels for a competence translate into percentages.
The worksheet contains the following columns:
Competence
The competencies you have defined for the selected job, for each selected organization.
Below Required Range Percent
The percentage of proficiency levels for the competence that are below the required minimum level for the job.
Within Required Range Percent
The percentage of proficiency levels for the competence that are within the required proficiency range for the job.
Above Required Range Percent
The percentage of proficiency levels for the competence that are above the required maximum level for the job.
Attained Level Percent
The percentage achievement level the selected person has attained for that competence.
A vertical bar chart enables you to see how an individual's proficiency level for a competence compares with the required proficiency standards. The chart displays two bars for each competence. The first bar represents the range of proficiency levels across a competence. The bar has three elements:
The minimum achievable proficiency level to minimum required proficiency level.
The minimum required proficiency level to maximum required proficiency level.
The maximum required proficiency level to maximum achievable proficiency level.
The second bar displays the individual's attained proficiency level for the competence.
