## Appendix: Benefits Reports

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

- View summary tables of all reports.

- View details for selected reports.

### Benefits Reports: A to Z

The reports listed in each table are sorted alphanumerically by report ID.

Report ID and Report Name | Description | Navigation
R080405 Dependent/Beneficiary Data by Data Type | Lists all supplemental data for dependents and beneficiaries, organized by data type. | Dependent Beneficiary Supplemental Data (G08BSDD2), Dep/Ben Data by Data Type
R080415 Dependent/Beneficiary Supplemental Data | Lists complete supplemental information for one or more dependents or beneficiaries in an easy-to-read format. | Dependent Beneficiary Supplemental Data (G08BSDD2), Dep/Ben Supplemental Data Report
R083450 Mandatory Participation Exception | Lists all employees who, because of their group status or the requirements of the plan, are not enrolled in the mandatory benefit plans but should be. | Periodic Processing (G08BB2), Mandatory Participation Exception Report
R083460 Dependent/Beneficiary Exception | Lists employees who are actively enrolled in benefit plans but who have not provided the required information about dependents or beneficiaries. | Processing (G08BB2), Dep/Ben Exception Report
R083675 (USA) 401(k) Discrimination Results | Lists the results of each nondiscrimination test (NDT) to identify compliance issues. Identifying compliance issues in a timely manner enables the employer to make corrections that might prevent a failed test result at the conclusion of the plan year, including disqualification of the plan. | Government Reporting (G05BG), Nondiscrimination Reporting On Non-Discrimination Testing Process, select Run Pass/Fail Test Report.
R083676 (USA) NDT - 415 Nondiscrimination Testing | Lists employees who contribute more to their deferred plan than the government allows. | You run this report when you process a payroll cycle. Coordinate with the payroll department to ensure that the report is set up to run as part of the payroll cycle.
R083470 Benefit Enrollment Outside Group | Lists all employees who are enrolled in benefit plans that are not available to members of their benefit group. After you identify employees who are enrolled in the wrong benefit group, you can enroll them in the correct benefit plans. | Periodic Processing (G08BB2), Benefit Enrollment Outside Group
R083480 Required Elections in Benefits | Lists all employees who are not enrolled in any benefit plan within a category that requires plan participation. | Periodic Processing (G08BB2), Required Elections in Benefits
R083490 Dep/Ben by Plan ID and Employee | Lists the employees who have dependents or beneficiaries enrolled in each benefit plan and includes information about each dependent, such as the relationship to the employee and the dependent or beneficiary type. | Periodic Processing (G08BB2), Dep/Ben by Plan ID and Employee
R083491 Dependent/Beneficiary Missing Tax ID, Gender, or DOB | Lists dependent or beneficiary records that do not contain a tax ID, gender, or date of birth. You should notify the appropriate employees so that they can provide this information. | Periodic Processing (G08BB2), Dep/Ben Missing Tax ID, Gender or DOB
R083492 Employee List by Benefit Group | Lists all of the benefit groups and the employees who are enrolled in those benefit groups and includes information about each employee's job type, job step, pay frequency, pay class, and employment status. | Periodic Processing (G08BB2), Employee List By Benefit Group
R083493 Benefit Enrollment by Plan | Lists each plan and the employees enrolled in each plan and includes previously enrolled employees, the ending status, and the ending date. | Periodic Processing (G08BB2), Benefit Enrollment by Plan
R083494 Plans/Options by Group and Category | Lists all benefit groups and benefit categories that are assigned to each group, as well as the benefit plans and options that are assigned to each benefit category. This report includes the plan ID and description for each benefit plan that you set up. It also includes information from the Plan Master program (P08320), including the employee and employer deduction, benefit, accrual (DBA) codes. | Periodic Processing (G08BB2), Plans/Options By Group and Category
R083496 Non-Qualifying Dependents | Lists dependents age and student status, which allows you to determine if they are eligible for benefits. | Periodic Processing (G08BB2), Non-Qualifying Dependents Periodic Processing (G08BB2), All Dependents Over Maximum Age Periodic Processing (G08BB2), Check Student Institutions

