| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
The table below lists all of the elements used in the Intelligent Communication Course Demand reports.
Note: To sort the table elements, click the up or down arrow in the column header.
...
| 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 | Identifies the campus of the student or where the course is being taught. | Live |
| Cohort | 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. | |
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 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 | 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. | |
| 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 | 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. | |
| Degree App Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | ||
| Degree App Term | BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD | ||
| Degree Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | Flag indicating the status of the student's application toward his or her degree:
| |
| 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 | Name of the college program the course is affiliated with. | |
| 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 | Classification of student from these options:
| Live |
| Student Level | CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | ||
| Student Type | BANNER->STVSTYP->STVSTYP_CODE | ||
| Term Code | BANNER->CSCHED_REGCART->TERM_CODE | Live | |
UID | BANNER->CSCHED_REGCART->STUDENTID |
...