This appendix contains the following topics:
The reports listed in each table are sorted alphanumerically by report ID.
Report ID and Report Name | Description | Navigation |
---|---|---|
R080405 | Lists all supplemental data for dependents and beneficiaries, organized by data type. | Dependent Beneficiary Supplemental Data (G08BSDD2), Dep/Ben Data by Data Type |
R080415 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Lists all types of coverage that are available for a qualified beneficiary.
This report includes data from these tables:
|
Periodic Processing (G05BCOB3), Election Coverage By Type |
R089202 | Lists premiums for all plans and plan options that a participant elected for COBRA coverage | Periodic Processing (G05BCOB3), Elected Plan Premium |
R089203 | Lists all of the plans and plan option coverages that a dependent or beneficiary has chosen. | Periodic Processing (G05BCOB3), Election Coverage By Beneficiary |
R089204 | 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 | 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 | 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 | 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 | Lists all of the payments received that do not match the amount due for that participant. | Periodic Processing (G05BCOB3), Received Payments |
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.
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 enable you to specify the default processing for programs and reports.
These processing options specify the information that prints on the report.
Specify whether the Tax ID is printed on the report. Values are:
Blank: Print.
1: Do not print.
Specify whether text information is printed on the report. Values are:
Blank: Print.
1: Do not print.
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 enable you to specify the default processing for programs and reports.
This processing options enable you to specify the 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.
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 enable you to specify the default processing for programs and reports.
These processing options enable you to specify the default processing for the report.
Specify the date to use for the exception report. Values are:
Blank: System date
Enter a date.
Specify the enrollment records to include in the report. Values are:
Blank: Print all records
1: Print active enrollment records only.
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 enable you to specify the default processing for programs and reports.
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
Processing option #1 - 1.25
Processing options #2 - 2
Processing option #3 - 2
Specify the multiplier related to the first test.
Specify the multiplier related to the second test.
Specify the factor related to the second test.
Specify whether to print the employee name and number on the report. Values are:
Blank: Print.
1: Do not print.
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.
Processing options enable you to specify the default processing for programs and reports.
This processing option specifies the year to use when selecting history records for the NDT - 415 Nondiscrimination Testing report (R083676).
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.
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 enable you to specify the default processing for programs and reports.
These processing options specify the effective "as of" date and whether to evaluate all enrollments or only active enrollments.
Specify the effective As Of date for determining enrollment statistics. A default of blank will use today's date.
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.
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 enable you to specify the default processing for programs and reports.
These processing options enable you to specify the default dates and verify employment.
Specify the effective As Of date for determining enrollment status. If you leave this processing option blank, the system will use the system date.
Specify the enrollments to evaluate. Values are:
Blank: Evaluate all enrollments using the specified As Of date.
Enter a plan.
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 enable you to specify the default processing for programs and reports.
Calculate the dependent's age as of the specified date range:
Specify the beginning date to use for calculation. A default of blank will use today's date.
Specify the ending date to use for calculation. A default of blank will use one day after the Beginning Date.
These processing options enable you to specify the maximum age for dependents.
Specify the maximum age for which all dependents are eligible. When left blank the system uses age 17.
Specify the maximum age for which full time students are eligible as dependents. When left blank the system uses age 22.
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 enable you to specify the default processing for programs and reports.
This processing option specifies the coverage information that appears on the report.
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.
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 enable you to specify the default processing for programs and reports.
This processing option specifies the coverage information that appears on the report.
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.
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 enable you to specify the default processing for programs and reports.
These processing options specify the DBA detail information that appears on the form and the effective date for premium and handling fees.
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.
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.
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 enable you to specify the default processing for programs and reports.
These processing options specify age and qualifying event parameters for the report.
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.
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.
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
This processing option specifies whether the process runs in proof or final 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).
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 enable you to specify the default processing for programs and reports.
These processing options specify the general constants appear on the report, according to 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.
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.