COGNOS Schedule of Classes (SOC) Reports
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_SOC_USER.
Use this form to request COGNOS access.
(More info from UDEW).
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.
- If you experience any problems, you can run the report directly from our Cognos folder:
SOC Department Contacts.
RESOURCES:
- UDSIS Glossary
- BI Data Dictionaries
- How to read TERM codes
QUESTIONS / COMMENTS?
Please contact the Registrar Scheduling office.
If the SOC Reports listed here do not provide the data you need, UD staff may submit a request for a custom report. (Login required)
SOC Reports (requires Cognos SA_SOC_USER access) | ||
Report |
Notes |
Prompts |
---|---|---|
S1. SOC-All>> Run Report S1 | Lists all courses by term, subject & section--Active, Tentative, Stop Further Enroll, Cancelled by term. Notes are not shown. |
|
S2. FORM: Request Specific Classroom Set-up(PBL or Computer Lab & ADA Notification)>> Run S2-FORM |
Creates a form for departments to complete and send to Registrar Scheduling staff to request various needs for classroom set-up. |
|
S3. Reserve Cap - SOC ALL w/Optional Honors Prompt>> Run Report S3 NOTE: The prompts on this report have been updated. You must click REPROMPT to display the subsequent prompt choices. | Provides Schedule of Class information, including class status, enrollment, reserve cap
and requirement groups. |
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). |
S4. Instructor Schedule - teaching history - by EMPL ID #>> Run Report S4 | Reports an Instructor's teaching schedule history, including enrollment totals and caps. |
|
S5. Final Exams Schedule - NEWARK & VIRTUAL CAMPUS - EXCEL Sortable>> Run Report S5 | Exams scheduled for the Newark Campus. |
|
S6. Enrollment & Instructor with Meeting Start/End Date(excludes Independent Study)>> Run Report S6 | Lists courses taught by the Instructor, except for Independent Study classes, with enrollment totals, course information and meeting start/end dates. |
|
S7. Enrollment - Total Credit Hours Generated per course by term>> Run Report S7 | Shows total enrollment credit hours generated per course by term. Formula is: max credit hours (x) total number of students rolled. |
|
S9. Class Section Errors Prior to Students Registering>> Run Report S9 |
Errors Prior to Students Registering for Class |
|
S10. SOC - w/Notes, Ac Org, Class #, Instr. Mode & Location>> Run Report S10 |
SOC - with Notes and Class#, Instructor Mode, and Location |
|
S11. SOC - Class Essentials>> Run Report S11 |
SOC - Class Essentials |
|
S12. SOC - RESERVE CAP Number with Description>> Run Report S12* *Note: Descriptions may not accurately reflect what is in UDSIS at this time. |
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. |
No prompts |
S13. SOC - When was a Course Last Offered?>> Run Report S13-Sbj (by Subject Area) >> Run Report S13-Crs (by Course ID#) |
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#. | Version 1: SUBJECT: Select Course Subject. |
S14. SOC - Automated Waitlist Job Errors>> Run Report S14 |
Automated Waitlist Job Errors. |
|
For Enrollment, Advisement and Graduation reports,
click here.
|