C JD Edwards EnterpriseOne Human Capital Management Foundation Reports

This appendix contains the following topics:

This appendix allows you to view:

  • Human Capital Management Foundation Reports: A to Z.

  • Selected Human Capital Management Fundamentals Reports.

C.1 Human Capital Management Foundation Reports: A to Z

This table lists the JD Edwards EnterpriseOne Human Capital Management Foundation reports, sorted numerically by report ID.

Report ID and Report Name Description Navigation
R051450

Job Evaluation Factor Data

Use this report to review the evaluation method, factors, points, and degrees assigned to each job. Use this information to compare the job evaluations for similar jobs and to determine whether the reporting structure of the jobs accurately reflects their evaluations. Job Specifications (G05BJ1), Job Evaluation Factor Data
R052001

Employees Above/Below Pay Grade

Use this report to review employees paid above the maximum amount for their pay grade or below the minimum amount for their pay grade. Job Specifications (G05BJ1), Employees Above/Below Pay Grade
R052202

Upcoming Reviews

Use this report to report employees who have upcoming reviews by supervisor. Pay Grade Step Administration (G05BJ2), Upcoming Reviews
R052450

Pay Ranges by Job Report

Use this report to review the pay ranges defined for each job. Job Specifications (G05BJ1), Pay Ranges by Job Report
R064011

Employee Roster

Use this report to view all employees or selected groups of employees entered in the JD Edwards EnterpriseOne Payroll system. Employee Management (G05BE1), Employee Roster
R064011D

Point in Time Employee Roster

Use this report to review all or selected groups of employees, as of a specific date, that are entered in the JD Edwards EnterpriseOne Payroll system. Point in Time Employee Master (G05B31), Point in Time Employee Roster
R064021

Employee Roster with Rate

Use this report to view information from the Employee Roster report, combined with information such as:
  • Salary amounts.

  • Work and residence tax areas.

  • Employment status.

  • Person who last changed the payroll data and the date that the change occurred.

Employee Management (G05BE1), Employee Roster with Rate
R064021D

Point in Time Employee Roster with Rate

Use this report to view the same information as in the Employee Roster with Rate report, but as of a specific date. Point in Time Employee Master (G05B31), Point in Time Employee Roster with Rate
R08001

Job Data & Evaluation Points

Use this report to review job information with evaluation information such as evaluation method, evaluation date, and evaluation points. Job Specifications (G05BJ1), Job Data & Evaluation Points
R080012

Evaluation Factors Table

Use this report after you set up the evaluation methods for evaluating jobs to review the evaluation methods that you defined. The information printed on the report is identical to the information in the Job Evaluation - Compensable Factors Table (F08011). Job Specifications Setup (G05BJ4), Evaluation Factors Table Report
R080400

Employee Data by Data Type Report

Use this report to review all employees who have information in a particular supplemental data type category, such as language skills. Employee Supplemental Data (G05BSDE1), Employee Data by Data Type Report
R080402

Job Data by Data Type

Use this report to review all jobs by a specified data item. For example, you can inquire on the Hazardous Materials Handling data item to identify all jobs that have this training as a requirement. Job Supplemental Data (G05BSDJ1), Job Data by Data Type Report
R080410

Employee Supplemental Data Report

Use this report to view an employee's supplemental data in an easy-to-read, resume-style format. Employee Supplemental Data (G05BSDE1), Employee Supplemental Data Report
R080412

Job Supplemental Data Report

Use this report to review all jobs that have information for all data items. Job Supplemental Data (G05BSDJ1), Job Supplemental Data Report
R080423

Employee History Log

Use this report to review history for either a single data item or for all data items that you are tracking for each employee. Employee History (G05BH1), Employee History Log
R080424A

Employee Salary History Analysis

Use this report to review changes to the primary job salary within the date range that you define. Employee History (G05BH1), Employee Salary History Analysis
R080430

Employee Turnover Report

Use this report to create turnover reports based on Company, Business Unit, Check Route code, and Job Type. Employee History (G05BH1), Employee Turnover Report
R080431

Employee Activity Analysis

Use this report to review employee turnover by the dates and data item that you define in your processing options. Employee History (G05BH1), Employee Activity Analysis
R083495

Update EE Master Age As Of

Use this report to update the employee age in the Employee Age field and the age of the employee's spouse in the Spouse Age field on the Personal form in the Employee Master program (P0801). Employee Adv & Technical Operations (G05BE3), Update EE Master Age As Of

C.2 Selected Human Capital Management Fundamentals Reports

Some reports include a more detailed description, as well as information about processing options. These reports are listed numerically by report ID in this appendix.

C.2.1 R052001-Employees Above/Below Pay Grade

Run the Employees Above/Below Pay Grade Max/Min report (R052001) to review employees paid above the maximum amount for their pay grade or below the minimum amount for their pay grade.

