Versions Compared

Key

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

...

Report Elements Glossary Table

...


Report : FIF_Summary

The FIF_Summary report recaps the metrics for the selected cohort pertaining to the Finish in Four objectives. The report displays in two tabs described below: FIF Scorecard and FIF Matrix. 

Tab 1: FIF Scorecard

The FIF _Summary report summarizes the total size of the selected cohortScorecard provides a summary of the Finish in Four metrics. 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 - Note: Only those students who get a degree from the same campus as where in which they started are now being counted as a successful graduate for FIF reports.

 

Filters 

Select Cohort

Campus Original

...

Data Refreshed on

 

Tab 2: FIF Matrix

This report The display on this tab provides the estimated 4-year graduation % matrix by original college and current college. The values in each cell of the table represent the estimated 4-year graduation % of the selected cohort of students who started in the their original college and are now in their current college. 

Business process update - 8/3/18 - Only Note: Only those students who get a degree from the same campus as where in which they started are now being counted as a successful grad graduate for FIF reports.

Selecting the individual cells in the matrix adjusts the visualizations below: Students who have graduated, and students who have an estimated graduation date. .

Filters 

Select Cohort

Campus Original

...

Anticipated 4-Year Graduations by Term

...

 

Report : FIF_Status

 

Tab 1: Four Year Non Completions

This tab displays the  The FIF-Status report displays the metrics of the student population and the likelihood of these students that they will graduate within the four-year window. The report displays in two tabs: Four-Year Non-Completions and Four-Year Completions. 

Tab 1: Four-Year Non-Completions

This tab displays the details of the students who are not expected to graduate in 4 years. 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 Note: Only those students who get a degree from the same campus as where in which they started are now being counted as a successful grad graduate for FIF reports.

Filters

Select Cohort

Campus Original

...

  • 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 potential 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 Note: Only those students who get a degree from the same campus as where in which they started are now being counted as a successful grad graduate for FIF reports.

Filters

Select Cohort

Campus Original

...

Data Refreshed on


...

Report : FIF_Detail

This report displays the graduation status and details of the individual The FIF_Detail report displays a table showing students in the selected cohort based on the different filters.Business process update - 8/3/18 - Only (along with other available filters, such as department or major). Details in the table include the graduation status, anticipated graduation term, whether the student is returning, and number of hours left to graduate.

Note: Only those students who get a degree from the same campus as where in which they started are now being counted as a successful grad graduate for FIF reports.

Filters 

Select Cohort

...

Data Refreshed on

 

...

 

Report : FIF_ProgressReport

...

Progress Report

The FIF_ Progress Report showcases the efforts of advisors on entering the FIF data for students. The data are by Current College.Business process update - 8/3/18 - Only working with the students in helping them complete their degree. Data are for students in their current college and delineate between those who have been in the current college the whole time vs those who have changed to their current college.  

Note: Only those students who get a degree from the same campus as where in which they started are now being counted as a successful grad graduate for FIF reports.

Filters 

Select Cohort

...

Report : FIF_Major_Changes

This The FIF_Major Changes report displays the details of all FIF cohort students students in the selected cohort who have changed their majors.

Business process update - 8/3/18 - Only Note: Only those students who get a degree from the same campus as where in which they started are now being counted as a successful grad graduate for FIF reports.


Filters 

Select Cohort

...

Last Refreshed Date

...

Report : FIF_Advisor

This report The FIF_Advisor report displays the list of advisors (Major 1) for students in students in the selected cohort and the selected current campus/college/department. Business process update - 8/3/18 - Only /department. Users can filter among colleges and departments, then select an advisor to see his or her students and their progress toward graduation. The report includes detailed metrics for both advisors and students

Note: Only those students who get a degree from the same campus where in which they started are now being counted as a successful grad graduate for FIF reports.

Filters 

Select Cohort

...

Report : FIF_PlannerDiscrepancyReport

This The FIF-Planner Discrepancy 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 termsin their DegreeWorks Planner for the current and/or future registration terms.

Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.

Filters 

Select Cohort

Campus Current

...

Report : FIF_FinalGradesReport

This The FIF_Final Grades 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.

Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.

Filters 

Select Cohort

Campus Current

...

Element

Source

(System->Table->COLUMN)

DescriptionFrequency of Update
Select Cohort
Anchor
Select Cohort
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
Anchor
Campus Original
Campus Original

SID-> Sid_Enrollments-> HOMECAMPUS

The campus where the student was enrolled when he/she first entered the cohort.Annual
College Original
Anchor
College Original
College Original
SID-> Sid_Enrollments-> COLLEGEThecollege where the student was enrolled when he/she first entered the cohort.Annual
Department Original
Anchor
Department Original
Department Original
SID-> Sid_Enrollments-> DEPARTMENTThe department where the student was enrolled when he/she first entered the cohort.Annual
Major Original
Anchor
Major Original
Major Original
SID-> Sid_Enrollments-> MAJORThe major where the student was enrolled when he/she first entered the cohort.Annual
Campus Current
Anchor
Campus Current
Campus Current
Banner-> Sgbstdn-> SGBSTDN_CAMP_CODEThe campus of the student's most recent enrollmentDaily
College Current
Anchor
College Current
College Current
Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1The college of the student's most recent enrollmentDaily
Department Current
Anchor
Department Current
Department Current
Banner-> Sgbstdn-> SGBSTDN_DEPT_CODEThe department of the student's most recent enrollmentDaily

