Standard Data Reports

North Green

Standard Data Reports

 

Disclaimer

  1. The report data available here is for UD staff INTERNAL USE ONLY. It is NOT for re-distribution to any other UD department. Should you be contacted by an outside vendor for data, direct them to the Registrar's Office Reporting team.
  2. UD Staff are required to protect confidential student data. PNPI guidelines and FERPA guidelines.
  • Student data reports (Enrollment, Advisement, Graduation) require the Access role: SA_SR_USERS. Use this form to request access. 
  • Schedule of Classes data reports require the Access role: SA_SOC_USER. Use this form to request access. 
  • To access Cognos from off-campus, you must first log in to the UD VPN software.
  • If the Standard Reports listed below do not provide the data you need, UD staff may submit a Registrar Data Request form for a custom report.  (Login required)

Standard Reports:

 

If the Standard Reports listed here do not provide the data you need, UD staff may submit a request for a custom report.  (Login required).

Students Active for Term by Program (E1/E1-ORG)

Students who are active in a term, selectable by Academic Program (college) or Academic Organization (department). 

Includes bio/demo information, program/plan details and term enrollment information.

Instructions:

Select a View (“Students Active for Term by Program” or “Students Active for Term by Academic Org”)

Use the “Select term(s) to begin” dropdown to choose an academic term. The report will return students who have that term on their record in UDSIS.

Use the PDF or Excel icons on the left to download. Select sheet ‘E1’.

Notes:

Prior to the end of free drop/add, this report will include all students for a term regardless of enrollment status. Once drop/add has ended for a term, this report will only include students who have enrollment in that term.

 

Students Active for Term by Major/Minor with all plans (E2/E2-COS)

Students who are active in a term, selectable by Academic Plan (major/minor/course of study/masters/doctoral/etc). Includes bio/demo information, program/plan details and term enrollment information.

Instructions:

Prior to the end of free drop/add, this report will include all students for a term regardless of enrollment status. Once drop/add has ended for a term, this report will only include students who have enrollment in that term.

Select a View (“Students Active for Term by Major/Minor with all Plans”)

Use the “Select term(s) to begin” dropdown to choose an academic term. The report will return students who have that term on their record in UDSIS.

Use the PDF or Excel icons on the left to download. Select sheet ‘E2".

Notes:

Prior to the end of free drop/add, this report will include all students for a term regardless of enrollment status. Once drop/add has ended for a term, this report will only include students who have enrollment in that term.

Grade Distribution Crosstab with average (E3)

Provides a Grade Distribution report by course subject and term.

Instructions:

Submit the UDSIS Data Request form. In the "Other Information" box, specify "E3 - Grade Distribution".

Provide the desired Academic Term, Course Subject Code and Course Catalog number(s).

Class Roster by Term (E4)

Provides a class roster of those currently enrolled by term, in a specific course and section.

After grades are posted, this report will also list student course grades.

Instructions:

Select a View (“Class Roster by Term”)

Use the “Select term(s) to begin” dropdown to choose an academic term (required) and subject/catalog number/section number.

Use the PDF or Excel icons on the left to download. Select Sheet 'E4'.

Active Students but not Enrolled in Classes for the term (E5)

Provides a list of students who are active but not enrolled in the selected term.  Includes Advisor Name, Email and Role.

Instructions:

Select a View (“”)

Use the “Select term(s) to begin” dropdown to choose an academic term. The report will return students who have that term on their record in UDSIS.

Use the PDF or Excel icons on the left to download. Select sheet ‘E5’.

Notes:

Prior to the end of free drop/add, this report will include all students active for the selected term that are not yet enrolled.

Enrollment Census reports (E6)

 >> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

This report menu provides enrollment figures for the semester with breakdowns available by Gender, Time Status and Residency.

Optional prompts within these categories allow colleges/departments to request their specific student data.

Notes:

Official enrollment numbers are posted on the Registrar’s website. More information will be posted here when these reports are available.

Courses with Seat Availability - Newark On-Campus Only (E7)

Provides a list of courses by subject(s), with their Enrollment Totals and Caps, as of Start of Day when the report is run.

Instructions:

