JD Edwards EnterpriseOne Payroll Reports

Appendix: JD Edwards EnterpriseOne Payroll Reports

This appendix provides an overview of payroll reports and enables you to:

View summary tables of all reports.
View details for selected reports.

Payroll Reports

You can print payroll reports to satisfy governmental requirements and to review current and historical payroll information, including taxes paid, workers' compensation insurance information, employee retirement plan investments, and union information. You can print these types of payroll reports:

Standard Reports
Periodic Reports
Union Reports

Standard Reports

Standard reports are those reports that you generate to review historical payroll information for accuracy and completeness. You can also use these reports to help you analyze trends.

Periodic Reports

Periodic reports are reports that you generate on a regular basis, typically to supply information to government agencies or organizations such as a unions. You typically generate periodic reports on a schedule that coincides with governmental, industry, or union reporting requirements; however, you can generate and review these reports more often.

Union Reports

If the organization has employees who are union members, you print union reports to satisfy government and union reporting requirements. Union reports include detailed information about work hours and wages for union employees.

JD Edwards EnterpriseOne Payroll Reports: A to Z

These tables list the JD Edwards EnterpriseOne Payroll reports, sorted alphanumerically by report ID. This section discusses:

JD Edwards EnterpriseOne Payroll standard reports
JD Edwards EnterpriseOne Payroll periodic reports
JD Edwards EnterpriseOne Payroll union reports

Payroll Standard Reports

This table lists the standard reports:

Report ID and Report Name	Description	Navigation
R053011 Historical Labor and Burden Distribution Register	Use this report to review and analyze labor and burden costs by employee, business unit, company, or by the grand totals for the entire organization.	U.S. History Reports (G07BUSP15), Historical Labor and Burden Distribution Register
R071913 Step Progression Historical Report	Use this report to review detailed step progression history information for each step progression employee.	Daily Processing (G07STEP1), Progression Historical Report Note. This report should be set up to print during the final update step of the payroll cycle.
R073231 Employee Pay & Tax Register	Use this report to review individual employees' taxes, and the pay amounts on which those taxes were based. The report includes gross pay, excludable wages, taxable wages, excess pay, and actual tax amounts for each tax type for the specified period.	U.S. History Reports (G07BUSP15), Employee Pay & Tax Register
R07345 Historical Payroll Register	This report lists the accumulated pay, benefit, deduction, accrual, and tax information for a selected group of employees for a selected period of time.	U.S. History Reports (G07BUSP15), U.S. Historical Payroll Register Canada History Reports (G77BCAP15), Canadian Historical Payroll Register Australia/New Zealand Reports (G07BUSP17), Historical Payroll Register
R07415 PDBA History By Company Report	Use this report to review a monthly list of pay types, deductions, benefits, and accruals (PDBAs) for each company in the organization.	U.S. History Reports (G07BUSP15), PDBA History by Company

Payroll Periodic Reports

This table lists the periodic reports:

Report ID and Report Name	Description	Navigation
R073101 Deduction/Benefit Workfile Build	Process the Deduction/Benefit Workfile Build program (R073101) to generate reports that enable you to review DBA history for individual employees. You specify the reports to produce in the processing options.	U.S. History Reports (G07BUSP15), DBA Register/401K Reports
R073102 Deduction/Benefit Report	Use this report to review individual employees' DBA information for the period that you specify. You generate this report by running the Deduction/Benefit Workfile Build program.	U.S. History Reports (G07BUSP15), DBA Register/401K Reports Set the processing option for this report to 1 to generate the report.
R073121 Job Billing Health & Welfare - Detail Report	Use this report to review pay type, deduction, benefit, and accrual information for each employee who worked in a specified job or business unit. You can generate this report only by running the Job Billing Workfile Build process.	U.S. History Reports (G07BUSP15), Job Billing Registers Set the processing option for this report to 1 to generate the report.
R073122 Job Billing Health & Welfare - Summary Report	Use this report to review pay type, total hours, gross pay, deduction, benefit, and accrual information for each job or business unit. You can generate this report only by running the Job Billing Workfile Build process.	U.S. History Reports (G07BUSP15), Job Billing Registers Set the processing option for this report to 1 to generate the report.
R073181 Employee Earnings History Summary Report	Use this report to review information about employees' payroll earnings during a specified period of time.	U.S. History Reports (G07BUSP15), Employee Earnings History
R073200 Job Billing Workfile Build Program	Process the Job Billing Register Workfile Build program (R073200) to generate job-billing reports. You specify the job-billing reports to produce in the processing options.	U.S. History Reports (G07BUSP15), Job Billing Registers
R073201 Job Billing Register - Detail Report	You produce this report to review detailed information regarding timecards and burden for each employee in a specified job. The report displays employee information, timecard and pay rate information, job type and step, actual burden amounts for each employee, and totals for each job that is included in the report. You can generate this report only by running the Job Billing Workfile Build process.	U.S. History Reports (G07BUSP15), Job Billing Registers Set the processing option for this report to 1 to generate the report.
R073211 Job Billing Register - Summary Report	You generate this report to review summarized job billing information for a specific job or business unit. This report displays hours, gross pay amounts, deduction amounts, and actual burden amounts for each job or business unit that is included in the report. You can generate this report only by running the Job Billing Workfile Build process.	U.S. History Reports (G07BUSP15), Job Billing Registers Set the processing option for this report to 1 to generate the report.
R073221 401K Report	Use this report to review employee and company contributions to individual employees' 401(k) plans. You generate this report by running the Deduction/Benefit Workfile Build program.	U.S. History Reports (G07BUSP15), DBA Register/401K Reports Set the processing option for this report to 1 to generate the report.
R073251A Investment Register Report	You produce this report to review the percentages of their investments that participants in a retirement plan, such as a 401(k) plan, allocate to fixed investments and the percentages that they allocate to equity investments. You generate this report by running the Deduction/Benefit Workfile Build program.	U.S. History Reports (G07BUSP15), DBA Register/401K Reports Set the processing option for this report to 1 to generate the report.
R073301 Job Billing Workers Compensation by Job Register	You generate this report to review workers' compensation information for each employee within a business unit or job. You can generate this report only by running the Job Billing Workfile Build process.	U.S. History Reports (G07BUSP15), Job Billing Registers Set the processing option for this report to 1 to generate the report.
R073302 Job Billing PL & PD by Job Register (personal liability & property damage)	You generate this report to review general liability calculations for each employee within a business unit or job. General liability includes personal liability (PL) and property damage (PD). You can generate this report only by running the Job Billing Workfile Build process.	U.S. History Reports (G07BUSP15), Job Billing Registers Set the processing option for this report to 1 to generate the report.
R07343 General Liability Insurance Report	This report provides general liability insurance subtotals as well as each employee's workers' compensation code, work state, company, and grand totals for general liability insurance.	U.S. History Reports (G07BUSP15), Worker's Comp/General Liability Canada History Reports (G77BCAP15), Worker's Comp/General Liability On Worker's Comp/General Liability Revisions (W07343A), click the General Liability Insurance Report option.
R07343 Worker's Compensation Insurance Report	This report provides workers' compensation insurance subtotals along with each employee's workers' compensation code, work state, company, and grand totals for workers' compensation insurance.	U.S. History Reports (G07BUSP15), Worker's Comp/General Liability Canada History Reports (G77BCAP15), Worker's Comp/General Liability On Worker's Comp/General Liability Revisions (W07343A), click the Workers Compensation Insurance Report option.

