ctcLink PeopleSoft Reporting

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

• State Enrollment Reporting and Data Quality Training on Canvas
• State Enrollment Reporting and Data Quality Training Guide

ctcLink PeopleSoft Query Developer Forms

• Nondisclosure Form
• Query Migration Request Form

ctcLink PeopleSoft Query Supporting Documentation

ctcLink PeopleSoft Reporting Online Courses

Course Enrollment for Designated Query Developer and End User Training

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

To enroll in upcoming instructor led ctcLink PeopleSoft Query Development courses, navigate to the SBCTC Calendar and under “Filter by Calendar”, click the Reporting Training hyperlink then follow the instructions to sign up.

Designated Query Developer Training

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

Courses Required for Query Manager Access

• ctcLink PeopleSoft Query Development Life Cycle (QDLC)
• ctcLink PeopleSoft Query 101 Basics
• ctcLink PeopleSoft Query 102 Query Security
• ctcLink PeopleSoft Query 201 Intermediate
• ctcLink PeopleSoft Query 301 Advanced
• ctcLink PeopleSoft Query 302 Migrations

Other Recommended Trainings

Additional Query Developer Courses

• ctcLink PeopleSoft Query 401 Expert
• ctcLink PeopleSoft Query Fundamentals Lab
  • Join us every Thursday at 11AM to learn the fundamentals of query development and ask any questions you might have. Join via Webex at the time of the meeting or email dataservices@sbctc.edu to request a calendar invite.

Pivot Grid Developer Course

• ctcLink PeopleSoft Query Pivot Grid Wizard

End-User Reporting Courses

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

• ctcLink PeopleSoft Reporting
• ctcLink PeopleSoft Pivot Grid Viewer
• metaLink
• Understanding Query Security
• ctcLink Peoplesoft Insights Dashboard

ctcLink PeopleSoft Reporting Tools

• metaLink - Data Dictionary, Query, Report and View search tool
  • How to use metaLink
• Quick Reference Guides (QRGs) and Materials

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:

• State Level Reporting and Data Quality – Spring 2019
• Commonly Used Tables and Views – Fall 2019
• Reporting Life Cycle of a Student – Fall 2022
• Query Development Lessons Learned – Winter 2022
• Searching Queries and Reports – Fall 2023
• Query Development Lessons Learned Part 2 – Spring 2024