This topic includes the three supplied sample formulas of type Appraisal Competency Line Scoring. When you define a competency assessment template with a rating-scale type of Fast Formula Based Line Scoring, the application uses the formula you select to calculate the score for each competency in the Competencies section of the appraisal.
This sample formula returns a competency rating derived from specified performance and proficiency ratings. Business group and legislation code are global (null).
/****************************************************************
*
* Formula Name : PERF_X_PROF
*
* Description : For a competency appraisal line, this formula
* multiplies Performance and Proficiency.
*
* Formula Type : Appraisal Competency Line Scoring
*
* Inputs : 1) performance, number, default required
* 2) proficiency, number, default required
* 3) weighting, number, default required
* 4) line_object_id (competency_id), number, always set
* 5) appraisal_id, number, always set
* 6) appr_template_id, number, always set
* 7) appr_system_type (e.g.. SELF,EMP360,MGR360TRANS), text, always set
* 8) appr_type, text
* Note : For appraisal_id, appr_template_id, appr_system_type, appr_type
* a) This is an input, not a context
* b) No seeded DBIs use this
* Outputs : 1) line_score, number
*
* Contexts : Business Group, Assignment, Organization,
* Person, Date Earned
*
* Example DBIs : ptu_per_person_type, asg_grade, asg_job,
* asg_status, asg_type, asg_primary,
* asg_position, asg_hours, asg_salary
*
****************************************************************/
/* Defaults for optional inputs and database items */
DEFAULT FOR performance IS 0
DEFAULT FOR proficiency IS 0
DEFAULT FOR weighting IS 0
/* Declare formula inputs */
INPUTS ARE performance(number)
,proficiency(number)
,weighting(number)
,line_object_id(number)
,appraisal_id(number)
,appr_template_id(number)
,appr_system_type(text)
,appr_type(text)
/* Main body of formula */
line_score = performance * proficiency
/* Return the line score */
RETURN line_score
This sample formula returns a competency rating derived from specified performance and weighting values. Business group and legislation code are global (null).
/****************************************************************
*
* Formula Name : PERF_X_WEIGHTING
*
* Description : For a competency appraisal line, this formula
* multiplies Performance and Weighting.
*
* Formula Type : Appraisal Competency Line Scoring
*
* Inputs : 1) performance, number, default required
* 2) proficiency, number, default required
* 3) weighting, number, default required
* 4) line_object_id (competency_id), number, always set
* 5) appraisal_id, number, always set
* 6) appr_template_id, number, always set
* 7) appr_system_type (e.g.. SELF,EMP360,MGR360TRANS), text, always set
* 8) appr_type, text
* Note : For appraisal_id, appr_template_id, appr_system_type, appr_type
* a) This is an input, not a context
* b) No seeded DBIs use this
* Outputs : 1) line_score, number
*
* Contexts : Business Group, Assignment, Organization,
* Person, Date Earned
*
* Example DBIs : ptu_per_person_type, asg_grade, asg_job,
* asg_status, asg_type, asg_primary,
* asg_position, asg_hours, asg_salary
****************************************************************/
/* Defaults for optional inputs and database items */
DEFAULT FOR performance IS 0
DEFAULT FOR proficiency IS 0
DEFAULT FOR weighting IS 0
/* Declare formula inputs */
INPUTS ARE performance(number)
,proficiency(number)
,weighting(number)
,line_object_id(number)
,appraisal_id(number)
,appr_template_id(number)
,appr_system_type(text)
,appr_type(text)
/* Main body of formula */
line_score = performance * weighting
/* Return the line score */
RETURN line_score
This sample formula returns a competency rating derived from specified proficiency and weighting values. Business group and legislation code are global (null).
/****************************************************************
*
* Formula Name : PROF_X_WEIGHTING
*
* Description : For a competency appraisal line, this formula
* multiplies Proficiency and Weighting.
*
* Formula Type : Appraisal Competency Line Scoring
*
* Inputs : 1) performance, number, default required
* 2) proficiency, number, default required
* 3) weighting, number, default required
* 4) line_object_id (competency_id), number, always set
* 5) appraisal_id, number, always set
* 6) appr_template_id, number, always set
* 7) appr_system_type (e.g.. SELF,EMP360,MGR360TRANS), text, always set
* 8) appr_type, text
* Note : For appraisal_id, appr_template_id, appr_system_type, appr_type
* a) This is an input, not a context
* b) No seeded DBIs use this
* Outputs : 1) line_score, number
*
* Contexts : Business Group, Assignment, Organization,
* Person, Date Earned
*
* Example DBIs : ptu_per_person_type, asg_grade, asg_job,
* asg_status, asg_type, asg_primary,
* asg_position, asg_hours, asg_salary
****************************************************************/
/* Defaults for optional inputs and database items */
DEFAULT FOR performance IS 0
DEFAULT FOR proficiency IS 0
DEFAULT FOR weighting IS 0
/* Declare formula inputs */
INPUTS ARE performance(number)
,proficiency(number)
,weighting(number)
,line_object_id(number)
,appraisal_id(number)
,appr_template_id(number)
,appr_system_type(text)
,appr_type(text)
/* Main body of formula */
line_score = proficiency * weighting
/* Return the line score */
RETURN line_score