TAB: Seating (Simple)
...
The report has two different tabs but the intent is just to return additional columns in the Seating (All Columns) tab and not to modify the results.
Data Source | ORACLE [PROD] |
|---|---|
Job/Process Source (Refresh Interval) | Banner [LIVE Data] |
Report Domain | SCACRSE, SSASECT, SIAASGN and related baseline tables |
Functional User(s) | Division Chairs, Deans |
Constituent(s) | |
Report Owner | Vanessa Escobar (Scheduling Coordinator) |
Data Domain(s) | Academic |
Contains PII | No |
🛠 What It’s Used For
Returns as much data as possible related to CRNs (Sections) for distribution, analysis, and data error checking.
🔘 Options
Parameters should be limited to the most useful and all other sorting should happen in columns or in outputs.
Options | Description |
|---|---|
Term | |
Division | |
Part of Term | |
Subject | |
Course Number | |
Campus | Campus listed on SSASECT. Not necessarily the Campus associated with the building on Meeting tab of SSASECT. |
Status | Select multiple by pressing CTRL or SHIFT |
Instructional Method | |
Instructor | Useful if only interested in faculty member. |
Filters: Work Experience | If checked only subjects starting with WEXP will be returned. |
CRN | Useful if only just searching for a specific CRN. |
🧠 Logic
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
Subject | Must not start with “A “ | Subject “A ENG” would be excluded |
Subject | Must not equal “AP” | |
Subject | Must not End with “X” | Subject “ENGX” would be excluded |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
...
| Change History |
|---|