Purging Person Data for Backed-Out and Voided Life Events

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.

arrow icon   To purge person data for backed-out and voided life events:

  1. Select Purge Backed-out Or Voided Life Events in the Name field.

  2. Enter the Effective Date of the process.

  3. 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.

  4. Enter a From and To Occurred Date to limit the purge to events that occurred within that date range.

  5. You can select from a variety of parameters that limit the purge to a specific group of persons:

  6. 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.

  7. Select Yes in the Audit Log field to generate a results log for this process that indicates the number of rows deleted.

  8. 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.

  9. Click OK.

  10. 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