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