Standard COGNOS Reports - Student Data
Fall 2022 Update:
- Cognos student data marts are currently being updated mid-morning. Users may encounter “Logon failed” errors prior to Noon.
- Data generated prior to the daily update may be two days old.
- 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.
- UD Staff are required to protect confidential student data. PNPI guidelines and FERPA guidelines.
SETUP:
Security: These reports require the COGNOS Access role: SA_SR_USERS.
Use this form to request COGNOS access.
(More info from IRE/Business Intelligence).
NOTES:
- To access Cognos from off-campus, you must first log in to the UD VPN software.
- Since some reports are extensive, select to receive these by email.
o Click Select a Delivery Method
o Choose Email report.
o In the From/To Email options window, click Attach the report and then click OK.
o When prompted ‘Do you want to close this window?’ click OK.
RESOURCES:
- UDSIS Glossary
- Code translation lists:
- Colleges (UGRD & GRAD)
- Majors (UGRD)
- Minors (UGRD)
- Concentrations (UGRD & GRAD)
- Certificates (UGRD & GRAD)
- Doctoral (GRAD)
- Masters (GRAD)
- BI Data Dictionaries
- How to read TERM codes
QUESTIONS / COMMENTS?
Please contact the Registrar Reporting team.
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)
ENROLLMENT |
Report |
Notes |
Prompts |
---|---|---|
E1. Students Active for Term by Program>> Run Report E1* *Recommended Delivery method is Email. *Note: E1-ORG report below runs much quicker. |
Includes GPA. Results may be filtered to highlight a specific range. |
FIRST Prompt page:
NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer). |
E1-ORG. Students Active for Term by Acad ORG>> Run Report E1-ORG |
This report is modeled after E1 but creates a single list of all rows as well as separating students into unique sheets for each academic organization. |
FIRST Prompt page:
NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer). |
E2. Students Active for Term by Major/Minor with all plans>> Run Report E2 *Note: For a specific Course of Study Flag report, click E2-COS Reports Folder below. |
Students in plans outside of their primary program ARE automatically included. |
NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer). |
E2-COS. Course of Study Reports>> Open E2 COS Report Folder (Then select a specific report to run) | These set of reports are identical to E2. Students Active for Term by Major/Minor with all plans but are specifically filtered for each Course of Study only. |
NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer). |
E3. Grade Distribution Crosstab with averageSubmit a request (Login required) |
Provides a Grade Distribution report by course subject and term. |
In the "Other Information" box, specify "E3-Grade Distribution". |
E4. Class Roster by Term, Subject, Catalog Number and Section>> Run Report 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. |
|
E5. Active Students but not Enrolled in Classes for the Term>> Run Report E5 |
Provides a list of students who are active and eligible to enroll for the term, but currently have NOT enrolled.
|
NOTES: This report can ONLY be run during a specific time period,
starting approximately one week before registration begins for a future term, through the following deadlines for the current term: If enrollment does not occur, these students will no longer appear on this list after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer). |
E6. Enrollment Census reports(from IR- UDSIS Official Extract data mart) >> Open E6 Report Folder (Then select a specific report to run) Registrar's Office Summary Webpage: Opening Day and Official Enrollment Numbers by Term |
This report menu provides enrollment figures for the FIRST, OFFICIAL (end of drop/add period) or LAST day of 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. The prompts chosen by the user appear at the bottom of the report. NOTE: Reports by default are created in html format. This allows you to click on the counts to receive the underlying student detail in Excel format. |
FIRST Prompt page:
(Optional) CAMPUS(es): Select the desired campus. (Optional) ACADEMIC CAREER(s): Select the desired career(s). (Optional) ACADEMIC PROGRAM(s): Select the desired program(s). (Optional) ACADEMIC PLAN(s): Select the desired plan(s). (Optional) HONORS STUDENTS (ONLY): Click the Y button if you want to restrict the report to Honors students. (Optional) INTERNATIONAL STUDENTS (ONLY): Click the Y button if you want to restrict the report to International students. |
E7. Courses with Seat Availability - Newark On-Campus Only>> Run Report 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. |
|
E8a. Course Enrollment Caps and Totals>> Run Report E8a (List only) |
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. |
|
E9. Grade Roster Status for MidTerm Grades>> Run Report 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. |
|
E10. Grade Roster Status for Final Grades>> Run Report 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. |
|
E11. Active Students with Registration Holds>> Run Report E11 |
Provides a list of students that currently have Registration Holds. Prompts include Service Indicator Hold and Service Indicator Reason. |
FIRST Prompt page:
|
E12. Waitlist Roster by Term, Subject, Catalog Number, and Section>> Run Report E12 |
Provides a waitlist roster of those currently waitlisted by term, in a specific course and section. |
|
E13. Active 4+1 StudentsSubmit a request (Login required) |
Provides a list of active students with 4+1 coding by college. |
Due to the nature of 4+1 student activation, this report is not available in Cognos and should be requested through the UDSIS Data Request form. |
ADVISEMENT |
||
A1. Students with Incomplete grades>> Run Report 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. |
Note: Now includes Career prompt and the output contains an "All" sheet and multiple sheets separated by Program. |
A2. Students with Term GPA < 2.0 and CUM GPA > 1.999>> Run Report A2 |
May be run by Colleges or Departments to identify students for outreach prior to receiving a derogatory academic standing. |
|
A3. Students with Term GPA < 2.0 and CUM GPA > 1.999 with Courses>> Run Report A3 |
Same report as above. Also included are semester classes and grades. |
|
A4. Students on Probation (CUM GPA < 2.0)>> Run Report A4 |
Lists student Cum GPA and Deficit points. |
|
A5. Students Active for Term by Major/Minor with all plans and all advisors>> Run Report A5 A5-Plan. Students Active for Term by Major/Minor with all plans and plan advisor>> Run Report A5-Plan |
Obtain lists
of all students and their plans, and all assigned Advisors. Use A5-Plan to check for students without an Advisor for the prompted plan(s). |
NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer). |
A6. Faculty Advisor and Students Assigned (by term)>> Run Report A6 |
May be run by Colleges or Departments to obtain a list of all students assigned to an Advisor for the term. |
|
A7. Students Enrolled in more than one Pass/Fail Course>> Run Report A7 |
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. |
|
A8. UD Student Advisor-ADD>> Run Report A8 A8-AS Majors Only AS Students Active for Term by Majors with all plans and ADVR plan advisor>> Run Report A8-AS Majors Only |
This report creates a "starter" file as input to the Student Advisor Batch Assignment Process (Training Required). |
|
A9. UD Student Advisor-REMOVE>> Run Report A9 |
This report creates a "starter" file as input to the Student Advisor Batch Process (Training Required). |
|
A10. Advisee Plan Audit>> Run Report A10 |
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. |
|
A11. UD Student Advisor-SWAP>> Run Report A11 |
This report creates a "starter" file as input to the Student Advisor Batch Process (Training Required). |
NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer). |
GRADUATION |
||
G1. Students Expecting to graduate by Term>> Run Report G1 | Active Students expected to graduate in Spring based upon expected grad term. Note: Summer is usually also selected. |
|
G2. Students Expecting to graduate by Term, including currently-registered courses>> Run Report G2 |
May be used to verify credits needed and/or requirements to be met. Note: Summer is usually also selected. |
|
G3. Seniors, based on Cumulative Units, by College and Major>> Run Report G3 |
May be used to verify the Expected Grad term information is correct. Note: Summer is usually also selected. |
|
G4. Degrees/Certificates Conferred with Plan by Program and Grad Term>> Run Report 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. |
Page 1
Page 2 |
G5. Degrees Conferred with Minor and Grad Term>> Run Report 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. |
|
G6. Students Expecting to graduate by Term, including Primary Advisor>> Run Report G6 |
Provides a list of students expecting to graduate by advisor. Note: Summer is usually also selected. |
|
GRADUATE COLLEGE |
||
GRAD001. Beginning/End of Term Report*>> Run Report GRAD001 *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
Page 2 |
For SOC Reports, click here.
|