Versions Compared

Key

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

The FIF reports are part  FIF reports document some of the elements in USF's 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 of students in the cohort that have graduated-to-date, number estimated to graduate, certification status of the students anticipated to graduate and counts of those anticipated to graduate by term.

 

Filters 

Select Cohort

Campus Original

College Original

Department Original

 

Report Elements

Actual Graduated %

Estimated 4 Year Graduation % (Includes Actual)

Certification Status for 4 year Anticipated Graduates

Anticipated 4 Year Graduations by term

Estimated Gap

Actual Gap

Actual Graduated

Estimated Graduates

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

Tab 1: FIF Scorecard

The FIF Scorecard 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)

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 Original

College Original

Department Original

Gender

Report Elements

Actual 4-Year Graduated %

Estimated 4-Year Graduation % (Includes Actual)

Certification Status

Anticipated 4-Year Graduations by Term

Actual Graduated

Estimated Graduates

Actual Gap

Estimated Gap

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 value values in each cell represents the estimated 4 year graduation % of of the Estimated 4-Year Graduation % Matrix table represent the percent of students in the selected cohort of students who started in the original college and are now in the current college (Original College is by row and Current College is by column)

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.

Selecting the individual cells in the matrix adjusts the visusalizations below.

 

visualizations below the table to show the number of students who have graduated and the number of students who have an estimated graduation date.

Filters 

Select Cohort

Campus Original

Gender

Report Elements

 College Original

College Current

Actual Graduated #

Estimated 4-Year Graduation %Graduation # (Includes Actual)

Anticipated 4-Year Graduations by termTerm

...

 

Report : FIF_Status

 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.

Filters

Select Cohort

Campus Original

College Original

Department Original

Report Elements

Potential Years to Graduate

Degree Plans Available

Anticipated Graduations By Term

Certification Status :  

Scholarship Status

Hours Left to Graduate

 Data Refreshed on

Tab 2:  Four Year Completions

This tab displays the details of the students who are estimated to graduate in 4 years.

Filters

Select Cohort

Campus Original

College Original

Department Original 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.

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 Original

College Original

Department Original

Gender

Report Elements

Potential Years to Graduate

Degree Plans Available

Anticipated Graduations By Term

Certification Status

Hours Left to Graduate

Scholarship Status

 Data Refreshed onOn

...

Tab 2:  Four Year Completions

This report tab displays the graduation status and details of the individual students who are estimated to graduate in the selected cohort based on the different filters.

Filters 

Select Cohort

Campus Current

College Current

Department Current

Major Current

Anticipated Grad Term

Certification Status

Potential Years to Graduate

Degree Awarded

Degree Plan Available

Return Status

Student Active

Graduation Application Status

Report Elements

Total Records Returned

UID

Last Name

First Name

Anticipated Grad 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: 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.

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 Original

College Original

Department Original

Gender

Report Elements

Potential Years to Graduate

Degree Plans Available

Anticipated Graduations By Term

Hours Left to Graduate

Certification Status

Degree Awarded

Potential Years to Grad

Degree Plan Available

Is Student Returning

Advisor Name

SSM Activity Date

Graduation Application Status Date

Last Refreshed Date

Data Refreshed on

 

 

Data Refreshed On


...

ProgressReport

Report : FIF_

Detail

The goal of this report was to show the progress of advisors on entering the FIF data for students. The data is by Current College

 

Filters 

Select CohortFIF_Detail report is a table listing students in the selected cohort (along with other available filters, such as department or major). Details in the table include the student's graduation status, anticipated graduation term, whether the student is returning, and the number of hours students have left to graduate.

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

College Current

Department Current

Major Current

...

Gender

Anticipated Grad Term

Potential Years to Grad

Degree Awarded

Degree Plan Availability

Return Status

Student Active

Graduation Application Status

Current Cohort #

Students Addressed %

Students Addressed Distribution: Internal vs External -  

Data Refreshed on

Report : FIF_Major_Changes

This report displays the details of all FIF cohort students who have changed their majors

Filters 

Select Cohort

Campus Current

College Current

Department Current

Major Current

Anticipated Grad Term

Certification Status

...

Report Elements

Total Records Returned

UID

Last Name

First Name

Anticipated Grad Term

Hours Left to Graduate

Degree Awarded

Degree Plan Availability

Return Status

Student Active

Recent Major Change Date

Report Elements

Total Records Returned

UID

Last Name

First Name

Campus Original

College Original

Department Original

Major Original

