UpdateSalaryHourlyRate

EE Master Workflow - Update Salary and Hourly Rate

Minor Business Rule

Object Name: N0500018

Parent DLL: CFND

Location: Client/Server

Language: NER

Functional Description

Purpose

The purpose of this NER update the employee master (F060116) with salary change information.

Setup Notes and Prerequisites

Special Logic

Technical Specifications
Parameters:
Data Item Data Structure I/ORequiredNotes
Description

SALSalaryINew Employee Salary
PHRTHourlyRateINew Employee Hourly
Rate
AN8Address Book NumberI
EFTOEffective DateI
TRSChange Reason CodeI
CMPACompa-ratioI

1.  Do a FetchSingle on F060116 using AN8 as the key.  This is done to automatically populate the
cache.

2.  Call the function WriteAdditionalInformationToCache which updates the cache with the change
reason code and effective date.  All other values are updated automatically.

3.  Update the table F060116.

Data Structure

DN0500018 - EE Master Workflow - Update Salary and Hourly Rate

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

mnSalary SAL MATH_NUMERIC NONE NONE

The amount that an employee is paid in one year, assuming that the employee is paid every pay period of the year. For WorldSoftware: For
the employee's primary job, the system stores the annual salary in the Employee Master Information table (F060116) and the Employee
Jobs table (F060118). For secondary jobs, the system stores the annual salary only in the Employee Jobs table (F060118). Depending on how
the value that is entered in the Display Salary (Annual/Effective) field in the HR History Constants table (F08040), this field displays one of the
following:   o  Annual salary. For salaried employees who are not linked with a contract calendar, the user enters the amount or the system
retrieves the amount from the Pay Grade/Salary Range Table (F082001). For employees who are linked with a contract calendar, the system
calculates this amount using the following formula: (((current salary minus salary paid before change) divided by number of periods to pay)
multiplied by pay frequency).   o  Effective salary. For employees whose jobs are linked with a contract calendar, the system recalculates the
effective salary when you enter a mid-calendar salary adjustment. After you enter a mid-calendar adjustment, the effective salary equals the
salary that is paid to the employee from the time of the adjustment through the end of the contract. The system calculates this amount using
the following formula: ((annual salary divided by pay frequency) times periods to pay).

mnHourlyRate PHRT MATH_NUMERIC NONE NONE

The employee's hourly rate, which is retrieved during time entry. If you enter a rate in this field on any other form, that rate can override the
value in the Employee Master table. In the Employee Master table, this number is the employee's base hourly rate. In the Union Rates table, it
is the straight time rate. NOTE: If you change the number of the data display decimal digits for this field, you must also change fields Rate -
Base Hourly (BHRT) and Rate - Hourly (SHRT) so that they have exactly the same number of data display decimal digits.

mnAddressNumber AN8 MATH_NUMERIC NONE NONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

jdDateEffectiveOn EFTO JDEDATE OPT NONE

A future date when all changes will take effect or the date when the changes went into effect. If you do not enter a date in this field, the system
uses the current date as the effective date.

szChangeReason TRS char OPT NONE

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.

mnCompaRatio CMPA MATH_NUMERIC OPT NONE

A calculation used to compare an employee's salary/wage against a midpoint amount set up within a pay grade or salary range.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnSalary	SAL	MATH_NUMERIC	NONE	NONE
The amount that an employee is paid in one year, assuming that the employee is paid every pay period of the year. For WorldSoftware: For the employee's primary job, the system stores the annual salary in the Employee Master Information table (F060116) and the Employee Jobs table (F060118). For secondary jobs, the system stores the annual salary only in the Employee Jobs table (F060118). Depending on how the value that is entered in the Display Salary (Annual/Effective) field in the HR History Constants table (F08040), this field displays one of the following: o Annual salary. For salaried employees who are not linked with a contract calendar, the user enters the amount or the system retrieves the amount from the Pay Grade/Salary Range Table (F082001). For employees who are linked with a contract calendar, the system calculates this amount using the following formula: (((current salary minus salary paid before change) divided by number of periods to pay) multiplied by pay frequency). o Effective salary. For employees whose jobs are linked with a contract calendar, the system recalculates the effective salary when you enter a mid-calendar salary adjustment. After you enter a mid-calendar adjustment, the effective salary equals the salary that is paid to the employee from the time of the adjustment through the end of the contract. The system calculates this amount using the following formula: ((annual salary divided by pay frequency) times periods to pay).
mnHourlyRate	PHRT	MATH_NUMERIC	NONE	NONE
The employee's hourly rate, which is retrieved during time entry. If you enter a rate in this field on any other form, that rate can override the value in the Employee Master table. In the Employee Master table, this number is the employee's base hourly rate. In the Union Rates table, it is the straight time rate. NOTE: If you change the number of the data display decimal digits for this field, you must also change fields Rate - Base Hourly (BHRT) and Rate - Hourly (SHRT) so that they have exactly the same number of data display decimal digits.
mnAddressNumber	AN8	MATH_NUMERIC	NONE	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
jdDateEffectiveOn	EFTO	JDEDATE	OPT	NONE
A future date when all changes will take effect or the date when the changes went into effect. If you do not enter a date in this field, the system uses the current date as the effective date.
szChangeReason	TRS	char	OPT	NONE
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.
mnCompaRatio	CMPA	MATH_NUMERIC	OPT	NONE
A calculation used to compare an employee's salary/wage against a midpoint amount set up within a pay grade or salary range.