Overview of US Employee Entry (P0801)

Purpose
Scope
Details
 Overview of Employee Record Entry
 Methods of Employee Record Entry
 Understanding Employee Information
 Record Reservation
 Employee Information (P0801)
 Setting Processing Options for Employee Information (P0801)
 Entering Employee Information - Employee (P0801EMP)
 Address Book Revisions
 Entering Employee Information - Personal
 Employee Organizational Assignments (P0801ORG)
 Setting Processing Options for Employee Organizational Assignments (P0801ORG)
 Entering Organizational Assignment Information (P0801ORG)
 Employee Basic Compensation (P0801CMP)
 Setting Processing Options for Basic Compensation (P0801CMP)
 Entering Basic Compensation Information (P0801CMP)
 Country-Specific (US) Employee Information
 Entering Country-Specific Information for U.S. Employees
 Employee History Information (Change Reason)
 Employee Tax Withholdings and Overrides
 Entering Tax Withholding and Overrides Information
 User-Defined Information for Employees/Jobs (Category Codes)
 Deleting Employee Records

Purpose

This document provides an overview of adding a US Employee using the Employee Information application (P0801). This document provides information on the series of forms that automatically display when adding a new employee record and addresses some specific scenarios that may be needed for some employees.

Scope

This document is intended for EnterpriseOne users who are setting up the Human Resources module for use within their organization.

Details

Overview of Employee Record Entry

Methods of Employee Record Entry

When you hire an employee, you must add an employee record that contains personal, company, job, and pay information for the employee. The information in the employee record can be used to analyze and report on your employees and to meet government reporting requirements. You can add employee records to the database using either of two methods:

This table describes the similarities and differences between the methods:

Method Comparison

Adding employee records one at a time

This method displays a series of forms that you need to complete to hire an employee. This method is preferable if you hire individuals with very diverse employee information so that hiring in groups is not applicable. You can use this method to add new employee and terminated employee (rehire) records to table Employee Master Information (F060116).

Adding multiple employee records

This method uses the Employee Quick Hire program (P060116Q). It saves data entry time because you add records in groups based on similar job information. You can use this method to add new employee, terminated employee (rehire), and applicant records to the F060116 table

Note: This document only covers the steps for adding employees one at a time.

Understanding Employee Information

Basic employee information includes general identification information about the employee. You need this information to include the employee in payroll processing. When you create a record for a new employee, the system stores information for the employee in the following tables:

Note: When you add a new employee record to the database, you complete a series of forms. As you complete each form, the next form appears. You can use the Back button to return to a previous form, where you can review or change information before saving the employee's record. The system saves the new record only after you complete the entire sequence of forms.

After you create a record of employee information, you can:

Record Reservation

Before adding employees it is important to understand record reservation. This is an optional functionality in JD Edwards EnterpriseOne Human Resources that prevents loss of data when two users simultaneously attempt to update the same record in the database. When you activate record reservation for a particular program, only one user at a time can access a record in the table that the program uses for data storage. For example, assume that record reservation has been activated for the employee master group of programs (P0801). User 1 is updating salary information for an employee in the Employee Basic Compensation program (P0801CMP). At the same time, User 2 opens the Basic Compensation program and attempts to access the same employee record. User 2 receives an error message indicating that the employee record is reserved. The system prevents User 2 from gaining access to the record. The record remains reserved until User 1 saves any changes and closes the program.

Two significant limitations to record reservation exist. First, it can only be used for the following programs:

And second, if you activate record reservation for any of the programs in the employee master group, it is activated for all the programs.

Employee Information (P0801)

Setting Processing Options for Employee Information (P0801)

Before adding an employee you should review the processing options for each program in this series of tasks. They define how much information you must enter. For example, processing options for organizational assignments define whether the Job Information table (F08001) supplies default job information when you add or change employee information. In the JD Edwards EnterpriseOne Address Book system, review the processing options for the Address Book Revisions program (P01012) to ensure that the tax ID is set to appear.Setting Processing Options for Employee Master (P0801)