Report ID and Report Name

Description

Navigation

R073101

Deduction/Benefit Workfile Build

Process the Deduction/Benefit Workfile Build program (R073101) to generate reports that enable you to review DBA history for individual employees. You specify the reports to produce in the processing options.

U.S. History Reports (G07BUSP15), DBA Register/401K Reports

R073102

Deduction/Benefit Report

Use this report to review individual employees' DBA information for the period that you specify.

You generate this report by running the Deduction/Benefit Workfile Build program.

U.S. History Reports (G07BUSP15), DBA Register/401K Reports

Set the processing option for this report to 1 to generate the report.

R073121

Job Billing Health & Welfare - Detail Report

Use this report to review pay type, deduction, benefit, and accrual information for each employee who worked in a specified job or business unit.

You can generate this report only by running the Job Billing Workfile Build process.

U.S. History Reports (G07BUSP15), Job Billing Registers

Set the processing option for this report to 1 to generate the report.

R073122

Job Billing Health & Welfare - Summary Report

Use this report to review pay type, total hours, gross pay, deduction, benefit, and accrual information for each job or business unit.

You can generate this report only by running the Job Billing Workfile Build process.

U.S. History Reports (G07BUSP15), Job Billing Registers

Set the processing option for this report to 1 to generate the report.

R073181

Employee Earnings History Summary Report

Use this report to review information about employees' payroll earnings during a specified period of time.

U.S. History Reports (G07BUSP15), Employee Earnings History

R073200

Job Billing Workfile Build Program

Process the Job Billing Register Workfile Build program (R073200) to generate job-billing reports. You specify the job-billing reports to produce in the processing options.

U.S. History Reports (G07BUSP15), Job Billing Registers

R073201

Job Billing Register - Detail Report

You produce this report to review detailed information regarding timecards and burden for each employee in a specified job. The report displays employee information, timecard and pay rate information, job type and step, actual burden amounts for each employee, and totals for each job that is included in the report.

You can generate this report only by running the Job Billing Workfile Build process.

U.S. History Reports (G07BUSP15), Job Billing Registers

Set the processing option for this report to 1 to generate the report.

R073211

Job Billing Register - Summary Report

You generate this report to review summarized job billing information for a specific job or business unit. This report displays hours, gross pay amounts, deduction amounts, and actual burden amounts for each job or business unit that is included in the report.

You can generate this report only by running the Job Billing Workfile Build process.

U.S. History Reports (G07BUSP15), Job Billing Registers

Set the processing option for this report to 1 to generate the report.

R073221

401K Report

Use this report to review employee and company contributions to individual employees' 401(k) plans.

You generate this report by running the Deduction/Benefit Workfile Build program.

U.S. History Reports (G07BUSP15), DBA Register/401K Reports

Set the processing option for this report to 1 to generate the report.

R073251A

Investment Register Report

You produce this report to review the percentages of their investments that participants in a retirement plan, such as a 401(k) plan, allocate to fixed investments and the percentages that they allocate to equity investments.

You generate this report by running the Deduction/Benefit Workfile Build program.

U.S. History Reports (G07BUSP15), DBA Register/401K Reports

Set the processing option for this report to 1 to generate the report.

R073301

Job Billing Workers Compensation by Job Register

You generate this report to review workers' compensation information for each employee within a business unit or job.

You can generate this report only by running the Job Billing Workfile Build process.

U.S. History Reports (G07BUSP15), Job Billing Registers

Set the processing option for this report to 1 to generate the report.

R073302

Job Billing PL & PD by Job Register (personal liability & property damage)

You generate this report to review general liability calculations for each employee within a business unit or job. General liability includes personal liability (PL) and property damage (PD).

You can generate this report only by running the Job Billing Workfile Build process.

U.S. History Reports (G07BUSP15), Job Billing Registers

Set the processing option for this report to 1 to generate the report.

R07343

General Liability Insurance Report

This report provides general liability insurance subtotals as well as each employee's workers' compensation code, work state, company, and grand totals for general liability insurance.

