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

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.

• ctcLink PeopleSoft Reporting
  • Training Manual
  • Presentation
• ctcLink PeopleSoft Pivot Grid Viewer
  • Training Manual
• metaLink
  • Training Manual
• Understanding Query Security
  •  Training Manual
  • Presentation

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

• ctcLink PeopleSoft Query Development Life Cycle (QDLC)
  • Training Manual
  • Presentation
• ctcLink PeopleSoft Query 101 Basics
  •  Training Manual
  • Presentation
• 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.

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

• ctcLink PeopleSoft Query 102 Query Security
  •  Training Manual
  • Presentation
• ctcLink PeopleSoft Query 201 Intermediate
  •  Training Manual
  • Presentation
• ctcLink PeopleSoft Query 301 Advanced
  •  Training Manual
  • Presentation
• ctcLink PeopleSoft Query 401 Expert
  •  Training Manual
  • Presentation

Pivot Grid Developer Course

• ctcLink PeopleSoft Query Pivot Grid Wizard
  
  • Training Manual
  • Presentation

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:

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

* for ctcLink