Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Course Demand Reports

The :

  • View 
  • View 
  • Gain 
  • Compare

Note: Security permissions are set to enable sharing of this data to appropriate users, i.e., 

The information below describes each of the IC dashboards, provides tips on navigation, and identifies common tasks you can use to view the data.

Table of Contents
maxLevel4

Report Elements Glossary Table

...

Report: Course Demand - College Scheduler Details

The 

...

Tab 1: Advisor Summary

...

Filter Panel

The left panel allows you to filter the data that displays in the data panel. Select to filter by one or more of the following options:

Image Removed

  • Advisor College: Select a college to view appointment data for that college; the list is filtered for the advisor.
  • Appointment Outcome: Select an appointment outcome among the following choices:
    • Attended
    • No Show
    • SSP Canceled
    • Student Canceled -  Fault
    • Student Canceled – No Fault
    • Walk-in
  • FIF Cohort: Select from the list of available FIF cohorts.
  • SRKALL Cohort: Select from the list of available SRKALL cohorts.
  • Select Date: Move the slider to select a date range or click in each date field to select from a calendar.

Data Panel

The panel on the right is the main workspace and consists of five sections. These sections are described in detail below.

Image Removed

Notes:

  • The displays for these sections are interactive; that is, if you select a component in one display, the numbers in the other sections adjust accordingly.
  • To select an item in the display, click the segment of the pie or bar chart. To return to the full display, click the segment again.

Section 1: Number of Appointments

This section (shaded green above) displays the number of advisor appointments and provides comparisons with the advisor’s college. The statistics show the following: 

  • Avg Daily Appts: Represents the average daily appointments for the advisor. The basis for this average is the number of days the advisor holds appointments and is not a daily measure.
  • Total Appts: Represents the total number of appointments for this advisor.
  • Avg. Daily Appts for College: Represents the average daily appointments for advisors in the same college as this advisor. The basis for this average is the following:
    • Each advisor's average daily appointments is calculated (number of appointments / number of working days holding appointments).
    • The average for the college is then calculated for all advisors in the college (sum of advisor averages / number of advisors).
  • Total Appts for College: Represents the number of appointments for all advisors in the same college as this advisor.

For example, Jane Advisor has 74 appointments in March and has nine days on which she holds appointments. Her average daily appointment measure is eight. The advisors in her college have a total of 808 appointments for the month. Based on the calculations using the actual days each of those advisors holds these appointments, the average daily appointment count for the college is 11.

Section 2: Appointments

This section displays the number of appointments for the advisor by month. If you filter by a date range in the Filter Panel, it displays numbers only for that time period. You can drill down using the “drill” buttons at the top left of this section. The default selection displays numbers of appointments by month.

  • Drill down Image Removedto view the days of the month to show appointments on particular dates in the month. 
  • Drill down again to show appointments by hours of the day, such as 7 am or 2 pm. 
  • Drill up Image Removedto show appointments by year.

You can also drill down to select a specific month and show the distribution among the dates for that month. To do this: 

  1. Click the down arrow to the right Image Removed to turn on Drill Down (Tool Tip: Click to turn on Drill Down). 
  2. Click the month you wish to view the appointment distribution.
  3. Optionally click a day to view distribution among hours in the day.
  4. To exit Drill Down mode, click the down arrow again.
  5. Drill upImage Removedto return to the monthly display.

Section 3: Appointment Status

This section displays the status of appointment. Each advisor appointment has one status based on these selections:

  • Canceled
  • Completed
  • Confirmed
  • Scheduled
  • Walk-in

You can click on any segment of the pie chart to adjust the display of data in other sections for that appointment type.

For example, if you select “Canceled” in the pie chart, the other sections display actual numbers for the canceled appointments. This can be helpful, for example, in determining the reasons for the canceled appointments or to see if these appointments fell on particular days of the month. Select “Canceled” again to return to all statuses.

Section 4: Reasons for Appointments

This section lists reasons for the appointments in a bar graph. Each advisor appointment has one reason based on these selections:

  • Academic Dismissal/Reinstatement
  • ACR Petitions
  • Career Advising
  • Change of Major/Major Reselection
  • Form Completion
  • General Advising
  • Holds
  • Minor & Certificates
  • Not Available
  • Pre-Orientation/Transfer Advising
  • Scheduling/Course Planning/Degree Progression

