Page Comparison

Insert excerpt_DraftNote_DraftNotenopaneltrue

Course Demand Reports

The Course Demand reports provide university-wide course and course scheduling data with continuous updates from Banner. The reports offer a tool that can assist in developing courses and course schedules within and across USF colleges. These reports can be used, for example:

...

Report Elements Glossary TableThe navigation for each of the reports is similar, with a data

...

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 users you narrow down the data in tables. 

...

The panel on the right is the main work area and each report displays a table showing the filtered results. To work with data in this panel:

• Select a column header to sort by that value, such as Delivery Method or Current Enrollment.
• To export the data to a spreadsheet, click anywhere in the table and click the ellipses (...) in the top right corner. Select Export Data and follow the prompts. Note that different browsers may display different options for opening and saving the resulting spreadsheet. 
• Select an individual row in the table to highlight the item. Select it again to return to the full table view.

The next sections are broken break down by the individual report reports and includes include links to the definitions in the Report Elements Glossary Table.

...

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

Campus11916479161

Cohort11916479161

College11916479161

Degree Status11916479161

Department11916479161

Major11916479161

Program Name11916479161

Student Type11916479161

Term Code11916479161

Report Elements

PIDM11916479161

UID11916479161

Campus11916479161

College11916479161

Dept

Major1

Conc111916479161

Minor111916479161

Major211916479161

Conc211916479161

Minor211916479161

Degree Status11916479161

Course Prefix11916479161Course Number

11916479161

Section Number11916479161Section Type

11916479161

Course Session11916479161Course Attributes

11916479161

...

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

College11916479161

Department11916479161

Program Name11916479161

Term Code11916479161

Course Prefix11916479161Course Number

11916479161

Report Elements

Course Prefix11916479161Course Number

11916479161

Course Title11916479161

Delivery Method11916479161

QM Flag11916479161

Course Attributes

# of Sections

Max Enrollment11916479161

Current Enrollment

Interest Student #

Potential Deficit11916479161

11916479161

11916479161

Enr # Year-1

Enr # Year-2

Enr # Year-3

Enr # Year-4

Enr # Year-5

...

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

Campus11916479161

Cohort11916479161

College11916479161

Degree App Status11916479161

Department11916479161

Major11916479161

Report Elements

Students #

Record #

UID11916479161

Name Last

Name First

Email11916479161

Last Enrolled Term11916479161

Campus11916479161

College11916479161

Dept

Major 1

Concentration 1

Minor 1

Major 2 

Concentration 2

Minor 2

Degree App Status

Degree App Term

Degree Type

DGW Overall %

DGW Requirements

DGW Req Comp %11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

...

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

College11916479161

Department11916479161

Program Name11916479161

Term Code11916479161

Course Prefix11916479161Course Number

11916479161

Course Section11916479161

Report Elements

Course Prefix11916479161Course Number

11916479161

Section Number11916479161Section Type

11916479161

Course Title11916479161

Delivery Method11916479161

QM Flag11916479161

Course Attributes11916479161Course Session

11916479161

Max Enrollment

Interest Student #

Potential Deficit

11916479161

11916479161

Enr # Year-1

Enr # Year-2

Enr # Year-3

Enr # Year-4

Enr # Year-5

Section College11916479161Section Department

11916479161

...

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_DraftNote_DraftNotenopaneltrue

BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRADDegree App Term Status Status StatusDEGSFlag indicating the status of the student's application toward :Degree

• AP - Applied
• AW - Awarded
• DE - Denied
• SO - Sought

DGW RequirementsDGW Req Comp %>DGWEmailFirst NameInterested withQM FlagSection DepartmentBANNER->SCBCRSE->SCBCRSE_DEPT_CODE Number Number Number>SSBSECT>SSBSECTSEQNUMBSection TypeSCHDCODE

