...
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.
Select 'HR/Campus Solution' and click.
Click on 'Reporting Tools'.
...
Development Reporting Instance
A 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.
Select 'Reporting HR/Campus Solution' and click.
From menu select and click 'Reporting Tools' to access Query Manager/viewer.
Select 'Query Manger' or 'Query Viewer' based on an user accesses 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. User can also add any queries to their favorite. For QM Select a query then click on Action drop down box, choose 'add to Favorites' then click 'Go'. For QV click 'Favorite' link for any chosen query will be added to an user's screen.
Useful Production Queries
...