Recent Major Change Date

Degree Plan Available

Last Refreshed DatePotential Years to Grad

Degree Plan Available

Is Student Returning

Student Email

Advisor Name

SSM Activity Date

Graduation Application Status Date

Last Refreshed Date

Data Refreshed On

 

...

 

...

Advisor

Report : FIF_

This report displays the list of advisors (Major 1)  for students in the selected cohort in the selected current campus/college/department. 

Progress Report

The FIF_ Progress Report showcases the efforts of advisors on 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 in which they started are being counted as a successful graduate for FIF reports.

Filters 

Select Cohort

Campus Current

College Current

Department Current

Report Elements

...

Advised Students

...

Advisor Name

Student Count

Student UID

Student Name

Degree Plan Available

Certification Student Status

Potential Year to Graduate

Anticipated Grad Term

Hours Left to Graduate

Major Change

Degree Awarded

Is Student Returning

Advisor Assigned Date

Students with Degree Plan %

Estimated Graduates in 4 Years %

 

Report : FIF_PlannerDiscrepancyReport

This report identifies students in the selected cohort who did not register for courses that correspond to courses in their DegreeWorks Planner for the current and future registration termsCurrent Cohort #

Students Addressed % 

Students Addressed Distribution: Internal vs External  

Data Refreshed On

...

Report : FIF_Major_Changes

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

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

...

Major Current

Anticipated Grad TermPlanner Term

Certification Status

Potential Years to Graduate

Degree Awarded

Degree Plan Availability

Return Status

Student Active

Graduation Application Status

Registration Open

Hold

Report Elements

Total Records Returned

UID

Last Name

First Name

Anticipated Grad Term

Degree Awarded

Degree

Advisor Name

Planner Term

Planned Hours

Course Credit Hours

Reg Begin Date

Reg End Date

Registration Open

Hold Flag

Campus Current

College Current

Department Current

 

...

The table below lists all the elements used in the FIF Reports

 

...

Source

(System->Table->COLUMN)

...

Banner-> Sgrchrt

...

Students listed in Banner with an FIF cohort. For this year it's FIF 2014.

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.

...

SID-> Sid_Enrollments-> HOMECAMPUS

...

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.

...

Campus Original

College Original

Department Original

Major Original

Degree Plan Available

Last Refreshed Date

...

Report : FIF_Advisor

The FIF_Advisor report displays the list of advisors for students in the selected cohort. Users can filter by selecting a college and department, then select an advisor in the Advisor Details table to see his or her students and their progress toward graduation. The report includes detailed metrics for both advisors and students such as Students with a Degree Plan for the advisors and Hours Left to Graduate for the students.

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

College Current

Department Current

Report Elements

Advisor UID

Advisor Name

Students #

Students Addressed %

Students with Degree Plan %

Estimated Graduates in 4 Years %

Student UID

Student Name

Degree Plan Available

Potential Year to Graduate

Anticipated Grad Term

Hours Left to Graduate

Major Change

Degree Awarded

Is Student Returning

Advisor Assigned Date

 

 

...

Report : FIF_PlannerDiscrepancyReport

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

College Current

Department Current

Major Current

Anticipated Grad Term

Planner Term

Degree Awarded

Return Status

Student Active

Graduation Application Status

Registration Open

Report Elements

Total Records Returned

UID

Last Name

First Name

Student Email

Anticipated Grad Term

Degree Awarded

Degree

Advisor Name

Planner Term

Planned Hours

Course Credit Hours

Reg Begin Date

Reg End Date

Registration Open

Hold

Campus Current

College Current

Department Current

Major Current

Concentration1

Concentration1_2

 

Report : FIF_FinalGradesReport

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

College Current

Department Current

Major Current

Anticipated Grad Term

Academic Standing

Potential Years to Grad

Degree Awarded

Degree Plan Availability

Return Status

Student Active

Graduation Application Status

Report Elements

Total Records Returned

UID

Last Name

First Name

Student Email

Anticipated Grad Term

Hours Left to Graduate

Degree Awarded

Is Student Returning

Advisor Name

Course Term

Subject

Course Number

Section Number

Final Grade

Academic Standing

Major Current

Concentration1

Concentration1_2

 

Anchor
Report Elements Glossary
Report Elements Glossary

The table below lists all the elements used in the FIF Reports.

 

PRECERTIFICATIONSTATUSHours Left to Graduate Degree AwardedStudent Active UID Last Name First Name Hours Left to Graduate Current Cohort # Students Addressed %

