Query Viewer Page

Use the Query Viewer page (QUERY_VIEWER_SRCH) to run the HR_TRANSAFTERORGCHG query to view a list of transferred employees that are affected after the organization change.

Navigation:

Reporting Tools, and then Query, and then Query Viewer

The purpose of this query is to list employees with an effective date greater than the Organization Plan effective date. Employees listed on this report will require manual intervention after the Mass Employee Transfer process has been run.

For example, an employee has the following job data:

Date	Action	DeptID
January 1, 2003	HIR	100
February 1, 2004	PRO	200

You decide to use the Ido functionality to transfer an employee to department 300 effective on January 1, 2004, before the February 1 date that already exists in the employee's record. Effective February 1, this transfer will be canceled due to the future-dated row. In most cases, you will want to update the February 1, 2004 date to reflect the new department, which is 300. This query enables you to detect when this type of situation occurs and manually update employees records after you process the Ido job insert.