GetPerformanceRatingByIncrease

Get Performance Rating Distr. By Increase Types

Minor Business Rule

Object Name: N0800185

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

The purpose of this business function is to get the employee counts and the total increase amounts by increase types for a low and high performance
appraisal level.

SetUp Notes

Technical Specifications

Parameters

Data ItemRequiredI/ODescription
MNAMEYIModel Name
RWTYPYIReview Type
ANPAYISupervisor Number
RVIEWYIReports View: 1=Direct reports, 2=Direct and Indirect Reports
EV01YIA code to count eligible employees whose increase amounts > 0, or to count eligible
employees whose increase amounts >=0
SCLLYILow Scale Value for Performance Appraisal
SCHLYIHigh Scale Value for Performance Appraisal
TRSNIIncrease Type #1
ECITNOEmployee Count for Increase Type #1
MATH01NOTotal Amount for Increase Type #1
TRSNIIncrease Type #2
ECITNOEmployee Count for Increase Type #2
MATH01NOTotal Amount for Increase Type #2
TRSNIIncrease Type #3
ECITNOEmployee Count for Increase Type #3
MATH01NOTotal Amount for Increase Type #3
TRSNIIncrease Type #4
ECITNOEmployee Count for Increase Type #4
MATH01NOTotal Amount for Increase Type #4
TRSNIIncrease Type #5
ECITNOEmployee Count for Increase Type #5
MATH01NOTotal Amount for Increase Type #5
TRSNIIncrease Type #6
ECITNOEmployee Count for Increase Type #6
MATH01NOTotal Amount for Increase Type #6
TRSNIIncrease Type #7
ECITNOEmployee Count for Increase Type#7 MATH01NOTotal Amount for Increase
Type #7
TRSNIIncrease Type #8
ECITNOEmployee Count for Increase Type #8
MATH01NOTotal Amount for Increase Type #8
TRSNIIncrease Type #9
ECITNOEmployee Count for Increase Type #9
MATH01NOTotal Amount for Increase Type #9
TRSNIIncrease Type #10
ECITNOEmployee Count for Increase Type #10
MATH01NOTotal Amount for Increase Type #10
MOWNRYIModel Owner

Related Tables

Table Table Description
F08830WFCompensation Root Work Table
F08831WFCompensation Detail Work Table
F05840Employee/Supervisor Relationship Level

Processing

• For each non blank and non null increase type:

//Select records from the business view//

• If report view = '1' //report view is direct reports//

• If counting eligible employees whose increase amounts > 0

• Select V08830WFJA, by Model Name, Review type, Supervisor Number, Increase Type, Modified
eligibility = '1' , increase amount > 0, relationship level = 1 and model owner

• Else //else counting increase amount >=0//

• Select V08830WFJA, by Model Name, Review type, Supervisor Number, Increase Type, Modified
eligibility = '1' , increase amount >= 0, relationship level = 1, and model owner

• End

• Else //else report view is all reports//
• If counting eligible employees whose increase amounts > 0

• Select V08830WFJA, by Model Name, Review Type, Supervisor Number, Increase Type, and Modified
eligibility = '1' ,Increase Amount > 0, and model owner

• Else //else counting increase amount >=0//

• Select V08830WFJA, by Model Name, Review Type, Supervisor Number, Increase Type, and Modified
eligibility = '1', Increase Amount >=0, and model owner

• End //end of if counting eligible employee whose increase =0//

• End //end of if report view = '1'//

• Fetch Next V08830WFJA
• Initialize the employee count for the increase type
• Initialize the total amount for the increase type

• While fetchnext is successful

• Employee count = Employee count + 1
• Total Amount = Total Amount + Increase Amount
• Fetchnext V08830WFJA

• EndWhile

Repeat the same logic with the next non blank and non null increase type

Data Structure

D0800185 - Get Performane Rating Distr. By Increase Types

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szModelName9	MNAME	char	REQ	INPUT
The model name. Valid values are: MASTER is a model name to be used for the Final Submitted Compensation. PUBLIC model is controlled by a UDC Table. Must use entry from the UDC Table. PRIVATE model could have any name the owner chooses.
cReviewType	RWTYP	char	REQ	INPUT
A code that indicates the last compensation review type.
mnSupervisor	ANPA	MATH_NUMERIC	REQ	INPUT
The address book number of the supervisor.
cReportView	RVIEW	char	REQ	INPUT
Flag to indicate Report View. UDC table (08/RV) is attached to this item.
cEligibleEmployeeCount	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
mnLowValue	SCLL	MATH_NUMERIC	REQ	INPUT
The lowest rating on the scale, level, or range.
mnHighValue	SCLH	MATH_NUMERIC	REQ	INPUT
The highest rating on the scale, level, or range.
szChangeReason1	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount1	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount1	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason2	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount2	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount2	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason3	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount3	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount3	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason4	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount4	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount4	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason5	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount5	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount5	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason6	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount6	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount6	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason7	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount7	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount7	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason8	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount8	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount8	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason9	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount9	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount9	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szChangeReason10	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnEmployeeCount10	ECIT	MATH_NUMERIC	OPT	OUTPUT

mnTotalAmount10	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnModelOwner	MOWNR	MATH_NUMERIC	OPT	INPUT
The address book number of the person creating the model.
mnTotalAnnualSalary1	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary2	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary3	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary4	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary5	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary6	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary7	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary8	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary9	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
mnTotalAnnualSalary10	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.

Related Functions

None

Related Tables

None