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 11
- 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
- Sexual Orientation, Gender Identity and Pronouns Data Dictionary
-
ctcLink PeopleSoft Query and Reporting Documentation 21
- 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 Security Tree Models with Role Definitions
- Prompt Tables to Use
- Query Secure Tables to Use by Pillar
- 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
- Data Services Reporting Hour
- Replacement Queries
-
ctcLink PeopleSoft Query and Reporting Development Training Materials and Courses 21
- 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 102 Query Security Training Manual
- ctcLink PeopleSoft Query 102 Query Security Training Presentation
- 102 Query Security 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 Query 401 Expert Training Manual
- ctcLink PeopleSoft Query 401 Expert Training Presentation
- ctcLink PeopleSoft Query 401 Expert Canvas Course
- ctcLink PeopleSoft Query Pivot Grid Wizard 101 Basics Training Manual
- ctcLink PeopleSoft Query Pivot Grid Wizard 101 Basics Training Presentation
- ctcLink PeopleSoft Pivot Grid Wizard 101 Basics Canvas Course
-
ctcLink PeopleSoft Query and Reporting End User Training Materials and Courses 9
- ctcLink Pivot Grid Viewer Training Presentation
- 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 Manual
- Understanding ctcLink Query Security Training Presentation
- 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
Colors and button shapes may appear differently in QRGs compared to the live PeopleSoft environment, but functionality has not been affected by the latest PeopleTools upgrade. Please refer to the Fundamentals section of the Reference Center for images of several current system pages.
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
- Onboarding Training Materials and Applications
- Fundamentals
- Crosswalks & Glossaries
- ctcLink Service Desk/Ticketing System
Process Alignment
- Project Overview
- Process Alignment Task Forces
- Utilization Dashboards
Resources
- 25Live (Software)
- Commonly Used Reports and Processes
- Data Services
- Governance
- ctcLink Enhancement Requests
- Legacy Access
- Megamation (Software)
- Navigation Paths
- PeopleSoft Security
- PMO - Project Information
- Testing (Current Activities)
- 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
- CS - 3Cs: Comments, Communications and Checklists
- 9.2 CS - Continuing Education
- 9.2 CS Fundamentals
- 9.2 CS - Curriculum Management
- HighPoint Campus Experience (HCX)
- 9.2 CS - Student Records
- 9.2 CS - Campus Solutions Resources
9.2 Finance
- 9.2 FIN - Finance Fundamentals
- 9.2 FIN - Finance Navigation Resources
- 9.2 FIN - Accounts Payable
- 9.2 FIN - Accounts Receivable
- FIN - Asset Management
- 9.2 FIN - Billing
- 9.2 FIN - Budget/Budgeting (Commitment Control)
- 9.2 FIN - Budget Security
- FIN - Delegations
- FIN - Travel & Expenses
- 9.2 FIN - General Ledger
- 9.2 FIN - Grants/Contracts
- FIN - Project Costing
- 9.2 FIN - Purchasing
- FIN - PBCS (Planning Budgeting Cloud Services)
- 9.2 FIN - Treasury - Cash Management
- 9.2 FIN - Finance Resources
- 9.2 FIN - Closing Periods and Years Procedures
- FIN Business Process Maps (Flow Charts)
9.2 Financial Aid
- FA - User Set Up
- FA - Student Access
- 9.2 FA - Viewing Financial Aid Pages
- FA - ISIR Processing
- 9.2 FA - Managing 3Cs
- FA - Financial Aid Term
- FA - Budgets
- 9.2 FA - Packaging and Awards
- 9.2 FA - SAP
- FA - Service Indicators/User Edit Messages
- FA - Disbursement
- FA - Pell
- 9.2 FA - Loans
- 9.2 FA - Return to Title IV
- 9.2 FA - Federal and State Reporting
- 9.2 FA - Reconciliation
- 9.2 FA - Financial Aid Business Process Guides
- 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 Faculty Self Service
- Financials Employee Self Service
- 9.2 HCM Employee Self Service
- 9.2 Manager Self Service
- 9.2 Student Homepage
- 9.2 Advisor Homepage
- 9.2 CS Staff Homepage
9.2 Student Financials
- SF - 1098-T's
- SF - Cashiering
- SF - Collections
- SF - General Ledger Interface
- SF - Payment Plans
- SF - Refunds
- SF - Running Start
- SF - Term Rollover and Fees
- SF - Third Party Contracts
- SF - Tuition Calculation
- SF - Student Financials Resources
Archived Project Materials
- Implementation Project Archives
- Local Configuration Guides Project Archives
- Testing Project Archives
0 Comments
Add your comment