ctcLink PeopleSoft Reporting

State Enrollment Reporting and Data Quality Training on Canvas

State Enrollment Reporting and Data Quality Training Guide

Nondisclosure Form

Query Migration Request Form

Affirmative Action Report Instructions

Commonly Used Tables - Campus Solutions (CS)

Commonly Used Tables - Finance (FIN)

Commonly Used Tables - Human Capital Management (HCM)

College Query Developers & Reporting Leads by College

College Roles Related to Reporting in ctcLink

Data Dump Query Protocol

Go-Live Reporting Resources

Most Used and Favorite Queries

Query Development LifeCycle (QDLC)

Query Development Lessons Learned 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

 

Basic Developer Courses:
Query Development Life Cycle (QDLC)	Training Manual	Presentation
PS Query 101 Basics	Training Manual	Presentation
Advanced Developer Courses:
PS Query 102 Security	Training Manual	Presentation
PS Query 201 Intermediate	Training Manual	Presentation
PS Query 301 Advanced	Training Manual	Presentation
End User Courses:
Understanding ctcLink Query Security	Training Manual	Presentation
PS Reporting	Training Manual	Presentation
PS Pivot Grid Viewer	Training Manual
Pivot Grid Developer Course:
ctcLink Pivot Grid Wizard 101 Basics	Training Manual

 

Course Enrollment

To enroll in ctcLink PeopleSoft Reporting Canvas courses as a Query Developer please send an email to dataservices@sbctc.edu with the subject line "Canvas Enrollment Request". In the body section of the email please list all courses you would like to be enrolled in. A Data Services team member will add you to the requested courses. Once added, you can log in to Canvas and join the course.

Basic Developer Courses required for Query Manager Access in PCD:

• Query Development Life Cycle (QDLC) 
• PS Query 101 Basics 

Advanced Developer Courses:

• PS Query 102 Security
• PS Query 201 Intermediate
• PS Query 301 Advanced
• PS Query 401 (Coming Soon)

Pivot Grid Developer Courses:

• Pivot Grid Wizard 101 Basics

Additional recommended Courses for Developers:

• How to Use metaLink
• Query Fundamentals Labs
  
  • Step-by-step instructions on topics covered during the weekly lab

End User Courses:

End users can enroll in these trainings to expand their understanding of PS Reporting by completing the Registration Form on the SBCTC Training Registration Page.

• PS Query Reporting for End Users
• PS Pivot Grid Viewer
• Understanding Query Security

Quality Assurance Reporting System (QARS)

• QARS Access Request Form (Standard)
• QARS Access Request Form (Fillable)
• QARS QRG
• QARS Report Guide

metaLink

(Data Dictionary and Query/Report/View Script Search)

• How to use metaLink

Quick Reference Guides (QRGs) and Materials

 

Join the ctcLink PeopleSoft Reporting Team for our "Reporting Hour" meeting quarterly 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