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

07/23/2020
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

05/31/2024

Query Module List by Pillar

09/15/2022

Query Prompt Tables to Use by Pillar

07/25/2024

Query Secure Tables to Use by Pillar

01/27/2023

Query Security Tree Models with Role Definitions

07/11/2024

Recommended Methods for Searching Queries and Reports

01/13/2017

Report Catalog

07/02/2024

Running Large Queries (one-pager)

04/28/2021

Structure for Query Manager Access

08/23/2023

Weekly Reporting WebEx Agenda

11/27/2017

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 dataservices@sbctc.edu requesting to be enrolled in Basic Developer courses.

Basic Developer courses

Once you have obtained Query Manager access in PCD you can email dataservices@sbctc.edu 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

Contacts

Ivy Brent
Associate Director of ctcLink BI
ibrent@sbctc.edu
360-704-3905

Adam Fauth
Reporting & BI Solutions Analyst*
afauth@sbctc.edu
360-704-1033

Douglas Zeno
Reporting Support Analyst
dzeno@sbctc.edu
360-704-4335

Emily Mullins
Reporting & BI Solutions Analyst*
emullins@sbctc.edu
360-704-1035

Lucy Peterson
Reporting & BI Solutions Analyst*
lpeterson@sbctc.edu
360-704-1046

Paula McDaniel
Data Analytics Learning &Education Instructor
pmcdaniel@sbctc.edu
360-704-3913

* for ctcLink

Page Manager: dzeno@sbctc.edu
Last Modified: 7/25/24, 11:58 AM

starburst graphic