U.S. History Reports (G07BUSP15), Worker's Comp/General Liability
Canada History Reports (G77BCAP15), Worker's Comp/General Liability

On Worker's Comp/General Liability Revisions (W07343A), click the General Liability Insurance Report option.

R07343

Worker's Compensation Insurance Report

This report provides workers' compensation insurance subtotals along with each employee's workers' compensation code, work state, company, and grand totals for workers' compensation insurance.

U.S. History Reports (G07BUSP15), Worker's Comp/General Liability
Canada History Reports (G77BCAP15), Worker's Comp/General Liability

On Worker's Comp/General Liability Revisions (W07343A), click the Workers Compensation Insurance Report option.

Payroll Union Reports

This table lists the union reports:

Report ID and Report Name	Description	Navigation
R073112 Health and Welfare Report by Employee	This report provides a detailed breakdown of the deductions and benefits from employee payments. You use this report primarily to satisfy union reporting requirements.	Periodic Processing (G07UN2), Health and Welfare Report by Employee
R073132 Health and Welfare Report by Provider and Employee	This report provides a detailed breakdown of the deductions and benefits from employee payments for all payees and providers. You use this report primarily to satisfy union reporting requirements.	Periodic Processing (G07UN2), Health & Welfare Report by Provider & EE
R073142 Health & Welfare Report by Payee & Union	This report lists the deductions and benefits that are assigned to payees by the union. You use this report primarily to satisfy union reporting requirements.	Periodic Processing (G07UN2), Health & Welfare Report by Payee & Union
R073151 Union Distribution Report	You print this report to review detailed information by union about each employee's work hours per pay period. You use this report primarily to satisfy union reporting requirements.	Periodic Processing (G07UN2), Union Distribution Report
R073152 Union Liability Report	You print this report to review a summary of the types of hours worked by each employee in each union.	Periodic Processing (G07UN2), Union Liability Report

JD Edwards EnterpriseOne Payroll Reports: Selected Reports

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

R053011 - Historical Labor and Burden Distribution Register

Use the Historical Labor and Burden Distribution Register program (R053011) to review labor and burden costs for each employee, business unit, and company within the organization. This information can be especially useful when you need to create budgets for each business unit, determine personnel hiring and headcount information, and verify the accuracy of past budget information. For example, if employees within the organization use labor distribution rules, the costs that are associated with their labor are typically divided among several business units. The Historical Labor and Burden Distribution Register displays all of the labor and burden costs for a specified period, including employer-paid taxes and benefits, by the business units to which the labor was actually charged. This report can also be used to track information about labor expenditures that are associated with state or federal grants.

The report displays details and totals of this information for each employee, business unit, company, and for the entire report:

Number of hours worked by pay type.
Amount of earnings by pay type.
Employer-paid taxes by tax type.
Employer-paid benefits by DBA code.

Note. To include burden information on the report, you must have created records in the Burden Distribution File table (F0724). To create these records, you set up burden rules for each business unit that you want to include in the report. When you process payroll, the system creates these records based on the burden rules that you set up. If you do not set up burden rules for a business unit, the report will not include any burden information for that business unit.

Additionally, the system includes burden information on the report only for the time periods during which you were creating burden records. For example, if you set up burden rules on January 1, 2007, the system will not include burden information for any records that were processed through a payroll cycle before this date.

See Setting Up Business Unit Burden Rules.

To compile the report, the system uses data from F0618 and F0724.

Processing Options for the Historical Labor and Burden Distribution Register (R053011)

Set these processing options before you run the Historical Labor and Burden Distribution Register.

General

Use these processing options to specify how to process historical labor and burden data.

1. Dates

Specify the Pay Period Ending Date, or the beginning and the end of the date range (Beginning Date Range (From) and Ending Date Range (Thru)) for which historical labor and burden information will be reported.

R071913 - Step Progression Historical Report

This report lists units, effective dates, and status information for all of the job levels in which an employee has worked during the period. You can run this report if you are processing step progression information using the automatic method or the stand-alone method.

Processing Options for the Step Progression Historical Report (R071913)

Set this processing option before you run the Step Progression Historical Register.

Default

These processing options identify the type of information that will appear on the report.

1. Display history records:

Specify the type of information to display on the Job Step Progression Historical report. Values are:

Blank: Display all step progression history. This option will display step progression history records for all job type and job step combinations in which an employee has worked. This is the default.

1: Display only active records. This option will display step progression history records for the employee's current job type and job step.

R073101 - Deduction/Benefit Workfile Build

You use the Deduction/Benefit Workfile Build to generate any or all of these reports:

Deduction/Benefit Report (R073102)
401K Report (R073221)
Investment Register Report (R073251A)

You use the processing options to specify the version for each report that you want to generate.

Processing Options for the Deduction/Benefit Workfile Build Program (R073101)

Set these processing options to specify the deduction/benefit and 401(k) reports to produce, and which version to use for each report that you want to generate.

Defaults

Use these processing options to set date ranges for the information that is used to create the reports and to determine which reports to produce.

1. Date From	Specify the beginning date of a valid range of dates.
2. Date Thru	Specify the ending date of a valid range of dates.
3. Current Month	Specify the month in which the report is being submitted. If you leave this processing option blank, the system date determines the month.
4. Company	Specify which company to use when processing the Deduction/Benefit Workfile Build.
5. Date to Base Current Amount	Specify whether to use work dates or payment dates to calculate the current amounts on the 401(k) report. Note. If you use payment dates, the report reflects the information that is stored in PDBA History, which is also based on payment dates. Values are: Blank: Work dates. 1: Payment dates.
6. Deduction/Benefit Report (R073102)	Specify whether to automatically produce the Deduction/Benefit Report after the Deduction/Benefit Workfile Build process is complete. Values are: Blank: Do not produce. 1: Produce.
7. 401K Report (R073221)	Specify whether to automatically produce the 401(k) Report after the Deduction/Benefit Workfile Build process is complete. Values are: Blank: Do not produce the report. 1: Produce the report.
8. Investment Report (R073251A)	Specify whether to automatically produce the Investment Report after the Deduction/Benefit Workfile Build process is complete. Values are: Blank: Do not produce. 1: Produce.

