Section Seating

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

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)

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)

Field Name

Data Source/Logic

Description (sample)


Version Date Comment
Current Version (v. 2) Oct 30, 2024 23:30 Jordan Lamb
v. 1 Oct 30, 2024 22:53 Jordan Lamb