Functional Description
Insert or update an existing Employee Master (F060116) record with information provided from
Applicant.
Purpose
The function is intended to be used from the Applicant Hire (P084H) application. It will only write
information to the fields if the information is available from the applicant master, requisition, and
job master.
Setup Notes and Prerequisites
Special Logic
Technical Specification
Set the parameter for change reason code to 001 for new hires if it does not already contain a value.
Set the parameter for effective date to the current date if if does not already contain a value.
See if a record exists in the employee master for the address number that was passed in. If one does
not, then set a local flag variable to 1 (one) to indicate inserting is required.
If the parameter specifing if job information should be used is set to 1 (one) then
Read the Job Information (F08001) using the values from
the job type and job type step parameters.
If a record doesn't exist in F08001 then
Set the use job info flag to 1 (one).
else
Set the FLSA parameter to the value
from the F08001 record.
end if
end if
If the parameter stating to use job info = 1 (one) and the
parameter stating to use pay info is not equal 1 (one)then
Update parameters that would normally contain pay info
with pay info from the job information (F08001) record.
end if
If insert/update flag is 1 then
Call the program to disable history triggers.
Insert record into F060116 address number and tax id
only populated.
Write history record for address number.
Write history record for tax id.
Call the program to enable history triggers.
Fetch the new record to establish before image values.
End if
Call the program Write Additional Information to Cache
Update record in F060116 with appropriate job and/or pay fields populated.
^
D0800096 - F060116 Update/Insert from Applicant Hire
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber_AN8 | 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
| ||||
szNameAlpha_ALPH | ALPH | char | REQ | INPUT |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
szSocialSecurityNumber_SSN | SSN | char | REQ | INPUT |
A number that indicates the tax ID. In the United States, the tax ID is the social security number. In Canada, it is the social insurance number.
| ||||
cSexMaleFemale_SEX | SEX | char | REQ | INPUT |
Valid codes are: M Male F Female | ||||
szCompanyHome_HMCO | HMCO | char | REQ | INPUT |
The company number where the employee records generally reside. | ||||
szCostCenter_MCU | MCU | char | REQ | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szCostCenterHome_HMCU | HMCU | char | REQ | INPUT |
The number of the business unit in which the employee generally resides. | ||||
cEmployeePayStatus_PAST | PAST | char | REQ | INPUT |
The code used to indicate whether an employee's pay status is active or inactive. Codes for active pay status employees are numeric,
| ||||
szJobCategory_JBCD | JBCD | char | REQ | INPUT |
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
| ||||
szJobStep_JBST | JBST | char | REQ | INPUT |
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
| ||||
szJobCategoryEeo_EEOJ | EEOJ | char | REQ | INPUT |
A user defined code (07/J) that specifies classifications established by the U.S. Equal Employment Opportunity Commission (EEOC) or the
| ||||
jdDateBirth_DOB | DOB | JDEDATE | REQ | INPUT |
The employee's date of birth. | ||||
jdDateOriginalEmployment_DSI | DSI | JDEDATE | OPT | NONE |
The date on which the employee was originally hired by the company. If the employee was terminated and subsequently rehired, the new
| ||||
jdDateEmploymentStart_DST | DST | JDEDATE | REQ | INPUT |
The date on which the employee actually reported to work for the most recent period of hire. When an employee initially begins working,
| ||||
jdDatePayStarts_PSDT | PSDT | JDEDATE | REQ | INPUT |
The date that an employee may begin participating in the company's benefit plans or may be included in payroll processing.
You can also
| ||||
szCountryForPayroll_CCPR | CCPR | char | REQ | INPUT |
A user defined code list 00/CN that indicates the country in which the employee resides. | ||||
cI9Status_HM01 | HM01 | char | REQ | INPUT |
A code indicating the method used to verify that this employee is eligible to work in the United States. Valid codes are:
Y I9 form on file
P
| ||||
cVeteran_HM02 | HM02 | char | REQ | INPUT |
A code that indicates the veteran status of the employee for EEO reporting purposes. Valid values are:
N
This employee is not a
| ||||
cDisabledVeteran_HM03 | HM03 | char | REQ | INPUT |
A code indicating whether this employee is a disabled veteran. Valid codes are:
Y
Yes, this employee is a disabled veteran.
N
No, this
| ||||
cHandicapped_HM04 | HM04 | char | REQ | INPUT |
A code indicating whether this employee has a mental or physical disability. Valid codes are:
Y
Yes, this employee has a mental or
| ||||
szPositionID_POS | POS | char | REQ | INPUT |
A code that you use for budgetary (position) control purposes. The position ID consists of:
o Position (position code and its description)
| ||||
szWorkStationId_JOBN | JOBN | char | REQ | INPUT |
The code that identifies the work station ID that executed a particular job. | ||||
szUserId_USER | USER | char | REQ | INPUT |
The code that identifies a user profile. | ||||
szProgramId_PID | PID | char | REQ | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated_UPMJ | UPMJ | JDEDATE | REQ | INPUT |
The date that specifies the last update to the file record. | ||||
szMinorityEeo_EEOM | EEOM | char | REQ | INPUT |
A user defined code (07/M) that designates minority classifications according to U.S. Equal Employment Opportunity Commission (EEOC)
| ||||
cUpdatePayInfo_VC01A | VC01A | char | REQ | INPUT |
A single character flag specifying if pay type, FLSA, pay grade, and pay grade step information
| ||||
cPayTypeHSP_SALY | SALY | char | OPT | NONE |
A code that specifies how an employee is paid. Valid codes are: H Hourly S Salaried P Piecework | ||||
cFlsaExemptYN_FLSA | FLSA | char | OPT | NONE |
A code that indicates whether the employee fits the rules of the Fair Labor Standards Act (FLSA) and thus does not have to be paid for
| ||||
szPayGrade_PGRD | PGRD | char | OPT | NONE |
A code that designates a category for grouping employees according to pay ranges. For each pay grade, you enter a pay range that
| ||||
szPayGradeStep_PGRS | PGRS | char | OPT | NONE |
A code that identifies a pay grade and pay step. You can use this code to determine an employee's pay rate.
If you have set up your
| ||||
cUpdateJobInfo_VC01A | VC01A | char | REQ | INPUT |
A single character flag specifying if job information should be inserted/updated into the employee
| ||||
szChangeReason_TRS | 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
| ||||
jdDateEffectiveOn_EFTO | 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
| ||||
szSalaryDataLocality | SLOC | char | OPT | NONE |
A user defined code (07/SL) that defines the different salary localities within an organization. For example, you can compare salaries for
|
None |
None |