CalculateCompaRatio

Compa-Ratio Server

Minor Business Rule

Object Name: N0800004

Parent DLL: CFND

Location: Client/Server

Language: NER

Functional Description
The purpose of the Named ER is to calculate the Compa Ratio for the Pay Rate passed.  The server returns a return code of 'N' if the
compa-ratio couldn't be processed, ' ' if the pay rate falls between the Low and High pay rates, 'L' if the pay rate is below the minimum
designated pay rate, and 'H' if the pay rate is above the maximum designated pay rate.

Technical Specifications

Parameters

Data Item Data Structure DescriptionI/ORequiredNotes
JBCDJob TypeIY**Job Type/Step or Pay Grade required, but not
both.
JBSTJob StepIY*
PGRDPay GradeIY*
SLOCSalary LocalityINBlank is considered valid locality.
EFTBEffective DateINIf Effective Date is not passed in, today's date is
used.
SALYPay ClassIY
FTEFull Time EquivalentsINRequired only if FTE adjustment is required.
SALNSalary RateIY****Salary or Hourly Rate required, but not both.
HRTNHourly RateIY**
CRAOWCompa-RatioOCalculated.
YSTProcessed CodeOL, H, N, or ' '
AAQ1Minimum SalaryORetrieved from Pay Grade Server or calculated from
F08290 data.
AAQ2Mid SalaryOibid.
AAQ3Maximum SalaryOibid.
DL01Locality DescriptionNNot Used in OneWorld.

Related Tables

Table Table Description
F08290Pay Range Formulas Table
F08001Job Information Table

Processing

If Effective Date is not initialized default to today's date.
If PayGrade is blank
  Retrieve Evaluation Points from F08001 base on Job Type/Step
  If Evaluation Points > 0
    Retrieve Pay Per Point/Based on Amount/Multiplier for Minimum/Multiplier for Maximum
                   Geographic Multiplier/Rounding Factor - based on Pay Class, Salary Locality and
                    most recently expired Effective Date from F08290.
    Calculate Mid Salary = Pay Per Point * Evaluation Points * Geographic Multiplier
                                          + Based On Amount.
    Calculate Minimum Salary = Mid Salary * Multiplier for Minimum.
    Calculate Maximum Salary = Mid Salary * Multiplier for Maximum.
    Round Mid Salary, Minimum Salary, and Maximum Salary to Round Factor.
  Else
    Error Flag = -1
  End If
Else
  Call Pay Grade Server
          -> Pay Grade
          -> Locality
          -> Pay Class
          <- Error Flag
          -> Effective Date
          <- Minimum Salary
          <- Mid Salary
          <- Max Salary
          -> Union Code
End If
If no Error Flag
  If Mid Salary = 0
    Processed Code = 'N'
  Else
    If Pay Class = 'S' then Pay Rate = Salary Rate
    If Pay Class = 'H' then Pay Rate = Hourly Rate
    Compa-Ratio = Pay Rate / Mid Salary
    If Pay Rate < Minimum Salary then Processed Code = 'L'
    If Pay Rate > Maximum Salary then Processed Code = 'H'
    If Pay Class = 'S' and Salary Rate <> 0 and Full Time Equivalents <> 0
      Compa-Ratio = Compa-Ratio / Full Time Equivalents
    End If
  End If
Else
  Processed Code = 'N'
End If

Data Structure

