Semester Registration Analysis
This report provides student registration counts and the gross SCH generated by student home campus and other student details. Current numbers are shown in comparison to the previous year point-in-time numbers.
Data Source: Banner
Refresh schedule: Thrice daily. The “Last Refreshed” timestamp on each page indicates the time when the data was last refreshed.
- Pages 1 & 2: Summer 2020/Fall 2020 →Provide summary numbers on student registration counts and the SCH generated by student home campus.
- Pages 3: Fall numbers by College & Student Details →Provides summary numbers on registration counts by student campus, college, level, new/continuing, part-time/full-time status, student type and classification. There is a student level drill through associated with this page.
- Page 4: Fall - Active Students Not Registered →Provides the count of active students that are not registered by college. There is a student level drill through associated with this page. The drill through provides student details such as "last term enrolled" and "registration hold Yes/No" column etc. among other data elements.
| Data Element | Data Source | Description | Report Pages |
|---|---|---|---|
Campus | BANNER->SGBSTDN->SGBSTDN_CAMP_CODE | Student home campus | 1, 2, 3, 4, drill through pages - 3 & 4 |
Levl | BANNER->SGBSTDN->SGBSTDN_LEVL_CODE | Student level | 1, 2, 3, 4, drill through pages - 3 & 4 |
Cur Reg Count | BANNER→SFRSTCR, STVRSTS | Current term headcount registration | 1, 2 |
Cur Possible Reg Count | BANNER→SFBRGRP, SFVRGRP | Active students with registration appointment | 1, 2 |
Cur Percent Registered | Calculated field | Cur Reg Count/ Cur Possible Reg Count | 1, 2 |
Prev Reg Count | BANNER→SFRSTCA | Previous year point-in-time headcount registration | 1, 2 |
Prev Possible Registration Count | BANNER→SFBRGRP, SFVRGRP | Previous year point-in-time active students with registration appointment | 1, 2 |
Prev Percent Registered | Calculated field | Prev Reg Count/Prev Possible Registration Count | 1, 2 |
Reg Count Diff | Calculated field | Cur Reg Count - Prev Reg Count | 1, 2 |
Percent Change in Reg | Calculated field | Reg Count Diff/ Prev Reg Count | 1, 2 |
Curr Tot SCH | BANNER→SFRSTCR, STVRSTS→ SUM(SFRSTCR_CREDIT_HR) | Total gross SCH by home campus of the student and (not the funding campus of the course section). | 1, 2 |
Prev Tot SCH | BANNER→SFRSTCR, STVRSTS→ SUM(SFRSTCR_CREDIT_HR) | Previous year gross SCH by home campus of the student | 1, 2 |
SCH Diff | Calculated field | Curr Tot SCH - Prev Tot SCH | 1, 2 |
Percent Change in SCH | Calculated field | SCH Diff/Prev Tot SCH | 1, 2 |
College | BANNER->SGBSTDN→ SGBSTDN_COLL_CODE_1 | Student's primary college | 3, 4, drill through pages - 3 & 4 |
New/Cont | BANNER→SGBSTDN→TERM_CODE_ADMIT | New admit/continuing student flag is derived based on the admit term of the student. When admit term = current term then new student else continuing student. | 3, 4, drill through pages - 3 & 4 |
Clas | BANNER→F_CLASS_CALC_FNC | Classification of student code with these options: 0C Non-Degree1F Freshman 2S Sophomore 3J Junior 4R Senior 5B Post Bachelors 6A Education Specialist 6C Doctoral Candidate 6D Doctorate 6M Masters 7A 1st Year Med 7B 2nd Year Med 7C 3rd Year Med 7D 4th Year Med 7P Doctor of Pharmacy 7T 1st Year DPT 7U 2nd Year DPT 7V 3rd Year DPT 6P 1st Year PA Student 6Q 2nd Year PA Student | 3, 4, drill through pages - 3 & 4 |
| Desc | BANNER->STVCLAS->STVCLAS_DESC | Description of the classification code of the student | 3, 4, drill through pages - 3 & 4 |
| Student Type | BANNER->STVSTYP->STVSTYP_CODE | Type of student at the time of most recent admission or readmission to the institution with these options: | 3, 4, drill through pages - 3 & 4 |
| Part-time/Full-time | Calculated based on student level and credit hours enrolled | Populated for Undergraduate and Graduate students. For Fall term, UG students enrolled in >= 12 credits are considered full-time and GR students enrolled >= 9 credits are considered full-time. | 3, 4, drill through pages - 3 & 4 |
| Honors Student | BANNER->SGRSATT→ SGRSATT_ATTS_CODE IN ('HONR', 'HON2', 'HONP') | Honors student identified based on the student attributes - HONR, HON2, HONP | 3, 4, drill through pages 3 & 4 |
| International Student | BANNER->SWVRACE->SWVRACE_TRUMP_RACE = 'F' | Non-Resident Alien student | 3, 4, drill through pages - 3 & 4 |
| Term | BANNER→STVTERM ->STVTERM_CODE | Registration Term | drill through pages - 3 & 4 |
| UID | BANNER->SPRIDEN→ SPRIDEN_ID | Unique identifier of the student | drill through pages - 3 & 4 |
| Admit Term | BANNER->SGBSTDN->SGBSTDN_TERM_CODE_ADMIT | Admit term of the student | drill through pages - 3 & 4 |
| Sections | BANNER→SFRSTCR, SFRSTCA | Number of course sections a student is enrolled in for the term. COUNT(SFRSTCR_CRN) for current term and COUNT(SFRSTCA_CRN) for point in time previous year. | drill through page - 3 |
| Credits | BANNER->SFRSTCR, SFRSTCA | Sum of credit hours a student is enrolled in for the term. SUM(SFRSTCR_CREDIT_HR) for current term and SUM(SFRSTCA_CREDIT_HR) for point in time previous year. | drill through page - 3 |
| Student Count | Calculated field (Count of UID) | Total number of active students not registered by college | 4 |
| Last Name | BANNER->SPRIDEN→ SPRIDEN_LAST_NAME | Student's last name | drill through page - 4 |
| First Name | BANNER->SPRIDEN→ SPRIDEN_FIRST_NAME | Student's first name | drill through page - 4 |
| Deg 1 | BANNER->SGBSTDN->SGBSTDN_DEGC_CODE_1 | Degree 1 from the student's primary curriculum | drill through page - 4 |
| Majr1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | Major 1 from student's primary curriculum | drill through page - 4 |
| Majr desc 1 | BANNER->STVMAJR->STVMAJR_DESC | Major 1 description | drill through page - 4 |
| Last Term Enrolled | Calculated based on the max term the student was enrolled | Last term the student enrolled MAX(SFRSTCR_TERM_CODE) | drill through page - 4 |
| Reg Hold Y/N | BANNER→SWRHOLD , SWRFCHD | Yes/No flag to indicate whether a 'Registration' hold exists on the student account (SWRFCHD_FNCT_CODE = 'R') | drill through page - 4 |
| USF Email | BANNER->GOREMAL | Student's USF email | drill through page - 4 |
Filter Panel
If filters are available, filter panel will be on top or left of data panel. All pages may not have filter panel.
Notes:
- Click the down arrow to select from options in the filters and narrow down your results.
- To deselect an item, click on the option again.
- Some filters are radio buttons and you can select only one item. The items in these filters are indicated as round buttons
. - Some filters allow multiple selections. To select multiples in a filter, hold the Ctrl key as you check the square boxes
.
- Filters for the report may not have Blank as an option.
Data Panel
Data panel displays the filtered results. To work with data in this panel:
- Select an individual row in the table to highlight the item/row. Select it again to return to the full table view.
- You can sort the data by column values, if the sorting is available for that column. Hover your mouse over the last row item in the column header and if a small black triangle appears
, you can sort that column in ascending or descending order by clicking on your mouse.
Select a column header to sort by that value, such as Campus.
Tasks
Export Data to Excel
To export the data results to Excel, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar 
will pop up. Click the 
in the top right corner .
A drop down menu will appear with 'Export data' as one of the options. Select Export Data to work with the data in Excel.
Note : The exported data in Excel may not look exactly like the screen.
Drill through
To 'Drill through', right click on a data cell in the data table. A menu will pop up with 'Drill Through" as one of the options. Selecting drill-though option will open another window with the details.
Note : All data tables may not have 'Drill through' functionality.
Reset to Default
If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image in the Report Header: 