Versions Compared

Key

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

...

Element

Source

(System->Table->Column)

DescriptionFrequency of Update
# of SectionsBANNER->SSBSECT->SSBSECT_SEQ_NUMBCount of SSBSECT_SEQ_NUMBLive
Campus


Cohort






College


College that is funding the course.




Conc1
Concentration
Conc2
Concentration
Course AttributesBANNER->SCRATTR->SCRATTR_ATTR_CODECourse level attributes from Banner.Live
Course Number
The code that includes the level of a course and is assigned to identify the course in a systematic manner.
Course Prefix
The alpha abbreviation assigned to a course by Common Course Numbering.
Course Section (=Section Number)
A unique identifier assigned by the institution for each section of a course offered during the term reported.
Course Session


Course TitleBANNER->SCBCRSE_TITLECourse title.
Current Enrollment
Current student enrollment, updated regularly when registration is open.
Delivery MethodSID_Instructional_Activity->delivery_method_indOnline delivery method = AD
Degree App Status


Degree App Term


Degree Status


Degree Type


Department
Department that is funding the course.
DGW Overall %


DGW Req Comp %


DGW Requirements


Email


Enrollment # Year-1SID_Instructional_Activity->SECTN_HEADCNT_ENROLActual enrollment number for the course in the same semester one year prior for all campuses.
Enrollment # Year-2SID_Instructional_Activity->SECTN_HEADCNT_ENROLActual enrollment number for the course in the same semester two years prior for all campuses..
Enrollment # Year-3SID_Instructional_Activity->SECTN_HEADCNT_ENROLActual enrollment number for the course in the same semester three years prior for all campuses..
Enrollment # Year-4SID_Instructional_Activity->SECTN_HEADCNT_ENROLActual enrollment number for the course in the same semester four years prior for all campuses..
Enrollment # Year-5SID_Instructional_Activity->SECTN_HEADCNT_ENROLActual enrollment number for the course in the same semester five years prior for all campuses..




Interest Student #CSCHED_REGCART

Number of students interested in taking the course from the College Scheduler tool for undergraduate students.

Count of rows for the term_code, crn, pidm in CSCHED_REGCART table.
The way of calculating interested students will change this sprint.


Last Enrolled Term


Major


Major2


Max EnrollmentBANNER->SSBSECT->SSBSECT_MAX_ENRLIndicates the total number of available seats in the current semester for all campuses.
Minor1


Minor2


Name First


Name Last


PIDM


Potential DeficitMax Enrollment-Interest Student #Calculated column
Program Name


QM Flag
This flag indicates the course has a Quality Matters or equivalent designation.
Section College


Section Department


Section Number


Section Type






Student Level


Student Type










Term Code










UID












...