CHRS Knowledge Base

Process Recommendation Rollover: Retention, Tenure, Promotion

Updated on

Overview

This job aid shows HR Administrators how to process the Retention, Tenure, Promotion (RTP) recommendation rollover.

Background

  • Recommendation rollover is part of the Retention, Tenure, Promotion (RTP) module, which manages tenured/tenure track faculty evaluation data, tracks review cycles, schedules evaluations, and captures recommendations and evaluation outcomes.
  • RTP data is maintained in the Faculty Review Tracking Tables.
  • The rollover process reads records for the current review year.
  • The process exports and imports a CSV file, which the campus reviews and revises. The file is then re-imported for the current year.
  • The export/import process uses the CSU FTP Utility.

Export the RTP Rollover CSV file

Step 1: Navigate to Process Recom Rollover.

Menu > CSU Retention, Tenure, Promo > CSU RTP Processes > Process Recom Rollover

Navbar button

Step 2: Enter a run control ID

  1. Select your Business Unit.
  2. Enter a Run Control ID.

Guidelines

  • You must select a business unit to find your run control ID.
  • If you do not have a run control ID, click Add a New Value to add one.
Run control ID search

Step 3: Set the Run Control Parameters:

  1. Select Export Faculty Review Data.
  2. Set the Cur Review Year: The year that you want copied to the export file.
  3. Set the Next Review Year: The year that will be imported into the Faculty Review Tracking Tables.
  4. Specify the File Name: Use a naming convention that is easy to remember. When you import the file later, you must enter the exact same file name.
    • Example: RTP_[campus]_[review year].csv.
    • The file must be a comma-separated value format (CSV).
Run Control parameters

Step 4: Click Save.

save

The Run Control Parameters are saved.

Step 5: Click Run.

Run

Process Scheduler Request opens.

Step 6: Confirm the process settings:

  1. Specify the active server’s name if needed.
  2. Confirm the process is selected.
  3. Click OK.
Process Scheduler

Step 7: Open Process Monitor.

Process Monitor link

Step 8: Refresh the page until the Distribution Status shows Posted.

Refresh button - distribution status is posted

Step 9: Click Details.

Details

Step 10: Click View Log/Trace.

View Log/Trace link

Step 11: Review the log file.

CSUAW048_39426.LOG
  • The file will shows the Emplid of any employees that were skipped by the export.
  • Employees are skipped if a row already exists for that employee for the next Review Year. The log lists the number of rows that were exported.

Step 12: Click OK to close the Process Detail window.

ok

Step 13: Go back to the Process Recom Rollover page.

Go back to Process Recom Rollover

Step 14: Click CSU File Utilities.

  • Optional: Copy the file name to your buffer first.
CSU File Uitilities

Step 15: Download the file:

  1. Enter the exact filename of the file.
  2. Click Download File.

Guidelines

  • You named this file in step 3.
  • The file is saved to your workstation.
  • The process exports three rows for each Emplid: There are three rows for possible review actions for each employee.
  • The export is a copy of all fields for the Current Review Year entered on the run control.
  • This is the complete file for users to begin their review for what values should be included in the rows in the Next Review Year.
File Name: RTP_FL_2022.csvDownload File button

Edit the RTP Rollover CSV file

A skilled user can edit the CSV file to provide values that should be included in the rows in the next review year.

Guidelines

Do
  • Edit the file in Microsoft Excel or other spreadsheet application.
  • Update the review year column (CSU_REVIEW_YEAR ) to the next review year.
  • Save the file as a CSV file.
  • Delete what you do not want to be loaded to the Faculty Review Tracking Tables. For example, last year’s promotion should not be included in next year’s data.
Do Not
  • Change the file extension.
  • Change the format of the file in any way, such as column headings, field width, column names.

Import the RTP Rollover CSV file

After you have edited the CSV file, you can import it using the next review year.

Step 1: Navigate to Process Recom Rollover.

Menu > CSU Retention, Tenure, Promo > CSU RTP Processes > Process Recom Rollover

Navbar button

Step 2: Enter a run control ID

  1. Select your Business Unit.
  2. Enter a Run Control ID.
Run control ID search

You must select a business unit to find your run control ID.

If you do not have a run control ID, click Add a New Value to add one.

 

Step 3: Set the Processing Option to Import Faculty Review Data.

Import Faculty Review Data

Step 4: Click CSU File Utilities.

CSU File Utilities link

Step 5: Click Upload File.

Upload File button

Step 6: Add the attachment:

  1. Click Choose File to browse to your local file.
  2. Click Upload.
Choose File and Upload buttons

Step 7: Confirm the upload was successful.

Success message

Step 8: Close FTP Utility,

X button

Step 9: Click Run.

Run

Process Scheduler Request opens.

Step 10: Confirm the process settings:

  1. Specify the active server’s name if needed.
  2. Confirm the process is selected.
  3. Click OK.
Process scheduler

Step 11: Refresh the page until the Distribution Status shows Posted.

Refresh button - posted distribution status

Step 12: Click Details.

Details

Step 13: Click View Log/Trace.

View Log/Trace

Step 14: Review the log file.

CSUAW048_39426.LOG
  • The file will shows the rows that were inserted into the Faculty Review Tracking Tables.

End of Article.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article Process Recommendation Transactions: Retention, Tenure, Promotion (RTP)
Next Article Run Personnel Payroll Transfer (PPT) for New Hire