As with the other sections, you can click on one component or selection to adjust the data in the other sections for that appointment reason.

For example, if you select “Holds,” the other displays adjust to show numbers for appointments set up to discuss registration holds.

Section 5: Appointments by Student

This table displays a list of students with advisor appointments during the date range selected. The number of students in the display changes depending on the filter(s) you select as well as the refinements you make in the bar and pie charts. The table layout displays the following fields:  

  • Student UID
  • Count of Appts
  • Date Recent Appt
  • Campus
  • College
  • Department
  • Major
  • Full Name
  • Email

You can expand the student listing to a full screen by clicking the “Focus mode” icon. To see this icon, hover over the Appointments by Student section and select the icon on the far right. Your screen changes to display a full list of the appointments. You can sort by any of the columns in the table by clicking the column label in the Header. To return to the previous display, click “Back to Report.”

Sample Tasks

The following are a few examples of ways you can view the data as well as explore the interactivity among the elements in the display.

Student Appointment Records

You can view a list of students for any of the specific metrics in the Appointments, Appointment Status, or Reasons for Appointments sections. For example:

View student names for registration holds:

  1. Right-click on the Holds bar in the Reasons for Appointments section.
  2. Select See Records. The report displays the students requesting advisor appointments for registration holds in table format. 
  3. Select Back to report to return to the dashboard. 

View student names for appointments in June:

  1. Right click on the June bar in the Appointments bar graph.
  2. Select See Records. The report displays a list of students having advisor appointments in June. 
  3. Select Back to report to return to the dashboard. 

Appointments by Calendar Ranges

You can view appointment data through a month to see if appointment reasons are concentrated on particular days. Note that the default view of the Appointments section shows appointments by month.

  1. If desired, select a date range in the Select Date filter.
  2. Drill the data to the day level by clicking the Image Removed button in the header of the Appointments (calendar) section.
  3. Select a particular day of the month to view the reasons for the appointments that day. For example, selecting the 1st of the month may indicate a concentration of scheduling changes.  
  4. Select the day again to return to all appointments.
  5. Select an appointment reason in the Reasons for Appointments section to view how concentrated or spread out those appointments are for the month.

Canceled Appointments

You can focus on appointment cancellations using both the metrics in the Data Panel and the filters in the Filter Panel.

  1. Select “Student Canceled – Fault” in the Appointment Outcome field in Filter panel to view the appointments canceled by students.
  2. View the calendar concentration for the times of the year and times of the month when these cancellations occurred.
  3. View the reasons the appointments were made to see if there are trends in the types of appointments.
  4. Finally, open the Appointments by Student listing (click the Focus mode icon) to view a list of these students and identify any students with multiple cancellations.
  5. To return to the full display, select Back to report, then click the "Student Canceled – Fault" again in the Appointment Outcome field to deselect this option and display all appointments. 

Reasons for Appointments

You can view metrics based on selected appointment reasons, such as students changing majors, to view appointment statuses or calendar concentrations.

  1. For example, select “Change of Major/Major Reselection” in the Reasons for Appointments section.
  2. View the appointment statuses and concentration of this appointment type by month or day.
  3. Right click the bar for “Change of Major/Major Reselection,” then click See Records to view the list of the students looking for advisor help in changing majors.
  4. Select Back to report to return to the dashboard.
Filters

Advisor Name

Advisor College

Appointment Outcome

FIF Cohort

SRKALL Cohort

Select Date

Report Elements

Avg Daily Appts

Avg Daily Appts for College

Total Appts

Total Appts for College

Appointment Status

Appointment Reason

Student UID

Count of Appts

Date Recent Appt

Campus

College

Department

Major

Full Name

Email

...

Report: Course Demand - Course Level

The IC – Supervisor Summary dashboard provides metrics of advisor appointment data from a supervisor or coordinator viewpoint. 

Filters

Campus

College

Department

Appointments Outcome

FIF Cohort

SRKALL Cohort

Select Date

Advisor Name

Report Elements

Daily Appointment Capacity

Avg Daily Appts

Total Appts

Capacity

Appointment Status

Reasons for Appointments

Student Appointment Distribution

Advisor UID

Name

#Appts

#Working Days

Avg Appts

Currently Enrolled Students With No Appointments

...

