On Friday, May 29, at 11:00am in the Library Building Room 620, we are going to hold another training session for Query Managers (or aspiring query managers) on the basics of using the CUNYfirst Reporting Instance for query development and the running of queries. Query Viewers are welcome to attend the session to increase your knowledge and understanding of the Reporting Instance environment. Note that this session will cover the same material as the training session that was held on May 1. The Basics of the Reporting Instance training session will cover:
- Production Reporting vs Reporting Instance Instance
- Locating the Reporting Instance
- Permissions and access for the Reporting Instance - roles and SACR (reference the form)
- Public query versus private query
- Viewing public and private queries and using prompts (term, admit from, admit to, degree, academic plans, etc.)
- Planning a query. What user information is needed?
- What is a student?
- Basic records in CS - ACAD_PROG, ACAD_PLAN, STDNT_CAR_TERM, CLASS_TBL_SE_VW (STDNT_ENRL and CLASS_TBL)
- Table key structure
- Effective dating
- Intro to Joins and Use
- Selection Criteria for a query
- Saving a Query
- Copying a Query to Another User
...