C.2.2 Processing Options for Employees Above/Below Pay Grade (R052001)

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

C.2.2.1 Title Display

1) Report Title Display:

Specify the text that the system displays in the report title. Values are:

Blank: Employees Above Pay Grade Maximum

1: Employees Below Pay Grade Minimum

C.2.3 R052202 - Upcoming Reviews

Upcoming Reviews is a batch program (R052202) to report employees who have upcoming reviews by supervisor. The system displays each employee with the dates of next review and type of review. You can set up processing options to determine whether this report runs automatically on a specified date to activate Workflow, and to allow the system to update the Upcoming Reviews by Supervisor program (P052200) on the self-service website. If workflow is activated, the system sends reminder messages to each supervisor about pending reviews.

You also set a processing option to determine which of the three versions you want to run. A version exists that reports on overdue reviews and a version that reports on all employees with upcoming reviews without specified review dates. Neither of these versions starts workflow.

C.2.4 Processing Options for Upcoming Reviews (R052202)

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

C.2.4.1 Defaults

Use these processing options to select an employee for this report and to include the Uniform Resource Locator for supervisory review instructions.

1. Employee Number Display

Specify the employee number that you want to print on the report. Values are:

A: Address book number

S: Employee tax identification number

O: Other number

2. URL For Supervisor Review Instructions

Specify the uniform resource locator for the supervisor review instructions.

C.2.4.2 Process

Use these processing options to specify whether to run the Workflow Reminder Process and to define defaults that limit the report to specific parameters.

1. Workflow Reminder Process

Specify whether to run the workflow reminder process. Values are:

1: Run.

0: Do not run.

2. From Date

Specify whether to limit reviews. The review date must be greater than or equal to the from date.

3. Thru Date

Specify whether to limit reviews processed. The review date must be less than or equal to the thru date.

4. Days From Today

Specify a number in this processing option to process all new review dates that are less than or equal to the system date and the number of days entered into the processing option.

C.2.5 R052450 - Pay Ranges by Job Report

You can run the Pay Ranges by Job report to review the pay ranges defined for each job. The information that prints is the same information that displays in the Work With Pay Ranges By Job program (P052002).

C.2.6 Processing Options for Pay Ranges by Job (R052450)

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

C.2.6.1 Defaults

1. Enter a Pay Range - As of Date. Blank will use the system date.

Specify an as of date for the pay range. Leave this processing option blank to use the system date.

C.2.7 R064011 - Employee Roster

The Employee Roster report (R064011) lists all employees or selected groups of employees entered in the JD Edwards EnterpriseOne Payroll system. You run this report to verify that the following employee information has been entered correctly:

  • Home company.

  • Business unit.

  • Basic dates.

  • Group plan.

  • Workers compensation.

  • Federal and state tax exemption.

  • Job type and job step.

  • Pay status.

  • EEO status.

C.2.8 Processing Options for Employee Roster (R064011)

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

C.2.8.1 Address

Use these processing options to specify whether the system prints the address information and phone number and which phone number type to use.

1. Enter '1' to print address information

Specify whether to print the current address for each employee on the report. The address will appear just below each employee number. Values are:

Blank or 0: Do not print

1: Print

2. Enter '1' to print phone number

Specify whether to print a telephone number for each employee on the report. The phone number appears immediately below each employee number or each employee address. To indicate the type of phone number that the system prints, use this processing option in combination with Phone Number Type processing option. Values are:

Blank or 0: Do not print.

1: Print.

3. Phone Number Type

Specify the type of phone number that the system prints for all employees; use this processing option in combination with the Enter 1 to print phone number option. For example, to print the home telephone number for each employee, enter HOM. This code is defined in UDC 01/PH.

C.2.9 R064011D - Point in Time Employee Roster

After you review your data selection, use the Point-In-Time Employee Roster program (R064011D) to review all or selected groups of employees, as of a specific date, that are entered in the JD Edwards EnterpriseOne Payroll system. You can run this report to analyze employee information, prepare responses to governmental inquiries, or verify that this employee information has been entered correctly:

  • Home company.

  • Business unit.

  • Basic dates.

  • Group plan.

  • Workers' compensation.

  • Federal and state tax exemption.

  • Job type and job step.

  • Pay status.

  • EEO status.

C.2.10 Processing Options for Point in Time Employee Roster (R064011D)

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

C.2.10.1 Address

1. Enter '1' to print address information

Enter 1 to print employee address information on the report or leave this processing option blank of you do not want to print address information.

C.2.10.2 Point in Time

Effective Date

Enter a valid calendar date for the report.

Version Name

Enter the report number that you want to run.

C.2.11 R064021 - Employee Roster With Rate

