GetCompensationSummaryTotals

Get Compensation Summary Totals

Minor Business Rule

Object Name: N0800184

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description
The purpose of  this business function is to calculate the total current salary, the total new salary and the total percent salary change for a specified 
supervisor's reports.


Technical Specifications


Parameters

Data ItemRequiredI/ODescription
MNAMEYIModel Name
RWTYPYIReview Type

ANPAYISupervisor Number

RVIEWYIReports View: 1=Direct reports, 2=Direct and Indirect Reports

TCSRVNOTotal Current Salaries

TNSRVNOTotal New Salaries

TPSRVNOTotal Percent Salary Change

MOWNRYIModel Owner


Related Tables 

Table Table Description

F05840Employee/Supervisor Relationship Level
F08830WFCompensation Root Work Table


Processing

• If reports view = '1' //direct reports//
•  Select V08830WFJB, by model name, review type, supervisor number, relationship level = 1, and model 
owner

• Else  //Else all reports//
• Select V08830WFJB, by model name, review type, supervisor number, and model owner
• End  //end of if report view = '1'//

• FetchNext V08830WFJB
• While fetchnext operation is successful
• Accumulate the total current salaries
• Accumulate the total new salaries
• FetchNext  V08830WFJB
• EndWhile
 
Total Percent Salary Change = (Total New Salaries  Total Current Salaries) / Total Current Salaries*100

Total Salary Change= Total New Salaries - Total Current Salaries




Data Structure

D0800184 - Get Compensation Summary Totals

Parameter NameData ItemData TypeReq/OptI/O/Both
szModelNameMNAMEcharREQINPUT

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.

cReviewTypeRWTYPcharREQINPUT

A code that indicates the last compensation review type.

mnSupervisorANPAMATH_NUMERICREQINPUT

The address book number of the supervisor.

cReportViewRVIEWcharREQINPUT

Flag to indicate Report View. UDC table (08/RV) is attached to this item.

mnTotalCurrentSalariesTCSRVMATH_NUMERICOPTOUTPUT

This field refers to the total current salaries for the report view requested.

mnTotalNewSalariesTNSRVMATH_NUMERICOPTOUTPUT

Total New Salaries for the report view requested.

mnTotalPercentSalChangeTPSRVMATH_NUMERICOPTOUTPUT

This field indicates the total percent of the salary change for the report view requested.

mnModelOwnerMOWNRMATH_NUMERICOPTINPUT

The address book number of the person creating the model.

mnTotalSalaryChangeTCSRVMATH_NUMERICOPTOUTPUT

This field refers to the total current salaries for the report view requested.

Related Functions

None

Related Tables

None