Processing options enable you to specify the default processing for programs and reports.

Defaults Tab - Use these processing options to define the defaults for the Security Business Unit, Tax Area (Residence) and Tax Area (Work) fields.

1. Security Business Unit - Specify whether the system updates the Address Book record for the employee with the security business unit that you enter on the Employee form (P0801EMP). Values are:

2. Tax Area - Specify whether the Tax Area (Residence) and Tax Area (Work) fields are required fields when you add or change an employee record. The JD Edwards EnterpriseOne Payroll system uses the tax area fields to calculate payroll taxes for employees. Values are:

Versions Tab - Use these processing options to define the versions that the system uses for Organizational Assignment, Basic Compensation, and Address Book Revision forms.

  1. Organizational Assignment Version - Specify the version of the program that you want to use when you add or change information on the Organizational Assignment form (P0801ORG). If you leave this processing option blank, the system enters the default version, ZJDE0001. When you define a version for Organizational Assignment, you can set processing options that control the type of default job information that you want the system to use on the Organizational Assignment form (P0801ORG) when you add or change an employee record.
  2. Basic Compensation Version - Specify the version of the program that you want to use when you add or change information on the Basic Compensation form (P0801CMP). If you leave this processing option blank, the system enters the default version, ZJDE0001. When you define a version for Basic Compensation, you can set processing options that control information that the system needs when you have activated the salary change workflow process.
  3. Address Book Version - Specify the version of the Address Book program (P01012) that the system uses when you add or change information on the Address Book Revision form. If you leave this processing option blank, the system uses the default version, ZJDE0002. When you define a version of the Address Book program, you can set processing options that control how the application functions. For example, you can specify whether the form displays the Tax ID field.

Termination Tab - Use these processing options to define default codes that are supplied to various records when an employee is terminated.

  1. Candidate Req Status (candidate requisition status) - Specify a code from UDC 08/CN to indicate the candidate requisition status that you use to indicate that an employee record is no longer attached to a requisition. This candidate requisition status must have DET entered in the special handling code field. When you terminate an employee, the system uses the code that you define in this processing option to update the candidate requisition status for all of the requisitions that the employee filled.
  2. Requisition Status - Use this processing option only if you have set up the System Options program (P05001S) to automatically create a new requisition when an employee is terminated. Specify a code from UDC 08/RS to indicate the requisition status that you want to assign to the new requisition. If you leave this processing option blank, the system does not create a new requisition when you terminate an employee.
  3. Organizational Structure Type - Specify a code from UDC 01/TS to indicate the organizational structure type that you use to indicate the parent/child relationship between terminated employees and their supervisors. The system uses the termination date to update the parent/child relationship. If you leave this processing option blank, the system does not update the parent/child relationship between the terminated employee and the supervisor.
  4. Applicant Status - Specify a code from UDC 08/AS to indicate the applicant status that you want to assign to terminated employees who will be returned to the applicant pool for future hiring considerations. If you leave this processing option blank, the system does not assign an applicant status to the terminated employee.

Entering Employee Information - Employee (P0801EMP)

In the Employee Information form the following fields can be completed:

Employee Information - Employee

The system uses the value in the Description-2 field on user-defined codes to indicate the number of pay periods per year and is used to calculate the amount per pay period for a salaried employee.

Note: For the calculation tables in the JD Edwards EnterpriseOne Payroll system and the eligibility tables and date codes in the JD Edwards EnterpriseOne Human Resources system, the system also uses this date as a start date when it calculates deductions, benefits, and accruals.

Address Book Revisions

After you enter basic employee information, you must enter address book information. When you enter an address book record for an employee, the system automatically enters an E (employee) in the Search Type field. If you are entering a record for a subcontractor, you must manually enter an S in that field.

Address Book Revisions

Note:

If you are using Effective Date processing the Effective Date field will display on the Mailing Address Revisions Tab as shown below. This functionality allows the user to change an employee mailing address in a future date and/or change it back. Example: The employee would like his W-2 sent to a different mailing address.