Major Current

Anchor
Major Current
Major Current

Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1The major of the student's most recent enrollmentDaily

Gender

Anchor
Gender
Gender

 Banner→ Spbpers->SPBPERS_SEXThe gender of the student. This is used as a filter to view data for Males only or Females only.  Daily 
Actual Graduated
Anchor
Actual Graduated
Actual Graduated
Banner-> ShrdgmrGraduation 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 %
Anchor
Actual Graduated %
Actual Graduated %
ComputedActual 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
Anchor
#Actual Gap
#Actual Gap
ComputedAdditional students who need to graduate within 4 years to meet the target graduation rateDaily

Estimated Graduates

Anchor
Estimated Graduates
Estimated Graduates

Estimated to Graduate in 4 Years

ComputedStudents Working Towards Graduation in the specified time and Actual Graduated studentsDaily
Estimated 4 Year Graduation %
Anchor
Estimated 4 Year Graduation %
Estimated 4 Year Graduation %
Computed Estimated Graduates as a percentage of FIF CohortDaily
Estimated Gap
Anchor
Estimated Gap
Estimated Gap
Computed Additional students who need an Anticipated Graduation Term before the end of the fourth year to meet the target graduation rateDaily
Anticipated 4 Year Graduations by Term
Anchor
Anticipated 4 Year Graduations by Term
Anticipated 4 Year Graduations by Term
Banner-> Advisor_TrackStudent-> ANTICIPATEDGRADTERMStudents 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
Anchor
Not Expected to Graduate in 4 Years
Not Expected to Graduate in 4 Years
ComputedStudents 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 %ComputedNot Expected to Graduate in 4 Years as a percentage of FIF CohortDaily
Working Towards GraduationComputedStudents 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
Anchor
Return Status
Return Status
Banner-> Advisor_TrackStudent-> ISSTUDENTNOTRETURNINGStudent Returning indicated Returning/Not Returning/Pending Review as identified by users in SSM-FIFDaily
Potential Years to Graduate
Anchor
Potential Years to Graduate
Potential Years to Graduate
Banner-> Advisor_TrackStudent-> POTENTIALYEARTOGRADPotential Years to Graduate as selected in SSM-FIF. Options include 3,4,5,6,7+ and Pending ReviewDaily
Anticipated Graduation Term
Anchor
Anticipated Graduation Term
Anticipated Graduation Term
Banner->Advisor_TrackStudent->ANTICIPATEDGRADTERMAnticipated 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

Anchor
Certification Status
Certification Status

 

The status of certification toward the FIF requirement. Selections are:

  • Certified - after final grades
  • FIF Planner prior to graduation
  • Outstanding requirements identified
  • Pending Review
  • Pre-Certified Post Add/Drop
Daily 
Degree Plan Available
Anchor
Degree Plan Available
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

Degree Awarded

Anchor
Degree Awarded
Degree Awarded

Banner-> ShrdgmrValues 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
Anchor
Student Active
Student Active
Banner-> Sgbstdn-> SGBSTDN_STST_CODEValues of Yes/No- Student is considered Active if enrolled in any of the latest 3 semestersDaily
UID
Anchor
UID
UID
SID-> SID_Enrollments-> UIDUSF ID of StudentDaily
Last Name
Anchor
Last Name
Last Name
SID-> SID_Person_Demo-> NAME_LASTLast Name of StudentDaily
First Name
Anchor
First Name
First Name
SID-> SID_Person_Demo->NAME_FIRSTFirst Name of StudentDaily
Hours Left to Graduate
Anchor
Hours Left to Graduate
Hours Left to Graduate
Banner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATENumber of hours remaining to graduate for the students in the cohort based on the selected filters.Daily
Current Cohort #
Anchor
Current Cohort #
Current Cohort #
ComputedNumber of students in the cohort based on the selected filters 
Students Addressed %
Anchor
Students Addressed %
Students Addressed %
Computed

Students are considered addressed if they:

  • have graduated
or
  • have an anticipated graduation term
,
  • have a potential
grad year, or
  • graduation year
  • are a student not returning
filled out. 
 

Students Addressed Distribution: Internal vs External

Anchor
Students Addressed Distribution: Internal vs External
Students Addressed Distribution: Internal vs External

ComputedInternal 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
Anchor
Total Records Returned
Total Records Returned
ComputedNumber of records returned in the report 
Data Refreshed on
Anchor
Data Refreshed on
Data Refreshed on
 Date that the report data was refreshed overall.Daily
Last Refreshed Date
Anchor
Last Refreshed Date
Last Refreshed Date
 Date that the student record was last updatedDaily
Advisor Name
Anchor
Advisor Name
Advisor Name

Banner->Sgradvr

Banner->Spriden->SPRIDEN_FIRST_NAME

Banner->Spriden->SPRIDEN_LAST_NAME

