Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

TAB: Room Capacity - Section Capacity

Note

Not Yet Complete

TAB: Room Capacity - Section Capacity

Data Source

Oracle

Job/Process Source (Refresh Interval)

Live Data

Functional User(s)

 Vanessa Escobar

Report Owner

 Vanessa Escobar

Data Domain(s)

Academic Services

Contains PII

No

🛠 What It’s Used For

Academic Services uses this to determine if a sections capacity is greater than the capacity of the room.

🔘 Options

Options

Description

Term

Choose the term to check comparisons for.

📄 Results

Field Name

Data Source/Logic

Description (sample)

TERM CODE

SSBSECT.SSBSECT_TERM_CODE

The term selected for comparison

CRN

SSBSECT.SSBSECT_CRN

the CRN for the course

SUBJECT CODE

SSBSECT.SSBSECT_SUBJ_CODE

The subject code for the course

COURSE NUMBER

SSBSECT.SSBSECT_CRSE_NUMB

The Course Number

ROOM CAPACITY

MIN(SLBRDEF.SLBRDEF_CAPACITY)

The minimum capacity for the rooms this course is scheduled to use

SECTION CAPACITY

MAX(SSBSECT.SSBSECT_MAX_ENRL)

the maximum enrollment number for this section

🗺 Report Domain

This report is built off the SSBSECT and SLBRDEF tables and checks the room the section is in and subtracts the section amount from the capacity to determine which sections have a higher section maximum than the rooms can handle.

...