Mailing Address Effective Date

Entering Employee Information - Personal

After you complete the Address form, you must enter employee personal information. Personal information includes items such as marital status, gender, and birth date. Use this information to track employee-specific information for reporting and analysis. When you need to update employee personal information that has already been entered, you can use the Employee Information program (P0801) on the Employee Management menu (G05BE1) to select an employee, select Personal from the Row menu, and enter changes. If your organization uses JD Edwards EnterpriseOne self-service software, employees can also enter their own changes.

Employee Information - Personal

Note: The JD Edwards EnterpriseOne Address Book system uses the country code for data selection and address formatting.

Employee Organizational Assignments (P0801ORG)

After you complete the Personal form, you must enter organizational assignment information. Organizational assignment information includes detailed information about the employee's work assignment, such as job type, job step, home business unit, performance appraisal types and dates, and employee competency levels. When you want to review job history for values on this form, first place the cursor in the desired field and then select the Job Hist. Tracking (form exit menu option). To review history for other values on this form that you might be tracking, place the cursor in the desired field and then select the History Tracking (form exit menu option). Use the Work With History Data Items (P08041) to set up the historical information data values that you want to track.

If you are using the Performance Appraisal module in the JD Edwards EnterpriseOne Human Resources system to create employee appraisals, the system automatically updates the Last Review Type and Last Review Date fields on the Organizational Assignment form when an appraisal is completed. You can then review the employee's appraisal directly from the Work With Organizational Assignment form using the Performance Appraisal (row exit menu option). For example, if a dispute arose about the level of an employee's salary, a human resource administrator could easily review the employee's record, and also access the employee's performance appraisal directly, to ensure that all necessary information is taken into account. If no appraisals have been created for the employee, the Performance Appraisal option is disabled.

You can also review current and historical performance appraisals that were completed by a specified supervisor. On the Work With Organizational Assignments form, you choose an employee who is assigned to the specified supervisor, and then select the Performance Appraisal (row exit menu option). You can select any employee who is associated with that supervisor, regardless of whether that employee has a completed performance appraisal. For example, human resource administrators might need to verify whether a supervisor has completed all of the performance appraisals for the department. Using this option, you can review all completed appraisals, or all appraisals that have not yet been completed by a specified supervisor.

Setting Processing Options for Employee Organizational Assignments (P0801ORG)

Defaults Tab - Use these processing options to determine what default job-related information the system uses to fill in the employee master information record when you add or change the job type for an employee. The program uses default information from the Job Information table (F08001) and the Business Unit / Job ID. X-Ref table (F08005), depending on which combination of processing options is set.

The Job Information Add and Job Information Change processing options use data in the F08001 table unless the Business Unit/Job ID Information processing options are set to 1 (default). When the Business Unit/Job ID Information Add and Business Unit/Job ID Information Change processing options are set to 1 and there is a matching business unit / job type record in the F08005 table, the union code, benefit group, and workers compensation information comes from the F08005 table. All other data comes from the F08001 table. If there is no matching business unit/job type record in the F08005 table, all data comes from the F08001 table.

The Job Category Add and Job Category Change processing options use data in the F08001 table if a matching job type/step record exists in that table. If no matching record exists, no data is used and no data is retrieved for the Job Information Add and Job Information Change processing options.

The Job Default Window processing options specify the setting that the system uses to automatically provide information from the F08001 table for the Job Default Window program (P08JD). The system displays the Job Default Window only when you are entering a new employee into the system.

1. Job Information Add - Specify whether the system enters default job information into the employee record when you specify a job type for a new employee. The application uses the following as default data: pay frequency, union code, EEO job category code, pay class, pay grade, overtime exempt, pay grade step, benefit group, workers compensation, and subclass. Values are:

Note:

