Skip to content

ctcLink PeopleSoft Reporting

This page, or its linked-to content, may only be available to college system staff.

The following resources, trainings, and materials are available for colleges using PeopleSoft.

First Step

Read the ctcLink PeopleSoft Reporting FAQ

ctcLink PeopleSoft Reporting Documentation

State Enrollment Reporting and Data Quality Training

ctcLink PeopleSoft Query Developer Forms

ctcLink PeopleSoft Query Supporting Documentation

Document Last Updated (MM/DD/YYYY)

Affirmative Action Report Instructions

Commonly Used Tables - Campus Solutions (CS) 12/18/2023
Commonly Used Tables - Finance (FIN) 08/19/2020
Commonly Used Tables - Human Capital Management (HCM) 08/19/2020
College Query Developers & Reporting Leads by College 05/31/2024
College Roles Related to Reporting in ctcLink 06/29/2021
Data Dump Query Protocol 05/06/2020
Go-Live Reporting Resources 02/25/2021
Most Used and Favorite Queries 07/02/2024
Query Development LifeCycle (QDLC) 07/18/2024
Query Development Lessons Learned 2022 12/08/2022

Query Folder List by Pillar


Query Module List by Pillar


Query Prompt Tables to Use by Pillar


Query Secure Tables to Use by Pillar


Query Security Tree Models with Role Definitions


Recommended Methods for Searching Queries and Reports


Report Catalog


Running Large Queries (one-pager)


Structure for Query Manager Access


Weekly Reporting WebEx Agenda


ctcLink PeopleSoft Reporting Online Courses

Course Enrollment

Two categories of reporting-related training are available: End-User Reporting and Designated Query Developer Training.

To enroll in ctcLink PeopleSoft Reporting Canvas courses navigate to the ctcLink Training Registration page and follow the steps for registration.  

End-User Reporting

End-User Reporting courses are open to all ctcLink users.

Designated Query Developer Training

Designated Query Developer Training courses are open to Query Developers who have been designated by their institution. 

To enroll in Designated Query Developer Training courses email requesting to be enrolled in Basic Developer courses.

Basic Developer courses

Once you have obtained Query Manager access in PCD you can email and request to be enrolled in Advanced Developer courses.

Advanced Developer Courses
Pivot Grid Developer Course

ctcLink PeopleSoft Reporting Tools

ctcLink PeopleSoft Reporting Hour Meetings

Join the ctcLink PeopleSoft Reporting Team for our "Reporting Hour" meetings to meet and discuss advanced topics with the team. Check the SBCTC Calendar for information on upcoming Reporting Hour sessions.

Past meeting recordings, presentations, and materials can be accessed in the Reporting Hour Canvas Page. The Canvas Page link is accessible to anyone, anytime.

Past Reporting Hour meeting topics:

  • Reporting Life Cycle of a Student
  • Query Development Lessons Learned 2022


Ivy Brent
Associate Director of ctcLink BI

Adam Fauth
Reporting & BI Solutions Analyst*

Douglas Zeno
Reporting Support Analyst

Emily Mullins
Reporting & BI Solutions Analyst*

Lucy Peterson
Reporting & BI Solutions Analyst*

Paula McDaniel
Data Analytics Learning &Education Instructor

* for ctcLink

Page Manager:
Last Modified: 7/25/24, 11:58 AM

starburst graphic