Production Reporting Tools
The CUNYfirst service includes production Reporting Tools (HR/Campus Solutions > Reporting Tools >Query > Query Viewer). The queries in the production Reporting Tools use live production data and the queries are managed by CUNY Central CIS. The production Reporting Tools queries are generally written to cover a general data need and often use prompts for to limit results to a particular institution, semester, career, etc. The production queries may not necessarily be specific to the unique needs of an individual business unit's process or data needs, but in these cases may serve as a starting point for a customization in the reporting instance, the instance that CUNY CIS allows the campus to develop and run queries on.
Go to https://home.cunyfirst.cuny.edu/oam/Portal_Login1.html to access CUNYfirst log-in page. Place Username and Password then click Log-in.
Click on 'Reporting Tools'.
Click on 'Query Viewer' link to access query.
Type a query name next to 'begin with' and hit 'search' button to fetch the query.
Click on 'Excel' to download a report from a separate window or 'Schedule' the same query for a Query Manger or Query Viewer.
Development Reporting Instance
Query Manager can view, schedule, create, delete, edit, organize queries by using reporting Instance . However, Query Viewer can be able to view and schedule queries. The public queries can be customize through CUNYfrist Reporting Instance. Note that: all data are one day older than CUNYfirst production system.
From menu select and click 'Reporting Tools' to access Query Manager/viewer.
Select Query Manger or Query Viewer based on user permission level.
Search to find an existing query. For example: CU_BAR or any public query then hit 'Search' button. User can be very specific to type their own query as the image shown below:
Select the appropriate query and click 'Edit' link to display properties for a query for a Query Manger. Click 'Excel' link to download a report for a Query Manger or Query Viewer.
Useful Production Queries
- CU_SR_COA_ROSTER_DTL - Verification of Attendance Roster - check for submission status of attendance roster