This table lists reports that are related to Consolidated Omnibus Budget Reconciliation Act (COBRA):

Report ID and Report Name | Description | Navigation
R08994 (USA) COBRA Payments | Lists all COBRA payments received and compare the payments with their amounts due and payment due dates. Information in the report is based on data in the COBRA Coverage (F08920) and COBRA Payment History (F08994) tables. | Periodic Processing (G05BCOB3), Payments
R089201 (USA) Election Coverage by Type | Lists all types of coverage that are available for a qualified beneficiary. This report includes data from these tables: COBRA Coverage (F08920) Benefits Plan Master (F08320) Plan Additional Options (F083202) | Periodic Processing (G05BCOB3), Election Coverage By Type
R089202 (USA) Elected Plan Premium | Lists premiums for all plans and plan options that a participant elected for COBRA coverage | Periodic Processing (G05BCOB3), Elected Plan Premium
R089203 (USA) COBRA Elected Coverage by Beneficiary | Lists all of the plans and plan option coverages that a dependent or beneficiary has chosen. | Periodic Processing (G05BCOB3), Election Coverage By Beneficiary
R089204 (USA) COBRA Print Election Form | Lists all plans and plan options that a participant is eligible to receive, as well as the cost for each plan. | Daily Processing (G05BCOB2), Print Election Form
R089205 (USA) Dependent Coming of Age | Lists dependents that have reached the age when they are no longer eligible for regular benefits coverage. This age is determined by the criteria that you set up in the processing options. | Periodic Processing (G05BCOB3), Dependent Coming Of Age
R089909 (USA) General Constants | Use this program after you set up the General Constants program (P08990) to print the general constants setup information, including effective dates, coverage information, and grace periods. | Periodic Processing (G05BCOB3), General Constants
R089919 (USA) Qualifying Events Constants | Use this program after you set up information in the Qualifying Event Constants program (P08991) to print a copy of this information. | Periodic Processing (G05BCOB3), Qualified Event Constants
R089941 (USA) Received Payment | Lists all of the payments received that do not match the amount due for that participant. | Periodic Processing (G05BCOB3), Received Payments

### Benefits 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 appendix.

#### R080415 - Dependent/Beneficiary Supplemental Data

To review complete supplemental information for one or more dependents or beneficiaries, run the Dependent/Beneficiary Supplemental Data report. This report compiles all of the supplemental data for a dependent or beneficiary into an easy-to-read format.

#### Processing Options for the Dependent/Beneficiary Supplemental Data Report (R080415)

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

Processing

These processing options specify the information that prints on the report.

1. Tax ID | Specify whether the Tax ID is printed on the report. Values are: Blank: Print. 1: Do not print.
2. Text Information | Specify whether text information is printed on the report. Values are: Blank: Print. 1: Do not print.

#### R083450 - Mandatory Participation Exception

Companies often have one or more benefit plans that are mandatory for some or all employees. The Mandatory Participation Exception report lists all employees who, because of their group status or the requirements of the plan, are not enrolled in the mandatory benefit plans but should be. You can use the report to identify the employees who are not enrolled in the mandatory plans, and then you can enroll them.

#### Processing Options for the Mandatory Participation Exception Report (R083450)

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

Options

This processing options enable you to specify the As Of date.

1. As Of Date | Specify the date to use for processing active employees. If you leave this processing option blank, the system will use the system date.

#### R083460 - Dependent/Beneficiary Exception

Some benefit plans require that employees specify dependents or beneficiaries. Run the Dependent/Beneficiary Exception report to identify employees who are actively enrolled in benefit plans but who have not provided the required information about dependents or beneficiaries. You should notify these employees so that they can provide this information.

Plans that are not active on the as of date and employees who are not enrolled on the as of date are not included in the report.

#### Processing Options for the Dependent/Beneficiary Exception Report (R083460)

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

Options

