This conversion cycle consists of Education and Tenure Data which includes but is not limited to:

• Degree
• Tenure

These records can be validated using the same criteria as used in the Employment/Job Data validation to ensure that employee Degree and Tenure Information has been accurately converted from Legacy to PeopleSoft.

There are multiple fields and screens within the Legacy system that are being converted to the PeopleSoft Job Information fields and pages.

The Validation Results and Feedback are due NO LATER THAN on the last day of the Data Validation Period. It is strong recommended that issues  are reported EARLY in the validation period and are not held until the end of the period. Validation Results and Feedback are for reporting closure of the college's validation activities for the conversion cycle.  To view a list of the validation periods please refer to the timeline topic in the Data Validation Overview - Getting Started Guide.

Questions about the conversion or conversion validation work can be directed to:

HCM Project Manager: Sanjiv Bhagat [email protected]

• Any employees hired into PPMS before the date of the Legacy snapshot will not be included in the data results for the current cycle.
• Since ctcLink (PeopleSoft) is an integrated system, an employee must have a record in Job Data in order for the Faculty Events and/or Profile Management record to exist within the system. If an employee coming in from PPMS was not converted successfully into Job Data, there will be no Tenure and/or Degree record.
• Both the Educ Level and Educ Level Yr fields must be populated on screen PS0004 in order for the Degree information to convert to ctcLink
• Tenure will not convert if the TENURE IND and TENURE DATE fields are blank on screen PS0001

Data validatiors should review 50% of their converted records very closely, while making sure that most of the remaining population is correct at a glance.

The project team has created queries specific to the areas in which validation is required. Start by navigating to the Query Viewer page: NavBar > Navigator > Reporting Tools > Query > Query Viewer

1. Click New Window in the upper right hand corner
2. Click the Home button (it looks like a house and is located above the Help button in the upper right hand corner)
3. At this point there should be two browser windows open, one with the Query Viewer, and one with the Personal Information page

In the Query Viewer window, click the drop down box next to Search By and select Folder Name. In the box next to “begins with”, type VALIDATION and click the Search button.

The following queries should appear:

• CTC_VALIDATE_TENURE shows all Faculty Tenure Status information
• CTC_VALIDATE_PERSON_DEGREE shows employee education details from the Person Profile

Click “Run to Excel” on any of the queries to run the query in a new window. This will allow sorting and filter capabilities. Make sure the pop up blocker in your browser is not blocking the ability to run the query.

After selecting a query to run, use the magnifying glass in the query window to select a viable Company code from the table (or type in your college number), and Click “View Results” to display the Excel file output.