Query Secure Tables to Use by Pillar
Purpose: Provide a list of records to use with specific fields in specific instances for query security..
Audience: Query Developers
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 20
- 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
- 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
-
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 PeopleTools 8.59 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
- Fundamentals
- Crosswalks & Glossaries
- ctcLink Service Desk/Ticketing System
Resources
- 25Live (Software)
- Commonly Used Reports and Processes
- Data Services
- Governance
- ctcLink Enhancement Requests
- Implementation Project Archived Materials
- Legacy Access
- Local Configuration Guides
- Megamation (Software)
- Navigation Paths
- PeopleSoft Security
- 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
- 9.2 CS Fundamentals
- 9.2 CS - Curriculum Management
- 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
- FIN - Delegations
- 9.2 FIN - Expenses
- 9.2 FIN - General Ledger
- 9.2 FIN - Grants/Projects/Contracts
- 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 3Cs
- 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 - 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