- Job Information Add 0: use the Job Entry and Evaluation (P08001) value for Overtime Exempt Y/N
- Job Information Add 1: if Data Dictionary FLSA default is Y or N use the Data Dictionary default value for Overtime Exempt Y/N. If Data Dictionary FLSA default is blank use the Job Entry and Evaluation (P08001) value for Overtime Exempt Y/N

2. Job Information Change - Specify whether the system populates the employee record with default job information when you change a job type for an existing employee. The application uses the following as default data: pay frequency, union code, EEO job category code, pay class, pay grade, overtime exempt, pay grade step, benefit group, workers compensation, and sub class. Values are:

3. Job Default Window - Specify which of the radio buttons, in the Job Default Window, will be selected when first entering the window. Values are:

4. Job Category Add - Specify whether the system populates the employee record with default job category codes when you specify a job type for a new employee. The application checks the F08001 table to see if the user-selected job type/step exists. If it does, the application uses any payroll category codes (10 in all) associated with the job type/step in the Employee/Job Category Codes form. Values are:

5. Job Category Change - Specify whether the system populates the employee record with default job category codes when you change a job type for an existing employee. The application checks the F08001 table to see if the user-selected job type/step exists. If it does, the application will use any payroll Category Codes (10 in all) associated with the job type/step in the Employee/Job Category Codes form. Values are:

6. Business Unit/Job ID Information Add - Specify whether the system populates the employee record with the default business unit/job information cross-reference when you specify a job type for a new employee. The application uses the union code, workers compensation, and benefit group from the F08005 table. Values are:

Note: Only union code appears on this application. The remaining two are used in the Employee Master table

7. Business Unit/Job ID Information Change - Specify whether the system populates the employee record with the default business unit/job information cross-reference when you change a job type for an existing employee. The application uses the union code, workers compensation, and benefit group from the F08005 table. Values are:

Versions Tab - Use these processing options to specify the program version that the system uses for Resource Competency Information (P05100), Competencies Gap Analysis (P08008), and Employee Performance Appraisals (P087712). If a custom version does not exist and you do not enter the version number, the system uses the default version of each program.

  1. Resource Competency Information Version - Specify the version of the Resource Competency Information program (P05100) that the system uses. If you leave this processing option blank, the system uses the default version, ZJDE0002. When you define a version of the Resource Competency Information program, you can use a processing option to specify the Competency Update Event Code.
  2. Gap Analysis Version - Specify the version of the Competencies Gap Analysis program (P08008) that the system uses. If you leave this processing option blank, the system uses the default version, ZJDE0003. When you define a version of the Competencies Gap Analysis program, you can set processing options to specify the audience and a default version of the Job Competencies In An Organization program (P08006).
  3. Performance Appraisal Version - Specify the version of the Employee Performance Appraisals program (P087712) that the system uses. If you leave this processing option blank, the system uses the default version, ZJDE0006. When you define a program version of the Employee Performance Appraisals program, you can set processing options that control various aspects of the program.

Entering Organizational Assignment Information (P0801ORG)

Use this form to enter Organizational Assignment Information, such as supervisor, team, position id., etc.

Employee Information - Organization Assignment

For example, you can identify position A0-1 as Accounting Manager for fiscal year 2007-2008, for home business unit 41. You might choose to set up positions so that the position IDs are the same as the corresponding job IDs. Within a home business unit, positions appear in the alphanumeric sequence of their position IDs. For example, position A0-1 appears before position A0-2.

Note:

If the Job Default Window form appears, review the information on this form, make any necessary changes, and then click OK.

Employee Basic Compensation (P0801CMP)

After you complete the Organizational Assignment form and/or Job Default Window, you must enter compensation information. Basic compensation information includes pay information, such as salary, hourly rate, pay class, and pay grade. When you want to update compensation information that has already been entered, you can select the Basic Compensation program (P0801CMP) from the Employee Management menu (G05BE1), locate the employee whose record you need to change, and then select Basic Compensation from the Row menu. When you want to review job history for values on this form, first place the cursor in the desired field and then select the Job Hist. Tracking menu option. To review history for other values on this form that you might be tracking, place the cursor in the desired field and then select the History Tracking menu option. To track historical information, you must first set up the values that you want to track.

