Recommended Methods for Searching Queries and Reports
Purpose: To outline the best methods for finding queries and reports
Audience: All ctcLink users
ctcLink Reference Center
test
Topics
-
Coding and SBCTC Reporting 10
- SBCTC Student & Course Coding Manual
- Classification of Instructional Programs (CIP) 2020
- SBCTC Coding Guidelines Tab
- SBCTC Coding Memos Tab
- Data Alerts
- Data Warehouse Data Dictionaries (Legacy to PS Mapping for Key Tables)
- Data Warehouse Distribution and Definitions
- MIS Reporting Calendars and Documentation
- Legacy and PeopleSoft Term Designation Calculator
- Fiscal Years and Biennium Designation Calculator
-
ctcLink PeopleSoft Query and Reporting Documentation 18
- ctcLink PeopleSoft Reporting FAQ
- Report Catalog
- ctcLink College Query Developers and Reporting Leads by College
- ctcLink Go-Live Reporting Resources
- ctcLink PeopleSoft Query Development Life Cycle (QDLC)
- Query Tree Models with Role Definitions
- Prompt Tables to Use
- Finance Commonly Used Tables
- Campus Solutions Commonly Used Tables
- ctcLink PS Query Developer Nondisclosure Form
- Human Capital Management Commonly Used Tables
- College Roles Related to Reporting in ctcLink
- Structure for Query Manager Access
- Query Folder List per Pillar
- Query Module List by Pillar
- Most Used and Favorite Queries
- Data Dump Query Protocol
- Understanding ctcLink PeopleSoft Query Security
-
ctcLink PeopleSoft Query and Reporting Development Training Materials and Courses 13
- QDLC Training Manual
- QDLC Training Presentation
- QDLC Canvas Course
- ctcLink PeopleSoft Query 101 Training Manual
- ctcLink PeopleSoft Query 101 Basics Training Presentation
- ctcLink PeopleSoft Query 101 Basics Canvas Course
- ctcLink PeopleSoft Query 201 Intermediate Training Manual
- ctcLink PeopleSoft Query 201 Intermediate Training Presentation
- ctcLink PeopleSoft Query 201 Intermediate Canvas Course
- ctcLink PeopleSoft Query 301 Advanced Training Manual
- ctcLink PeopleSoft Query 301 Advanced Training Presentation
- ctcLink PeopleSoft Query 301 Advanced Canvas Course
- ctcLink PeopleSoft Pivot Grid Wizard 101 Basics Canvas Course
-
ctcLink PeopleSoft Query and Reporting End User Training Materials and Courses 8
- ctcLink PeopleSoft Pivot Grid Viewer Course
- ctcLink PeopleSoft Query Reporting Training Manual
- ctcLink PeopleSoft Query Reporting Training Presentation
- ctcLink PeopleSoft Query Reporting Course
- Recommended Methods for Searching Queries and Reports
- Understanding ctcLink Query Security Training Presentation
- Understanding ctcLink Query Security Training Manual
- Understanding ctcLink Query Security Canvas Course
-
Other Data Services Training Materials and Courses 2
-
Integrated Postsecondary Education Data System (IPEDS) 1
-
Quality Assurance Reporting System (QARS) 3
QRGs are intended to provide a quick walk-through for college staff performing a business process in ctcLink and do not necessarily provide a comprehensive explanation of all possible scenarios. Updates to Reference Center materials are made continuously, so please check back frequently for the most current information.
Other Resources
Welcome to ctcLink (Start Here!)
- Intro to ctcLink
- PeopleSoft Fundamentals Training Videos
Resources
- 25Live (Software)
- ctcLink Document Repository (cDR)
- Commonly Used Reports and Processes
- Crosswalks & Glossaries
- Data Services
- Governance
- Implementation Project Archived Materials
- Local Configuration Guides
- Megamation (Software)
- Navigation Paths
- PeopleSoft Security
- Post Go-Live Resources
- PMO - Project Information
- Testing (Current & Project Archive)
- Training Videos
9.2 Campus Solutions
- 9.2 CS - Academic Structure
- 9.2 CS - Academic Advisement
- 9.2 CS - Admissions
- CS Business Process Maps (Flow Charts)
- 9.2 CS - Campus Community
- 9.2 CS - 3Cs: Comments, Communications and Checklists
- 9.2 CS - Continuing Education
- CS Fundamentals
- 9.2 CS - Curriculum Management
- 9.2 CS - Fundamentals
- Mobile (HCX)
- 9.2 CS - Student Records
- 9.2 CS - Campus Solutions Resources
9.2 Finance
- 9.2 FIN - Accounts Payable
- 9.2 FIN - Accounts Receivable
- 9.2 FIN - Asset Management
- 9.2 FIN - Billing
- 9.2 FIN - Budget/Budgeting (Commitment Control)
- 9.2 FIN - Budget Security
- 9.2 FIN - Treasury - Cash Management
- 9.2 FIN - Closing Periods and Years Procedures
- 9.2 FIN - Delegations
- 9.2 FIN - Expenses
- 9.2 FIN - General Ledger
- 9.2 FIN - Grants/Projects/Contracts
- 9.2 FIN - Project Costing
- 9.2 FIN - Purchasing
- 9.2 FIN - Finance Overview Videos
- 9.2 FIN - Finance Resources
- FIN - PBCS (Planning Budgeting Cloud Services)
- FIN Business Process Maps (Flow Charts)
9.2 Financial Aid
- 9.2 FA - Budgets
- 9.2 FA - Disbursement
- 9.2 FA - Financial Aid Business Process Guides
- 9.2 FA - Financial Aid Term
- 9.2 FA - ISIR Processing
- 9.2 FA - Loans
- 9.2 FA - Managing 3C's
- 9.2 FA - Packaging and Awards
- 9.2 FA - SAP
- 9.2 FA - Service Indicators/User Edit Messages
- 9.2 FA - Student Access
- 9.2 FA - User Set Up
- 9.2 FA - Return to Title IV
- 9.2 FA - Viewing Financial Aid Pages
- 9.2 FA - Federal and State Reporting
- 9.2 FA - COD Reporting
- 9.2 FA - Dual Processing
- 9.2 FA - Reconciliation & Reporting
- 9.2 FA - Financial Aid Resources
9.2 Human Capital Management
- 9.2 HCM - Absence Management
- 9.2 HCM - Benefits
- 9.2 HCM - FWL (Faculty Workload)
- HCM Business Process Maps (Flow Charts)
- 9.2 HCM - HR Core
- 9.2 HCM - Payroll
- 9.2 HCM - TAM (Talent Acquisition Management)
- 9.2 HCM - Time & Labor
- 9.2 HCM - Human Capital Management Resources
9.2 Self Service
- 9.2 Employee Self Service
- 9.2 Faculty Self Service
- 9.2 Manager Self Service
- 9.2 Student Home Page
- 9.2 Advisor Homepage
- 9.2 CS Staff Homepage
9.2 Student Financials
- 9.2 SF - Cashiering
- 9.2 SF - Collections
- 9.2 SF - General Ledger Interface
- 9.2 SF - Payment Plans
- 9.2 SF - Refunds
- 9.2 SF - Term Rollover & 1098T
- 9.2 SF - Third Party Contracts
- 9.2 SF - Tuition Calculation
- 9.2 SF - Student Financials Resources
Service Desk
- ctcLink ServiceDesk/Ticketing System
0 Comments
Add your comment