Page Comparison

Section Column

width	5%

Image Removed

Section

Column

width	95%

Panel

borderColor	#006747
bgColor	#F4F5F7

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 Twice daily. The “Last Refreshed” timestamp on each page indicates the time when the data was last refreshed.

Panel

titleColor	white
titleBGColor	#006747
title	Report pages

Pages 1 & 2: Summer 2020/Fall 2020 Term Registration Comparison →Provide summary numbers on student registration counts and the SCH generated by student home campus.
Pages 3: Fall Registration numbers by College & Student Details College →Provides summary numbers on registration counts by student college, 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 The 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.
Average SCH for New FTICs → Provides average SCH for new FTIC students (summer/fall starts) by college & campus.

All of the pages on this report provide drill throughs to student level details. Right-clicking into a data cell in the data table shows the "Drill through" option.

Levl

Panel

titleColor	white
titleBGColor	#006747
title	Glossary

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

Term Registration Comparison

Active Students Not Registered

Average SCH for New FTIC's

Drill-through pages

Level

BANNER->SGBSTDN->SGBSTDN_LEVL_CODE

Student level

1, 2, 3, 4, drill through pages - 3 & 4

Cur

Term Registration Comparison

Registration Numbers by College

Drill-through pages

Reg Count

BANNER→SFRSTCR, STVRSTS

BANNER→SFRSTCA

Current term headcount

registration

1, 2

Cur Possible Reg Count

BANNER→SFBRGRP, SFVRGRPActive 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

registration	Term Registration Comparison
Possible Reg	BANNER→SFBRGRP, SFVRGRP

Previous year point-in-time active

Active students with registration

appointment

1, 2

Prev Percent Registered

appointment

Term Registration Comparison

% Reg

Calculated field

Term Registration

Count

Comparison

1, 2

Reg

Count

Diff	Calculated field

Cur

Current Reg Count -

Prev Percent Change in

Previous Reg Count

1, 2

Term Registration Comparison
% Chg Reg	Calculated field	Reg Count Diff/

Prev Curr Tot

Previous year Reg Count

1, 2

Prev Tot SCH

BANNER→SFRSTCR, STVRSTS→ SUM(SFRSTCR_CREDIT_HR)

Term Registration Comparison

SCH

BANNER→SFRSTCR, STVRSTS→ SUM(SFRSTCR_CREDIT_HR)

Total gross SCH by home campus of the student and (not the funding campus/budget unit of the course section).

1, 2

Previous year gross SCH by home campus of the student

1, 2

Term Registration Comparison
SCH Diff	Calculated field

Curr Tot

Current SCH -

Prev Tot Percent Change in

Previous SCH

1, 2

Term Registration Comparison
% Chg SCH	Calculated field	SCH Diff/

Prev Tot

Previous year SCH

1, 23, 4, drill through pages - 3 & 4

Term Registration Comparison

College

BANNER->SGBSTDN→ SGBSTDN_COLL_CODE_1

Student's primary college

SID_Title_GlobalDepartments_All_Vw	Global College code (derived using xref-rules created by IT for mapping student college and department codes (from SGBSTDN ) to one usf global college code	Registration Numbers by College Drill through pages
CollegeTitle	SID_Title_GlobalDepartments_All_Vw	Global College title	Registration Numbers by College Drill through pages
DepartmentTitle	SID_Title_GlobalDepartments_All_Vw	Global Department (derived using xref-rules created by IT for mapping student college and department codes (from SGBSTDN ) to one usf global college code	Registration Numbers by College Drill through pages
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

Drill through pages
Clas	BANNER→F_CLASS_CALC_FNC	Classification of student code with these options: 0C Non-Degree 1F 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

Registration Numbers by College

Drill through pages

Desc

BANNER->STVCLAS->STVCLAS_DESC

Description of the classification code of the student

3, 4, drill through pages - 3 & 4

Registration Numbers by College

Drill through pages

Student Type

BANNER->STVSTYP->STVSTYP_CODE

Type of student at the time of most recent admission or readmission to the institution with these options:
B,E - grouped as FTIC's
J,U are grouped as Transfer students
H,0 are grouped as Unclassified
X External degree
M Medicine
G Graduate
T Doctor of Physical Therapy
K Doctorate of Nursing Practice
R Doctor of Pharmacy
A Physician Assistant

3, 4, drill through pages - 3 & 4

Registration Numbers by College

Drill through pages

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

Registration Numbers by College Average SCH for New FTIC's

Drill through pages

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

Registration Numbers by College Average SCH for New FTIC's

Drill through pages

International Student

BANNER->SWVRACE->SWVRACE_TRUMP_RACE = 'F'

Non-Resident Alien student

3, 4, drill through pages - 3 & 4

Registration Numbers by College Average SCH for New FTIC's

Drill through pages

Term

BANNER→STVTERM ->STVTERM_CODE

Registration Term

drill through pages - 3 & 4

All
UID	BANNER->SPRIDEN→ SPRIDEN_ID	Unique identifier of the student

drill through pages - 3 & 4

Drill-through pages
Admit Term	BANNER->SGBSTDN->SGBSTDN_TERM_CODE_ADMIT	Admit term of the student

drill through pages - 3 & 4

Sections

Drill-through pages
SectionCount	BANNER→SFRSTCR

, CreditsBANNER->SFRSTCR, SFRSTCA

BANNER→ 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 - 3Student Count Calculated field (Count of UID) Total number of active students not registered by college 4

Drill-through pages

CreditHours

BANNER→SFRSTCR

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

Drill-through pages
Last Name	BANNER->SPRIDEN→ SPRIDEN_LAST_NAME	Student's last name

drill through page - 4Deg

Drill-through pages
First Name	BANNER->SPRIDEN→ SPRIDEN_FIRST_NAME	Student's first name

drill through page - 4

Drill-through pages
Degree 1	BANNER->SGBSTDN->SGBSTDN_DEGC_CODE_1	Degree 1 from the student's primary curriculum

drill through page - 4Majr1

Drill-through pages
Major1	BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1	Major 1 from student's primary curriculum

drill through page - 4Majr desc 1

Drill-through pages
Major1_2	BANNER-

>STVMAJR->STVMAJR_DESCMajor 1 description drill through page - 4

>SGBSTDN->SGBSTDN_MAJR_CODE_1_2	Major 2 from student's first curriculum	Drill-through pages
Conc1	BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1	Student's concentration code	Active Students Not Registered -Drill-through page
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

Active Students Not Registered -Drill-through page
AppliedToGraduate	BANNER→ SHRDGMR → SHRDGMR_DEGS_CODE IN ('AP','SO', 'AW')	Student has any of the following degree status: Applied, Sought or Awarded	Active Students Not Registered -Drill-through page
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

Active Students Not Registered -Drill-through page

- 4


USF Email	BANNER->GOREMAL	Student's USF email

drill

Active Students Not Registered -Drill-through page

- 4

Panel

titleColor	white
titleBGColor	#006747
title	Tips

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 Image Removed 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 Image Removed , you 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:

Panel

titleColor	white
titleBGColor	#006747
title	You Might Also Be Interested In...

Versions Compared

Old Version 37

New Version Current

Key

Part of Student Success Hub

maintained by Student Success Research and Analytics

Semester Registration Analysis

Filter Panel

Data Panel

Tasks

Export Data to Excel

Drill through