Report: Course Demand - Degree Works

The IC – Supervisor Summary dashboard provides metrics of advisor appointment data from a supervisor or coordinator viewpoint. 

Filters

Campus

...

Report: Course Demand - Section Level

The IC – Supervisor Summary dashboard provides metrics of advisor appointment data from a supervisor or coordinator viewpoint. 

Filters

Campus

...

Report Elements Glossary Table

 

The table below lists all of the elements used in the Intelligent Communication reports.

Note: To sort the table elements, click the up or down arrow in the column header. 

...

Source

(System->Table->Column)

...

appiandb.AS_appointment ->appointmentid

Calculated

...

The number of appointments for the advisor in the selected date range.

...

Crete.FIF_SPRIDEN_Staging -> SPRIDEN_LAST_NAME] + Crete.FIF_SPRIDEN_Staging -> SPRIDEN_FIRST_NAME

...

appiandb.AS_reference  -> displayValue in

...

The result of the advisor appointment. Available values for this field are:

  • Attended
  • No Show
  • SSP Canceled
  • Student Canceled – Fault
  • Student Canceled – No fault
  • Walk-In

...

appiandb.AS_reference -> displayValue in

...

The reason the student requested the appointment. Available values for this field are:

  • Academic Dismissal/Reinstatement
  • ACR Petitions
  • Career Advising
  • Change of Major/Major Re-selection
  • Form Completion
  • General Advising
  • Holds
  • Minor & Certificates
  • Not Available
  • Pre-Orientation/Transfer Advising
  • Scheduling/Course Planning/Degree Progression

...

appiandb.AS_reference -> displayValue in (18,19,25,26,28,29)

...

The status of the appointment. Available values for this field are:

  • Canceled
  • Completed
  • Confirmed
  • Scheduled
  • Walk-In

The Appointment Status pie chart displays numbers for each of the above appointment statuses based on the filters selected.

...

appiandb.AS_reference -> displayValue in

...

Calculated:

...

Calculated:
AVERAGE(DISTINCTCOUNT (appiandb.AS_appointment  -> appointmentId)) per College per day

...

SID.IC_StudentList_Vw -> CampusTitle

...

The targeted capacity for the number of appointments an advisor holds per day, established by the department and college.

The default appointment capacity is set to 100 and can be adjusted by using the slider or by typing in a different value in the field. An upper limit of 200 is hard-coded.

...

appiandb.AS_unitBookingTreeLogic->levelTwoDesc

SID. IC_StudentList_Vw -> DepartmentTitle

...

DISTINCTCOUNT(IC[appointmentId])

...

Calculated: DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) where attendeeTypeRefId = 17

...

Total Appts for College

...

Calculated:
DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) per College

...

 

Gallery
includeAdvisor_Filter.png, Advisor_Data.png, Supervisor_Filter.png, Supervisor_Data.png
titleDoc Images

 

 

 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:

  • To assist the Registrar's Office in reviewing the demand for classes by term to ensure the necessary classes are offered and enough seats are available by section.
  • To identify students close to completion and view the courses these students have shown interest in taking.
  • To identify courses that have had at least one instance of distant learning in the past five years.

Note: Security permissions are set to enable sharing of this data to appropriate users.

The information below describes each of the four Course Demand reports and provides tips on navigation.


Tip
titleData Updates

Data are continuously updated to provide real-time information.

Table of Contents
maxLevel4

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. 

Filter Panels

Filters are listed on both the top and left panels of the report. Click the down arrow to select from options in the filters and narrow down your results.

Notes: 

  • If you select an item in one filter, the table adjusts immediately. In addition, the selections available in the remaining filters are narrowed down to correspond with the selected filter. For example, if you select Course Prefix = ADV, the Course Numbers selections are only those for Advertising. 
  • To "deselect" an item, click the option again. 
  • To select multiples in a filter, hold the Ctrl key as you check the boxes. Note that not all filters allow you to select more than one (Term Code for one).

Data Panel

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 break down the individual reports and include links to the definitions in the Report Elements Glossary Table.

Report: Course Demand - College Scheduler Details

The Course Demand - College Scheduler Details report lists undergraduate students and the courses they expressed interest in scheduling within College Scheduler. This report does not give information on past classes, but shows course selection by student for the term selected in the Filter panel. 

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

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

