...
| Table of Contents | ||||
|---|---|---|---|---|
|
Campus Solution Resources
Latest PS Query Training Guide:
Basic Training Topics
- Production Reporting vs Reporting Instance
- Locating the Reporting Instance
- Permissions and access for the Reporting Instance - roles and SACR - see CS Reporting Access Request Form and HR Reporting Access Form
- Public query versus private query in the Reporting Instance
- Viewing public and private queries and using prompts (finding terms, admit from, admit to, degree, academic plans etc)
- Fundamentals of Using CUNYfirst Reporting Tool
- Planning a query. What user information is needed?
- Basic records in Campus Solutions: ACAD_PROG, ACAD_PLAN, STDNT_CAR_TERM, CLASS_TBL_SE_VW (STDNT_ENRL and CLASS_TBL).
- Table key structure
- Effective dating
- Joining tables
- Selection criteria
- Query Organization
...
Set up described in these documents may vary slightly from CUNY's but these may assist you with basic understanding of PS Query.
- Wesleyan University PS Query Docs
- Part 1 - Basic : http://sfis.blogs.wesleyan.edu/files/2013/12/Intro-to-PS-Query-Part-1-Overview-and-Viewer.pdf
- Part 2 - Query Manager : http://sfis.blogs.wesleyan.edu/files/2013/12/Intro-to-PS-Query-Part-2-Query-Manager1.pdf
- Part 3 - Advanced Concepts : http://sfis.blogs.wesleyan.edu/files/2014/09/PS-Query-Part-3-Advanced-Concepts.pdf
- University of Michigan - Data Dictionaries linked throughout this page - http://www.mais.umich.edu/reporting/studentdatasets.html
- NYS Office of the State Comptroller Query Guide
- University of Maine - Getting Started with PeopleSoft Query
- Videos from Pepperdine on PS Query - https://www.youtube.com/channel/UCfO0VwRAP3ryYmOjRVWb0Wg
- Videos linked from this page (see bottom) - http://community.pepperdine.edu/it/tools/wavenet/faculty-staff/videocenter.htm
- Doc from Bowling Green for their Query Manager class
- Other related info at https://www.bgsu.edu/its/services/peoplesoft/queries/manager.html
- Query Basics from UNC