Query Viewer Access
Beginning June 2023, faculty and staff may request Query Viewer as additional access is EIS which provides the ability to run student records reports in real time. This access can be requested using the online Enterprise Systems Security Request Form.
Use the link above to be directed to the login screen for the online security request form. When prompted, login to ServiceNow using your UNT credentials. Complete all required fields. Under ‘Type of request’ select ‘Other’ and under ‘Please describe the access needed enter ‘Query Viewer’. Click 'Order Now' to submit your request. You will receive email confirmation when your request has been completed.
Use of online request forms are limited to UNT Faculty and Staff only. For off-campus requests or questions, please contact Ensys.Data@ad.unt.edu.
All student record reports are intended for internal departmental use only. If you need official statistics or information to be used for accreditation, please contact the Office of Institutional Research.
Query Viewer Instructions
Once you have received email confirmation that Query Viewer access has been granted, use the instructions to guide you through the process of running a query.
The criteria used to produce the report results will not be visible to you, so you should only run queries that you are familiar with to avoid pulling data that does not meet the criteria you intend.
Standard Reports
The reports below are available to run in Query Viewer. If the reports below do not meet your needs, please see the section below on Custom Reports.
| Report Name | Description |
|---|---|
| NTPQ_ACTIVE_BY_PLAN | List of students active in a specified plan. |
| NTPQ_ACTIVE_ENROLLED_ALL | All active and enrolled students for the current term (includes subplan). |
| NTPQ_GRADS_BY_TERM | List of students who have completed a specified major/plan by term. |
| NTPQ_MAJORS_BY_MINOR | List of students and their majors who are active in a specified minor. |
| NTPQ_ROSTER_BY_MAJOR | List of classes for the term that students of a specified plan are enrolled in. |
| NTPQ_ROSTER_BY_SUBJECT | Students enrolled in courses of the specified term for the specified subject. |
| NTPQ_AWARDS_BY_TERM | Presidents and Deans lists awards by term. |
| NTPQ_GRADUATION_TRACKING_UGRD | Undergrad graduation application tracking status by term and program. |
Custom Reports
If the data you need cannot be provided by one of the standard reports listed above, please submit a data request using the online Enterprise Systems Data Request form and we can work with you to develop a query or report that meets your needs.
Questions
If you have questions or need assistance, please contact Ensys.Data@ad.unt.edu.