Setting Processing Options for Basic Compensation (P0801CMP)

Process Tab - Use these processing options to specify whether the system sends a workflow message when a salary change exceeds the specified amount or percentage. When the threshold is exceeded, the system activates the Employee Salary Change Approval process (EEMAST1) in workflow. The system updates the new salary change only after the workflow request is approved.

  1. Workflow - Salary Threshold - Specify an amount that, if the salary is increased by the amount entered or increased by more than the amount entered, then the system initiates the Employee Salary Change Approval Process (EEMAST1) workflow. The system sends an approval message to the workflow recipient, and the salary is updated after the change is approved.
  2. Workflow - Salary Percent Change Threshold - Specify the percentage of salary increase at which the system starts the Change Approval Workflow Process (EEMAST1). When the salary is increased to or beyond the percent entered, the system starts the workflow process. The system sends an approval message to the workflow recipient and the salary is updated only after the change is approved.

Once EEMAST1 workflow is activated and the P0801CMP processing option set and if the change is over the Threshold the compensation change the P0801CMP will give a pop-up:
Workflow Pending Review Notification, Your changes have been submitted for approval and are pending review.

The EEMAST1 is hard-coded to send the approval to address number 7500. If the User ID profile is setup for this address number then the user can access the Work Center for queue Salary Approved - Salary Approval there is a drop-down in the Message Text to launch Workflow Approval.jde. If you require the approval to go to a different address number the EEMAST1 would need to be customized in Workflow Modeler for the GETAPPROVL recipient rules.

Entering Basic Compensation Information (P0801CMP)

Use this form to enter compensation information for the employee, such as, pay class, salary/hourly rate, etc.

Basic Compensatio

Note: Some of the information displayed in this form defaults in from entries made on prior forms.

Note: Pay Rate Source is not editable since it comes from HR constants (F08040) which is accessed from System Options - HRM Foundation Position Control Options P05001S.

Setting the Pay Rate Source to 1 in constants does not automatically update existing employee rates. Even if their job type or step is changed the rate will not be automatically recalculated. There are only 2 options of existing employee's:

1. To change per individual employee you can launch Basic Compensation and blank out the Salary or Hourly Rate and then click OK. The Salary and Hourly Rate will come from the Union Pay Rates (F069126). There is a reconfirm warning. To commit this change then click the OK button again.

2. Another option is to run the Synchronize Employee Master with Union Rates (R059122). There are 3 versions to meet your needs of proof/final for changes only or to recalculate all rates.

Note: If you change the number of the data display decimal digits for this field, you must also change Rate - Base Hourly field (BHRT) and the Rate - Hourly field (SHRT) so that they have exactly the same number of data display decimal digits.
Note: When you enter a value in this field, the value that you enter overrides the default value from the Pay Grade Step table.

To review pay history information, click in the Pay Grade or Grade Step field and then select Job and Pay History from the Form menu. Selecting the Job and Pay History option displays the Job and Pay History Window form. The Job and Pay History Window form uses information from the Employee Master Information table (F060116) and the Employee Jobs History File table (F060119).

To review human resources history information, click in any field except Job Type/Step and then select History Tracking from the Form menu. Choosing the History Tracking options displays the History Window form. The History Window form uses information from Employee Master Information table (F060116) and the HR History table (F08042). The data that the system displays might be different, depending on whether the system option for history tracking is enabled.

Country-Specific (US) Employee Information


After you complete the Basic Compensation form, you must enter country-specific information. When you enter country-specific information, the system displays fields for only the information that applies to the country code that you entered for the employee. Many of these fields are user-defined fields that you can customize to meet the specific needs of your organization. Country-specific information includes information that is required only in the country in which the employee works.

Entering Country-Specific Information for U.S. Employees

