...
| Table of Contents | ||||
|---|---|---|---|---|
|
Latest PS Query Training Guide:
| View file | ||||
|---|---|---|---|---|
|
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
...