GetIncreaseGuidelineLimits

Get Increase Guideline Limits

Minor Business Rule

Object Name: N0800167

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description
Purpose
To fetch the record from Increase Guidelines Master Table F08820 to get the column group based on the
Guideline Code, Column Factor, and PO effective date. Fetch the record from Increase Guideline Range
Table F08821 to get the low and high limit based on the Guideline Code, Effective date from the
Guidelines Master Table and the Row Factor.

Setup Notes and Prerequisites

Special Logic

Technical Specifications

Call Get Increase Guideline Master Group to get the effective date and the group number (Group 1 6).
Call Get Increase Guideline Range Limits to get the High and Low Limits to be passed to the calling
application using the group number from Increase Guideline Master Group.

Data Structure

D0800167A - Get Increase Guideline Limits

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szIncreaseGuidelineTable	IGDLT	char	REQ	INPUT
A table code to define the increase guideline ranges for an increase type.
jdDateEffectiveRates	EFT	JDEDATE	REQ	INPUT
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnPerformanceAppraisalLevel	PAPL	MATH_NUMERIC	OPT	INPUT
A code that specifies the level of proficiency at which a supervisor rates a person or asset for a particular competency type and competency code.
mnTotalJobCompetencyPercen	JBPCTRQD	MATH_NUMERIC	OPT	INPUT
A number that indicates how an employee is progressing in relation to the required competency level for a particular job. The system calculates this value by first calculating the value for the Employee Competency Percent of Required field (EEPCTRQD) for all employee competencies that are related to a job competency for a particular job. The system then multiplies these percentages by their respective weighting factor and adds them together to determine the total job competency percent achieved.
mnTierRanking	TIRNK	MATH_NUMERIC	OPT	INPUT
A value that allows a supervisor to either rank employees individually or group them into tiers. When employees are ranked, each employee is assigned a unique number. When employees are grouped into tiers, several employees can have a common number. For example, a supervisor can assign a tier of 1 through 3 to 12 employees. Each employee can be assigned to tier 1, 2, or 3.
cR08830eq1P08812eq2N08180eq3	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnGuidelineLowRange	GLLOR	MATH_NUMERIC	OPT	OUTPUT
A guideline is given to managers when they are designating wage increases. This field indicates the guideline low range.
mnGuidelineHighRange	GLHR	MATH_NUMERIC	OPT	OUTPUT
A guideline is given to managers when they are designating wage increases. This would be the guideline high range.
cGuideLineInputmethod	GLIM	char	OPT	OUTPUT
UDC table with fixed amount or percentage.
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnCompaRatio	CMPA	MATH_NUMERIC	OPT	INPUT
A calculation used to compare an employee's salary/wage against a midpoint amount set up within a pay grade or salary range.
mnLengthinservicemonth	LISM	MATH_NUMERIC	OPT	INPUT
The number of months an employee has worked for the company.
mnTimeinJobmonth	TIJM	MATH_NUMERIC	OPT	INPUT
The number of months the employee has been in this job.
mnTimeinPositionmonth	TIPM	MATH_NUMERIC	OPT	INPUT
The number of months the employee has in this position.

Related Functions

None

Related Tables

None

GetIncreaseGuidelineMasterGroup

Get Increase Guideline Limits

Minor Business Rule

Object Name: N0800167

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description
Purpose
To fetch the record from Increase Guidelines Master Table F08820 to get the column group based on the
Guideline Code, Column Factor, and PO effective date and pass it back to the calling application.

Setup Notes and Prerequisites

Special Logic

Technical Specifications
Select from F08820 Increase Guideline Master Table where Guideline table code equals the Guideline
Table code passed in and the effective date is less than or equal to the passed in date. Fetch next
from the table until a record is found with an end date greater then or equal to the passed in date or
that is null.

Check if the Data Item for Column Factor from F08820 = 'PAPL', 'TIRNK' or 'JBPCTRQD'.
If a matching record exists then

Look at each group's from (Column Group 1 From) and through (Column Group 1 Through) values.
Get the group number where the from and through values are equal to or around the amount from the
corresponding BF PAPL, BF 'TIRNK' etc. Get the Data Item for Row Factor from the F08820 record. Otherwise
Set a flag to call B0800168

If the Data Item for Row Factor = 'PAPL', 'TIRNK' or 'JBPCTRQD' then pass back the
corresponding amount from 'PAPL', 'TIRNK' or 'JBPCTRQD' in BF MATH01 and set BF EV01 = 1. Otherwise Set a
flag to call B0800168

If the flag is set to call B0800168

Call the new BSFN B0800168, Get Employee Master Specific Data Item. Pass in the Data
Item For Column Factor to get back the factor. Look at each group's from (Column Group 1
From) and through (Column Group 1 Through) values. Get the group number where the from and
through values are equal to or around the factor returned by Get Employee Master Specific
Data Item.