Classification of student from 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 LevelCRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION

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
Anchor Campus Campus Campus	BANNER->SSBSECT->SSBSECT_CAMP_CODE	Identifies the campus of the student or where the course is being taught.	Live
Anchor Cohort Cohort 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.	Live
Anchor College College College	BANNER->SCBCRSE->SCBCRSE_COLL_CODE	College that is funding the course.	Live
Anchor Conc1 Conc1 Concentration 1	BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1	ConcentrationStudent's primary concentration in area of study.	Live
Anchor Conc2 Conc2 Concentration 2	BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2	Concentration
Anchor
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. Click this link to see a full list of these values: http://systemacademics.usf.edu/curriculum-codes/documents/templates/banner%20course%20attributes%20-%2003-27-2020.pdf	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 assigned 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
Anchor Course Title Course Title Course Title	BANNER->SCBCRSE_TITLE	Course 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_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
Anchor Degree App Status Degree App Status Degree App Status	BANNER->SHRDGMR->SHRDGMR_DEGS_CODE
Anchor
Degree App Term	Degree App Term
Flag indicating the status of the student's application toward his or her degree: AP - Applied AW - Awarded DE - Denied SO - Sought	Live
Anchor Degree
App Term Degree
App Term Degree
App Term	BANNER->SHRDGMR->SHRDGMR_
TERM_CODE_GRAD
The term the student put in an application for his or her degree
Anchor
.
Live
Anchor Degree Type Degree Type Degree Type	CRETE ->DIMDGWSTUDENT>DGW_DEGREE	The degree being sought, such as BA or BS.	Weekly
Anchor Department Department Department	BANNER->SGBSTDN->SGBSTDN_DEPT_CODE	Department that is funding the course.	Live
CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS_COMPLETION_PERCENTAGE
Anchor
DGW Requirements	DGW Requirements
Anchor DGW Overall % DGW Overall % DGW Overall %	CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGE
Anchor
DGW Req Comp %	DGW Req Comp %
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
Anchor DGW Req Comp % DGW Req Comp % DGW Req Comp %	CRETE ->DIMDGWSTUDENTREQUIREMENTS-
>DGW_REQUIREMENTS
Anchor
Email	Email	CRETE ->DIMDGWSTUDENT>EMAIL
Anchor
First Name	First Name	CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST
Anchor
Year 1	Year 1
_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
Anchor DGW Requirements DGW Requirements DGW Requirements	CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS	The individual DegreeWorks credit requirements, such as Civics Literacy or Credits Outside Major.	Weekly
Anchor Email Email Email	CRETE ->DIMDGWSTUDENT>EMAIL	The email for the student.	Weekly
Anchor Year 1 Year 1 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.	Live
Anchor Year 2 Year 2 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..	Live
Anchor Year 3 Year 3 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..	Live
Anchor Year 4 Year 4 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..	Live
Anchor Year 5 Year 5 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..	Live
Anchor
Interested Student #
First Name First Name First Name	CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST	First name of the student.	Weekly
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.	Weekly
Anchor Last Name Last Name Last Name	CRETE ->DIMDGWSTUDENT->PERSONNAMELAST	Last name of the student.	Weekly
Anchor Major Major Major	BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1	The student's primary major.	Live
Anchor Major2 Major2 Major2	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
Anchor Minor1 Minor1 Minor1	BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_1	The student's primary minor.	Live
Anchor Minor2 Minor2 Minor2	BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_2	The student's second minor.	Live
Anchor PIDM PIDM PIDM	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
Anchor Program Name Program Name Program Name	CRETE->TEMP_COURSEDEMAND->PROGRAMNAME	Name of the college program with which the course is affiliated
.
Anchor
QM Flag	QM Flag	CRETE -> temp_qmcourses	This flag indicates the course has a Quality Matters or equivalent designation.
Anchor
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
Anchor
Section Department	Section Department
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_
Anchor
Section Type	Section Type
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
Anchor Section Type Section Type Section Type	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: C - Class Lecture D - Discussion G - Graduate Dissertation I - Internship L - Laboratory M - Medical Clinical Professional O - Other P - Individual Performance R - Supervised Research S - Supervised Teaching T - Graduate Thesis Z - Directed Individual Study	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	Weekly
Anchor Student Type Student Type Student Type	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
Anchor Term Code Term Code Term Code	BANNER->CSCHED_REGCART->TERM_CODE	The academic term in the format: YYYYMM - description.	Live
Anchor UID UID UID	BANNER->CSCHED_REGCART->STUDENTID

 

Gallery
include Advisor_Filter.png, Advisor_Data.png, Supervisor_Filter.png, Supervisor_Data.png title Doc Images

 

 

...

The unique University Identification number of the student.

Live