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

PROD_DB

Job/Process Source (Refresh Interval)

Baseline Banner Tables (Live Data)

Functional User(s)

Report Owner

Contains PII

No

🛠 What It’s Used For

🔘 Options

Options

Description

Accounting Method

Allows the results to be filtered based on the Section’s accounting method. Defined by SSBSECT_ACCT_CODE.

Term

Allows the results to be filtered based on the Section’s term code. Defined by SSBSECT_TERM_CODE.

Academic Year

Allows the results to be filtered based on the Academic Year. This is the Academic Year associated with the Section’s Term Code. Defined by the STVTERM_ACYR_CODE referenced from the section’s SSBSECT_TERM_CODE.

📄 Results

Field Name

Data Source/Logic

Description (sample)

Measurements

Census Enroll

SSBSECT_CENSUS_ENRL

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

Max Enroll

SSBSECT_MAX_ENROL

The Max Enroll value represents the maximum enrollment capacity for the Section.

Fill Rate

“Census Enroll” / “Max Enroll”

The Fill Rate is the ratio between the Section’s census enrollment and the Section’s max enrollment. It is a measurement of the Section’s load.

If a Section’s census enrollment is 10 and its max enrollment is 20, then Fill Rate is 10 / 20 = 0.50

Fill Rate %

“Fill Rate” * 100%

The percentage representation of the Fill Rate.


If a Section’s Fill Rate is 0.50, then Fill Rate % is 0.5 * 100% = 50%

Dimensions

Division

SCBCRSE_DIVS_CODE

SCBCRSE is joined on Subject and Course, with the most recent effective term up until, and including, section’s Term.

Subject

SSBSECT_SUBJ_CODE

The section’s subject code.

Course

SSBSECT_CRSE_NUMB

The section’s course.

CRN

SSBSECT_CRN

The section’s CRN.

🗺 Report Domain

A unique Section is defined by a CRN and Term.


Version Date Comment
Current Version (v. 1) Jun 29, 2022 19:57 Garrett Woodard
v. 2 Jun 29, 2022 20:25 Jordan Lamb
v. 1 Jun 29, 2022 19:57 Garrett Woodard
  • No labels