Students Addressed Distribution: Internal vs External

Total Records Returned Last Refreshed Date Advisor Name Advisor NameSgradvr

Banner->Spriden->SPRIDEN_FIRST_NAME

Banner->Spriden->SPRIDEN_LAST_NAME

Advisor Type Student Count Student Name Major Change Advisor Assignment Date Graduation Application Status Recent Major Change Date SSM Activity Date Advised Students Advisor UID Students with Degree Plan % Estimated Graduates in 4 Years % Graduation Application Status DateBanner-> Shrdmgr-> SHRDGMR_APPL_DATE/GRADACTIVITYIf Date” is used
  • If graduation application status (SHRDGMR_DEGS_CODE) is Denied then “Recent Activity Date” is used
  • Planner TermRegistration OpenHoldDegreePlanned HoursCourse Credit HoursReg Begin DateReg End DateRegistration OpenHold Flag 
    Element

    Source

    (System->Table->COLUMN)

    DescriptionFrequency of Update

     Academic Standing

    Anchor
    Academic Standing
    Academic Standing

    Banner->Shrttrm->SHRTTRM_ASTD_CODE_END_OF_TERM The student's academic standing as of the end of the term.Daily 

    Actual Gap

    Anchor
    Actual Gap
    Actual Gap

    ComputedThe number of students who need to graduate within 4 years, in addition to those who have graduated, so that the cohort can meet the target graduation rate.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 the cohort start. 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.Daily

    Actual Graduated %

    Anchor
    Actual Graduated %
    Actual Graduated %

    ComputedActual Graduated students as a percentage of the FIF Cohort within a 4-year window from the time of the cohort start. 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.Daily

    Advisor Assigned Date

    Anchor
    Advisor Assignment Date
    Advisor Assignment Date

    Banner->Sgradvr->ACTIVITY_DATEDate when the student was most recently assigned to a particular advisor. The Advisor Assigned Date is a scroll bar in the FIF_Advisor report and captures students who have had an advisor assignment within the dates selected.Daily

    Advisor Name

    Anchor
    Advisor Name
    Advisor Name

    Banner->Sgradvr

    Banner->Spriden->SPRIDEN_FIRST_NAME

    Banner->Spriden->SPRIDEN_LAST_NAME

    The advisor's first name concatenated with last nameDaily

    Advisor Type

    Anchor
    Advisor Type
    Advisor Type

    Banner->Sgradvr->ADVR_CODERestricted to only Priority 1 Assigned Advisor and Priority 2 Assigned Advisor.Daily

    Advisor UID

    Anchor
    Advisor UID
    Advisor UID

     The UID of the advisor.Daily

    Anticipated 4-Year Graduations by Term

    Anchor
    Anticipated 4 Year Graduations by Term
    Anticipated 4 Year Graduations by Term

    Banner-> Advisor_TrackStudent->
    Pre-Certification Status as selected in SSM-FIF for students Working Towards Graduation (Includes Not Available, Pre-Certified Post Add/Drop and Pre-Certified Pre-Semester)Daily
    Anchor
    Hours Left to GraduateHours Left to Graduate  Daily
    Anchor
    Degree AwardedDegree AwardedBanner-> ShrdgmrValues of Yes/No based on graduation status of Awarded for Bachelor level degrees in BannerDaily
    Anchor
    Student ActiveStudent ActiveBanner-> Sgbstdn-> SGBSTDN_STST_CODEValues of Yes/No- Student is considered Active if enrolled in any of the latest 3 semestersDaily
    Anchor
    UIDUIDSID-> SID_Enrollments-> UIDUSF ID of StudentDaily
    Anchor
    #Last Name#Last NameSID-> SID_Person_Demo-> NAME_LASTLast Name of StudentDaily
    Anchor
    First NameFirst NameSID-> SID_Person_Demo->NAME_FIRSTFirst Name of StudentDaily
    Anchor
    Hours Left to GraduateHours Left to GraduateBanner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATENumber of hours remaining to graduateDaily
    Anchor
    Current Cohort #Current Cohort #ComputedNumber of students in the cohort based on the selected filters 
    Anchor
    Students Addressed %Students Addressed %ComputedStudents are considered addressed if they have graduated or have an anticipated graduation term, a potential grad year, or student not returning filled out.  
    Anchor
    Students Addressed Distribution: Internal vs ExternalStudents Addressed Distribution: Internal vs ExternalComputedInternal 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). 
    Anchor
    Total Records ReturnedTotal Records ReturnedComputedNumber of records returned in the report 
    ANTICIPATEDGRADTERMStudents listed in SSM-FIF with an anticipated graduation term on or before the end of their fourth year, but who are not documented as graduated in the Banner database. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018.Daily

    Anticipated Graduation Term

    Anchor
    Anticipated Graduation Term
    Anticipated Graduation Term

    Banner->Advisor_TrackStudent->ANTICIPATEDGRADTERMThe student's anticipated term for graduation 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

    Campus Current

    Anchor
    Campus Current
    Campus Current

    Banner-> Sgbstdn-> SGBSTDN_CAMP_CODEThe campus of the student's most recent enrollment.Daily

    Campus Original

    Anchor
    Campus Original
    Campus Original

    SID-> Sid_Enrollments-> HOMECAMPUS

    The campus where the student was enrolled when he or she first entered the cohort.Annual

    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 

    College Current

    Anchor
    College Current
    College Current

    Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1The college of the student's most recent enrollment.Daily

    College Original

    Anchor
    College Original
    College Original

    SID-> Sid_Enrollments-> COLLEGEThe college where the student was enrolled when he or she first entered the cohort.Annual

    Concentration1

    Anchor
    Concentration1
    Concentration1

    Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1

    Concentration Code1 of the student's primary curriculum on his or her 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 his or her most recent enrollment.

    Daily

    Course Credit Hours

    Anchor
    Course Credit Hours
    Course Credit Hours

    DegreeWorks->Rad_Class_Dtl->RAD_CREDITSThe total credit hours taken by the student for the term.Daily

    Course Number

    Anchor
    Course Number
    Course Number

    Banner->Shrtckn->SHRTCKN_CRSE_NUMB The course number of the course taken. Daily

    Course Term

    Anchor
    Course Term
    Course Term

    Banner->Shrtckn->SHRTCKN_TERM_CODE The term in which the student completed the course.Daily 

    Current Cohort #

    Anchor
    Current Cohort #
    Current Cohort #

    ComputedThe total number of students in the cohort by college.Daily

    Data Refreshed on

    Anchor
    Data Refreshed on
    Data Refreshed on

     Date that the report data was refreshed overall.Daily

    Degree

    Anchor

    Last Refreshed DateLast Refreshed Date Date that the student record was last updatedDaily
    Anchor
    Advisor Name

    Degree
    Degree

    DegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREEThe student's degree as shown on the DegreeWorks Planner.Daily

    Degree Awarded

    Anchor
    Degree Awarded
    Degree Awarded

    Banner->
    First name concatenated with Last NameDaily
    Anchor
    DescriptionDescriptionBanner->Sgradvr->ADVR_CODERestricted to only Priority 1 Assigned Advisor and Priority 2 Assigned AdvisorDaily
    Anchor
    Student CountStudent CountBanner->SgradvrCount of number of students who have been assigned to that specifor advisorDaily
    Anchor
    Student NameStudent Name

    SID-> SID_Person_Demo-> NAME_LAST

    SID-> SID_Person_Demo-> NAME_FIRST

    Last name concatenated with First NameDaily
    Anchor
    Major ChangeMajor ChangeComputedBased 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
    Anchor
    Advisor Assignment DateAdvisor Assignment DateBanner->Sgradvr->ACTIVITY_DATEDate when a student was most recently assigned to a particular advisorDaily
    Anchor
    Graduation Application StatusGraduation Application StatusBanner->Shrdgmr->SHRDGMR_DEGS_CODEApplied (Advisor), Applied (Student), Awarded, Denied, NoneDaily
    Anchor
    Recent Major Change DateRecent Major Change Date The most recent date of major changeDaily
    Anchor
    SSM Activity DateSSM Activity Date Last date that any of the fields in the FIF tab in SIS has been changedDaily
    Anchor
    Advised StudentsAdvised StudentsComputedCount of students who have been assigned to that specific dvisorDaily
    Anchor
    Advisor UIDAdvisor UID UID of AdvisorDaily
    Anchor
    Students with Degree Plan %Students with Degree Plan %ComputedPercentage of students who have been assigned to that specific advisor who have a degree planDaily
    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
    Anchor
    Graduation Application Status DateGraduation Application Status Date
    ShrdgmrThis shows a value of Yes or No based on graduation status of Awarded for Bachelor Level degrees in Banner within a 4-year window from the cohort start date. 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.Daily

    Degree Plan Available

    Anchor
    Degree Plan Available
    Degree Plan Available

    Banner->Advisor_TrackStudent-> HASFIFGRADPLAN

    Avaliable options are: Yes, No, and 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

    Department Current

    Anchor
    Department Current
    Department Current

    Banner-> Sgbstdn-> SGBSTDN_DEPT_CODEThe department of the student's most recent enrollment.Daily
    Department Original
    Anchor
    Department Original
    Department Original
    SID-> Sid_Enrollments-> DEPARTMENTThe department where the student was enrolled when he or she first entered the cohort.Annual

    Estimated 4-Year Graduation #

    Anchor
    Estimated Graduates
    Estimated Graduates

    ComputedNumber of students who have graduated or are working towards graduation in the specified time.Daily

    Estimated 4-Year Graduation %

    Anchor
    Estimated 4 Year Graduation %
    Estimated 4 Year Graduation %

    ComputedEstimated number of graduates as a percentage of the total FIF cohort.Daily
    Estimated Gap
    Anchor
    Estimated Gap
    Estimated Gap
    ComputedThe number of additional students who need an anticipated graduation term before the end of the fourth year to meet the target graduation rate.Daily

    Estimated Graduates in 4 Years %

    Anchor
    Estimated Graduates in 4 Years %
    Estimated Graduates in 4 Years %

    ComputedThe number of students working towards graduation in the specified time and the number of actual graduated students as a percentage of the number of students the specific advisor has been assigned.Daily

    Final Grade

    Anchor
    Final Grade
    Final Grade

    Banner->Shrtckg->SHRTCKG_GRDE_CODE_FINALThe student's final grade for the course .Daily 

    First Name

    Anchor
    First Name
    First Name

    SID-> SID_Person_Demo->NAME_FIRSTFirst Name of student.Daily

    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 

    Graduation Application Status

    Anchor
    Graduation Application Status
    Graduation Application Status

    Banner->Shrdgmr->SHRDGMR_DEGS_CODEA flag in the database indicating the status of the student's application for graduation. Available options are: Applied (Advisor), Applied (Student), Awarded, Denied, and None.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

    The date the student or advisor applied for graduation. Notes:

    • 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
    Daily
    Anchor
    Planner TermPlanner TermDegreeWorks->Dap_Plancrs_Dtl->DAP_TERMCourse Term on the DegreeWorks PlannerDaily
    Anchor
    Registration OpenRegistration OpenComputedIndicates whether or not a student can register for the term based on the registration start and end dates (SFRWCTL)Daily
    Anchor
    HoldHoldComputedIndicates whether or not a student has a registration holdDaily
    Anchor
    DegreeDegree   
    Anchor
    Planned HoursPlanned Hours   
    Anchor
    Course Credit HoursCourse Credit Hours   
    Anchor
    Reg Begin DateReg Begin Date   
    Anchor
    Reg End DateReg End Date   
    Anchor
    Registration OpenRegistration Open   
    Anchor
    Hold FlagHold Flag  
    • Date” is used.
    • If graduation application status (SHRDGMR_DEGS_CODE) is Denied then “Recent Activity Date” is used.
    Daily

    Hold

    Anchor
    Hold
    Hold

    ComputedThe student's concatenated list of holds from Banner.Daily

    Hours Left to Graduate

    Anchor
    Hours Left to Graduate
    Hours Left to Graduate

    Banner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATEThe number of hours remaining to graduate for the students in the cohort based on the selected filters.Daily

    Last Name

    Anchor
    Last Name
    Last Name

    SID-> SID_Person_Demo-> NAME_LASTLast Name of student.Daily

    Last Refreshed Date

    Anchor
    Last Refreshed Date
    Last Refreshed Date

     Date that the student record was last updated.Daily

    Major Change

    Anchor
    Major Change
    Major Change

    ComputedThe value (Yes or No) is based on the student's major having changed from when he or she first entered the cohort.Daily

    Major Current

    Anchor
    Major Current
    Major Current

    Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1The student's most recently selected major.Daily

    Major Original

    Anchor
    Major Original
    Major Original

    SID-> Sid_Enrollments-> MAJORThe major the student selected when he or she first entered the cohort.Annual

    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 %ComputedThe number of students who are not expected to graduate in 4 years as a percentage of the FIF cohort.Daily

    Planned Hours

    Anchor
    Planned Hours
    Planned Hours

    DegreeWorks->Dap_Plancrs_Dtl->DAP_CREDITSThe total planned credit hours for the term per degree for the student as listed on the DegreeWorks Planner.Daily

    Planner Term

    Anchor
    Planner Term
    Planner Term

    DegreeWorks->Dap_Plancrs_Dtl->DAP_TERMThe course term as listed on the DegreeWorks Planner.Daily

    Potential Years to Graduate

    Anchor
    Potential Years to Graduate
    Potential Years to Graduate

    Banner-> Advisor_TrackStudent-> POTENTIALYEARTOGRADThe number of years estimated for the student to graduate, as recorded in SSM-FIF. Available selections are 3, 4, 5, 6, 7+, and Pending Review.Daily

    Recent Major Change Date

    Anchor
    Recent Major Change Date
    Recent Major Change Date

     The date of the student's most recent change of major.Daily
    Reg Begin Date
    Anchor
    Reg Begin Date
    Reg Begin Date
    Banner->Sfrwctl->SFRWCTL_BEGIN_DATEThe first date the student is eligible to register for the term.Daily

    Reg End Date

    Anchor
    Reg End Date
    Reg End Date

    Banner->Sfrwctl->SFRWCTL_END_DATEThe last date the student is eligible to register for the term.Daily
    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

    Return Status

    Anchor
    Return Status
    Return Status

    Banner-> Advisor_TrackStudent-> ISSTUDENTNOTRETURNINGThe status of students indicated as Returning, Not Returning, or Pending Review as identified by users in SSM-FIF.Daily

     Section Number

    Anchor
    Section Number
    Section Number

    Banner->Shrtckn->SHRTCKN_SEQ_NO The section number of the course taken .Daily 

    Select Cohort

    Anchor
    Select Cohort
    Select Cohort

    Banner-> Sgrchrt

    Students listed in Banner with an FTICFT<YY>08 cohort, e.g., FTICFT1408, FTICFT1508. Note that these Banner cohorts FTICFT<YY>08 are translated to FIF20<YY>, for example FTICFT1408 translates to FIF2014 in these reports.

    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 full-time students.

    Annual

    SSM Activity Date

    Anchor
    SSM Activity Date
    SSM Activity Date

     The last date that any of the fields in the FIF tab in SIS have been changed.Daily
    Student Active
    Anchor
    Student Active
    Student Active
    Banner-> Sgbstdn-> SGBSTDN_STST_CODEThis field displays values of Yes or No based on whether the student is considered actively enrolled. The student is considered Active if he or she is enrolled in any of the latest 3 semesters.Daily

    Student Count

    Anchor
    Student Count
    Student Count

    Banner->SgradvrCount of the number of students who have been assigned to the specific advisor.Daily

    Student Email

    Anchor
    Student Email
    Student Email

    Banner->Goremal->GOREMAL_EMAIL_ADDRESS

    Student's preferred email (if a preference has been set) concatenated with his or her USF email.

    Business Logic - By default every student is assigned an "@mail.usf.edu" account, which is shown in the data. If a student has set a preferred account other than the USF account, it will be included in addition to the default "@mail.usf.edu" account. In certain cases, if a student has set their "@mail.usf.edu" account as preferred, it will be duplicated and listed for complete coverage of communication options.

    Daily

    Student Name

    Anchor
    Student Name
    Student Name

    SID-> SID_Person_Demo-> NAME_LAST

    SID-> SID_Person_Demo-> NAME_FIRST

    Student's last name concatenated with first name.Daily

    Student UID

    Anchor
    UID
    UID

    SID-> SID_Enrollments-> UIDUSF ID of the student.Daily

    Students Addressed %

    Anchor
    Students Addressed %
    Students Addressed %

    Computed

    Students are considered addressed if they:

    • have graduated
    • have an anticipated graduation term
    • have a potential graduation year
    • are a student not returning
     

    Students Addressed Distribution: Internal vs External

    Anchor
    Students Addressed Distribution
    Students Addressed Distribution

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

    Students with Degree Plan %

    Anchor
    Students with Degree Plan %
    Students with Degree Plan %

    ComputedThe 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

    Subject

    Anchor
    Subject
    Subject

    Banner->Shrtckn->SHRTCKN_SUBJECT_CODE The subject code of the course taken.Daily 

    Total Records Returned

    Anchor
    Total Records Returned
    Total Records Returned

    ComputedThe number of records returned in the report.
    Working Towards GraduationComputedThe number of students listed in SSM-FIF with an anticipated graduation term on or before the end of their fourth year, but who are not documented as graduated in the Banner database. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018.Daily

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    ...