...
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 | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | ||
Degree App Term | BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD | ||
Degree Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | ||
Degree Type | CRETE ->DIMDGWSTUDENT>DGW_DEGREE | ||
Department | BANNER->SGBSTDN->SGBSTDN_DEPT_CODE | Department that is funding the course. | |
DGW Overall % | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGE | ||
DGW Req Comp % | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS_COMPLETION_PERCENTAGE | ||
DGW Requirements | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS | ||
CRETE ->DIMDGWSTUDENT>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 | CRETE ->DIMDGWSTUDENT->DGW_ACTIVE_TERM | ||
Major | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | ||
Major2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_2 | ||
Max Enrollment | BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | |
Minor1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_1 | ||
Minor2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_2 | ||
Name First | CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST | ||
Name Last | CRETE ->DIMDGWSTUDENT->PERSONNAMELAST | ||
PIDM | BANNER->CSCHED_REGCART->PIDM | ||
Potential Deficit | Max Enrollment-Interest Student # | Calculated column | |
Program Name | CRETE->TEMP_COURSEDEMAND->PROGRAMNAME | ||
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 | BANNER->SSBSECT->SSBSECT_SCHD_CODE | ||
Student Level | CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | ||
Student Type | BANNER->STVSTYP->STVSTYP_CODE | ||
Term Code | BANNER->CSCHED_REGCART->TERM_CODE | ||
UID | BANNER->CSCHED_REGCART->STUDENTID |
Gallery | ||||
---|---|---|---|---|
|
...