The Employee Roster with Rate report (R064021) contains the same information as the Employee Roster report (R064011) plus this information:

  • Salary amounts.

  • Person who last changed the payroll data and the date that the change occurred.

  • Work and residence tax areas.

  • Employment status.

  • Termination/change status.

  • Contract employee information.

  • Earned income credit status.

  • Residence status.

  • Tax method.

  • Pay frequency and class.

C.2.12 Processing Options for Employee Roster with Rate (R064021)

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

C.2.12.1 Employee No

1. Enter 'A' to print Address Book number, 'S' for Social Security number or 'O' for Third number

Specify the employee information that the system prints on the report. Values are:

A: Address book number

S: Social security number

O: Third number

C.2.13 R064021D - Point in Time Employee Roster with Rate

After you review your data selection, use the Point-In-Time Employee Roster with Rate program (R064021D) to review all or selected groups of employees as of a specific date. This report is useful in preparing information in response to a governmental inquiry, analyzing employee information, and ensuring accurate data entry. In addition to the reporting parameters of the Point-In-Time Roster program (R064011D), this report contains this information:

  • Salary amounts.

  • Person who last changed the payroll data and the date that the change occurred.

  • Work and residence tax areas.

  • Employment status.

  • Termination/change status.

  • Contract employee information.

  • Earned income credit status.

  • Residence status.

  • Tax method.

  • Pay frequency and class.

  • FLSA (Fair Labor Standards Act) exemption status.

C.2.14 Processing Options for Point in Time Employee Roster with Rate (R064021D)

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

C.2.14.1 Employee No

1. Enter 'A' to print Address Book number, 'S' for Social Security number or 'O' for Third number

Specify the employee information that the system prints on the report. Values are:

A: Address book number

S: Social security number

O: Third number

C.2.14.2 Point in Time

Effective Date

Enter a valid calendar date for the report.

Version Name

Enter the report number that you want to run.

C.2.15 R080400 - Employee Data by Data Type

Run the Employee Report by Data Type program (R080400) to review all employees who have information in a particular supplemental data type category, such as language skills. The information that prints on this report is the same information that you can review online using the Supplemental Data program (P00092).

You can list employees alphabetically by last name or numerically by employee number.

This report includes a summary of data as it applies to certain employees from these tables:

  • Supplemental Database Data Type (F00091).

  • Supplemental Data (F00092).

  • Employee Master Information (F060116).

Before running this report, you must prepare data for point-in-time reporting.

See Preparing Data for Point-in-Time Reports

C.2.16 Processing Options for Employee Report By Data Type (R080400)

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

C.2.16.1 Narrative

1. Enter a '1' to bypass printing text information on the report. Default of blank will print the text.

Specify whether the system prints narrative text on the report. Values are:

Blank: Print.

1: Do not print.

C.2.17 R080410 - Employee Supplemental Data Report

Examples of how you can run reports to review employee supplemental information are:

  • As an individual employee summary.

  • As a summary of all your employees and their related profile data.

  • By supplemental data type.

To review complete supplemental information for one or more employees, run the Employee Supplemental Data Report program (R080410). This program compiles all of an employee's supplemental data into an easy-to-read, resume-style format.

The report includes a summary of data stored in these tables for each of the employees that you select:

  • HRM Supplemental Data Types (F08090).

  • Human Resources General Description-User Def Codes (F08092).

  • Human Resources General Description - Narration (F08093).

  • Employee Master Information (F060116).

The information that prints on this report is the same information that you can review on Employee Master (P0801).

You can list employees alphabetically by last name or numerically by employee number.

C.2.18 Processing Options for Employee Supplemental Data Report (R080410)

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

C.2.18.1 Processing

Use these processing options to specify whether the system prints certain types of information. Also use these processing options to specify default information regarding the designated printing form and printer settings.

1. Enter a '1' if you wish to bypass printing the Tax ID. (Default of blank will print the number.)

Specify whether to print the tax ID on the report. A default of blank automatically prints the tax ID. Values are:

Blank: Print

1: Do not print

2. Enter a '1' if you wish to bypass printing the Asking Salary. (Default of blank will print the number.)

Specify whether to print the asking salary. A default of blank automatically prints the asking salary. Values are:

Blank: Print

1: Do not print

3. Enter a '1' if you wish to bypass printing any extended narrative associated with the data.

Specify whether to print any extended narrative text that is associated with the data. A default of blank automatically prints any extended narrative text. Values are:

Blank: Print

1: Do not print

C.2.19 R080412 - Job Supplemental Data

The Job Profile Report (R080412) helps you to review all jobs that have information for all data items.

C.2.20 Processing Options for Job Profile Report (R080412)

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

C.2.20.1 Narrative

1. Enter a '1' to bypass printing text information on the report. Default of blank will print the text.

Specify whether the system prints text information on the report. Values are:

Blank: Print.

1: Do not print.

C.2.21 R080423 - Employee History Log

