9.2 TIAA-CREF Over 6 Pct Report

Purpose: Use this document as a reference for using the custom TIAA-CREF Over 6 Pct Report in ctcLink.

Audience: Benefits Administrators, Payroll Administrators.

This report will be used by Payroll Administrators to help identify those TIAA-CREF 7.5 and 10 percent plans to charge the excess above 6 percent to the correct fund. It does not redistribute the funds, it merely identifies those that need redistribution.

TIAA-CREF Over 6 Pct Report

Navigation:  NavBar > Navigator > Payroll for North America > CTC Custom > CTC Reports > TIAA-CREF Over 6 Pct

  1. The TIAA-CREF Over 6 Pct run control search page displays.
  2. Select the Add a New Value tab.
  3. Enter the desired information into the Run Control ID field.
  4. Select the Add button.
Add a New Value Tab
  1. The Distribute Benefits Charges to Multiple Accounts page displays.
  2. Enter the desired information into the following fields:
    1. Company (college code).
    2. From Date:
      • You may select the calendar icon to find a specific date, or manually enter the dates in the following format: XX/XX/XXXX
      • The dates you choose here will either catch Pay End Dates or not in the report
    3. To Date
  3. Select the Run button.
Run Control Parameters Entry
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
Process Scheduler Request Page
  1. The Distribute Benefits Charges to Multiple Accounts page displays.
  2. Make note of the Process Instance number.
  3. Select the Process Monitor link.
Process Instance Number
  1. The Process Monitor page displays.
  2. From the Process List tab, select the Refresh button until the Run Status is Success and the Distribution Status is Posted. The process is finished once this occurs.
  3. Select the Go back to TIAA-CREF Over 6 Pct link.
Process List Tab
  1. The Distribute Benefits Charges to Multiple Accounts page displays.
  2. Select the Report Manager link.
Report Manager Link
  1. The Report Manager page displays.
  2. From the List tab, select the xlsx (Excel) file link in the Reports section.
Report Manager List Tab
  1. The Report Index page displays.
  2. Select the TIAA-CREF Over Pct.xlsx link in the File List section to open the excel spreadsheet.
Distribution Details File List Section
  1. Once the Excel spreadsheet opens the report you can view detailed information; including a report summary at the bottom of the sheet.
  2. The report contains the following fields, which are mostly taken from the HR Accounting Line tables:
    • RETIRE TITLE (SBRP2 or SBRP3)
    • EMPLOYEE NAME
    • EMPLID
    • EARN TYPE
    • PAY END DATE (based on your date selection when setting the Run Control Parameters prior to running the report)
    • PAYR ACCT (current account being charged)
    • GROSS AMT
    • RETIRE AMT
Report Results in Excel Spreadsheet
Report Summary with Totals
  1. Use the results of this report to adjust from current PAYR ACCT to the new account, as needed.  
    • This will take the cooperation of the local Finance professionals in General Ledger (GL). Contact your local GL accountant to follow the needed adjustment procedure.
  2. You have successfully created and viewed a TIAA-CREF Over 6 Percent Report.
  3. End of Procedure.

0 Comments

Add your comment

E-Mail me when someone replies to this comment