| Data Element | Data Source | Description | Report Pages |
|---|
Campus | BANNER->SGBSTDN->SGBSTDN_CAMP_CODE | Student home campus | 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 | 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/ Previous year Reg Count | Term Registration Comparison |
SCH | BANNER→SFRSTCR, STVRSTS→ SUM(SFRSTCR_CREDIT_HR) 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). Previous year gross SCH by home campus of the student | Term Registration Comparison |
SCH Diff | Calculated field | Current SCH - Previous SCH | Term Registration Comparison |
% Chg SCH | Calculated field | SCH Diff/Previous year SCH | 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 |
| 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. | 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 |
| Desc | BANNER->STVCLAS->STVCLAS_DESC | Description 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-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. | 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 Student | BANNER->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_ID | Unique identifier of the student | Drill-through pages |
| Admit Term | BANNER->SGBSTDN->SGBSTDN_TERM_CODE_ADMIT | Admit 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_NAME | Student's last name | Drill-through pages |
| First Name | BANNER->SPRIDEN→ SPRIDEN_FIRST_NAME | Student's first name | Drill-through pages |
| Degree 1 | BANNER->SGBSTDN->SGBSTDN_DEGC_CODE_1 | Degree 1 from the student's primary curriculum | Drill-through pages |
| Major1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | Major 1 from student's primary curriculum | Drill-through pages |
| Major1_2 | BANNER->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) | 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') | Active Students Not Registered -Drill-through page |
| USF Email | BANNER->GOREMAL | Student's USF email | Active Students Not Registered -Drill-through pageCohort Term | Calculated based on the term of entry of the incoming transfer student | Fall term of the incoming undergraduate transfer student when the student is a Summer/Fall admit. (Summer/Fall Cohort Group) Spring term of the incoming undergraduate transfer student when the student is a Spring admit. (Spring Cohort Group) | All |
Cohort Type | Calculated field | Transfer cohorts are put into four different categories. Below are the definitions: - FCSTAA – All identified transfer types with an earned Associate in Arts (AA) from the Florida College System (FCS) with start date of summer/fall or spring.
- FCSTWO – FCS w/o AA - All identified transfer types without an earned Associate in Arts (AA) from the Florida College System (FCS) with start date of summer/fall or spring.
- OTHRAA – Other AA - All identified transfer types with an earned AA from the FCS with start date of summer/fall or spring.
- OTHRWO – Other w/o AA - All identified transfer types without an earned AA from the FCS with start date of summer/fall or spring.
| All |
| Cohort Group | Calculated field | The Transfer cohorts fall into two cohort groups - Summer/Fall and Spring. - Summer/Fall - undergraduate transfer student entering in the Summer or Fall term
- Spring - undergraduate transfer students entering in the Spring term
| All |
| Students in Cohort | Calculated field | Sum total of the number of students in the cohort selected based on the slicers | Transfer Cohort Student Profile |
Full-Time Indicator | Calculated based on student level and credit hours enrolled | For the Fall term, UG students enrolled in >= 12 credits are considered full-time | All |
Campus | SID→ SID_Enrollments_All_vw→ HomeCampus | Student home campus | All |
College | SID→ SID_Enrollments_All_vw→ Global_College | College is based on Global College crosswalk post-consolidation in 2020. This is the starting college of the student. (same as initial college) | All |
Department | SID→ SID_Enrollments_All_vw→ Global_Dept | Department is based on Global College crosswalk post-consolidation in 2020 | All |
Major | SID→ SID_Major_Titles | The primary Major of the student | All |
Gender | SID→ SID_Enrollments_All_vw→ Gender | The gender of the student. Values: Male, Female, Unknown | All |
Ethnicity | SID→ SID_Enrollments_All_vw→ Ethnic | The ethnicity of the student Description of ethnic code: when E.ethnic = 'A' then 'Asian'
when E.ethnic = 'B' then 'Black'
when E.ethnic = 'H' then 'Hispanic'
when E.ethnic = 'W' then 'White'
when E.ethnic = 'I' then 'American Indian'
when E.ethnic = 'M' then 'Two or More Race'
when E.ethnic = 'O' then 'Non-Resident Alien'
when E.ethnic = 'P' then 'Native Hawaiin or Other Pacific Islander'
when E.ethnic = 'X' then 'Not-Reported' | All |
Transfer Year | Calculated field | Tracking the academic year of the transfer student. Students are followed through the end of summer so that each year begins with fall (for summer/fall cohort) or spring semester (for spring cohort) and ends with the summer semester. | Transfer Student Flow by Term Student Progression Graduation Rate Trends |
| Term | SID→ SID_Enrollments_All_vw→ TERMID | Enrollment Term | Transfer Student Flow by Term |
| Cohort N | Calculated field | Total number of students in the selected cohort | Transfer Student Flow by Term |
| Adjusted Cohort | Calculated field | A total number of students after adjusting for any students removed from the cohort. Allowable exclusions for Transfer students include those who are removed from the cohort because they entered an Advanced Graduate program without earning a bachelor's degree (Architecture, Pharmacy), students may be removed from the cohort because they were incorrectly reported or any member of the original cohort who is deceased or permanently disabled. | All |
Retained/Persisted (Fall) | Calculated field | Retention includes the number of students that re-enrolled in the 2nd fall semester. Persistence (for the purpose of this report) is defined as the number of students that re-enrolled in the corresponding fall semester plus the graduates of previous years. | Transfer Student Flow by Term |
Retention/Persistence Rate (Fall) | Calculated field | Retained or Persisted /Adjusted Cohort | Transfer Student Flow by Term |
| Total Graduated | Calculated field | The total number of students that graduated. This is a cumulative total | Transfer Student Flow by Term |
| Graduation Rate | Calculated field | Total Graduated /Adjusted Cohort | Transfer Student Flow by Term |
| Graduation Year | Calculated field | The academic year in which the student graduates. | Graduation Rate |
| Initial College | SID→ SID_Enrollments_All_vw→ Global_College
| The starting/initial college of the student | 2-Year Graduation Flow by College 3-Year Graduation Flow by College |
| Degreed College | SID→ SID_Degrees_Awarded_All_VW→ Global_College | The college from which the student graduates. For the purpose of this report, the list of values also includes ***Active***NotGraduated*** and ***Inactive***NotGraduated*** - ***Active***NotGraduated*** → These are students that are active in the Student Information System (Banner) at the 2 or 3 year benchmark (based on the report) and have not graduated.
- ***Inactive***NotGraduated*** → These are students that have stopped out i.e. are inactive in the Student Information System (Banner) at the 2 or 3-year benchmark (based on the report) and have not graduated.
| 2-Year Graduation Flow by College 3-Year Graduation Flow by College |
| DegreedN | Calculated field | The number of students that have received a degree or are in the ***Active***NotGraduated*** or ***Inactive***NotGraduated*** categories | 2-Year Graduation Flow by College 3-Year Graduation Flow by College |
