ctcLink PeopleSoft Reporting

State Reporting Training (CANVAS)

Nondisclosure Form

Query Migration Request Form (Example ONLY - Migration requests must be submitted through the ticketing system)

College Roles Related to Reporting in ctcLink

Structure for Query Manager Access

Report Catalog

Query Development LifeCycle (QDLC)

Go-Live Reporting Resources

Query Tree Models with Role Definitions

College Query Developers & Reporting Leads by College

Prompt Tables to Use

Query Folder List per Pillar

Query Module List by Pillar

Campus Solutions Commonly Used Tables

Finance Commonly Used Tables

Human Capital Management Commonly Used Tables

Most Used and Favorite Queries

Running Large Queries (one-pager)

Affirmative Action Report Instructions

Data Dump Query Protocol

Recommended Methods for Searching Queries and Reports

Weekly Reporting WebEx Agenda

 

QDLC Training Manual

QDLC Training Presentation

PS Query 101 Training Manual

PS Query 101 Training Presentation

PS Query 201 Training Manual

PS Query 201 Training Presentation

PS Query 301 Training Manual

PS Query 301 Training Presentation

PS Reporting Training Manual (End-user course for using queries; not developing them)

PS Reporting Training Presentation (End-user course for using queries; not developing them)

PS Pivot Grid Viewer Training Manual (End-user course for using Pivot Grid Viewer; not developing Pivot Grids)

ctcLink Pivot Grid Wizard 101 Basics Training Manual

Query Development Life Cycle (QDLC) Canvas Course  (Required course for Query Manager Access in PCD)

PS Query 101 Basics Canvas Course (Required course for Query Manager Access in PCD)

PS Query 201 Intermediate Canvas Course

PS Query 301 Advanced Course

PS Query Reporting Canvas Course (End-user course for using queries; not developing them)

PS Pivot Grid Viewer Course (End-user course for using Pivot Grid Viewer; not developing Pivot Grids)

Pivot Grid Wizard 101 Basics Canvas Course

How to Use metaLink Course

Fundamentals Lab Canvas Course (Step-by-step instructions on topics covered during the weekly lab)

Quality Assurance Reporting System (QARS)

• QARS Access Request Form
• QARS QRG
• QARS Report Guide

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

• How to use metaLink

Quick Reference Guides (QRGs) and Materials