Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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.


  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.