With the exception of unrestricted life events, you can back out or void any type of life event for a person. You should periodically purge this backed-out and voided data to reduce the volume of person data stored in your database.
You can purge person data related to backed-out and voided life events for Advanced Benefits and Compensation Workbench plans. The purge process removes a variety of data such as enrollment rates, premium results, and electable choice information.
You run processes from the Submit Requests window.
Select Purge Backed-out Or Voided Life Events in the Name field.
Enter the Effective Date of the process.
Select the Life Event for which you want to purge backed-out or voided person data.
Or, select a Life Event Type to purge all backed-out or voided instances of that life event type.
Enter a From and To Occurred Date to limit the purge to events that occurred within that date range.
You can select from a variety of parameters that limit the purge to a specific group of persons:
Person Name
Person Selection Rule
Organization
Location
Benefits Group
Legal Entity
Payroll
Select a Backed Out Status of Voided or Backed Out.
If you select Backed Out, the process purges data related to both backed-out and voided life events.
Select Yes in the Audit Log field to generate a results log for this process that indicates the number of rows deleted.
Select Yes in the Delete Life Events field to remove potential life events with a status of Voided.
Selecting Yes does not remove potential life events with a status of Unprocessed.
Click OK.
Complete the batch process request and click Submit.
The purge process deletes data from the tables listed below. To improve system performance, a database administrator should optimize these tables through sizing, indexing, and standard performance tuning after purging data.
Ben_elig_per_f
Ben_elig_per_opt_f
Ben_enrt_rt
Ben_enrt_prem
Ben_enrt_bnft
ben_elctbl_chc_ctfn
ben_elig_per_elctbl_chc
ben_pil_elctbl_chc_popl
ben_elig_dpnt
ben_prtt_rt_val
ben_prtt_enrt_actn_f
ben_prtt_prem_f
ben_prtt_enrt_ctfn_prvdd_f
ben_elig_cvrd_dpnt_f
ben_prtt_enrt_rslt_f
ben_pl_bnf_f