Writing Formulas for Rating Competencies and Objectives

During an appraisal, you can:

For more information about how the application calculates competency and objective scores, see Assessing Competencies and Objectives

Appraisal Objective Line Scoring

The formula context values are:

The formula input values are:

The formula output value is line_score (number).

HRMS provides sample formulas PERF and PERF_X_WEIGHTING. See: Sample Appraisal Objective Line Scoring Formulas

Appraisal Competency Line Scoring

The formula context values are:

The formula input values are:

The formula output value is line_score (number).

HRMS provides sample formulas PERF_X_WEIGHTING, PERF_X_PROF, and PROF_X_WEIGHTING. See: Sample Appraisal Competency Line Scoring Formulas

Appraisal Total Scoring

The formula context values are:

The formula input values are:

The formula output value is final_rating (number).

Note that the Appraisal Total Score formula must return a rating level ID associated with a level from the final-rating scale identified in the appraisal template. The application generates rating level IDs automatically. For simplicity, the sample Appraisal Total Score formulas return a level value (such as 1, 2, or 3) rather than the required rating level ID. To obtain the rating level ID:

  1. In the Rating Scales window, query the final-rating scale identified in the appraisal template.

  2. Select the first level value (for example, 1).

  3. From the Help menu, select Diagnostics, then Examine. The Examine Field and Variable Values window appears.

  4. Select the Field value RATING_LEVEL_ID. The rating level ID appears in the Value field.

Repeat this procedure for each level in the rating scale.

HRMS provides sample formulas AVG_COMP_AND_OBJ and SUM_COMP_AND_OBJ. See: Sample Appraisal Total Scoring Formulas