Payroll data dependency purge

Payroll data dependency purge

Archive or Purge
Purge
Commit Type (Default)
EVERY_X_RECORDS
Commit Parameters (Default)
BATCH_RECORD_COUNT=200
Default Aging Days
1825 days
Tables affected
SC_WARNING
WBI_OVERRIDE_VALUE
MASS_ENTRY_OVR
TIME_OFF_DAY_OVR
Description/Notes

Removes all payroll data dependency purge. This process involves removing:

  1. All data from TIME_OFF_DAY_OVR table where their ovr_id is in override table for which ovr_start_date is before the aging date and ovrtyp_id is:
    • >= 700 and < 900
    • Are not >= 1500 and < 1600
    • Are not >= 400 and < 500
  2. All data from MASS_ENTRY_OVR table where their ovr_id is in override table for which ovr_start_date is before the aging date and ovrtyp_id is:
    • >= 700 and < 900
    • Are not >= 1500 and < 1600
    • Are not >= 400 and < 500
  3. All data from WBI_OVERRIDE_VALUE table where their ovr_id is in override table for which ovr_start_date is before the aging date and ovrtyp_id is:
    • >= 700 and < 900
    • Are not >= 1500 and < 1600
    • Are not >= 400 and < 500
  4. All data from SC_WARNING table where their ovr_id is in override table for which ovr_start_date is before the aging date and ovrtyp_id is:
    • >= 700 and < 900
    • Are not >= 1500 and < 1600
    • Are not >= 400 and < 500