Training Topics and Resources

Training topics, documentation and resources for CUNYfirst Reporting Instance Query Managers and Viewers.

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)
• Planning a query.  What user information is needed? 

• What is a student?

• Active Student vs Enrolled Student

• 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
• Saving a Query
• Copying a Query to Another User

Level II -  Topics

• Joins - standard and outer, adding an outer join manually
• Prompts - creation of prompts, using tables, mandatory and optional.
• Expressions
• Subqueries (Exists vs Does not Exist)
• Unions

Baruch CUNYfirst Reporting Instance Training Videos

• Recording of CUNYfirst Reporting Training - Basics of the Reporting Instance 5/29/15*
• Recording of CUNYfirst Reporting Training - Level II Query Manager - 6/12/15*

*This training video is provided through Blackboard Collaborate. Before viewing this video you may need to install the Collaborate Launcher if you haven't done so previously on this computer.

Resources for both CUNYfirst Reporting Instance

• CUNYfirst Reporting Instance Resources - Resource provided by CUNY related to CUNYfirst Reporting Instance, access forms, training seminar (pdfs/vidoes), the CUNY Office of Institutional Reporting's resources/information, etc.

Public Guides/Videos on Using PS Query from External Organizations

Set up described in these documents may vary slightly from CUNY's but these may assist you with basic understanding of PS Query.

• 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