...
Element | Source (System->Table->Column) | Description | Frequency of Update |
---|---|---|---|
# of Sections | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | Count of SSBSECT_SEQ_NUMB | Live |
Campus | BANNER->SSBSECT->SSBSECT_CAMP_CODE | ||
Cohort | BANNER->SGRCHRT->SGRCHRT_CHRT_CODE | ||
College | BANNER->SCBCRSE->SCBCRSE_COLL_CODE | College that is funding the course. | |
Conc1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1 | Concentration | |
Conc2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2 | Concentration | |
Course Attributes | BANNER->SCRATTR->SCRATTR_ATTR_CODE | Course level attributes from Banner. | Live |
Course Number | BANNER->SCBCRSE→SCBCRSE_CRSE_NUMB BANNER->SSBSECT->SSBSECT_CRSE_NUMB | The code that includes the level of a course and is assigned to identify the course in a systematic manner. | |
Course Prefix | BANNER->SCBCRSE→SCBCRSE_SUBJ_CODE BANNER->SSBSECT->SSBSECT_SUBJ_CODE | The alpha abbreviation assigned to a course by Common Course Numbering. | |
Course Section (=Section Number) | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | A unique identifier assigned by the institution for each section of a course offered during the term reported. | |
Course Session | BANNER->SSBSECT->SSBSECT_PTRM_CODE | ||
Course Title | BANNER->SCBCRSE_TITLE | Course title. | |
Current Enrollment | BANNER->SSBSECT->SSBSECT_ENRL | Current student enrollment, updated regularly when registration is open. | |
Delivery Method | SID_Instructional_Activity->delivery_method_ind | Online 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 | |||
CRETE ->DGWSTUDENT_REQUIREMENTS->EMAIL | |||
Enrollment # Year-1 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester one year prior for all campuses. | |
Enrollment # Year-2 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester two years prior for all campuses.. | |
Enrollment # Year-3 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester three years prior for all campuses.. | |
Enrollment # Year-4 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester four years prior for all campuses.. | |
Enrollment # Year-5 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual 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. | |
Last Enrolled Term | |||
Major | |||
Major2 | |||
Max Enrollment | BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | |
Minor1 | |||
Minor2 | |||
Name First | |||
Name Last | |||
PIDM | |||
Potential Deficit | Max Enrollment-Interest Student # | Calculated column | |
Program Name | |||
QM Flag | CRETE -> temp_qmcourses | This flag indicates the course has a Quality Matters or equivalent designation. | |
Section College | BANNER->SCBCRSE->SCBCRSE_COLL_CODE | ||
Section Department | BANNER->SCBCRSE->SCBCRSE_DEPT_CODE | ||
Section Number | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | ||
Section Type | |||
Student Level | |||
Student Type | |||
Term Code | |||
UID | |||
...