This chapter contains the following topics:
Section 27.1, "Understanding Benefits Self-Service Work Files"
Section 27.2, "Purging the Employee Current and Pending Elections Work Table"
Section 27.3, "Purging the Dependent and Beneficiary Cross-Reference Work Table"
Section 27.4, "Purging the Current Dependent and Beneficiary Cross-Reference Work Table"
Section 27.5, "Purging the Employee Personal Information, Contacts, and Phone Work Tables"
Section 27.6, "Purging the Available Plans and Plan Options Work Table"
Before each annual open benefits enrollment, you should remove old data from your self-service work files. By removing old data, you reduce the possibility that the system could save old data that is no longer applicable to the current work force in the live tables.
This section provides an overview and discusses how to run the Purge Employee Current/Pending Elections Work Table.
You can use the Purge Employee Current/Pending Elections Work Table program (R085540) to remove existing data from the Employee Current/Pending Elections Work Table (F085530W). This program also uses data in the Employee Master Information table (F060116).
From the Employee Self Service General Mgmt (G08BESS327), Purge Employee Current/Pending Work Table.
This section provides an overview of the Purge Dependent/Beneficiary X-Reference Table program and discusses how to:
Run the Purge Dependent/Beneficiary X-Reference Table program.
Set processing options for the Purge Dependent/Beneficiary X-Reference Table program.
You can use the Purge Dependent/Beneficiary X-Reference Table program (R085542) to remove existing data from the Dependent/Beneficiary X-Reference Work Table (F085536W). This program also uses data in the Employee Master Information table (F060116).
You can set a processing option to specify whether this program deletes records that have not been saved to live files. You can also set a processing option to specify the type of enrollment.
You might want to set up an additional version of this UBE so that you can run one version prior to open enrollment and another version for benefit enrollments that are based on life events.
From the Employee Self Service General Mgmt (G08BESS327), Purge Dependent/Beneficiary X-Reference Table.
Processing options enable you to specify the default processing for programs and reports.
Use these processing options to specify whether the program removes data that the system has not saved in live tables. You can also designate the type of enrollment records that the system removes.
Specify whether the system removes unprocessed records from the Dependent/Beneficiary X-Reference Work Table (F085536W) that have not been saved in live tables. Values are:
Blank: Keep (do not delete) unprocessed records.
1: Delete unprocessed records.
Specify the type of records that the system removes from the Dependent/Beneficiary X-Reference Work Table (F085536W). Values are:
1: Open Enrollment
2: Current Enrollment
This section provides an overview and discusses how to run the Purge Current Dep/Ben X-Reference Work Table program.
You can use the Purge Current Dependent/Beneficiary X-Reference program (R085543) to remove existing data from the Current Dep/Ben X-Reference Work Table (F085537W). This program also uses data in the Employee Master Information table (F060116).
From the Employee Self Service General Mgmt (G08BESS327), Purge Current Dependent/Beneficiary X-Reference.
This section provides an overview of the Purge Employee Personal, Contact, Phone Work Tables program and discusses how to:
Run the Purge Employee Personal, Contact, Phone Work Tables program.
Set processing options for the Purge Employee Personal, Contact, Phone Work Tables program.
You can use the Purge Employee Personal/Contact/Phone program (R054040) to remove existing data from these tables:
Employee Personal Profile Information Work (F054101W)
Employee Emergency Contact Work (F054111W)
Employee Phone Number Work (F054115W)
This program also uses data in the Employee Master Information table (F060116).
You can set processing options to specify whether you want the system to remove records that have not been previously saved in live tables.
From the Employee Self Service General Mgmt (G08BESS327), Purge Employee Personal/Contact/Phone.
Processing options enable you to specify the default processing for programs and reports.
Use this processing option to specify whether you want the system to remove data that has not been saved in live tables.
Specify whether the system removes records that have not been saved in live tables. The system removes records from these tables:
Employee Personal Profile Information Work Table (F054101W).
Employee Emergency Contact Work Table (F054111W).
Employee Phone Number Work Table (F054115W).
Values are:
Blank: The system keeps unprocessed records (does not delete).
1: The system removes unprocessed records.
This section provides an overview of the Purge Available Plans/Plan Options program and discusses how to:
Run the Purge Available Plans/Plan Options program.
Set processing options for the Purge Available Plans/Plan Options program.
You can use the Purge Available Plans and Plan Options by Employee Table to remove existing data from the Available Plans and Plan Options by Employee Work Table (F085520W).
You can set a processing option to specify whether you want the system to remove records that have not been saved to live tables. You might also want to set up a second version of this program. You can set a processing option so that one version removes open enrollment records and the second version removes life event enrollment records.
From the Employee Self Service General Mgmt (G08BESS327), Purge Available Plans/Plan Options.
Processing options enable you to specify the default processing for programs and reports.
Use these processing options to specify whether you want the system to remove records that have not been saved in the live tables. You can also specify the type of enrollment event records that you want removed.
Specify whether unprocessed records that have not been updated to live tables should be deleted from the Available Plans and Plan Options by Employee Work Table file (F085520W). Values are:
Blank: The system keeps (does not remove) records that have not been saved in live tables.
1: The system removes records that have not been saved in live tables.
Specify the type of records that the system removes from the Available Plans and Plan Options by Employee Work Table (F085520W). Values are:
1: Open enrollment
2: Current enrollment