|
Combined Benefits and Benefits Communications
The templates delivered with the Benefits Communications Toolkit are designed to make running reports out of Oracle® as efficient as possible. The templates are loaded through and can be customized within Microsoft® Excel, Word and Access.
Delivered Kubes
A brief summary of each Kube and the templates associated with it is included here:
Benefit Statement
- Benefit Confirmation Statement
Form letter that provides a confirmation statement for each employee that lists out the plans and options they have selected, the total benefit amount, the period and annual contributions, as well as the employer's annual contribution. Can be merged to paper, fax and e-mail.
Return to List of Kubes
Benefits Confirmation
- Benefits Confirmation
The Benefits Confirmation documents are sent after employees have enrolled in plans and are used as a confirmation of their elections. It includes plans and rates as well as dependents and beneficiaries. It is an excellent communication tool for open enrollment.
Return to List of Kubes
Dependents and Beneficiaries
- Covered Dependents
This template breaks out the number of employees by option for each plan. This is useful in reconciling what is in Oracle® and what vendors have on file.
- Plan Beneficiaries
This template has a similar purpose as Covered Dependents except this one lists out plans with beneficiaries.
Return to List of Kubes
Return to List of Kubes
Enrollment Results
- Enrollment Actions Items
Enrollment Action Items are generated during the enrollment process (if they have been configured) and identify further actions that must be completed before enrollment is complete. This template breaks out actions based on their completion status and lists what plans and options have outstanding actions. An employee count and due date is provided for each entry. This template helps organizations ensure employees have finalized their enrollment by the necessary due dates.
- Enrollment Results - Counts
This template provides an employee count by plan and option for each plan type and program. This template is especially useful for plans that have no rates associated with them and also allows for usage analysis during Open Enrollment decision-making.
- Enrollment Results - Rates
This template allows for cost analysis of plans and options by program and activity type (i.e. Employee vs. Employer Payroll contribution). Tax type is also included to display when the various options are deducted. Communicated Amount refers to what the employee is being told they are paying by period. Defined Amount is how that rate is actually defined in the system. Annual Amount is Defined Amount annualized. This allows for comparison against actual element values.
- Excess Credits
Excess Credits refer to “cafeteria-style” benefits and can be analyzed in this template (as long as a flex credit program has been configured). The template summarizes by plan, pool, and benefit, how much money has been provided to employees, how much has actually been used, how much has been cashed out, as well as any roll-ups and forfeitures. This is very useful in determining appropriate amounts for flex credit programs.
- Monthly Participant Premiums
This template tracks what employers are required to pay the vendor based upon employee enrollment. The template lists out the number of employees and the premium value for each plan. A higher-level view of the template displays totals by Payer, Supplier, and Type. If Regular Premiums, Stop Premiums, and ASO fees have been configured, those are also captured here. The template is very useful for making Open Enrollment decisions regarding plans and vendors.
Return to List of Kubes
Life Events
- Person Life Events
Life Events define events in a person’s life that may result in changes to a person’s available benefits (i.e. marriage). This template captures what life events have occurred, the date they occurred, and how many employees are associated with each event. This is useful in ensuring employees make necessary changes to their enrollments in the allotted amount of time as well as ensuring current configurations are adequately capturing all events. The report is broken out by status to make analysis easier. Started indicates that the person has electable choices to make. Processed indicates that the event was processed and closed (usually indicates electable choices have been assigned). Voided indicates that the life event should not be processed and all prior electable choices should be restored. Backed Out indicates the life event can be re-processed if desired.
- Person Potential Life Events
This template is best run before Open Enrollment to see what Life Events need to be addressed before Open Enrollment. This is especially useful in determining if any Life Events are firing off erroneously. The template lists out the number of employees that have each potential life event by date. The report is summarized by status to allow for easier analysis. Detected indicates the change to the person was made in the HR Form. Changes made in the OAB Life Events form will have a status of unprocessed (sometimes these direct changes can cause issues because not all electable choices are viewable). Voided indicates that the life event was captured but backed out to prevent it from processing.
Return to List of Kubes
Total Compensation
- Total Compensation
This Kube retrieves all current benefits and salary data from the database and displays it in a Microsoft® Access document, ready to distribute to your employees. The Total Compensation report uses graphics and annual totals of the company’s contributions to the employee’s compensation package.
Return to List of Kubes
|
