Prompt Tables to Use
Purpose: Provide a list of records to use as prompt tables for specific fields.
Audience: Query Developers
Link to PS Prompt Tables to Use (by Pillar)
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
17
- ctcLink PeopleSoft Reporting FAQ
- 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 5
- Other Data Services Training Materials and Courses 2
- Integrated Postsecondary Education Data System (IPEDS) 1
- dataLink 3
- metaLink 3
- Quality Assurance Reporting System (QARS) 3
Other Resources
User Acceptance Testing
- DG6 User Acceptance Testing for FIN
- DG6 User Acceptance Testing for HCM
- DG6 User Acceptance Testing for CS
- User Acceptance Testing - Other Resources
- PBCS (Planning Budget Cloud Service)-(Budget Development Tool) - User Acceptance Testing
Resources
- Welcome to ctcLink
- Spring Term Shift
- Parallel Testing
- Post Go-Live Resources
- ctcLink Document Repository (cDR)
- PeopleSoft Security
- Commonly Used Reports and Processes
- Data Services
- Legacy to PeopleSoft Conversion Data Validation
- Crosswalks & Glossaries
- Remediation
- Process Scheduling
- Navigation Paths
- 25 Live
- Megamation
- Training Videos
- Project Implementation Information
- Business Analyst Boot Camp
- Additional Resources
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 (WORK IN PROGRESS)
- 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