Payroll data
Payroll data
- Archive or Purge
- Archive
- Commit Type (Default)
- Every_X_Employee
- Commit Parameters (Default)
- EMP_BATCH_SIZE=10
- CONTROLLING_POLICY_PRIORITY=60
- Default Aging Days
- 2557 days
- Tables affected
- OVERRIDE
- WORK_DETAIL_ADJUST
- EMPLOYEE_BALANCE_LOG
- CLOCK_TRAN_PROCESSED
- WORK_DETAIL WORK_SUMMARY
- TIMESHEET_LOCK MASS_ENTRY_OVR
- SC_WARNING WBI_OVERRIDE_VALUE
- TIME_OFF_DAY_OVR
- EMPLOYEE_SCHEDULE
- Description/Notes
- Payroll Data will be archived for all employees.
- Moves all payroll data to the archive schema. This process
involves moving:
-
- All data from the WORKBRAIN_SUMMARY table where wrks_work_date is
before the aging date and matches the emp_id of the employee whose records are being
archived.
- All data from the WORK_DETAIL table for the work summaries
identified in #1.
- All data from the CLOCK_TRAN_PROCESSED table for the work
summaries identified in #1.
- All data from the EMPLOYEE_BALANCE_LOG table for the work
summaries identified in #1.
- All data from the EMPLOYEE_SCHEDULE table where WORK_DATE falls in
WRKS_WORK_DATE of work summaries identified in #1.
- All data from the WORK_DETAIL_ADJUST table where wrkda_work_date
is before the aging date and matches the emp_id in #1.
- All data from OVERRIDE table where 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
For emp_id in #1.
- All data from the MASS_ENTRY_OVR table where ovr_id is in the
overrides identified in #7.
- All data from the SC_WARNING table ovr_id is in the overrides
identified in #7.
- All data from the WBI_OVERRIDE_VALUE table where ovr_id is in the
the overrides identified in #7.
- All data from the TIME_OFF_DAY_OVR table where ovr_id is in the
overrides identified in #7.
- All data from the TIMESHEET_LOCK table where tsl_end_date is
before the aging date and matches the emp_id in #1.