First name concatenated with Last NameDaily
Advisor Type
Anchor
Description
Description
Banner->Sgradvr->ADVR_CODERestricted to only Priority 1 Assigned Advisor and Priority 2 Assigned AdvisorDaily
Student Count
Anchor
Student Count
Student Count
Banner->SgradvrCount of number of students who have been assigned to that specific advisorDaily
Student Name
Anchor
Student Name
Student Name

SID-> SID_Person_Demo-> NAME_LAST

SID-> SID_Person_Demo-> NAME_FIRST

Last name concatenated with First NameDaily
Major Change
Anchor
Major Change
Major Change
ComputedBased 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 termDaily
Advisor Assignment Date
Anchor
Advisor Assignment Date
Advisor Assignment Date
Banner->Sgradvr->ACTIVITY_DATEDate when a student was most recently assigned to a particular advisorDaily
Graduation Application Status
Anchor
Graduation Application Status
Graduation Application Status
Banner->Shrdgmr->SHRDGMR_DEGS_CODEApplied (Advisor), Applied (Student), Awarded, Denied, NoneDaily
Recent Major Change Date
Anchor
Recent Major Change Date
Recent Major Change Date
 The most recent date of major changeDaily
SSM Activity Date
Anchor
SSM Activity Date
SSM Activity Date
 Last date that any of the fields in the FIF tab in SIS has been changedDaily
Advised Students
Anchor
Advised Students
Advised Students
ComputedCount of students who have been assigned to that specific dvisorDaily
Advisor UID
Anchor
Advisor UID
Advisor UID
 UID of AdvisorDaily
Students with Degree Plan %
Anchor
Students with Degree Plan %
Students with Degree Plan %
ComputedPercentage 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 %
Anchor
Estimated Graduates in 4 Years %
Estimated Graduates in 4 Years %
ComputedStudents 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
Anchor
Graduation Application Status Date
Graduation Application Status Date

Banner-> Shrdmgr-> SHRDGMR_APPL_DATE/

Banner-> Shrdmgr-> SHRDGMR_GRAD_DATE/

Banner-> Shrdmgr-> SHRDGMR_ACTIVITY_DATE

  • If graduation application status (SHRDGMR_DEGS_CODE) is Applied or Sought then “Application Date” is used
  • If graduation application status (SHRDGMR_DEGS_CODE) is Awarded then “Graduation Date” is used
  • If graduation application status (SHRDGMR_DEGS_CODE) is Denied then “Recent Activity Date” is used
Daily
Planner Term
Anchor
Planner Term
Planner Term
DegreeWorks->Dap_Plancrs_Dtl->DAP_TERMCourse term on the DegreeWorks PlannerDaily
Registration Open
Anchor
Registration Open
Registration Open
ComputedIndicates whether or not a student can register for the term based on the registration start and end dates (SFRWCTL)Daily
Hold
Anchor
Hold
Hold
ComputedStudent's concatenated list of holds from BannerDaily
Degree
Anchor
Degree
Degree
DegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREEStudent degree on the DegreeWorks PlannerDaily

Planned Hours

Anchor
Planned Hours
Planned Hours

DegreeWorks->Dap_Plancrs_Dtl->DAP_CREDITSTotal planned credit hours for the term per degree for the student on the DegreeWorks PlannerDaily
Course Credit Hours
Anchor
Course Credit Hours
Course Credit Hours
DegreeWorks->Rad_Class_Dtl->RAD_CREDITSTotal credit hours taken by the student for the term Daily
Reg Begin Date
Anchor
Reg Begin Date
Reg Begin Date
Banner->Sfrwctl->SFRWCTL_BEGIN_DATEFirst date the student is eligible to register for the termDaily

Reg End Date

Anchor
Reg End Date
Reg End Date

Banner->Sfrwctl->SFRWCTL_END_DATELast date the student is eligible to register for the termDaily
 Academic Standing
Anchor
Academic Standing
Academic Standing
Banner->Shrttrm->SHRTTRM_ASTD_CODE_END_OF_TERM Academic standing of the student as of the end-of-termDaily 
 Course Term
Anchor
Course Term
Course Term
Banner->Shrtckn->SHRTCKN_TERM_CODE Term when the student completed the courseDaily 
 Subject
Anchor
Subject
Subject
Banner->Shrtckn->SHRTCKN_SUBJECT_CODE Subject code of the course takenDaily 
 Course Number
Anchor
Course Number
Course Number
Banner->Shrtckn->SHRTCKN_CRSE_NUMB Course number of the course taken Daily
 Final Grade
Anchor
Final Grade
Final Grade
Banner->Shrtckg->SHRTCKG_GRDE_CODE_FINALFinal grade the student earned for the course Daily 
 Section Number
Anchor
Section Number
Section Number
Banner->Shrtckn->SHRTCKN_SEQ_NO Section number of the course taken Daily 
Concentration1
Anchor
Concentration1
Concentration1
Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1

Concentration Code1 of the student's primary curriculum on the most recent enrollment

Daily
Concentration1_2
Anchor
Concentration1_2
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
Anchor
Student Email
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

...