Get the Data Item for Row Factor from F08820, Increase Guideline Master Table, this value
will be passed back to the calling application.

Pass back the Effective Date, Guideline Input Method (%,$), and the Group Number from the
table.

Data Structure

D0800167B - Get Increase Guideline Master Group

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szIncreaseGuidelineTable	IGDLT	char	REQ	INPUT
A table code to define the increase guideline ranges for an increase type.
jdDateEffectiveRatesFromPO	EFT	JDEDATE	REQ	INPUT
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnPerformanceAppraisalLevel	PAPL	MATH_NUMERIC	OPT	INPUT
A code that specifies the level of proficiency at which a supervisor rates a person or asset for a particular competency type and competency code.
mnTotalJobCompetencyPercen	JBPCTRQD	MATH_NUMERIC	OPT	INPUT
A number that indicates how an employee is progressing in relation to the required competency level for a particular job. The system calculates this value by first calculating the value for the Employee Competency Percent of Required field (EEPCTRQD) for all employee competencies that are related to a job competency for a particular job. The system then multiplies these percentages by their respective weighting factor and adds them together to determine the total job competency percent achieved.
mnTierRanking	TIRNK	MATH_NUMERIC	OPT	INPUT
A value that allows a supervisor to either rank employees individually or group them into tiers. When employees are ranked, each employee is assigned a unique number. When employees are grouped into tiers, several employees can have a common number. For example, a supervisor can assign a tier of 1 through 3 to 12 employees. Each employee can be assigned to tier 1, 2, or 3.
cN08187eq1P08812eq2N08180eq3	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnRowFactorEnteredAmt	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
cGuideLineInputmethod	GLIM	char	OPT	OUTPUT
UDC table with fixed amount or percentage.
jdDateEffectiveRatesFromTable	EFT	JDEDATE	OPT	OUTPUT
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
nGroupNumber	INT01	integer	OPT	OUTPUT
Number of Days in Future to Query for Responses Due.
szDataitemforRowFactor	RWF	char	OPT	OUTPUT
A data item to represent the increase guideline row ranges
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnCompaRatio	CMPA	MATH_NUMERIC	OPT	INPUT
A calculation used to compare an employee's salary/wage against a midpoint amount set up within a pay grade or salary range.
mnLengthinservicemonth	LISM	MATH_NUMERIC	OPT	INPUT
The number of months an employee has worked for the company.
mnTimeinJobmonth	TIJM	MATH_NUMERIC	OPT	INPUT
The number of months the employee has been in this job.
mnTimeinPositionmonth	TIPM	MATH_NUMERIC	OPT	INPUT
The number of months the employee has in this position.

Related Functions

None

Related Tables

None

GetIncreaseGuidelineRangeLimits

Get Increase Guideline Limits

Minor Business Rule

Object Name: N0800167

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description
Purpose
To fetch the record from Increase Guideline Range Table F08821 to get the low and high limit based on
the Guideline Code, Effective date from the Guidelines Master Table and the Row Factor.

Setup Notes and Prerequisites

Special Logic

Technical Specifications

If BF EV01 = 1 then

Set a Var Factor = BF MATH01

Else

Call the new BSFN B0800168, Get Employee Master Specific Data Item. Pass in the Row Factor Data
Item to get back the factor.

Set the Var Factor = the factor from B0800168

End if

Select from F08821 Increase Guideline Range Table where Guideline table code equals the Guideline
Table code passed in, the effective date equal to the passed in date, and the Row Factor From is less
then the Var Factor. Fetch next from the table until a record is found with a Row Factor Through greater
then or equal to the Var Factor.

Get the group that matches the group number passed in and pass back the high and low limit.

Data Structure

D0800167C - Get Increase Guideline Range Limits

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szIncreaseGuidelineTable	IGDLT	char	REQ	INPUT
A table code to define the increase guideline ranges for an increase type.
jdDateEffectiveRatesFromTable	EFT	JDEDATE	REQ	INPUT
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
nGroupNumber	INT01	integer	REQ	INPUT
Number of Days in Future to Query for Responses Due.
szDataitemforRowFactor	RWF	char	REQ	INPUT
A data item to represent the increase guideline row ranges
mnRowFactorEnteredAmt	MATH01	MATH_NUMERIC	OPT	INPUT
- - - Good Performance Low Value.
cRowValueEntered	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnGuidelineLowRange	GLLOR	MATH_NUMERIC	OPT	OUTPUT
A guideline is given to managers when they are designating wage increases. This field indicates the guideline low range.
mnGuidelineHighRange	GLHR	MATH_NUMERIC	OPT	OUTPUT
A guideline is given to managers when they are designating wage increases. This would be the guideline high range.
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.

Related Functions

None

Related Tables

None