These processing options enable you to specify the default processing for the report.

1. As Of Date | Specify the date to use for the exception report. Values are: Blank: System date Enter a date.
2. Print Active Enrollment Records | Specify the enrollment records to include in the report. Values are: Blank: Print all records 1: Print active enrollment records only.

#### R083675 - (USA) 401(k) Discrimination Results

After you run the tests to determine key employees and the test that accumulates the results of all previous tests for the current year (average deferral percentage (ADP) and average contribution percentage (ACP)), you run the 401(k) Discrimination Results report (R083675) to determine compliance with governmental regulations for qualified plans.

The 401(k) Discrimination Results report (R083675) performs two tests. In the first test, the ADP and ACP of the nonhighly-compensated employees (NHCE) is multiplied by the multiplier that you entered in the first processing option. If the ADP and ACP of the highly-compensated employees (HCE) is less than the result, the organization passes the test, and the report indicates that the HCE are not overly contributing to a 401(k) plan.

If the first test fails, you run the second test. This test has two parts. To meet the government requirements for NDT, the organization must pass both parts of the second test.

The first part of the second test multiplies the ADP and ACP of the NHCE by the multiplier that you entered in the second processing option. If the ADP and ACP of the HCE is less than the result, the report results indicate that the HCE are not overly contributing to a 401(k) plan.

The second part of the second test adds the ADP and ACP of the nonhighly-compensated group to the factor that you entered in the third processing option. If the ADP and ACP of the HCE is less than the result, the report results indicate that the HCE are not overly contributing to a 401(k) plan.

Note. Data selection for this test must be based on the ADP/ACP test for the test year.

#### Processing Options for the 401(k) Discrimination Results Report (R083675)

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

Default

These processing options specify the default values for the tests that the report performs. Processing options 1, 2, and 3 are the current percentages used for final ADP/ACP testing. By federal regulation, the ADP of HCEs cannot exceed the greater of 1.25 times the ADP of the NHCEs, or the lesser of the following:

- 2 plus the percentage points of the ADP of the NHCEs and

- 2 times the ADP of the NHCEs

The same rules apply when testing the ACP. The system calculates both the ADP and ACP tests together. You complete the processing options as described for the current percentages

1. Processing option #1 - 1.25

2. Processing options #2 - 2

3. Processing option #3 - 2

1. Multiplier - First Test | Specify the multiplier related to the first test.
2. Multiplier - Second Test | Specify the multiplier related to the second test.
3. Factor - Second Test | Specify the factor related to the second test.
4. Print Employee Number and Name | Specify whether to print the employee name and number on the report. Values are: Blank: Print. 1: Do not print.

#### R083676 - (USA) NDT - 415 Nondiscrimination Testing

Governmental regulations specify the maximum percentage that an employee can contribute to deferred plans. To identify employees who contribute more to their deferred plan than the government allows, run the NDT - 415 Nondiscrimination Testing report (R083676). You can print or view the report and review the results each pay period to ensure that all employees remain in compliance. You should run this report after pre-payroll processing is complete.

You run this report when you process a payroll cycle. Coordinate with the payroll department to ensure that the report is set up to run as part of the payroll cycle.

Verify that the NDT - 415 Nondiscrimination Testing Report (R083676) is set up in UDC 07/RJ.

See Setting Up Pay Cycle Reports, Reviewing Payroll Cycle Reports.

#### Processing Options for the NDT - 415 Nondiscrimination Testing Report (R083676)

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

Defaults

This processing option specifies the year to use when selecting history records for the NDT - 415 Nondiscrimination Testing report (R083676).

1. History Records From F06146 | Specify the year (CCYY) to use when selecting records from the Employee Transaction History Summary table (F06146). If you leave this processing option blank, the system will use the system date.

#### R083470 - Benefit Enrollment Outside Group

This report lists all employees who are enrolled in benefit plans that are not available to members of their benefit group. After you identify employees who are enrolled in the wrong benefit group, you can enroll them in the correct benefit plans.

