SIS - Data Center: Ad Hoc Reporting in SIS

logo

The Data Center is a reporting tool you can utilize to run ad-hoc reports on real-time student and curricular data in a familiar, secure environment with the information gathered from the Student Information System.

More Detailed information about the data center (>Reporting Tools >Data Center).

The Student Information System (SIS) includes a search-and-report tool called Data Center, created by the Office of the Registrar.

Faculty and staff with certain roles have access to Data Center, which is located under “Reporting Tools” in the main menu of SIS. If you are faculty or staff with permission to use SIS and don’t have access to Data Center, you can request access. To do so, please complete the SIS Authorization Form. On the form, fill in the top section; under Additional Roles, write “(A) UW_SR_DEPARTMENT_CENTER” to add the Data Center role; obtain the necessary signatures; then submit as directed on the form.


Sample searches

Find all Social Welfare students.

Use the academic plan field to contain the code for Social Work (916). The results will include B.S., B.A., and Ph.D. students.

screenshot from SIS showing the example with a box around the academic plan field

Find Social Welfare students intending to graduate this term.

In addition to the academic plan of 916 for Social Welfare, specify a career of undergraduate (UGRD) and a declared four-digit graduation term (e.g., 1172). We do not recommend searching by "graduation status" as this will exclude those with an additional major in the searched academic plan.

screenshot from SIS showing the search on active students  example with box around career, academic plan, and declared graduation term

Find students with 100 or more credits, who are still in Pre-Biological Systems Engineering (not fully admitted to the Biological Systems Engineering major).

Specify a range of credits from 100 to something higher (e.g., 999), and the academic plan code of PAE for Pre-Biological Systems Engineering.

screenshot from SIS showing the example of search on active students with box around academic plan and cumulative credits

Find students within a specific option within a major (e.g. option in Analysis & Research for the BS in Sociology).

Set the academic plan field to “is exactly” (for the sub-plan field to work, the academic plan field must be set to “is exactly”), enter an academic plan code (e.g., BS 922), then either enter or search for/chose the code for the sub-plan (e.g., AR).

screenshot from SIS showing the example on Search on Active Students with box around academic plan and sub-plan

Find email addresses of undeclared students who are enrolled in courses in my department (Sociology) this term (Fall 2016).

Use the academic plan code of “000” for undeclared majors. The bottom section of Data Center’s fields are criteria related to specific terms. Choose a four-digit term code (e.g., 1172) and the three-digit subject area code (900 for Sociology).

Cross-listed courses are still a known issue for Data Center. It will only query under the subject area that the student enrolled in for cross-listed courses. 

screenshot from SIS showing the example of Search on Active Students with box around academic plan, term and subject

If you want to find—in this example—all undeclared students enrolled in a cross-listed course, use the six-digit course ID field instead of the subject area field (see second screenshot below).

screenshot from SIS showing the example of search on active student with box around academic plan, term and course ID



Keywordsdegree (degrees, degree planner), record (records), sis (SIS)   Doc ID72755
OwnerKate K.GroupOffice of the Registrar
Created2017-04-20 10:54:52Updated2024-01-02 12:39:04
SitesDoIT Help Desk, Office of the Registrar
Feedback  0   0