Insert excerpt
...
| Table of Contents | ||
|---|---|---|
|
Report Elements Glossary Table
...
Banner Course Attributes |
|---|
Banner Course Attributes (Codes and Descriptions)
Overview
The Course Demand reports contain information on university courses, course sections, student degree requirements, and student course selection. The display and navigation for each of the four reports is similar, with a data panel in the main work area and filter panels on the top and left side to help you narrow down the data in tables.
...
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Report Elements
Course Prefix11916479161Course Number
Section Number11916479161Section Type
Course Session11916479161Course Attributes
Report: Course Demand - Course Level |
|---|
...
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Course Prefix11916479161Course Number
Report Elements
Course Prefix11916479161Course Number
...
Report: Course Demand - Degree Works |
|---|
The Course Demand - Degree Works report lists undergraduate students and their progress toward their degree. The report provides overall progress toward the student's degree as well as progress made toward individual degree requirements, such as Civics Literacy or Foreign Language.
...
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions. .
Filters
Report Elements
Students #
Record #
...
Report: Course Demand - Section Level |
|---|
The Course Demand - Section Level report shows current student enrollment at the section level for the term selected. Data show max enrollment for the course as well as the number of interested students. The report also provides enrollment information for the five years prior to the current term.
...
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Course Prefix11916479161Course Number
Report Elements
Course Prefix11916479161Course Number
Section Number11916479161Section Type
Course Attributes11916479161Course Session
Enr # Enr # Year-1
Section College11916479161Section Department
...
| Anchor | ||||
|---|---|---|---|---|
|
Report Elements Glossary Table
...
The table below lists all of the elements used in the Course Demand reports.
Note: To sort the table elements, click the up or down arrow in the column header. Insert excerpt
| Element | Source (System->Table->Column) | Description | Frequency of Update | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BANNER->SSBSECT->SSBSECT_SEQ_NUMB | Count of SSBSECT_SEQ_NUMB | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_CAMP_CODE | Identifies the campus of the student or where the course is being taught. | Live | ||||||||||||
| BANNER->SGRCHRT->SGRCHRT_CHRT_CODE | The specific classification for students, established for tracking and reporting. This report uses the following formatting/categorization: FTICYY08 – Full-time first time in college student entering in summer (continuing to fall) or fall semesters. SKRALLYY08 – Full- or part-time first time in college student entering in summer (continuing to fall) or fall semesters. | Live | ||||||||||||
| BANNER->SCBCRSE->SCBCRSE_COLL_CODE | College that is funding the course. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1 | Student's primary concentration in area of study. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2 | Student's second concentration in area of study. | Live | ||||||||||||
| BANNER->SCRATTR->SCRATTR_ATTR_CODE | Course level attributes from Banner. | Live | ||||||||||||
| Anchor | Course Number | Course Number | Course Number|||||||||||||
Click this link to see a full list of these values: | Live | ||||||||||||||
| BANNER->SCBCRSE→SCBCRSE_CRSE_NUMB BANNER->SSBSECT->SSBSECT_CRSE_NUMB | The code that includes the level of a course to identify the course in a systematic manner. | Live | ||||||||||||
| BANNER->SCBCRSE→SCBCRSE_SUBJ_CODE BANNER->SSBSECT->SSBSECT_SUBJ_CODE | The alpha abbreviation assigned to a course by Common Course Numbering. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_SEQ_NUMB | A unique identifier assigned by the institution for each section of a course offered during the term reported. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_PTRM_CODE | An indicator used by the university to uniquely identify a session of less than 10 weeks within a summer term OR less than full term for fall and spring terms. | Live | ||||||||||||
| BANNER->SCBCRSE_TITLE | Title or description of the course. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_ENRL | Current student enrollment, updated regularly when registration is open. | Live | ||||||||||||
| SID_Instructional_Activity->delivery_method_indBANNER->SSBSECT->SSBSECT_INSTM_CODE | A classification of a course based on the delivery of direct instruction. Full Distance Learning Course (AD) - 100% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. All special course components (e.g., exams, internships, practica, clinicals, labs) that cannot be completed online can be completed off-campus. Primarily Classroom Learning Course (CL) - Less than 50% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. This designation can include activities that do not occur in a classroom (e.g., exams, internships, practica, clinicals, labs). Hybrid Course (HB) - 50-79% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. Primarily Distance Learning Course (PD) - 80-99% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. All special course components (e.g., exams, internships, practica, clinicals, labs) that cannot be completed online can be completed off-campus. | Live | ||||||||||||
| BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | Live | Flag indicating the status of the student's application toward his or her degree:
| Live | |||||||||||
| BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD | The term the student put in an application for his or her degree. | Live | ||||||||||||
| BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | Flag indicating the status of the student's application toward his or her degree:
| Live | ||||||||||||
| Anchor | Degree Type | Degree Type | Degree TypeCRETE ->DIMDGWSTUDENT>DGW_DEGREE | Live | |||||||||||
| CRETE ->DIMDGWSTUDENT>DGW_DEGREE | The degree being sought, such as BA or BS. | Weekly | |||||||||||||
| BANNER->SGBSTDN->SGBSTDN_DEPT_CODE | Department that is funding the course. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGE | Student's overall completion percentage in satisfying the DegreeWorks credit requirements toward his or her degree, including major, minor, and concentration requirements as well as university requirements. | |||||||||||||
| Weekly | |||||||||||||||
| CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS_COMPLETION_PERCENTAGE | The completion percentage by DegreeWorks requirement. , i.e., the student's progress towards completing the individual credit requirements according to catalog hours. | |||||||||||||
| Weekly | |||||||||||||||
| CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS | The individual DegreeWorks credit requirements, such as Civics Literacy or Credits Outside Major. | |||||||||||||
| Weekly | |||||||||||||||
| CRETE ->DIMDGWSTUDENT>EMAIL | The email for the student. | |||||||||||||
| Weekly | |||||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester one year prior for all campuses. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester two years prior for all campuses.. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester three years prior for all campuses.. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester four years prior for all campuses.. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester five years prior for all campuses.. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST | First name of the student. | |||||||||||||
| Weekly | |||||||||||||||
| 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. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENT->DGW_ACTIVE_TERM | The academic term in which the student was last enrolled. The format for this field is YYYYMM. | |||||||||||||
| Weekly | |||||||||||||||
| CRETE ->DIMDGWSTUDENT->PERSONNAMELAST | Last name of the student. | |||||||||||||
| Weekly | |||||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | The student's primary major. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_2 | The student's second major. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_1 | The student's primary minor. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_2 | The student's second minor. | Live | ||||||||||||
| BANNER->CSCHED_REGCART->PIDM | The internal identification number of the applicant. | Live | ||||||||||||
| Max Enrollment-Interest Student # | Calculated column = Max Enrollment - Interested Student #. | Live | ||||||||||||
| CRETE->TEMP_COURSEDEMAND->PROGRAMNAME | Name of the college program with which the course is affiliated | Live | ||||||||||||
| Anchor | QM Flag | QM Flag | QM FlagCRETE -> temp_qmcourses | A flag indicating the course has a Quality Matters or equivalent designation||||||||||||
| . | Live | ||||||||||||||
| Calculated based on filters. | Number of records showing in the report based on the filters selected. Each student has multiple records representing their selected courses. | Live | ||||||||||||
| BANNER->SCBCRSE->SCBCRSE_COLL_CODE | A code indicating the college to which this section is assigned. The code is an abbreviation for the college name, for example, ED = Education. | Live | ||||||||||||
| BANNER->SCBCRSE->SCBCRSE_DEPT_CODE | A code indicating the department to which the section is assigned. The code is an abbreviation for the department name, for example, FIN = Finance. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_SEQ_NUMB | A unique identifier assigned by the institution for each section of a course offered during the term reported. | Live | ||||||||||||
| Section Type | Section TypeBANNER->SSBSECT->SSBSECT_SCHD_CODE | The means by which instruction is predominantly delivered for this course section as reported on the Student Data Course File. | ||||||||||||
| BANNER->SSBSECT->SSBSECT_SCHD_CODE | The means by which instruction is predominantly delivered for this course section as reported on the Student Data Course File. Options for this field are:
| Live | |||||||||||||
| Calculated based on filters. | Number of students displayed in the table based on the filters selected. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | The undergraduate level of the student, with these options: 01 - Freshman | |||||||||||||
| Weekly | |||||||||||||||
| BANNER->STVSTYP->STVSTYP_CODE | Classification of student, with these options:
| Live | ||||||||||||
| BANNER->CSCHED_REGCART->TERM_CODE | The academic term in the format: YYYYMM - description. | Live | ||||||||||||
| BANNER->CSCHED_REGCART->STUDENTID | The unique University Identification number of the student. | Live |
...