"For a given term, provision full Adobe All Apps licenses for all active grad and undergrad instructors (except two specific people and dual-credit sections) and all active students (undergrad broadly, grad only in the Arts department), excluding Continuing Education and Creative Writing."
This is your go-to reusable term provisioning query for Adobe license assignment — the one you'd run at the start of each term.
This is the most complete and refined provisioning query in your collection — it's essentially the production-ready version of ADOBE_ENROLLMENTS_PER_CLASS.sql, generalized from a single course to a full term. It assigns actual Adobe licenses (not blank), uses a substitution variable instead of a hardcoded term, and covers all four populations in one query.
Graduate Instructors ─┐
Undergrad Instructors ├─ UNION → (no ORDER BY)
Undergrad Students │
Graduate Arts Students ─┘
Four blocks, all active (nothing commented out at the block level).
| Feature | Earlier queries | ADOBE_ENROLLMENTS_V2.sql |
|---|---|---|
Product_Configurations |
Blank | Full Adobe All Apps + Spark assigned |
| Term parameter | :TERM_ID (bind variable) |
&TERM (substitution variable — SQL*Plus style) |
| Instructor exclusions | Not present | NAME.DFLT_ID NOT IN ('1004854','1024389') in both instructor blocks |
| Section filter | Varies | UG instructors locked to ('01','02','03','04','D1','D2','D3','D4') |
| Graduate students | Missing or commented out | Fully active, scoped to DEPT_ID IN ('ARTS') |
CRST_ID filter |
Inconsistent | Applied to all blocks except grad instructors |
Block 1 — Graduate Instructors
CLVL_ID IN ('G') — grad-level courses onlyDEPT_ID NOT IN ('CRWR') — with a commented-out MCW exclusion nearby, suggesting this was tunedCRST_ID filter is commented out — possibly intentional for grad instructors who may have irregular course status codesPER_CLASSBlock 2 — Undergrad Instructors