Report Elements

11916479161

11916479161

11916479161

11916479161

Dept

Major1

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161


Report: Course Demand - Course Level

The Course Demand - Course Level report shows current student enrollment at the course 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

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

Report Elements

11916479161

11916479161

11916479161

11916479161

11916479161

# of Sections

11916479161

11916479161

11916479161

11916479161

Enr # Year-1

Enr # Year-2

Enr # Year-3

Enr # Year-4

Enr # Year-5


...


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. 

You can use this report for example, to identify students who are close to completing their degree to review the courses they will need to graduate. 

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

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

Report Elements

Students #

Record #

11916479161

Name Last

Name First

11916479161

11916479161

11916479161

11916479161

Dept

Major 1

Concentration 1

Minor 1

Major 2 

Concentration 2

Minor 2

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161


...


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. 

Note that you can drill to College, Department, and Program Name to see courses linked to programs of study in Acalog.  

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

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

Report Elements

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

11916479161

Enr # Year-1

Enr # Year-2

Enr # Year-3

Enr # Year-4

Enr # Year-5

11916479161

11916479161




...


Anchor
Report Elements Glossary
Report Elements Glossary

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. 


Element

Source

(System->Table->Column)

DescriptionFrequency of Update

Anchor
Number Sections
Number Sections
# of Sections

BANNER->SSBSECT->SSBSECT_SEQ_NUMBCount of SSBSECT_SEQ_NUMBLive

Anchor
Campus
Campus
Campus

BANNER->SSBSECT->SSBSECT_CAMP_CODEIdentifies 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_CODECollege that is funding the course.Live

Anchor
Conc1
Conc1
Concentration 1

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1Student's primary concentration in area of study.Live

Anchor
Conc2
Conc2
Concentration 2

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2Student'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 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_NUMBA 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_CODEAn 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_TITLETitle or description of the course.Live

Anchor
Current Enrollment
Current Enrollment
Current Enrollment

BANNER->SSBSECT->SSBSECT_ENRLCurrent student enrollment, updated regularly when registration is open.Live

Anchor
Delivery Method
Delivery Method
Delivery Method

BANNER->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

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_GRADThe term the student put in an application for his or her degree.Live

Anchor
Degree Type
Degree Type
Degree Type

CRETE ->DIMDGWSTUDENT>DGW_DEGREEThe degree being sought, such as BA or BS.Weekly

Anchor
Department
Department
Department

BANNER->SGBSTDN->SGBSTDN_DEPT_CODEDepartment that is funding the course.Live

Anchor
DGW Overall %
DGW Overall %
DGW Overall %

CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGEStudent'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_COMPLETION_PERCENTAGEThe 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_REQUIREMENTSThe individual DegreeWorks credit requirements, such as Civics Literacy or Credits Outside Major.Weekly

Anchor
Email
Email
Email

CRETE ->DIMDGWSTUDENT>EMAILThe email for the student.Weekly

Anchor
Year 1
Year 1
Enrollment # Year-1

SID_Instructional_Activity->SECTN_HEADCNT_ENROLActual 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_ENROLActual 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_ENROLActual 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_ENROLActual 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_ENROLActual enrollment number for the course in the same semester five years prior for all campuses..Live

Anchor
First Name
First Name
First Name

CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRSTFirst 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_TERMThe 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->PERSONNAMELASTLast name of the student.Weekly

Anchor
Major
Major
Major

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1The student's primary major.Live

Anchor
Major2
Major2
Major2

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_2The student's second major.Live

Anchor
Max Enrollment
Max Enrollment
Max Enrollment

BANNER->SSBSECT->SSBSECT_MAX_ENRLIndicates the total number of available seats in the current semester for all campuses.Live

Anchor
Minor1
Minor1
Minor1

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_1The student's primary minor.Live

Anchor
Minor2
Minor2
Minor2

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_2The student's second minor.Live

Anchor
PIDM
PIDM
PIDM

BANNER->CSCHED_REGCART->PIDMThe 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->PROGRAMNAMEName of the college program with which the course is affiliated.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_CODEA 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_CODEA 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_NUMBA 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_CODEThe academic term in the format: YYYYMM - description.Live

Anchor
UID
UID
UID

BANNER->CSCHED_REGCART->STUDENTIDThe unique University Identification number of the student.Live