Versions Compared

Old Version 2

changes.mady.by.user Revati Vogeti

Saved on

compared with

New Version 3

changes.mady.by.user Revati Vogeti

Saved on

Key

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

...

Report : XTRN Audit Log

Filters 

Select CohortDepartment

Campus Original

College Original

...

Estimated Graduates

Data Refreshed on

 

Tab 2: FIF Matrix

This report provides the estimated 4 year graduation % matrix by original college and current college. The value in each cell represents 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 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 below.

 

Filters 

Select Cohort

Campus Original

Report Elements

 College Original

College Current

Actual Graduated

Estimated 4 Year Graduation % (Includes Actual)

Anticipated 4 Year Graduations by term

 

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 a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.

Filters

Select Cohort

Campus Original

College Original

Department Original

Report Elements

Potential Years to Graduate

Degree Plans Available

Anticipated Graduations By Term

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.

Business process update - 8/3/18 - 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.

Filters

Select Cohort

Campus Original

College Original

Department Original

Report Elements

Potential Years to Graduate

Degree Plans Available

Anticipated Graduations By Term

Hours Left to Graduate

Data Refreshed on

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 a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.

Filters 

Select Cohort

Campus Current

College Current

Department Current

Major Current

Anticipated Grad Term

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 Term

Hours Left to Graduate

Degree Awarded

Potential 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

 

 

Report : FIF_ProgressReport

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

Business process update - 8/3/18 - 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.

Filters 

Select Cohort

Campus Current

College Current

Department Current

Report Elements

Degree Plan

Student 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

Business process update - 8/3/18 - 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.

Filters 

Select Cohort

Campus Current

College Current

Department Current

Major Current

Anticipated Grad Term

Potential Year 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 Date

Report : FIF_Advisor

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

Business process update - 8/3/18 - 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.

Filters 

Select Cohort

Campus Current

College Current

Department Current

Report Elements

Advised Students

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

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.

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

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.

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

 

AnchorReport Elements GlossaryReport Elements GlossaryThe table below lists all the elements used in the FIF

  

Anchor
Report Elements Glossary
Report Elements Glossary

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

 

Element

Source

(System->Table->COLUMN)

DescriptionFrequency of Update

Select Cohort

Anchor

Select Cohort

Department

Select Cohort

Department

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
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 %
ComputedEstimated Graduates as a percentage of FIF CohortDaily
Estimated Gap
Anchor
Estimated Gap
Estimated Gap
ComputedAdditional 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
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
Hours Left to Graduate
Anchor
Hours Left to Graduate
Hours Left to Graduate
  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 graduateDaily
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 %
ComputedStudents 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

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

...