Classification Action Request – This is a formal request by Departments for HR to review a job classification with regard to its essential duties and responsibilities, knowledge, skills and abilities, minimum required qualifications with regard to education and experience, and or certifications, working conditions and physical demands. It is critically important for any organization properly evaluate its job classifications so that the human capital of the organization is appropriately and competitively “priced.” Average is based on actual results from previous years.

Step-By-Step Data Gathering Process:

Data for this KPI comes from our weekly reclassification and waiver reports, which can be accessed by CCC personnel. The report is maintained by the CCC Administrative Assistant and is distributed to CCC team members by e-mail every Tuesday.

If not by e-mail, another way to access weekly reclassification and waiver reports is to use the following steps:

1. Route to Class (\\AS141)
2. Select the folder titled “Reclassifications and Waiver Reports”.
3. Select the folder with the most relevant fiscal year.
4. Open the latest report.

Once the most recent reclassification and waiver report is opened, save it to the CCC division’s KPI folder for later manipulation by following this route: X:\AS141\Class\A CCC Division KPIs\CAR statistics.  Here you will save the report under the month and year you are reporting on, which is always one month back. For example, if today were April 5, one would want to report March’s data.

Now that the weekly reclassification and waiver report has been saved in the folder, manipulation can take place for KPI purposes.

To begin, focus should be directed to column L – Completion Date. Delete all of the rows that were not completed in the month you are reporting on. Continuing with the example of wanting to report March’s data, delete all the rows that are pending or completed pre-March / post-March. By the end, your “Completion Date” row should be consistent of only one month. Save the report.

Next, scroll to the bottom of the report. Double check the equations in the green and blue boxes to make sure they’re right. Sometimes with rows being deleted, the equations don’t cover a column top to bottom as they should and rows are left out when they shouldn’t be.

Last, with the equations verified, one can see how many reclassification requests were completed in 60 days or less versus how many took more than 60 days. These are the two numbers needed to report in the data owner spreadsheet.

ClearPoint Data Series Descriptions & Formulas

# on Time (The # of reclassification requests completed in the month that took 60 days or less to finish.)

Total # Processed (The # of reclassification requests completed in the month regardless the # of days it too to finish them.)

% of reclassification requests completed within 60 days = (# on Time / Total # Processed) * 100

Target Calculations

The division’s target is to completed reclassification requests within 60 days 90% of the time.

Overall target – division does not have one.

High variance – This target is a predetermined percentage set by the department director. It is not calculated via a ClearPoint formula.

Low variance – This target is a predetermined percentage set by the department director and CCC manager. It is not calculated via a ClearPoint formula.

Evaluation

% of reclassification requests completed within 60 days is the evaluated series.

Actual = ( # on time / Total # processed ) * 100