Versions

Use these processing options to identify the version that you want the system to use to create the reports.

1. Deduction/Benefit Report (R073102) Version , 2. 401K Report (R073221) Version, and 3. Investment Report (R073251A) Version

Select the version to use to produce the report. If you leave this option blank, the system uses version XJDE0001.

Note. You must enter a 1 in the processing option on the Defaults tab in order for the system to produce the report.

R073102 - Deduction/Benefit Report

You can review month-to-date, quarter-to-date, and year-to-date totals for employees' DBA information.

Processing Options for the Deduction/Benefit Report (R073102)

Set these processing options to specify the details of the information that the Deduction/Benefit Report includes.

Use these processing to specify the information that appears on the report.

1. Employee number to print.

Specify the type of employee number that appears on the report. Values are:

Blank: Address Book number.

1: Tax ID number.

2: Other employee number.

2. Print MTD, QTD, YTD information (print month-to-date, quarter-to-date, year-to-date information)

Specify whether the report displays month-to-date, quarter-to-date or year-to-date information. Values are:

Blank: Do not display union and job codes.

1: Display current period information only.

3. Deductions appear as negative

Specify whether the report displays deductions as negative amounts. Values are:

Blank: No.

1: Yes.

R073112 - Health and Welfare Report by Employee

The system treats all employees who are not covered by a plan or union as a group. Totals for each group are displayed on a Union Total Information Page that follows the last member of the group. You can run the report at any time. The report lists this information:

Gross pay earned.
Related deductions, benefits, and accruals.
Basis for the deductions and benefits.
Employee totals.
Totals for payee/union.

The information provided in this report is based on these tables:

F0618
F0719

Processing Options for Health and Welfare Report by Employee (R073112)

Set these processing options enable before you run the Health and Welfare Report by Employee.

Dates

Use these processing options to specify the dates that are used to process the report.

1. Date Range

Specify the date range for selecting records for processing. Both from and through dates must be entered.

2. Date Range Type

Specify the date field that the system uses in the data selection. Values are:

Blank: Check Dates (Default).

1: Work Dates.

Job Category

Use this processing option to specify the job categories that are used to process the report.

1. Apprenticeship Job Category Codes, Job Type (Craft) Code 1-5

Specify up to five category codes for apprenticeship jobs. These codes will be used to separate apprenticeship totals from all other job category totals on the report.

D/B/A Codes

Use this processing option to specify which DBA codes are used to process the report.

D/B/A Codes 1-5 (deduction/benefit/accrual codes 1–5)

Specify up to five DBA codes, which will be used to track and print totals for each rate within the DBA. Typically, this processing option is used for DBAs, such as 401(k), where the rate is entered at the employee level.

Employee Mode

Use this processing option to specify which employee number prints on the report.

1. Employee Number Mode

Specify the type of employee number that will print on the report. Values are:

1: Address Book number.

2: Tax ID number (default).

3: Third employee number.

R073121 - Job Billing Health & Welfare - Detail Report

This register displays the total hours and gross pay amounts for each job classification and business unit or job, as well as benefit amount totals for each business unit or job.

You can automatically generate this report when you process the Job Billing Register Workfile Build program (R073200). You specify in the processing options for the Job Billing Register Workfile Build program the reports to be created during the workfile build process.

See R073200 - Job Billing Workfile Build Program.

Processing Options for the Job Billing Health & Welfare - Detail Report (R073121)

Set these processing options before you generate the Job Billing Health & Welfare - Detail Report.

Display

Use these processing options to specify the information that appears on the report.

1. Select employee number to print:

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

A: Address Book Number.

S: Social Security Number.

O: Third Employee Number.

2. Include payroll burden costs:

Specify whether to print burden costs on the report, and specify the type of burden costs to print. You can print flat burden, which is a fixed burden cost that does not vary by the work hours or any other factors. Alternatively, you can print actual burden costs, which are calculated using burden type, burden rate, method, and work hours. Values are:

Blank: Do not include burden costs.

1: Flat Burden.

2: Actual Burden.

R073122 - Job Billing Health & Welfare - Summary Report

See R073200 - Job Billing Workfile Build Program.

Processing Options for the Job Billing Health & Welfare - Summary Report (R073122)

Set these processing options before you generate the Job Billing Health & Welfare - Summary Report.

Defaults

Use this processing option to specify whether payroll burden costs appear on the report.

1. Include payroll burden costs:

Specify whether to include burden costs in the report and select which type of burden costs to include. You can include flat burden, which is a fixed burden cost that does not vary by the work hours or any other factors. Alternatively, you can include actual burden, which is calculated using burden type, burden rate, method, and work hours. Values are:

Blank: Do not include burden costs.

1: Flat burden.

2: Actual burden.

R073132 - Health and Welfare Report by Provider and Employee

This report is organized by provider (payee). It lists amounts by employee within a union (or group plan), with a group total page, and prints an accumulated listing within the payee across all unions (or group plans). You can run the report at any time. The report lists this information:

Hours and gross pay basis for the deductions listed.
All deductions assigned to the payee for each employee.
Employee totals.
Report divided by payee or provider.
Totals for each payee.

To compile the report, the system uses data from F0618 and F0719.