Run the Employee History Log report (R080423) to review history for either a single data item or for all data items that you are tracking for each employee. The information that prints on this report is the same information that you can review with the Employee History Inquiry program (P050242).

This report locates information from the Employee Master Information table (F060116) and the HR History table (F08042).

C.2.22 Processing Options for Employee History Log (R080423)

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

C.2.22.1 Narrative

1. Enter a '0' or blank to see just Active employees. Enter a '1' to see just inactive employees. Enter a '2' to see both Active and Inactive employees. 1. Enter a '0' or blank to see just Active employees. Enter a '1' to see just inactive employees. Enter a '2' to see both Active and Inactive employees.

Specify whether to print active and inactive employees on the report.

2. Enter Beginning Effective On Date

Specify the beginning date in a range of effective dates for the system to use when deciding which records to print on the report.

3. Enter Ending Effective On Date

Specify the ending date in a range of effective dates for the system to use when deciding which records to print on the report.

4. Enter the Data Item you wish to view. Blanks will display all data items being tracked.

Specify the data item that you want to view on the report.

C.2.23 R080424A - Employee Salary History Analysis

Run the Employee Salary History report (R080424A) to review changes to the primary job salary within the date range that you define.

The system selects a salary record and an hourly record for each employee. It then compares the effective dates of the two records and chooses the earlier date to identify the pay class that is linked to the employee.

If the pay class is S (salary), the system prints the employee's information based on salary information. If the pay class is H (hourly), the system prints the employee's information based on hourly rate information.

C.2.24 Processing Options for Employee Salary History Analysis (R080424A)

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

C.2.24.1 Narrative

1. Enter a '0' or blank to see just Active employees. Enter a '1' to see just inactive employees. Enter a '2' to see both Active and Inactive employees. 1. Enter a '0' or blank to see just Active employees. Enter a '1' to see just inactive employees. Enter a '2' to see both Active and Inactive employees.

Specify whether to print active and inactive employees on the report.

2. Enter beginning Effective On date

Specify the beginning date in a range of effective dates for the system to use when deciding which records to print on the report.

3. Enter ending Effective On date

Specify the ending date in a range of effective dates for the system to use when deciding which records to print on the report.

4. Enter a '1' to include all employees even if they fall outside the reporting period range of date.

Specify whether to include all employees on the report.

C.2.25 R080430 - Employee Turnover Report

After you define the turnover columns, you can run the Employee Turnover Report (R080430). You can create turnover reports based on Company, Business Unit, Check Route code, and Job Type.

C.2.26 Processing Options for Employee Turnover Report (R080430)

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

C.2.26.1 Process

1. Enter the From Date to begin tracking turnover.

Specify the from date to begin tracking turnover.

2. Enter the Thru Date when calculations are to cease. Default of blank will calculate through today.

Specify the thru date when calculations are to cease. Default of blank will calculate through today.

3. Enter the Turnover Column Group which contains the column headings you wish to have display on the report.

Specify the turnover column group that contains the column headings you want to include on the report.

C.2.27 R080431 - Employee Activity Analysis

Run the Employee Activity Analysis report (R080431) to review employee turnover by the dates and the data item that you define in the processing options. You can also set up the processing options to segment the date that you entered in the From Date and Thru Date fields into six segments, such as months or years.

C.2.28 Processing Options for Employee Activity Analysis Report (R080431)

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

C.2.28.1 Setup

1) From Date

Use this processing option to limit reviews. The review date must be greater than or equal to the from date.

2) Thru Date

Use this processing option to limit reviews processed. The review date must be less than or equal to the thru date.

3) Turnover Column Group

Specify the turnover column group that contains the column headings you want to include on the report.

4) Data Item

Specify the data item that contains the data you want to include on the report.

C.2.28.2 Segments

1) Date 1 through 6) Date 6)

Specify the beginning date for each segment.

C.2.29 R083495 - Update EE Master Age as of

The Update Employee Master Age As Of report (R083495) updates the employee age in the Employee Age field and the age of the employee's spouse in the Spouse Age field on the Personal form in the Employee Master program (P0801). The system calculates the new value for the Employee Age field based on the employee's date of birth and the date specified in your processing options. The system calculates the new value for the Spouse Age field based on the Spouse Date of Birth value and the date specified in your processing options.

C.2.30 Processing Options for Update Employee Master Age as of (R083495)

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

C.2.30.1 Date

1. Enter the as of date to be used when calculating employees age. Blank = Age for Employee will NOT be updated

Specify the as of date that the system uses when calculating the employee age.

2. Enter the as of date to be used when calculating age for spouses. Blank = Age for Spouses will NOT be updated

Specify the as of date that the system uses when calculating the spouse age.

C.2.30.2 Change Reason

1. Enter the change reason for history tracking.

Specify the change reason.