Table Information for the Purge Data Screen

The Purge ESS Data process deletes records from several tables.

Updated tables include:

Purge Benefits Options

  • Benefit Enrollment
    • HB_EMPL_OPENENROLL
  • Life Event 
    • HB_EMPL_LE_ENROLL

Purge ESS  Employee Benefit Elections

  • Benefit Enrollment
    • HB_EMPL_ESS_ELEC
    • HB_EMPL_ESS_BNFIC
    • HB_EMPL_ESS_LIFE
  • Life Event
    • HB_EMPL_LE_ELEC
    • HB_EMPL_LE_BNFIC
    • HB_EMPL_LE_LIFE
    • ESS_UF_HDR
    • ESS_UF_LN

Purge ESS Dependent Benefit  Elections

  • Benefit Enrollment 
    • HB_DEP_ESS_ELEC
  • Life Event 
    • HB_DEP_LE_ELEC