DN0800004 - Compa-Ratio Server

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szJobCode	JBCD	char	NONE	NONE
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and apply that information to the employees who are linked to that job type.
szJobStep	JBST	char	NONE	NONE
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job type to determine pay rates by job in the Pay Rates table.
szPayGrade	PGRD	char	NONE	NONE
A code that designates a category for grouping employees according to pay ranges. For each pay grade, you enter a pay range that includes a minimum, a midpoint, and a maximum pay rate. The system uses these pay ranges to calculate compa-ratios for the employees that you assign to pay grades. After you enter a pay grade for an employee, the system displays either an error or a warning message if you enter a rate for the employee that is not within the pay range for the employee's pay grade. To set up pay grades, use Pay Grades by Class (P082001). If you have set up your system to use rates in the Pay Grade Step table as the default pay rates for employees, changing an employee's pay grade step causes the system to automatically update the following fields: o Salary o Hourly Rate o Hours per day o Hours per year o Days per year
szLocality	SLOC	char	NONE	NONE
A user defined code (07/SL) that defines the different salary localities within an organization. For example, you can compare salaries for employees on the East Coast with employees in the Midwest.
jdDateEffective	EFTB	JDEDATE	NONE	NONE
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
cPayClass	SALY	char	NONE	NONE
A code that specifies how an employee is paid. Valid codes are: H Hourly S Salaried P Piecework
mnFullTimeEquiv	FTE	MATH_NUMERIC	NONE	NONE
The full-time equivalent (FTE) amount. This figure is the portion of a full-time worker that an employee represents within the business unit. For example, an employee who works 20 hours per week would represent .50 (1/2 FTE). This number cannot be greater than 1 for any employee.
mnSalaryRate	SALN	MATH_NUMERIC	NONE	NONE
The employee's new annual salary for all payroll entries manually entered or automatically generated for the payroll period after the Date of Next Raise from the employee's master record. See the definition for data item NRDT (Date - Next Raise).
mnHourlyRate	HRTN	MATH_NUMERIC	NONE	NONE
The base hourly rate increase for an employee. The following will be added together to determine recommended hourly increase for an employee: o Hourly Rate (see data item, HRTN), o Cost of Living (see data item, AMT6), o Local Cost of Living (see data item, AMT7), o Merit Increase (see data item, AMT8), and o Promotion (see data item, AMT9).
cProcessedCode	YST	char	NONE	NONE
A code used to indicate whether a payroll transaction has been processed through the payroll cycle. This value is held within various files within the payroll system. Valid values are: Blank Unprocessed. 1 Processed. P Processed and checks have been printed (F07350 Only). ************************************************************ The F07351 contains values as they relate to the printed payment. For the F07351, valid values are: Blank Not Printed. I Interim Printed. 1 Non-Interim Printed.
mnMinSalary	AAQ1	MATH_NUMERIC	NONE	NONE
The minimum salary or hourly rate allowed within a pay grade. This field is used to trigger warnings in the Salary and Wage module when an employee's salary or rate is lower than the minimum permitted within the pay grade.
mnMidSalary	AAQ2	MATH_NUMERIC	NONE	NONE
The midpoint salary or hourly rate within a pay grade or pay range. For job IDs with a defined pay grade, this amount is defined in the Pay Grade table (F082001). For job IDs that are evaluated by points, this amount is calculated using a Pay Range Formula table (F08290). The compa-ratio figure (data item #CRA) is calculated by dividing an employee's salary or rate by the appropriate midpoint.
mnMaxSalary	AAQ3	MATH_NUMERIC	NONE	NONE
The maximum salary or hourly rate within a pay grade. This field is used to trigger warnings in the Salary and Wage module when an employee's salary or rate is higher than the maximum permitted in the pay grade.
szLocalityDesc	DL01	char	NONE	NONE
A user defined name or remark.
mnAmountCompaRatio	CRAOW	MATH_NUMERIC	NONE	NONE
The ratio of an employee's rate of pay to the established midpoint of the pay grade. This statistic is used to establish controls within rate ranges and to specify the number of employees normally at or above this level by department or organization-wide. The system automatically calculates the compa-ratio by dividing the employee's salary by the pay grade midpoint. This field will be blank in the following circumstances: o No pay range formulas with an effective date that precedes the next review date were assigned to the employee in the Employee Master table. o No pay range formula has been established and linked to an employee with a job that has job evaluation points and an effective date that precedes the next review date.
szUnionCode	UN	char	NONE	NONE
A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate.

Related Functions

None

Related Tables

None