University of Delaware
Upcoming Events

COGNOS Schedule of Classes (SOC) 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. Unless otherwise noted, these reports use Cognos data marts which are refreshed nightly from UDSIS. The report data will be AT MOST one day old, compared to UDSIS.
  3. Do NOT re-use old reports. Since information is updated nightly, re-generate the report using the links below, or contact the Registrar's Office Reporting team.
  4. UD Staff are required to protect confidential student data. See 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).

Browsers:

  Internet Explorer is recommended. Perform this one-time setup.

  If using Firefox, right-click the "Run Report" link and choose "Open in a new window".
   This will give you a prompt to open the Excel spreadsheet when the report completes.

TRAINING:

IT-Client Support & Services training session video: Using Excel with Registrar's Standard Reports.

NOTES:

  1. When prompted to login to COGNOS, use your UDelNet ID and password.
  2. The output format is set as Spreadsheet.
  3. Since some reports are extensive, select to receive these by email.
    1. Click Select a Delivery Method.
    2. Choose Email report.
    3. In the From/To Email options window, click Attach the report and then click OK.
    4. When prompted ...Do you want to close this window? click OK.
  4. If you experience any problems,    you can run the report directly from our Cognos folder: SOC Department Contacts.

QUESTIONS / COMMENTS?

Please contact the Registrar Scheduling office.



Report

Notes

Prompts
(Enter in COGNOS window/tab)

SOC Reports (requires Cognos SA_SOC_USER access)
S1. SOC-All


   >> Run Report

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

  1. ACADEMIC_TERM: Select the Current Term. Hit OK at bottom of screen.
  2. SUBJECT: Select Course Subject Code or Select all.
  3. (Optional) SECTION: Select Section number or Select all.
  4. Click Finish.
S2. FORM: Request Specific Classroom Set-up
(PBL or Computer Lab & ADA Notification)

   >> Run Report

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

  1. TERM: Select Academic Term and then click the Select Subject button.
  2. SUBJECT: Select the Course Subject or click Select All.
  3. Click Finish.
S3. Reserve Cap - SOC ALL w/Optional Honors Prompt


   >> Run Report

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

  1. ACADEMIC_TERM: Select the Current Term. Hit OK at bottom of screen.
  2. SUBJECT: Select Course subject or click Select All.
  3. (Optional) SECTION: Select desired course sections or click Select All.
  4. Click Finish.
S4. Instructor Schedule - teaching history - by EMPL ID #


   >> Run Report

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

  1. Instructor ID: Enter the Employee ID.
  2. Click Finish.
S5. Final Exam Schedule - Newark Campus (EXCEL Sortable)


   >> Run Report

Exams scheduled for the Newark Campus.

  1. ACADEMIC_TERM: Select the Current Term. Hit OK at bottom of screen.
  2. EXAM FLAG: Select N (no) or Y (yes).
  3. (Optional) SUBJECT: Click the Select Subject button and choose a Subject or Select all .
  4. Click Finish.
S6. Enrollment & Instructor with Meeting Start/End Date
(excludes Independent Study)

   >> Run Report

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

  1. ACADEMIC_TERM: Select the Current Term. Hit OK at bottom of screen.
  2. (Optional) COLLEGE: Select College and hit Submit OR, to continue, click Select Department .
  3. (Optional) DEPARTMENT: Select Department and hit Submit OR, to continue, click Select Subject.
  4. (Optional) SUBJECT: Select Subject and hit Submit.
S7. Enrollment - Total Credit Hours Generated per course by term


   >> Run Report

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

  1. TERM: Select the desired Term.
  2. SUBJECT: Select Subject.
  3. Click Finish.
S8. Class Sections with Instructor, Workload & Enrollment Totals


   >> Run Report

The Workload Verification Error Report.

  1. ACADEMIC TERM: Select the desired Academic Term.
  2. ACADEMIC GROUP: Select College owner.
  3. SUBJECT: Select Course Subject.
  4. Choose "Display Class Sections with Error" or "All Class Sections".
S9. Class Section Errors Prior to Students Registering


   >> Run Report

Errors Prior to Students Registering for Class

  1. ACADEMIC TERM: Select the desired Academic Term.
  2. ACADEMIC GROUP: Select College owner.
  3. (Optional) SUBJECT: Select Course Subject.
  4. (Optional) CLASS STATUS
S10. SOC - w/Notes, Ac Org, Class #, Instr. Mode & Location


   >> Run Report

SOC - wwith Notes and Class#, Instructor Mode, and Location

  1. TERM: Select the desired Academic Term.
  2. SUBJECT: Select Course Subject.
  3. (Optional) Section: Select Course Section/s.
S11. SOC - Class Essentials


   >> Run Report

SOC - Class Essentials

  1. TERM: Select the desired Academic Term.
  2. SUBJECT: Select Course Subject.
  3. (Optional) Section: Select Course Section/s.
For Enrollment, Advisement and Graduation reports, click here.
(Requires Cognos SA_SR_USER access)