Plain English interpretation

In Plain English

"Give me the campus email, name, and group assignment for every active instructor and enrolled student in the given term, excluding Continuing Education, so we can bulk-provision their software accounts."

Overview

This is a user provisioning query — it pulls a list of people (faculty and students) who need accounts in some system (likely Adobe Creative Cloud, given the column names like "Product Configurations" and "Developer Access"). It outputs a standardized CSV-style format for bulk user import.

The query is built from 6 UNION'd SELECT blocks, all returning the same 14 columns.

Structure at a Glance

Instructors (Undergrad, non-TEAM)    ─┐
Instructors (Undergrad, TEAM)         │
Instructors (Grad, non-TEAM)          ├─ UNION all → ORDER BY Last Name
Instructors (Grad, TEAM)              │
Students (Undergrad)                  │
Students (Grad)                      ─┘

The Two Populations

Faculty blocks (4 queries)

• Pull from SR_COURSE_SECTION → joined to CO_INSTRUCTOR → then to name/email tables
• "User Groups" = 'Active Faculty'
• Filtered by:
  • TUIT_ID IN ('01') → Undergrad tuition category
  • TUIT_ID IN ('11','14') → Graduate tuition categories
  • DEPT_ID NOT IN ('CE') → Excludes Continuing Education
  • NAME.DFLT_ID IS NOT NULL → Person must have a default name record
• The TEAM split: two blocks handle INST_ID = 'TEAM' (team-taught courses) separately from regular instructors, though notably both blocks are identical in output — so this distinction doesn't change the result, just ensures TEAM instructors aren't accidentally excluded

Student blocks (2 queries)

• Pull from SR_COURSE_SECTION → joined to SR_ENROLL → then to name/email tables
• "User Groups" = 'Active Students'
• Similar dept/name filters