Note: If you use the GeoCoder, the system uses the employee address information to determine the GeoCode for the Tax Area (Residence) field, and uses the GeoCode from the employee's home business unit as the GeoCode for the Tax Area (Work) field. The system automatically populates these fields if there is only one possible GeoCode available for the field.

National - Fiscal Data US

Employee History Information (Change Reason)

After you complete the preceding form, you can enter employee history information. You enter this information only if the system is set up to track employee history. You can set up the system to track employee history when you enter a record for a new employee or change existing employee information. You specify the data items for which you want to track history. Then, each time you change the information in those data items, the system updates the HR History table (F08042). When you need to access the History Window form after the initial hiring process, you can select the Employee Information program (P0801) from the Employee Management menu (G05BE1), and then select an employee record. Then, from the Employee form, you can select History Tracking from the Form menu.

Change Reason

Employee Tax Withholdings and Overrides

After you complete the Change Reason form, you can enter tax withholding and override information for a new employee or change existing employee information. When you need to change tax withholding and override information that has already been entered, you can select Employee Tax Overrides - USA from the Employee Management menu (G05BE1). You enter tax withholding and override information to indicate the number and type of exemptions that employees claim on their withholding allowance forms. Quantum for Payroll Tax, the tax calculation system that integrates with the JD Edwards EnterpriseOne Payroll system, uses this information to calculate employees' taxes each pay period. The system provides the tax area and tax type for federal income tax (tax type A) with no exemptions and no override withholding amount. If the employee has any exemptions, you must enter the number of exemptions. The system uses the number of federal exemptions to calculate all taxes unless you enter separate override records for state and local taxes.

Note: Although Oracle does not provide tax advice, this section does provide users with information about how to enter tax information into the system. This document is not intended to provide users with information about which values to enter for an employee. For specific information about the values to enter for employee tax overrides, refer to the Quantum Calculation Guide for State/Local Reciprocity, or contact your local taxing authorities.

Entering Tax Withholding and Overrides Information

The first record in the detail area is the Federal A tax type. Use it to specify tax exemptions and overrides for federal income tax. The system uses exemptions that you enter into this record for all state and local authorities for which there is no specific entry lower in the detail area. However, the override amounts do not carry forward.

Employee Tax Overrides

Note:

User-Defined Information for Employees/Jobs (Category Codes)

After you add an employee record, you can enter additional information for the employee that is unique to your organization or industry. You can use this information for reporting and analysis purposes.

You use the Work With Employee Information form to access category codes 11-20 and user-defined dates 11-20. Select an employee record on the Work With Employee Information form and then select User Def.Cat 1-10 from the Row menu or select User Def Dates 01–10 from the Row menu. User defined category codes are setup via the appropriate user defined tables. For example, Category Code 11 would be defined in UDC table 06/11. (This information can be found in the visual assist for the applicable field). A user-defined date is a field that can hold a date which is not already defined in the Payroll system. For example, if your organization needs to track the date when an employee received a particular certification or license, you can set up this user-defined date field to track that date information. The descriptions for the user defined dates are changed via the Work With Data Dictionary Items - Work With Data Items (P92001), and may require another level of permissions in the system.

User Defined codes 11-20

User Defined Dates 11-20


You use the Organization Assignment form(P0801ORG) to access category codes 01-10 and user-defined dates 01-10.
Select an employee record on the Work With Organizational Assignments form and then select User Def Cat 01–10 from the Form menu. Enter user-defined information for an employee. For user defined dates related to jobs (organization), select an employee record on the Work With Organizational Assignments form and then select User Def Dates 01–10 from the Form menu. These category codes and user defined dates are set up the same way as described above for codes 11-20 and dates 11-20. The Job Type category codes 01-10 defaults are controlled by the P0801ORG processing options on the Defaults tab.

User Defined Codes 1-10

User Defined Dated 1-10

Deleting Employee Records

Due to record retention requirements, employees are rarely deleted. However, if you complete the process (proceed through all the forms) and then decide you want to delete; the employee must be deleted from the Address Book Module (P01012), as well. If the employee has transaction history, the system will not allow a deletion.