Select a View (“Courses with Seat Availability - Newark On-Campus Only”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘E7’.

 

Course Enrollment Caps and Totals (E8a)

Provides a list of courses by subject(s), with their Enrollment Totals and Caps, as of Start of Day when the report is run. Choose the report version including course subtotals, or the list-only version.

Instructions:

Select a View (“Course Enrollment Caps and Totals”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘E8a’.

Grade Roster Status for MidTerm Grades (E9)

Provides a list of courses by subject(s), with their MidTerm Grade Roster status, as of Start of Day when the report is run.

Instructions

Select a View (“Grade Roster Status for MidTerm Grades”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘E9’.

Grade Roster Status for Final Grades (E10)

Provides a list of courses by subject(s), with their Final Grade Roster status, as of Start of Day when the report is run.

Instructions:

Select a View (“Grade Roster Status for Final Grades”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘E10’.

Active Students with Registration Holds (E11)

Provides a list of students that currently have Registration Holds. Prompts include Service Indicator Hold and Service Indicator Reason.

Instructions:

Select a View (“Active Students w Registration Holds”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘E11’.

Waitlist Roster by Term, Subject, Catalog Number, and Section (E12)

Provides a waitlist roster of those currently waitlisted by term, in a specific course and section.

Instructions:

Select a View (“Waitlist Class Roster by Term, Subject, Catalog Number and Section”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘E12’.

Active 4+1 Students (E13)

Submit UDSIS Data Request form temporarily.

Provides a list of active students with 4+1 coding by college.

Instructions:

Due to the nature of 4+1 student activation, this report is not available via self-service and should be requested through the UDSIS Data Request form.

In the "Other Information" box, specify "Active_4plus1_Student” report from Tableau.

Students with Incomplete grades (A1)

May be run by Colleges or Departments prior to the 10th day of the following semester, to check for students in jeopardy of a negative Academic standing due to the change of an Incomplete grade.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Students with Term GPA LT 2.0 and CUM GPA GT 1.999 (A2)

May be run by Colleges or Departments to identify students for outreach prior to receiving a derogatory academic standing.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

 

Students with Term GPA LT 2.0 and CUM GPA GT 1.999 with Courses (A3)

Same report as above. Also included are semester classes and grades.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Students on Probation (CUM GPA LT 2.0) (A4)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

Lists student Cum GPA and Deficit points.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Students Active for Term by Major/Minor with all plans and all advisors (A5)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

Obtain lists of all students and their plans, and all assigned Advisors.  Includes GPA. Results may be filtered to highlight a specific range.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Students Active for Term by Major/Minor with all plans and plan advisor (A5-Plan)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

Faculty Advisor and Students Assigned by term (A6)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

May be run by Colleges or Departments to obtain a list of all students assigned to an Advisor for the term.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Students Enrolled in more than one Pass/Fail Course (A7)

(Report coming soon)

May be run by Colleges or Departments to advise students who are enrolled in more than one Pass/Fail course for the term, in violation of UD policy.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

UD Student Advisor-ADD (A8)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

This report creates a "starter" file as input to the Student Advisor Batch Assignment Process (Training Required).
All active students for the term for the prompted majors/minors(s) who do NOT have an ADVR Advisor. Edit this file to add the assigned ADVR advisor and then run the batch assignment process.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Majors Only AS Students Active for Term by Majors with all plans and ADVR plan advisor (A8-AS)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

UD Student Advisor-REMOVE (A9)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

This report creates a "starter" file as input to the Student Advisor Batch Process (Training Required).

It will list all current advisees of the selected Advisor. Staff edit the file and use it to remove advisees from the Advisor in the batch process.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Advisee Plan Audit (A10)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

This report lists all students active in the prompted term who have "inactive" plans listed at Records and Enrollment > Student Background Information > Student Advisor. These plans are highlighted in yellow.

Staff can edit the advisor information, either updating the Academic Plan if the advisor is still valid, or totally removing the advisor row. The student's active programs/plans are listed to aid in this.

Notes:

Advising reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

 

UD Student Advisor-SWAP (A11)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

Students Expecting to graduate by Term (G1)

Active Students expected to graduate in Spring based upon expected grad term. Note: Summer is usually also selected.

Notes:

Graduation reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

Students Expecting to graduate by Term, including currently-registered courses (G2)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

May be used to verify credits needed and/or requirements to be met. Note: Summer is usually also selected.

Notes:

Graduation reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available. EXPECTED GRAD TERM: Enter grad term and click Insert. Click Finish.

Seniors, based on Cumulative Units, by College and Major (G3)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

May be used to verify the Expected Grad term information is correct. Note: Summer is usually also selected.

Notes:

Graduation reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available. EXPECTED GRAD TERM: Enter grad term and click Insert. Click Finish.

 

Degrees/Certificates Conferred with Plan by Program and Grad Term (G4)

Provides a list of students who have earned their degree or a certificate in the Program and Term specified. Note that degrees are posted by the Registrar's Office a few weeks after graduation. Note: Previous Fall and Current Winter are usually selected.

Notes:

Graduation reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available. EXPECTED GRAD TERM: Enter grad term and click Insert. Click Finish.

Degrees Conferred with Minor and Grad Term (G5)

Provides a list of students who have earned their degree with the MINOR specified. Note that degrees are posted by the Registrar's Office a few weeks after graduation. Note: Previous Fall and Current Winter are usually selected.

Notes:

Graduation reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available. EXPECTED GRAD TERM: Enter grad term and click Insert. Click Finish.

Students Expecting to graduate by Term, including Primary Advisor (G6)

>> Report Coming Soon.
Submit UDSIS Data Request form temporarily.

Provides a list of students expecting to graduate by advisor. Note: Summer is usually also selected.

Student information is duplicated for each advisor, so that the report can easily be sorted and distributed for review.

Notes:

Graduation reports will be available here as soon as they are published. Please submit the UDSIS Data Request form until the new versions are available.

GRAD001. Beginning/End of Term Report*

(report coming soon)

*For questions/ concerns, please contact Bill Barnett

Course registration listing for each student in selected graduate academic plan(s). "End of term" option includes grades. Includes all graduate students with an active term record, regardless of whether they are registered in any classes.

Page 1

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Choose the desired Term. Then click OK button at bottom of screen

  3. Page 2

  4. Select Academic Plan(s).
  5. Select Report Type (Beginning of Term or End of Term; End of Term includes grades). Then click Finish at the bottom.

SOC-All (S1)

Lists all courses by term, subject & section--Active, Tentative, Stop Further Enroll, Cancelled by term. Notes are not shown.

Instructions:

Select a View (“SOC-ALL”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S1’.

FORM: Request Specific Classroom Set-up (S2)

(PBL or Computer Lab & ADA Notification)

Creates a form for departments to complete and send to Registrar Scheduling staff to request various needs for classroom set-up.

Instructions:

Select a View (“FORM Request”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S2’.

Reserve Cap - SOC ALL w/Optional Honors Prompt (S3)

Provides Schedule of Class information, including class status, enrollment, reserve cap and requirement groups.

Note: Campus has been added to report.

Instructions:

Select a View (“SOC - All Reserve Caps”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S3’.

Instructor Teaching Schedule Report  (S4)

Reports an Instructor's teaching schedule history, including enrollment totals and caps.

Instructions:

Select a View (“Instructor Teaching Schedule Report”)

Use the “Select term(s) to begin” dropdown to choose an academic term and the “Instructor Primary Name” dropdown to choose an instructor.

Use the PDF or Excel icons on the left to download. Select sheet ‘S4’.

Final Exams Schedule (S5)

Exams scheduled for the Newark Campus.

Instructions:

Select a View (“Final Exams Schedule”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S5’.

Enrollment (S6)

(excludes Independent Study)

Lists courses taught by the Instructor, except for Independent Study classes, with enrollment totals, course information and meeting start/end dates.

Instructions:

Select a View (“Enrollment”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S6’.

Enrollment - Total Credit Hours (S7)

Shows total enrollment credit hours generated per course by term. Formula is: max credit hours (x) total number of students rolled.

Instructions:

Select a View (“Enrollment – Total Credit Hours”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S7’.

Class and Class Enrollment Instructor (S9)

Errors Prior to Students Registering for Class.

Instructions:

Select a View (“Class and Class Enr Extract Errors”)

Use “Academic Term Description” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S9’.

SOC - w/Notes and Academic Org  (S10)

Instructions:

Select a View (“SOC - w/Notes & Academic Org”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S10’.

SOC - Class Essentials (S11)

Instructions:

Select a View (“SOC-Essentials”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S11’.

SOC - Reserve Group (S12)

A listing of all reserve cap requirement numbers and reserve cap requirement group descriptions for staff to review before requesting new reserve cap requirement groups.

Instructions:

Select a View (“Reserve Group”)

Use the PDF or Excel icons on the left to download. Select sheet ‘S12’.

SOC - When was a Course Last Offered? (S13) 

(by Course ID# and Subj)

Class detail information regarding when a course was last offered. The report may be run either by providing a Subject Area or a Course ID#.

Instructions:

Select a View (“Last Course Offered”)

Use the “Course ID” dropdown to choose a course.

Use the PDF or Excel icons on the left to download. Select sheet ‘S13’.

 

SOC - Automated Waitlist Job Errors (S14)

Instructions:

Select a View (“SOC - Automated Waitlist Job Errors”)

Use the “Select term(s) to begin” dropdown to choose an academic term.

Use the PDF or Excel icons on the left to download. Select sheet ‘S14’.

QUESTIONS / COMMENTS?

Please contact the Registrar Reporting team.