Topics and notes Training topics, documentation and resources for CUNYfirst Reporting Instance training sessions for Query Managers .Our plan is to schedule some 1-1.5 hr training sessions for Query Managers ( and Viewers). The sessions will be recorded and be made available - possibly through a Blackboard organization (more info on this to follow)..
| Table of Contents | ||||
|---|---|---|---|---|
|
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?
- 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