The FIF reports are part of the efforts to help USF raise the 4-year graduation rate for students. With USF embarked upon a path to preeminence, this finish in four goal will benefit students, their families, and USF. The reports developed help the Provost, Senior Executives, and Advisors achieve this goal.
...
Report Elements Glossary Table
...
Report : FIF - Summary |
|---|
Tab 1: FIF
...
Scorecard
This report summarizes the total size of the selected cohort, number . The displays on this page include:
- The number and percent of students in the cohort that have graduated
...
- to
...
- date within a 4-year window
...
- The number and percent of students estimated to graduate within the 4-year window
- The number of students either over or under the goal of 60% of the total cohort
- The anticipated 4-Year graduations by term (Fall, Spring, Summer)
Business process update - 8/3/18 - Only those students who got get a degree from the same campus as where they started are now being counted as a successful grad graduate for FIF reports.
Filters
...
Gender
Report Elements
Estimated 4-Year Graduation % (Includes Actual)
Certification Status for 4 year Anticipated Graduates
Anticipated 4-Year Graduations by termTerm
...
This report provides the estimated 4-year graduation % matrix by original college and current college. The value values in each cell represents represent the estimated 4-year graduation % of the selected cohort of students who started in the original college and are now in current college.
Business process update - 8/3/18 - Only students who got get a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.
Selecting the individual cells in the matrix adjusts the visusalizations visualizations below.
Filters
Gender
Report Elements
Estimated 4-Year Graduation %Graduation # (Includes Actual)
Anticipated 4-Year Graduations by termTerm
...
Report : FIF_Status |
|---|
Tab 1: Four Year Non Completions
This tab displays the details of the students who are not expected to graduate in 4 years.Business process update - 8/3/18 - Only students who got Details include:
- The left panel displays the total number and percent of students who are not expected to graduate and includes the number of students who are not expected to return to the university.
- The center panel consists of two displays for those students not expecting to graduate: number of years to graduate, degree plans available, and hours left to graduate.
- The right panel shows the anticipated term of graduation, such as Spring 2019 or Fall 2021.
Business process update - 8/3/18 - Only students who get a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.
Filters
Gender
Report Elements
...
Tab 2: Four Year Completions
This tab displays the details of the students who are estimated tab displays the details of the students who are estimated to graduate in 4 years.
- The left panel displays the total number and percent of students who are expected to graduate and includes the number of students currently working toward graduation.
- The center panel consists of two displays for those students expecting to graduate in 4 years: number of years to graduate, degree plans available, and hours left to graduate.
- The right panel shows the anticipated term of graduation, such as Spring 2019 or Fall 2021.
Business process update - 8/3/18 - Only students who got get a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.
...
Gender
Report Elements
...
...
Report : FIF_Detail |
|---|
This report displays the graduation status and details of the individual students in the selected cohort based on the different filters.
Business process update - 8/3/18 - Only students who got get a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.
...
Gender
Potential Years to GraduateGrad
Degree Plan AvailableAvailability
...
...
Report : FIF_ProgressReport |
|---|
The goal of this report was to show This report shows the progress of advisors on entering the FIF data for students. The data is data are by Current College.
Business process update - 8/3/18 - Only students who got get a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.
...
Students Addressed Distribution: Internal vs External -
...
Report : FIF_Major_Changes |
|---|
This report displays the details of all FIF cohort students who have changed their majors.
Business process update - 8/3/18 - Only students who got get a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.
...
Certification Status
Potential Year Years to Graduate
...
Report Elements
...
...
Report : FIF_Advisor |
|---|
This report displays the list of advisors (Major 1) for students in students for the selected cohort in the selected current campus/college/department.
Business process update - 8/3/18 - Only students who got get a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.
...
...
Report : FIF_PlannerDiscrepancyReport |
|---|
This report identifies students in the selected cohort who did not register for courses that match courses in their DegreeWorks Planner for the current and/or future registration terms.
...
Report : FIF_FinalGradesReport |
|---|
This report identifies students in the selected cohort who did not satisfactorily complete a course (after grades roll) that was in their DegreeWorks planner or who were on academic probation after end-of-term processing.
...
The table below lists all the elements used in the FIF Reports.
| Element | Source (System->Table->COLUMN) | Description | Frequency of Update | ||||||
|---|---|---|---|---|---|---|---|---|---|
Select Cohort
| Banner-> Sgrchrt | Students listed in Banner with an FTICFT<YY>08 cohort. For example, FTICFT1408, FTICFT1508. Note that these Banner cohorts FTICFT<YY>08 are translated to FIF20<YY>, for example FTICFT1408 is translated to FIF2014. FIF2014 - This cohort includes First Time In College(FTIC) students who started in Summer 2014 and continued on to Fall 2014 as a Full Time student along with students who started in Fall 2014 as a Full Time student. | Annual | ||||||
Campus Original
| SID-> Sid_Enrollments-> HOMECAMPUS | The campus where the student was enrolled when he/she first entered the cohort. | Annual | ||||||
College Original
| SID-> Sid_Enrollments-> COLLEGE | Thecollege where the student was enrolled when he/she first entered the cohort. | Annual | ||||||
Department Original
| SID-> Sid_Enrollments-> DEPARTMENT | The department where the student was enrolled when he/she first entered the cohort. | Annual | ||||||
Major Original
| SID-> Sid_Enrollments-> MAJOR | The major where the student was enrolled when he/she first entered the cohort. | Annual | ||||||
Campus Current
| Banner-> Sgbstdn-> SGBSTDN_CAMP_CODE | The campus of the student's most recent enrollment | Daily | ||||||
College Current
| Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1 | The college of the student's most recent enrollment | Daily | ||||||
Department Current
| Banner-> Sgbstdn-> SGBSTDN_DEPT_CODE | The department of the student's most recent enrollment | Daily | ||||||
Major Current
| Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1 | The major of the | |||||||
| student's most recent enrollment | Daily | ||||||||
Gender
| The gender of the student. This is used as a filter to view data for Males only or Females only. | Daily | |||||||
Actual Graduated
| Banner-> Shrdgmr | Graduation status of Awarded for Bachelor level degrees in Banner within a 4 year window from the time of cohort start. Only students who got a degree from the same campus as where they started are now being counted as a successful grad for FIF reports. | Daily | ||||||
Actual Graduated %
| Computed | Actual Graduated students as a percentage of FIF Cohort within a 4 year window from the time of cohort start. Only students who got a degree from the same campus as where they started are now being counted as a successful grad for FIF reports. | Daily | ||||||
Actual Gap
| Computed | Additional students who need to graduate within 4 years to meet the target graduation rate | Daily | ||||||
Estimated Graduates
Estimated to Graduate in 4 Years | Computed | Students Working Towards Graduation in the specified time and Actual Graduated students | Daily | ||||||
Estimated 4 Year Graduation %
| Computed | Estimated Graduates as a percentage of FIF Cohort | Daily | ||||||
Estimated Gap
| Computed | Additional students who need an Anticipated Graduation Term before the end of the fourth year to meet the target graduation rate | Daily | ||||||
Anticipated 4 Year Graduations by Term
| Banner-> Advisor_TrackStudent-> ANTICIPATEDGRADTERM | Students listed in SSM-FIF with an Anticipated Graduation Term before the end of the fourth year, but aren't documented as graduated in Banner. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018. | Daily | ||||||
Not Expected to Graduate in 4 Years
| Computed | Students listed in SSM-FIF with an Anticipated Graduation Term after the end of the fourth year. For FIF2014 this would be Fall 2018 or after. | Daily | ||||||
| Not Expected to Graduate in 4 Years % | Computed | Not Expected to Graduate in 4 Years as a percentage of FIF Cohort | Daily | ||||||
| Working Towards Graduation | Computed | Students listed in SSM-FIF with an Anticipated Graduation Term before the end of the fourth year, but aren't documented as graduated in Banner. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018. | Daily | ||||||
Return Status
| Banner-> Advisor_TrackStudent-> ISSTUDENTNOTRETURNING | Student Returning indicated Returning/Not Returning/Pending Review as identified by users in SSM-FIF | Daily | ||||||
Potential Years to Graduate
| Banner-> Advisor_TrackStudent-> POTENTIALYEARTOGRAD | Potential Years to Graduate as selected in SSM-FIF. Options include 3,4,5,6,7+ and Pending Review | Daily | ||||||
Anticipated Graduation Term
| Banner->Advisor_TrackStudent->ANTICIPATEDGRADTERM | Anticipated Graduation Term as listed in SSM-FIF. This is computed based on the highest term in the DegreeWorks plan as identified by the 'FIF%' header for each student. | Daily | ||||||
Certification Status
| The status of certification toward the FIF requirement. Selections are:
| Daily | |||||||
Degree Plan Available
| Banner->Advisor_TrackStudent-> HASFIFGRADPLAN | Yes/No/Pending Review No indicates the FIF plan exists in DegreeWorks but is either unlocked or inactive Pending Review indicates that no FIF plan exists in DegreeWorks. | Daily | ||||||
Hours Left to Graduate
| Daily | ||||||||
Degree Awarded
| Banner-> Shrdgmr | Values of Yes/No based on graduation status of Awarded for Bachelor level degrees in Banner within a 4 year window from the cohort start date. Only students who got a degree from the same campus as where they started are now being counted as a successful grad for FIF reports. | Daily | ||||||
Student Active
| Banner-> Sgbstdn-> SGBSTDN_STST_CODE | Values of Yes/No- Student is considered Active if enrolled in any of the latest 3 semesters | Daily | ||||||
UID
| SID-> SID_Enrollments-> UID | USF ID of Student | Daily | ||||||
Last Name
| SID-> SID_Person_Demo-> NAME_LAST | Last Name of Student | Daily | ||||||
First Name
| SID-> SID_Person_Demo->NAME_FIRST | First Name of Student | Daily | ||||||
Hours Left to Graduate
| Banner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATE | Number of hours remaining to graduate | Daily | ||||||
Current Cohort #
| Computed | Number of students in the cohort based on the selected filters | |||||||
Students Addressed %
| Computed | Students are considered addressed if they have graduated or have an anticipated graduation term, a potential grad year, or student not returning filled out. | |||||||
Students Addressed Distribution: Internal vs External
| Computed | Internal vs External is the ratio of addressed students who have been in the college the whole time (internal) versus those who have changed college (external). | |||||||
Total Records Returned
| Computed | Number of records returned in the report | |||||||
Data Refreshed on
| Date that the report data was refreshed overall. | Daily | |||||||
Last Refreshed Date
| Date that the student record was last updated | Daily | |||||||
Advisor Name
| Banner->Sgradvr Banner->Spriden->SPRIDEN_FIRST_NAME Banner->Spriden->SPRIDEN_LAST_NAME | First name concatenated with Last Name | Daily | ||||||
Advisor Type
| Banner->Sgradvr->ADVR_CODE | Restricted to only Priority 1 Assigned Advisor and Priority 2 Assigned Advisor | Daily | ||||||
Student Count
| Banner->Sgradvr | Count of number of students who have been assigned to that specific advisor | Daily | ||||||
Student Name
| SID-> SID_Person_Demo-> NAME_LAST SID-> SID_Person_Demo-> NAME_FIRST | Last name concatenated with First Name | Daily | ||||||
Major Change
| Computed | Based on the major having changed from when the student first entered the cohort (original major) to the current major of the student based on the most recent enrollment term | Daily | ||||||
Advisor Assignment Date
| Banner->Sgradvr->ACTIVITY_DATE | Date when a student was most recently assigned to a particular advisor | Daily | ||||||
Graduation Application Status
| Banner->Shrdgmr->SHRDGMR_DEGS_CODE | Applied (Advisor), Applied (Student), Awarded, Denied, None | Daily | ||||||
Recent Major Change Date
| The most recent date of major change | Daily | |||||||
SSM Activity Date
| Last date that any of the fields in the FIF tab in SIS has been changed | Daily | |||||||
Advised Students
| Computed | Count of students who have been assigned to that specific dvisor | Daily | ||||||
Advisor UID
| UID of Advisor | Daily | |||||||
Students with Degree Plan %
| Computed | Percentage of students who have been assigned to that specific advisor who have a degree plan in DegreeWorks as identified by the 'FIF%' header. | Daily | ||||||
Estimated Graduates in 4 Years %
| Computed | Students Working Towards Graduation in the specified time and Actual Graduated students as a percentage of the students the specific advisor has been assigned. | Daily | ||||||
Graduation Application Status Date
| Banner-> Shrdmgr-> SHRDGMR_APPL_DATE/ Banner-> Shrdmgr-> SHRDGMR_GRAD_DATE/ Banner-> Shrdmgr-> SHRDGMR_ACTIVITY_DATE |
| Daily | ||||||
Planner Term
| DegreeWorks->Dap_Plancrs_Dtl->DAP_TERM | Course term on the DegreeWorks Planner | Daily | ||||||
Registration Open
| Computed | Indicates whether or not a student can register for the term based on the registration start and end dates (SFRWCTL) | Daily | ||||||
Hold
| Computed | Student's concatenated list of holds from Banner | Daily | ||||||
Degree
| DegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREE | Student degree on the DegreeWorks Planner | Daily | ||||||
Planned Hours
| DegreeWorks->Dap_Plancrs_Dtl->DAP_CREDITS | Total planned credit hours for the term per degree for the student on the DegreeWorks Planner | Daily | ||||||
Course Credit Hours
| DegreeWorks->Rad_Class_Dtl->RAD_CREDITS | Total credit hours taken by the student for the term | Daily | ||||||
Reg Begin Date
| Banner->Sfrwctl->SFRWCTL_BEGIN_DATE | First date the student is eligible to register for the term | Daily | ||||||
Reg End Date
| Banner->Sfrwctl->SFRWCTL_END_DATE | Last date the student is eligible to register for the term | Daily | ||||||
Academic Standing
| Banner->Shrttrm->SHRTTRM_ASTD_CODE_END_OF_TERM | Academic standing of the student as of the end-of-term | Daily | ||||||
Course Term
| Banner->Shrtckn->SHRTCKN_TERM_CODE | Term when the student completed the course | Daily | ||||||
Subject
| Banner->Shrtckn->SHRTCKN_SUBJECT_CODE | Subject code of the course taken | Daily | ||||||
Course Number
| Banner->Shrtckn->SHRTCKN_CRSE_NUMB | Course number of the course taken | Daily | ||||||
Final Grade
| Banner->Shrtckg->SHRTCKG_GRDE_CODE_FINAL | Final grade the student earned for the course | Daily | ||||||
Section Number
| Banner->Shrtckn->SHRTCKN_SEQ_NO | Section number of the course taken | Daily | ||||||
Concentration1
| Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1 | Concentration Code1 of the student's primary curriculum on the most recent enrollment | Daily | ||||||
Concentration1_2
| Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1_2 | Concentration Code1_2 of the student's primary curriculum on the most recent enrollment | Daily | ||||||
Student Email
| Banner->Goremal->GOREMAL_EMAIL_ADDRESS | Preferred email (If preference has been set by student) concatenated with usf email. Business Logic - By default every student is assigned a '@mail.usf.edu' account which is shown in the data. If students have further set a 'preffered' account then it will be pulled in as well to go along with the default '@mail.usf.edu' account. In certain cases, if the student has set their '@mail.usf.edu' account then it will be duplicated and listed for complete coverage of communication options. | Daily |
...