| Element | Source (System->Table->Column) | Description | Frequency of Update |
|---|
| Anchor |
|---|
| Number Sections |
|---|
| Number Sections |
|---|
|
# of Sections | 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 |
| Anchor |
|---|
| Course Attributes |
|---|
| Course Attributes |
|---|
|
Course Attributes | BANNER->SCRATTR->SCRATTR_ATTR_CODE | Course level attributes from Banner. | Live |
| Anchor |
|---|
| Course Number |
|---|
| Course Number |
|---|
|
Course Number | 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 |
| Anchor |
|---|
| Course Prefix |
|---|
| Course Prefix |
|---|
|
Course Prefix | BANNER->SCBCRSE→SCBCRSE_SUBJ_CODE BANNER->SSBSECT->SSBSECT_SUBJ_CODE | The alpha abbreviation assigned to a course by Common Course Numbering. | Live |
| Anchor |
|---|
| Course Section |
|---|
| Course Section |
|---|
|
| Anchor |
|---|
| Section Number |
|---|
| Section Number |
|---|
|
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. | Live |
| Anchor |
|---|
| Course Session |
|---|
| Course Session |
|---|
|
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. | Live |
| BANNER->SCBCRSE_TITLE | Title or description of the course. | Live |
| Anchor |
|---|
| Current Enrollment |
|---|
| Current Enrollment |
|---|
|
Current Enrollment | BANNER->SSBSECT->SSBSECT_ENRL | Current student enrollment, updated regularly when registration is open. | Live |
| Anchor |
|---|
| Delivery Method |
|---|
| Delivery Method |
|---|
|
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. | Live |
| Anchor |
|---|
| Degree App Status |
|---|
| Degree App Status |
|---|
|
Degree App Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE |
| Live |
| Anchor |
|---|
| Degree App Term |
|---|
| Degree App Term |
|---|
|
Degree App Term | BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD |
| Live |
| Anchor |
|---|
| Degree Status |
|---|
| Degree Status |
|---|
|
Degree Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | Flag indicating the status of the student's application toward his or her degree: - AP - Applied
- AW - Awarded
- DE - Denied
- SO - Sought
| Live |
| CRETE ->DIMDGWSTUDENT>DGW_DEGREE |
| Live |
| BANNER->SGBSTDN->SGBSTDN_DEPT_CODE | Department that is funding the course. | LiveWeekly |
| Anchor |
|---|
| DGW Overall % |
|---|
| DGW Overall % |
|---|
|
DGW Overall % | 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. | LiveWeekly
|
| Anchor |
|---|
| DGW Req Comp % |
|---|
| DGW Req Comp % |
|---|
|
DGW Req Comp % | 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. | LiveWeekly
|
| Anchor |
|---|
| DGW Requirements |
|---|
| DGW Requirements |
|---|
|
DGW Requirements | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS | The individual DegreeWorks credit requirements, such as Civics Literacy or Credits Outside Major. | LiveWeekly
|
| CRETE ->DIMDGWSTUDENT>EMAIL | The email for the student. | Live |
| 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. | Live |
| Anchor |
|---|
| Interested Student # |
|---|
| Interested Student # |
|---|
|
Interested 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. | Live |
| Anchor |
|---|
| Last Enrolled Term |
|---|
| Last Enrolled Term |
|---|
|
Last Enrolled Term | CRETE ->DIMDGWSTUDENT->DGW_ACTIVE_TERM | The academic term in which the student was last enrolled. The format for this field is YYYYMM. | Live |
| CRETE ->DIMDGWSTUDENT->PERSONNAMELAST | Last name of the student. | Live |
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | The student's primary major. | Live |
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_2 | The student's second major. | Live |
| Anchor |
|---|
| Max Enrollment |
|---|
| Max Enrollment |
|---|
|
Max Enrollment | 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 |
| Anchor |
|---|
| Potential Deficit |
|---|
| Potential Deficit |
|---|
|
Potential Deficit | 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 |
| CRETE -> temp_qmcourses | A flag indicating the course has a Quality Matters or equivalent designation. | Live |
| Anchor |
|---|
| Number of Records |
|---|
| Number of Records |
|---|
|
Record # | 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 |
| Anchor |
|---|
| Section College |
|---|
| Section College |
|---|
|
Section College | 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 |
| Anchor |
|---|
| Section Department |
|---|
| Section Department |
|---|
|
Section Department | 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 |
| Anchor |
|---|
| Section Number |
|---|
| Section Number |
|---|
|
Section Number (=Course Section) | 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_SCHD_CODE | The means by which instruction is predominantly delivered for this course section as reported on the Student Data Course File. | Live |
| Anchor |
|---|
| Number of Students |
|---|
| Number of Students |
|---|
|
Student # | Calculated based on filters. | Number of students displayed in the table based on the filters selected. | Live |
| Anchor |
|---|
| Student Level |
|---|
| Student Level |
|---|
|
Student Level | CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | The undergraduate level of the student, with these options: 01 - Freshman
02 - Sophomore
03 - Junior
04 - Senior
06 - Unclassified | Live |
| BANNER->STVSTYP->STVSTYP_CODE | Classification of student, with these options: - Beginner, First time in college
- Doctorate of Nursing Practice
- Early admit, prior to HS grad
- Graduate
- Other undergraduate transfer
- Transfer from FL Community College
- Undeclared, unclassified
| 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 |