Functional Description
Purpose
The purpose of this business function is to synchronize the compensation review work tables with
employee changes. Eligibility for increase types is re-tested when needed. The information in the
compensation review work tables are kept current with the employee master information, and supervisors are
able to make increase recommendation based on real time employee information.
This business function is automatically called by the Employee Master Trigger, if a system option
indicates that Compensation Review Process is currently opened to the supervisors.
Setup Notes and Prerequisites
Special Logic
Technical Specifications
If an employee's record is found with no supervisor in F08830WF do not update record, it is a bogus
record to signify that the last level supervisor has submitted
their comp review.
Fetch employee data from F060116 and F060120 to see what information has changed
Employee is terminated, send e-mail to the first level manager
When an employee is terminated their F08830WF record(s) are updated with a Model
Type Code = 'T'
Change made other than termination, send e-mail to first level supervisor
Check for a change and set flag for each data item that has changed. The data Items are as follows:
PAST - Employee Pay Status
CO - Company
HMCU - Cost Center Home
JBCD - Job Category
JBST - Job Step
CPDT - Date in Current Position
UN - Union Code
POS - Position
SAL - Salary
SLOC - Locality
SALY - Pay Type HSP
PGRD - Pay Grade
PGST - Pay Grades Step
DR - Date Last Raise
CMPA - Compa Ratio
CDIJ - Date Current
Write existing records to cache for both f08830wf and f08831wf and delete records from both work
files.
Call NER to re-write the employee's records to the work files for the current
model name.
ProcessAllEmployeeIncreaseType
Writekey key data from cache to new record in F08830wf
If the salary has changed the new annual salary will be recalculated from the
increase amounts based on the current salary. If there is no salary change
then the new salary comes from cache
Get records from F08831wf cache to update the records in the work file
Check to see if the increase amount if outside of the guidelines if so set flag INCRO in F08831WF = 1
Get the increase %, prorate amt, and prorate %, if the salary has been changed
and there is an increase amount in cache by calling
Process Increase Amount/ Percentage
Calculate the new annualized salary
Update F08831WF
Check to see if the new salary is outside of the guidelines if so set flag NSOR for F08830WF = 1
Calculate the New Hourly Rate, and New Compa Ratio
Update F08830WF
Delete the Cache
If no record exists in F08830WF for this employee, create one
Get employee info from F060116 and F060120
Get supervisors name
call function ProcessAllEmployeeIncreaseType to write records to the work files
D0800180A - Sync Compensation Review Work Tables with Employee Changes
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| 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
| ||||
| szProgramId | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
| None |
| None |