Processing Options for Health and Welfare Report by Provider and Employee (R073132)

Set these processing options before you run the Health and Welfare Report by Provider and Employee.

Display

Use these processing options to specify the information that appears on the report.

1. Report Period Begin Date	Specify the beginning of the date range for which DBAs will be reported.
2. Report Period End Date	Specify the end of the date range for which DBAs will be reported.
3. Date Range Type	Specify whether the data will be selected based on work date or check date. Any value other than 1 will result in check dates being used.
4. Employee Identification Number	Specify which employee number to print on the report. Values are: Blank: The default value that was set up in company options. 1: Address Book number. 2: Tax ID number. 3: Alternate employee number. If you enter any other value in this processing option, the system uses the default value that was set up in company options.

R073142 - Health and Welfare Report by Payee and Union

You can run the report at any time. The report lists these items:

Hours and gross-pay basis by pay period for the deductions listed.
Figures by union for the payee or provider in each pay period.
Totals for each payee or provider.

The information provided in this report is based on F0618 and F0719.

Processing Options for Health & Welfare Report by Payee & Union (R073142)

Set these processing options before you run the Health & Welfare Report by Payee & Union.

Dates

Use these processing options to specify the date range for the data that is included in the report.

1. Date Range

Specify the date range to use to produce the report. Both from and through dates must be entered.

2. Date Range Type

Specify the date field against which to perform data selection. Values are:

Blank: Check date (default).

1: Work date.

R073151 - Union Distribution Report

This report provides this information:

Hours worked for each pay period for each employee.
Total hours worked for the month.
Total gross pay.
Employee totals.
Union totals.
Grand totals for the entire report.

The information provided in this report is based on F0618.

Processing Options for the Union Distribution Report (R073151)

Set these processing options before you run the Union Distribution Report.

Display

Use these processing options to specify the information to print on the report.

1. Pay Period End Date

Specify whether to display the pay period ending date on the report. This value is informational only. This value does not control data selection. You must set up the data selection in the program version. If this processing option is blank, the system does not print the pay period end date on the report.

2. Employee Identification Number

Specify which employee identification number to print on the report. Values are:

Blank: Use the default value set up in company constants.

1: Use the address book number.

2: Use the social security number (employee tax ID).

3: Use the alternate employee number.

Any other value in this processing option will cause the default value that is set up in company constants to be used.

R073152 - Union Liability Report

This report shows actual hours worked and equivalent hours worked for union employees for each week in the reporting period. You can specify the reporting period for the report, as well as the pay types and employee identification numbers that appear on the report.

The information provided in this report is based on the Employee Transaction History table (F0618). and on the Union Liability Basis Tables that you define in user-defined code (UDC) list 06/IP. You use these tables to define the multiplication factor and description for each hour type that appear on the report.

Note. Before you generate the Union Liability Report (R073152), set up Union Liability Basis Tables in UDC 06/IP.

See JD Edwards EnterpriseOne Tools 8.98: Foundation Guide.

Processing Options for the Union Liability Report (R073152)

Set these processing options before you run the Union Liability Report.

Display

Use these processing options to specify the information to print on the report.

1. Pay Cycle Code	Specify the pay cycle type (from master pay cycles) to be used in the report.
2. Month	Specify the month for which pay period ending dates will appear on the report.
3. Year	Specify the year of the reporting period.
4. Century	Specify the century of the reporting period.
5. Employee Identification Number	Specify which employee identification number appears on the report. Values are: Blank: Use the default value set up in company constants. 1: Use the address book number. 2: Use the social security number (employee tax ID). 3: Use the alternate employee number. Any other value will cause the default value that is set up in company constants to be used.
6–10. Union Liability Basis Code 1–5	Specify tables of pay, deduction, and benefit types that define the basis for various payroll calculations. These tables are used in several processes, such as defining insured pay types for workers' compensation and identifying pay types to be included in automatic timecard generation. The order that these codes are entered in the processing options is the order that they will appear on the report.

R073181 - Employee Earnings History Summary Report

You produce this report to review employees' payroll earnings during the period of time that you specify, such as month-to-date, quarter-to-date, or year-to-date.

Processing Options for the Employee Earnings History Summary Report (R073181)

Set these processing options before you run the Employee Earnings History Summary Report.

Process

Use these processing options to determine what information to include on the report.

1. Employee Number

Specify which employee identification number to print on the Employee Earnings History Summary report. Values are:

A: Address Book Number.

S: Social Security Number.

O: Third Employee Number.

2. Date From

Specify the beginning date of a valid range of dates to include in the report. If you leave this processing option blank, the system does not produce a report.

3. Date Thru

Specify the ending date of a valid range of dates to include in the report. If you leave this processing option blank, the system does not produce a report.

R073200 - Job Billing Workfile Build Program

To generate job billing reports, you must build the F07UI200 table. This table, and the job-billing reports that you want to produce, are created when you process the Job Billing Register Workfile Build program (R073200). The system compiles the job billing reports using timecard history information that is stored in F0618 and burden information (associated with that timecard history) that is stored in F0724. You use the job billing reports to provide detailed cost information regarding the work that is performed for a particular job. Before you generate any of the job billing reports:

Create versions of each of the job billing reports that you want to produce.

See JD Edwards EnterpriseOne Tools 8.98: Foundation Guide.
Complete the processing options for the Job Billing Register Workfile Build program (R073200).

Note. For the system to populate F0724, you must set up burden rules for each business unit.

See Setting Up Business Unit Burden Rules.

Processing Options for the Job Billing Workfile Build Program (R073200)

Set these processing options to specify the job-billing reports to produce, and which version to use for each report that you want to generate.

Defaults

Use these processing options to set date ranges for the information that is used to create job billing registers and to determine which job billing registers to produce.

