Reverse Job Effective Dated Row

PURPOSE: Use this document as a reference for removing a new effective date row in Job Data, that was created incorrectly as a result of the Job Effective Dated Row Insert process, for a single group of employees.

AUDIENCE: Human Resource Specialists and/or Human Resource Administrators

WARNING: All data entries for this process must be identical to the data entries used for the Job Effective Dated Row Insert that is being removed (i.e. Company, Effective Date, Action, Reason, Pay Group).

Navigation: Main Menu  > Workforce Administration > CTC Custom > CTC Processes > Reverse Job Eff. Dated Row

  1. Click the Add New Value tab. (This step is strictly for the first run; after that you may use this new run control).
  2. Create a Run Control (something unique and easy to remember).
  3. Click the Add button.
Add a New Value tab
  1. Select the appropriate Company.
  2. Enter/Select the Effective Date for the Job Data Insert.
  3. Select the appropriate Action for the Job Data Record.
  4. Select the appropriate Reason (optional but highly recommended).
  5. Select the appropriate PayGroup.
  6. Select the appropriate Department (if applicable).
  7. Click Run (this will open the Process Scheduler request page)
Process Request Parameters section
  1. Click OK (this will activate the run).
Process Scheduler Request page
  1. Click the Process Monitor hyperlink to view the progress of the request.
Process Monitor link
  1. Click Refresh until the Run Status changes to Processing then to Success, and the Distribution Status changes to Posted.
  2. Click the Go back to Reverse Job Eff. Dated Row hyperlink.
Process List tab
  1. Click the Report Manager hyperlink.
Report Manager hyperlink
  1. Click the  CTC_XJEDI_AE report link.
Reports section
  1. Click the JOB_EFFECTIVE_DATE hyperlink to view the actual results. (A separate window will appear containing the results. It is best to save or print these results for validation).
File List section

NOTE: You should ALWAYS VALIDATE your data at the end of this process. Select a few individuals from the report to validate in Job Data.  (Navigation: Main Menu >  Workforce Administration > Job Information > Job Data)

Congratulations you have successfully inserted an Effective Dated Row into Job Data for a single Pay Group!!!!