#### Processing Options for the Benefit Enrollment Outside Group Report (R083470)

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

Edits

These processing options specify the effective "as of" date and whether to evaluate all enrollments or only active enrollments.

1. Effective As Of date | Specify the effective As Of date for determining enrollment statistics. A default of blank will use today's date.
2. Evaluate active enrollments | Specify whether all enrollments or only active enrollments should be evaluated. Values are: 0: Evaluate all enrollments based on the As Of date specified in a previous processing option. 1: Evaluate only active enrollments.

#### R083480 - Required Elections in Benefits

This report lists all employees who are not enrolled in any benefit plan within a category that requires plan participation. Also, if you specify a particular plan in the processing option, you can identify the employees who are missing enrollment in that plan.

#### Processing Options for the Required Elections in Benefits Report (R083480)

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

Options

These processing options enable you to specify the default dates and verify employment.

1. Date for determining enrollment status | Specify the effective As Of date for determining enrollment status. If you leave this processing option blank, the system will use the system date.
2. Verify enrollment | Specify the enrollments to evaluate. Values are: Blank: Evaluate all enrollments using the specified As Of date. Enter a plan.

#### R083496 - Non-Qualifying Dependents

Use any of the three dependent status reports to determine whether dependents are eligible for benefits according to their age and student status:

Report Name | Description
Non-Qualifying Dependents | This report lists all dependents who are over the maximum age for all dependents and are not enrolled as full-time students. This report also lists all dependents who are over the maximum age for full-time students, regardless of student status.
All Dependents Over Maximum Age | This report lists all dependents who are over the maximum age for all dependents. Dependents who are full-time students are listed with the names of the schools in which they are enrolled.
Check Student Institutions | This report lists the schools in which all dependents between the maximum age for all dependents and the maximum age for full-time students are enrolled. You can use this list to verify that the schools are accredited institutions.

#### Processing Options for the Non-Qualifying Dependents Report (R083496)

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

General

Calculate the dependent's age as of the specified date range:

1. Beginning Date | Specify the beginning date to use for calculation. A default of blank will use today's date.
2. Ending Date | Specify the ending date to use for calculation. A default of blank will use one day after the Beginning Date.

Max. Age Range

These processing options enable you to specify the maximum age for dependents.

1. Maximum age for which all dependents are eligible. | Specify the maximum age for which all dependents are eligible. When left blank the system uses age 17.
2. Maximum age for which full time students are eligible as dependents. | Specify the maximum age for which full time students are eligible as dependents. When left blank the system uses age 22.

#### R089202 - (USA) Elected Plan Premium

The Elected Plan Premium report provides a list of premiums for all plans and plan options that a participant elected for COBRA coverage. You can also use this report as a tool for COBRA compliance analysis. The report is based on data from the COBRA Coverage table (F08920).

#### Processing Options for the Elected Plan Premium Report (R089202)

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

Display

This processing option specifies the coverage information that appears on the report.

1. Display Option | Specify which fields appear on the Election Coverage by Beneficiary report (R089203). Values are: Blank: All fields appear. 1: DBA details (DBA number and description) are omitted. 2: DBA details and from and through dates are omitted.

#### R089203 - (USA) Election Coverage by Beneficiary

Review the Election Coverage by Beneficiary report to determine all of the plans and plan option coverages that a dependent or beneficiary has chosen. Depending on the processing options that you select, this report can also list the plans that the dependent or beneficiary did not elect for COBRA coverage.

#### Processing Options for the Election Coverage by Beneficiary Report (R089203)

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

Display

This processing option specifies the coverage information that appears on the report.

1. Display Option | Specify the types of coverages that will be displayed. Values are: Blank: The coverages not elected by the beneficiary will be displayed. 1: The coverages elected by the beneficiary will be displayed.

#### R089204 - (USA) COBRA Print Election Form

The COBRA Print Election Form report (R089204) lists all plans and plan options that a participant is eligible to receive, as well as the cost for each plan. Mail this form with the COBRA notification letter so that the participant can make coverage selections from the form. You can also use the report to compare plans and plan options with the COBRA notification letter in order to ensure accuracy.

