Versions Compared

Old Version 18

changes.mady.by.user Sangita Singh

Saved on

compared with

New Version Current

changes.mady.by.user Shruti Kumar

Saved on

Key

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

Live Search
spaceKeyODS
placeholderSearch Within ODS Knowledge Base
typepage
labelsknowledge_base
 

SSRA Semester Enrollment Planning Suite

Part of Student Success Hub

maintained by Student Success Research and Analytics


Section



Column
width95%


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
titleColorwhite
titleBGColor#006747
titleReport pages



  • Pages 1 & 2: Summer 2020/Fall 2020 -> Provide 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 Clas -> College →Provides summary numbers on registration counts by student college, campus, college, level, new/continuing, part-time/full-time status, student type and classification. 
  • Active Students Not Registered →Provides the count of active students that are not registered by college. The drill through associated with this page provides student details such as "last term enrolled" and student classification."registration hold Yes/No" column 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.  


Prev Reg Count
Panel
titleColorwhite
titleBGColor#006747
titleGlossary


Data ElementData SourceDescriptionReport Pages

Campus

BANNER-
>SSBSECT
>SGBSTDN-
>SSBSECT
>SGBSTDN_CAMP_CODE

Student home campus

1, 2, 3

Levl

Student level

1, 2, 3

Cur Reg Count

Current term headcount registration

1, 2

Cur Possible Reg Count

Active students with registration appointment

1, 2

Cur Percent Registered

Cur Reg Count/ Cur Possible Reg Count

1, 2

Term Registration Comparison 

Active Students Not Registered 

Average SCH for New FTIC's

Drill-through pages 

Level

BANNER->SGBSTDN->SGBSTDN_LEVL_CODE

Student level

Term Registration Comparison 

Registration Numbers by College

Drill-through pages 

Reg Count

BANNER→SFRSTCR, STVRSTS 

BANNER→SFRSTCA

Current term headcount registration

Previous year point-in-time headcount

registration

1, 2

Prev Possible Registration Count

Previous year point-in-time active students with registration appointment

1, 2

Prev Percent Registered

Prev Reg Count/Prev Possible Registration Count

1, 2

Reg Count Diff

Cur Reg Count - Prev Reg Count

1, 2

Percent Change in Reg

registration 

Term Registration Comparison 

Possible Reg 

BANNER→SFBRGRP, SFVRGRP


Active students with registration appointment 


Term Registration Comparison 

% Reg

Calculated field 

Reg Count/ Possible Reg

Term Registration Comparison 

Reg Diff

Calculated field 

Current Reg Count - Previous Reg Count

Term Registration Comparison 

% Chg Reg

Calculated field 

Reg Count Diff/

Prev

Previous year Reg Count

1, 2

Curr Tot SCH

Term Registration Comparison 

SCH

BANNER→SFRSTCR, STVRSTS→ SUM(SFRSTCR_CREDIT_HR)

BANNER→SFRSTCR, STVRSTS→ SUM(SFRSTCR_CREDIT_HR)

Total gross SCH

. The summary numbers are

by home campus of the student and (not the funding campus/budget unit of the course section

.

1, 2

Prev Tot SCH

).

Previous year gross SCH

. By

by home campus of the student

1, 2

Term Registration Comparison 

SCH Diff

Calculated field 
Curr Tot

Current SCH -

Prev Tot Percent Change in SCH

Previous SCH

1, 2

Term Registration Comparison 

% Chg SCH

Calculated field 

SCH Diff/

Prev Tot

College

BANNER->SCBCRSE->SCBCRSE_COLL_CODE

Student's primary college

3

New/Cont

New admit and continuing student

3

Clas

Student classification code

3

Desc

Student classification description

3

Previous year SCH

1, 2

Term Registration Comparison 

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 

CollegeTitleSID_Title_GlobalDepartments_All_VwGlobal College title

Registration Numbers by College

Drill through pages 

DepartmentTitleSID_Title_GlobalDepartments_All_VwGlobal 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.

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

Registration Numbers by College

Drill through pages 

DescBANNER->STVCLAS->STVCLAS_DESCDescription of the classification code of the student

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

Registration Numbers by College

Drill through pages 

Part-time/Full-timeCalculated 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.

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

Registration Numbers by College Average SCH for New FTIC's

Drill through pages 

International StudentBANNER->SWVRACE->SWVRACE_TRUMP_RACE = 'F'Non-Resident Alien student 

Registration Numbers by College Average SCH for New FTIC's

Drill through pages 

Term BANNER→STVTERM ->STVTERM_CODE Registration Term All
UID BANNER->SPRIDEN→ SPRIDEN_IDUnique identifier of the studentDrill-through pages 
Admit Term BANNER->SGBSTDN->SGBSTDN_TERM_CODE_ADMITAdmit term of the student

Drill-through pages 

SectionCount

BANNER→SFRSTCR

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 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 pages 
Last Name BANNER->SPRIDEN→ SPRIDEN_LAST_NAMEStudent's last name Drill-through pages 
First Name BANNER->SPRIDEN→ SPRIDEN_FIRST_NAMEStudent's first name Drill-through pages 
Degree 1BANNER->SGBSTDN->SGBSTDN_DEGC_CODE_1Degree 1 from the student's primary curriculum Drill-through pages
Major1BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1Major 1 from student's primary curriculum Drill-through pages 
Major1_2BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1_2Major 2 from student's first curriculum Drill-through pages 
Conc1BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1Student'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)Active Students Not Registered -Drill-through page
AppliedToGraduateBANNER→ 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/NBANNER→SWRHOLD , SWRFCHD Yes/No flag to indicate whether a 'Registration' hold exists on the student account (SWRFCHD_FNCT_CODE = 'R')Active Students Not Registered -Drill-through page
USF Email BANNER->GOREMALStudent's USF email Active Students Not Registered -Drill-through page




Panel
titleColorwhite
titleBGColor#006747
titleTips

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 Small 25mm Lapel Pin Button Badge Novelty Plain White Badge ...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 Black Triangle PNG, Free HD Black Triangle Transparent Image - PNGkitImage 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
titleColorwhite
titleBGColor#006747
titleYou Might Also Be Interested In...