1. Date From	Specify the beginning date of a valid range of dates.
2. Date Thru	Specify the ending date of a valid range of dates.
3. Date Range Type	Specify the type of date that the system uses to select data for the job billing registers. Using the date range entered in the Date From and Date Thru processing options, the system uses payroll history data that has either work dates or pay period end dates that are included in the specified date range. Values are: Blank: Work Date. 1: Pay Period End Date.
4. Job Billing Register Detail (R073201)	Specify whether the system produces the Job Billing - Register Detail report (R073201). This report lists each employee's hours, labor distribution amount, and burden amounts. The report also provides totals by business unit or job for the hours, labor distribution amount, and burden amount. Values are: Blank: Do not produce. 1: Produce.
5. Job Billing Register Summary (R073211)	Specify whether the system produces the Job Billing Summary Register (R073211). This report provides totals by unit or job for hours, gross pay, deduction amounts, and actual burden. To display deduction amounts and actual burden, you must process timecards through the JD Edwards EnterpriseOne Payroll system. Values are: Blank: Do not produce. 1: Produce.
6. Job Billing H & W Detail (R073121) (health & welfare)	Specify whether the system produces the Job Billing Health & Welfare - Detail (R073121). This report lists pay types, deductions, benefits, and accruals for each employee within a business unit or job. The report also provides the total hours, gross pay amounts, and benefit amounts for each job classification and business unit or job. Values are: Blank: Do not produce. 1: Produce.
7. Job Billing H & W Summary (R073122)	Specify whether the system produces the Job Billing Health & Welfare Summary Report (R073122). This report provides total hours, gross pay amounts, and benefit amounts for each job classification and business unit or job. Values are: Blank: Do not produce. 1: Produce.
8. Job Billing W/C by Job (R073301) (workers compensation)	Specify whether the system produces the Job Billing Workers Compensation by Job Register (R073301). This report lists detailed information for workers' compensation calculations for each employee within a business unit or job. The register also provides a grand total workers' compensation amount for the company, and totals by business unit and job classification for hours, gross pay, excludable gross pay, reportable gross pay, and workers' compensation amounts. Values are: Blank: Do not produce. 1: Produce.
9. Job Billing Register PL & PD by Job (R073302)	Specify whether the system produces the Job Billing Personal Liability & Property Damage by Job Register (R073302). This report lists detailed information for general liability calculations for each employee within a business unit or job. The register also provides a grand total general liability amount for each company, and totals by business unit and job classification for hours, gross pay, excludable gross pay, reportable gross pay, and general liability amounts. Values are: Blank: Do not produce. 1: Produce.

Versions

Use these processing options to identify the version that you want the system to use to create job billing reports.

1. Job Billing Register Detail (R073201) , 2. Job Billing Register Summary (R073211), 3. Job Billing H & W Detail (R073121), 4. Job Billing H & W Summary (R073122), 5. Job Billing W/C by Job (R073301), and 6. Job Billing Register PL & PD by Job (R073302)

Select the version to use to produce the report. If you leave this processing option blank, the system uses version XJDE0001.

Note. You must enter a 1 in the processing option on the Default tab in order for the system to produce the report.

R073201 - Job Billing Register - Detail Report

You can automatically produce this report when you process the Job Billing Register Workfile Build program (R073200). You specify which reports are created during the workfile build process in the processing options for the Job Billing Workfile Build program.

See R073200 - Job Billing Workfile Build Program.

Processing Options for the Job Billing Register - Detail Report (R073201)

Set these processing options before you generate the Job Billing Register - Detail Report.

Display

Use these processing options to specify the information that appears on the report.

1. Detail or summary:

Specify whether the system prints the report in detail or summary format. The detail format includes all of the information that is included in the summary format, plus individual job entries. Values are:

Blank: Detail format.

1: Summary format.

2. Select employee number to print:

Specify which employee number will print on the report. Values are:

A: Address Book Number.

S: Social Security Number.

O: Third Employee Number.

3. Enter '1' to include payroll burden costs.

Specify whether the system prints payroll burden costs on the report. You must process timecards through JD Edwards EnterpriseOne Payroll system to print this information. Values are:

0: Do not print.

1: Print.

R073211 - Job Billing Register - Summary Report

You can automatically generate this report when you process the Job Billing Register Workfile Build program (R073200). You specify which reports are created during the workfile build process in the processing options for the Job Billing Register Workfile Build program.

See R073200 - Job Billing Workfile Build Program.

Processing Options for the Job Billing Register - Summary Report (R073211)

Set these processing options before you generate the Job Billing Register - Summary Report.

Default

Use these processing options to specify the information that appears on the report.

1. Include Payroll Burden Costs

Specify whether to include payroll burden costs on the report. You must process payroll through the JD Edwards EnterpriseOne Payroll system, and you must create detailed burden records to print this information. Values are:

Blank: Do not print.

1: Print.

2. Summarize Benefits

Specify whether to display summarized benefit information on the report. Values are:

Blank: Do not display.

1: Summarized benefit.

2: All benefits.

R073221 - 401K Report

In addition to reviewing employee and company contributions to employees' retirement accounts, you can also review total contributions by company.

Processing Options for the 401K Report (R073221)

Set these processing options to specify the details of the information that the 401(k) Report includes.

Defaults

Use these processing to specify the information that appears on the report.

1. Employee Number.

Specify the type of employee number that appears on the report. Values are:

Blank: Address Book Number.

1: Tax ID Number.

2: Additional Employee Number.

2. Type of report.

Specify the types of amounts that the report displays. Values are:

Blank: Display Current Amounts and MTD.

1: Display Current Amounts and QTD.

2: Display Current Amounts and YTD.

3: Display Monthly Amounts and QTD.

