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
- 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
On the data side we will focus on student records, but the overall training is applicable to other areas.
The session will be recorded and made accessible to query managers following the training.
Please email me back if you are interested in attending this session on May 29, so we can confirm seat count.
We will be offering a Level II course for query managers on June 9. This Level II course will be a hands-on format and include a more depth look at joins (standard and left outer), expressions, sub-queries, and unions. Save the date and a follow-up email will be sent with details shortly.