ConvertCompetencyPercentToLevel

Convert Competency Percent Achieved to Level

Minor Business Rule

Object Name: N0800225

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this function is to convert a competency percent achieved into a level and to return
the level and its associated description.

Setup Notes and Prerequisites

Special Logic

Technical Specification

If the Competency Level Rule Weight is not equal to  and the Required Competency Level is not
equal to  then the Competency Level is equal to the Percent Achieved divided by the Competency
Level Rule Weight and multiply that result by the Required Competency Level

If the Competency Level Rule Weight is not equal to  and the Required Competency Level is equal
to , then the Competency Level is equal to the PercentAchieved divided by the Competency Level
Rule Weight, an from that result is subtracted by 1.

The calculated Competency Level is then rounded to 3 decimal places

The calculated Competency Level is then checked to see if it is valid within the scale, and the
description is retrieved.

If the Competency Level Rule Weight is equal to  then the Competency Level is 0

Data Structure

D0800225 - Convert Competency Percent Achieved to Level

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnPercentAchieved JBPCTRQD MATH_NUMERIC REQ INPUT

Percent Achieved - The percent achieved for this competency. Do not enter this
in decimal form. If the acheived is 100%, then pass this value as 100.

mnRequiredCompetencyLevel REQL MATH_NUMERIC REQ INPUT

Required Competency Level - The required level to achieve for this competency.

mnCompetencyLevelRuleWeight LVWT MATH_NUMERIC REQ INPUT

Competency Level Rule Weight - The weight this competency contributes to the
overall achieved level.

szScale SCLE char REQ INPUT

Scale - The scale associated with this competency.

mnCompetencyLevel CMPV MATH_NUMERIC OPT OUTPUT

Competency Level - Returns the level associated with the percent achieved.

szCompetencyLevelDescription DL01 char OPT OUTPUT

Competency Level Description - Returns the description associated with the
competency level.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnPercentAchieved	JBPCTRQD	MATH_NUMERIC	REQ	INPUT
Percent Achieved - The percent achieved for this competency. Do not enter this in decimal form. If the acheived is 100%, then pass this value as 100.
mnRequiredCompetencyLevel	REQL	MATH_NUMERIC	REQ	INPUT
Required Competency Level - The required level to achieve for this competency.
mnCompetencyLevelRuleWeight	LVWT	MATH_NUMERIC	REQ	INPUT
Competency Level Rule Weight - The weight this competency contributes to the overall achieved level.
szScale	SCLE	char	REQ	INPUT
Scale - The scale associated with this competency.
mnCompetencyLevel	CMPV	MATH_NUMERIC	OPT	OUTPUT
Competency Level - Returns the level associated with the percent achieved.
szCompetencyLevelDescription	DL01	char	OPT	OUTPUT
Competency Level Description - Returns the description associated with the competency level.