#### Processing Options for the COBRA Print Election Form Report (R089204)

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

Display

These processing options specify the DBA detail information that appears on the form and the effective date for premium and handling fees.

1. Coverage DBA details and charges | Specify which DBA details and charges appear on the form. Values are: Blank: All DBA details and charges appear. 1: DBA details (DBA number and description) are omitted. 2: DBA details, premium charges, and handling charges are omitted.
2. Effective Date to print new Premium and Handling charges | Specify which Premium and Handling charges are displayed. Values are: Blank: Current records are displayed. Any Date: New Premium and Handling charges are calculated and displayed.

#### R089205 - (USA) Dependent Coming of Age

The Dependent Coming of Age report lists dependents that have reached the age when they are no longer eligible for regular benefits coverage. This age is determined by the criteria that you set up in the processing options.

This report includes data from these tables:

- Participant file (F08901).

- Dep/Ben to Employee Plan X-Reference (F08336).

- Employee Master Information (F060116).

- Address Book - Contact Phone Numbers (F0115).

You must run this program in final mode to create a Dependent Coming of Age qualified event. Simply recording the dependent's birth date in the beneficiary table does not automatically trigger a qualified event when the dependent comes of age. Because this program does not read the event rules, you do not need to set up an event rule for Dependent Coming of Age.

Though the report uses processing options rather than event rules, you must still set up an event constant for DC - Dependent Child in order to define coverage periods and verify that the Send COBRA Letter To Employee option is turned off.

When you run this program, you must also add data selection for Beneficiary Relationship to Employee (BENA) that is equal to the values that you set up in UDC 08/RL for Child or Foster or Step Child. (Generally, these values are C for Child and F for Foster or Step Child). This data selection excludes young spouses that are within the age range of dependent children from being included in the processing.

#### Processing Options for the Dependent Coming of Age Report (R089205)

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

Select

These processing options specify age and qualifying event parameters for the report.

1. Enter Coming of Age for Dependents | Specify the age that defines the legal age (coming of age) of a dependent. When a dependent turns this age, and is not a student, he/she is no longer eligible to be part of an employee's benefits. The dependent may be eligible to pay the premiums for these benefits as part of the U.S. COBRA federal laws.
2. Enter Maximum Age for Dependents | Specify the maximum age of a dependent. When a dependent turns this age, and is or is not a student, he/she is no longer eligible to be part of an employee's benefits. The dependent may be eligible to pay the premiums for these benefits as part of the U.S. COBRA federal laws.
3. Select COBRA Qualified Event for Coming of Age | Specify the COBRA qualifying event that is associated with a dependent coming of age. Values are: BK: Employer's Bankruptcy DC: Dependent Child Status DH: Death DV: Divorce or Legal Separation HR: Work Hour Reduction MC: Medicare Eligibility TM: Termination of Employment

Process

This processing option specifies whether the process runs in proof or final mode.

2. Proof or Update mode. | Specify whether the report will be run in Proof or Final mode. Values are: Blank or 0: Proof Mode. The user may verify the results for accuracy, but no tables are updated. 1: Final Mode. Records are updated in the COBRA Qualified Beneficiary File (F08910) and COBRA Coverage table (F08920).

#### R089909 - General Constants

After you set up the General Constants program (P08990), you can use this report to print the general constants setup information, including effective dates, coverage information, and grace periods.

#### Processing Options for the General Constants Report (R089909)

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

Process

These processing options specify the general constants appear on the report, according to effective date.

1. Effective Date | Specify the effective date to be used for company constant selection. Only the company constants that are active as of the effective date will be reported. If left blank, the default value is the current system date.
2. Report All Company Constants | Specify all company constants regardless of effective date. A default of blank will print only those company constants active on the effective date defined in processing option 1. Values are: Blank: Report only those company constants active on the effective date defined in processing option 1. 1: Report all company constants regardless of effective date.