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

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

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)
  • Training Manual
  • Presentation
• ctcLink PeopleSoft Query 101 Basics
  •  Training Manual
  • Presentation
• 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 302 Migrations

Other Recommended Trainings

Additional Query Developer Courses

• ctcLink PeopleSoft Query 401 Expert
  •  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.

Pivot Grid Developer Course

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

End-User Reporting Courses

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
• ctcLink Peoplesoft Insights Dashboard
  • Training Manual
  • Presentation
  • Recording

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