Understanding the Available Plans Workfile

An expert system administrator can use the Available Plans and Plan Options by Employee program (P085520W) to enter changes to the data in the Available Plans and Plan Options by Employee Work Table (F085520W) before the system stores the temporary information from this table in the live tables.

After you build the Available Plans and Plan Options by Employee Work Table, this table provides a current picture of all the available benefit plans and benefit plan options from which an employee can choose. As employees enter changes, this file records the changes that are active for the upcoming benefit plan year.

A system administrator might enter changes to this table to correct data errors or to change information that is not accessible to an employee. For example, an employee is unable to update benefits choices during open enrollment and open enrollment is now closed. During open enrollment, the system automatically assigned the current benefit choices as the choices for the upcoming benefit year. The records in the Available Plans and Plan Options by Employee Work Table confirm that the employee is enrolled in a Preferred Provider Option benefit plan (PPO) for the upcoming benefit year. The employee wants to change medical coverage from a PPO plan to an HMO plan. The system administrator can use the Available Plans and Plan Options by Employee program to remove the employee enrollment in the PPO plan and record an enrollment in an HMO plan. The system administrator must be aware that if dependents are affected by the benefit plan change, all issues that might be related to the change must be manually addressed. The system does not review, track, or implement related changes to this or other tables.