4: Display Monthly Amounts and YTD.

5: Display Quarterly Amounts and YTD.

3. Deduction appear as negatives.

Specify whether the report displays deductions as negative amounts. Values are:

Blank: No.

1: Yes.

R073231 - Employee Pay & Tax Register

You can use the Employee Pay & Tax Register to balance and verify information that appears on the employee year-end tax reports and forms. You can run the report with or without detailed transaction information. You can also choose which employee number appears on the report. In addition, you can choose which of these types of employee history you want to include on the report:

Month-to-date history (default).
Quarter-to-date history with monthly totals.
Quarter-to-date history with grand totals only.
Year-to-date history with monthly totals.
Year-to-date history with quarterly totals.
Year-to-date history with grand totals only.

The system retrieves information from F06136 and F06166 to produce this report.

Processing Options for the Employee Pay & Tax Register (R073231)

Set these processing options before you run the Employee Pay & Tax Register.

Defaults

These processing options enable you to specify the default information that the system uses to create the report.

1. Employee Number	Specify the employee number that appears on the report. Values are: Blank: Address Book number. 1: Tax ID number. 2: Third employee number.
2. Period End Date	Specify the period end date. You must enter a date in this processing option.
3. History Type	Specify the type of history information that appears on the report. Values are: Blank: Month-to-date. 1: Quarter-to-date with monthly balances. 2: Quarter-to-date totals only. 3: Year-to-date with monthly balances. 4: Year-to-date with quarterly balances. 5: Year-to-date totals only.
4. Detailed Transactions	Specify whether the report displays the detailed transactions associated with each balance. Values are: Blank: No. 1: Yes.

R073251A - Investment Register Report

In addition to reviewing employees' allocations to fixed investments and to equity investments, you can also review total investment amounts by company. You can use the JD Edwards EnterpriseOne Human Resources system to allocate percentages of retirement plan investments.

See Working with Fund Allocations.

Processing Options for the Investment Register Report (R073251A)

Set these processing options before you run the Detail Investment Register Report.

Process

Use these processing to specify the information that appears on the report.

1. Level of Detail	Specify the level of detail for the information to print on the report. Values are: P: Pay Period Detail. M: Monthly Detail. Q: Quarterly Detail. A: Annual Detail.
2. Employee Deduction Code	Specify the deduction code to print on the report.
3. DBA Code Ranges for Employee Investments	Specify the code ranges for the employee investments to print on the report. For both Fixed Investments and Equity Investments, identify these ranges: Range 1 from Type Range 1 thru Type Range 2 from Type Range 2 thru Type
4. Basic Benefit Code	Specify the benefit code to print on the report.
5. DBA Code Ranges for Employer Matching Investments.	Specify the code ranges for the employer matching investments to print on the report. For both Fixed Investments and Equity Investments, identify these ranges: Range 1 from Type Range 1 thru Type Range 2 from Type Range 2 thru Type
6. Print Negative Employee Investments	Specify whether to print negative employee investments. Blank: No (Default). 1: Yes.
7. Employee Number	Indicates the employee number that appears on the report. Values are: A: Address Book Number (Default). S: Social Security Number. O: Third Employee Number.

R073301 - Job Billing Workers Compensation by Job Register

In addition to providing a grand total of the workers' compensation amounts for the company, the register also provides these totals by business unit and job classification:

Total hours
Total gross pay
Excludable gross pay
Reportable gross pay
Workers' compensation amount

See R073200 - Job Billing Workfile Build Program.

Processing Options for the Job Billing Workers Compensation by Job Register (R073301)

Set these processing options before you generate the Job Billing Workers Compensation by Job Register.

Default

Use these processing options to specify default information for this report.

1. Select employee number to print:

Specify which employee number prints on the report. Values are:

A: Address Book Number.

S: Social Security Number.

O: Third Employee Number.

2. Include payroll burden costs:

Specify which payroll burden costs to print on the report. You can print flat burden, which is a fixed amount that does not vary by period, or you can print actual burden, which is a calculated amount that can vary. Values are:

Blank: Do not include burden.

1: Flat burden.

2: Actual burden.

R073302 - Job Billing Personal Liability and Property Damage by Job Register

In addition to providing a grand total of the general liability amount for the company, the register provides these totals by business unit and job classification:

Total hours
Total gross pay
Excludable gross pay
Reportable gross pay
General liability amount

See R073200 - Job Billing Workfile Build Program.

Processing Options for the Job Billing PL & PD by Job Register (R073302)

Set these processing options before you generate the Job Billing PL & PD by Job Register.

Default

These processing options determine the default information that is used to produce the report.

1. Select employee number to print:

Specify which employee number to print. Values are:

A: Address Book Number.

S: Social Security Number.

O: Third Employee Number.

2. Include payroll burden costs:

Specify which payroll burden costs to include on the report. Flat burden is a fixed burden cost that does not vary by period. The actual burden is a calculated burden cost that can vary. You must create detailed burden records to print actual burden costs. Values are:

Blank: Do not include burden.

1: Flat burden.

2: Actual burden.

3. General Liability set up as 'GENL' on Worker's Comp Table: (workers' compensation table)

Specify whether the general liability account on the Worker's Compensation table is set up as GENL. Values are:

Blank: No.

1: Yes.

R07343 - General Liability Insurance Report and Worker's Compensation Insurance Report

You can produce the Worker's Compensation Insurance Report and the General Liability Insurance Report to review historical insurance information. You can produce these reports in detail or summary format, depending upon the type of information that you want to review. When you produce these reports, you can decide whether you want to summarize information by country and state, or by country, state, and county. Use these reports to review detailed general liability insurance and workers' compensation insurance information for all employees that are processed through payroll cycles within the organization.

Access the Worker's Comp/General Liability Revisions form.

Version	Enter the version of either the General Liability Insurance Report or the Worker's Compensation Insurance Report that you want to process.
Address Book Number	Click this option to print the employee address book number on the report.
Social Security Number	Click this option to print the employee social security number on the report.
Other Employee Number	Click this option to print the other employee identification number on the report.
Canadian Detail Report with Totals by Company, State, and County	Click this option to display detailed Canadian information with totals by company, state, and county on the report
Detail Report with Totals by Company and State	Click this option to display detailed U.S. information with totals by company and state on the report
Canadian Summary Report with Totals by Company, State, County, and Workers Comp (workers compensation)	Click this option to display detailed Canadian information with totals by company, state, county, and workers' compensation on the report
Summary Report with Totals by Company, State, and Workers Comp	Click this option to display summary U.S. information with totals by company, state, and workers' compensation information on the report

R07345 - Historical Payroll Register

You can use the information that is included in the Historical Payroll Register to reconcile and audit payroll history at various times during the year, such as quarter- or year-end. The report includes information about accumulated pay, benefit, deduction, accrual, and tax information at these levels:

Employee
Business unit
Company
Grand total

The system uses data from these history tables to produce the Historical Payroll Register:

F0618
F0719
F06166
F0716

Processing Options for the Historical Payroll Register (R07345)

Set these processing options before you run the Historical Payroll Register.

Process

Use these processing options to specify how you want the system to process historical payroll data.

1. Payroll Type	Specify the type of payroll history that the Historical Payroll Register processes. Values are: Blank: U.S. payroll history. 1: Canadian payroll history. 2: Australian payroll history. 3: New Zealand payroll history.
2. Summary Mode	Specify the level of detail to print on the Historical Payroll Register report (R07345). Values are: 0: Detail by check control number. 1: Summary per pay period end date. 2: Summary per month. 3: Summary per quarter. 4: Summary per year. 5: Summary per check date. Note. If you choose to summarize by pay period end date, the report totals might be different than the report totals that you receive when you use any of the other five summary modes because the pay period end date might occur in a different month than the check date.
3. Payroll Tax Year	Specify the payroll tax year that you want to use to process employee history for an entire year. When you enter a value in this processing option, the system disregards any values in the Date From and Date Thru processing options. To use those options to specify a partial year, you must leave this processing option blank. When you leave all three of these processing options blank, the report does not produce any output.
4. Partial Year Date From	Specify the beginning date of a valid range of dates to print. Use this processing option in conjunction with the Date Thru processing option to process employee history for a partial year. You cannot specify a date range that is greater than one payroll tax year. If you do not specify a partial year using this processing option and the Date Thru processing option, you must enter a value in the Payroll Tax Year processing option, or the report does not produce any output.
5. Partial Year Date Thru	Specify the ending date of a valid range of dates to print. Use this option in conjunction with the Date From processing option to process employee history for a partial year. You cannot specify a date range that is greater than one payroll tax year. If you do not specify a partial year using this processing option and the Date From processing option, you must enter a value in the Payroll Tax Year processing option, or the report does not produce any output.

Use these processing options to specify the information to print on the report.

1. Print Employee Tax ID on Report	Specify whether the employee's tax ID appears on the report. Values are: Blank: Yes. 1: No. Note. (AUS and NZL) If you are processing this report for employees in Australia or New Zealand, the system does not include employee tax ID numbers on the report, regardless of how this option is set. Also, you cannot sort employees in Australia or New Zealand by tax ID number. If you choose to sort Australian or New Zealand employees by tax ID number, the system sorts them by address book number, because displaying employee tax IDs is against privacy regulations in these countries.
2. Print Employer Paid DBAs and Taxes	Specify whether the system prints employer-paid DBAs and taxes on the report. Values are: Blank: No, do not print DBAs or taxes. 1: Print DBAs and taxes. 2: Print DBAs only. 3: Print taxes only.
3. Print YTD Totals by Employee or HMCU/HMCO (home business unit/home company)	Specify how the report displays an employee's year-to-date history totals. Values are: Blank: By HMCU and HMCO. 1: By Employee.
4. Sort Employees By	Specify the order that the system uses to print employee records on the report. For Australian or New Zealand employees, the employee's address number is stored in the Employee Tax ID field in the Employee Master Information table (F060116). Therefore, option 1 will print Australian and New Zealand employees by address number, not employee tax ID. Values are: Blank: Address Number. 1: Employee Tax ID. 2: Alpha Name.
5. Print Employee History by BIN Number/Employer Tax ID (business identification number)	Specify whether employee DBAs and taxes appear separately by business identification number (BIN) or employer tax ID. If you do not choose to print information separately, employee DBA and tax information is grouped together, regardless of the company in which the employee worked. Values are: Blank: No. 1: Yes.

R07415 - PDBA History By Company Report

You can use this report to review monetary amounts and hours by pay type, and quarter-to-date and year-to-date totals of PDBA amounts by type or by company. To compile the report, the system retrieves information from F06146.

Processing Options for the PDBA History By Company Report (R07415)

Set these processing options before you run the PDBA History By Company Report.

Period

Use these processing options to specify the dates for which this report runs.

1. Enter Fiscal Year	Specify the fiscal year for which the report should be processed.
2. Enter Thru Period Number	Specify the ending period number of a valid range of dates to print. This number corresponds to the month in a calendar year.

Hours

Use these processing options to specify how to display hours information on the report.

1. Enter a '1' to show the hours on the report.	Enter 1 to show the hours on the report. If you leave this processing option blank, hours will not be displayed on the report.
2. Enter the character that will indicate that the row being printed indicates hours.	Specify the character that you want to use to indicate that the row being printed shows hours.