Page Comparison

...

Report : FIF_Major_Changes

...

Element

Source

(System->Table->COLUMN)

Description

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

Thecollege where the student was enrolled when he/she first entered the cohort.

Annual

Department Original

Anchor

	Department Original
	Department Original

SID-> Sid_Enrollments-> DEPARTMENT

The department where the student was enrolled when he/she first entered the cohort.

Annual

Major Original

Anchor

	Major Original
	Major Original

SID-> Sid_Enrollments-> MAJOR

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

The campus of the student's most recent enrollment

Daily

College Current

Anchor

	College Current
	College Current

Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1

The college of the student's most recent enrollment

Daily

Department Current

Anchor

	Department Current
	Department Current

Banner-> Sgbstdn-> SGBSTDN_DEPT_CODE

The department of the student's most recent enrollment

Daily

Major Current

Anchor

	Major Current
	Major Current

Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1

The major of the student's most recent enrollment

Daily

Gender

Anchor

	Gender
	Gender

Banner→ Spbpers->SPBPERS_SEX

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

Anchor

	Actual Graduated %
	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

Anchor

	Actual Gap
	Actual Gap

Computed

Additional students who need to graduate within 4 years to meet the target graduation rate

Daily

Estimated 4-Year Graduation #

Anchor

	Estimated Graduates
	Estimated Graduates

Computed

Students Working Towards Graduation in the specified time and Actual Graduated students.

Daily

Estimated 4 Year Graduation %

Anchor

	Estimated 4 Year Graduation %
	Estimated 4 Year Graduation %

Computed

Estimated Graduates as a percentage of FIF Cohort

Daily

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 rate

Daily

Anticipated 4 Year Graduations by Term

Anchor

	Anticipated 4 Year Graduations by Term
	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

Anchor

	Not Expected to Graduate in 4 Years
	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

Anchor

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

Anchor

	Potential Years to Graduate
	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

Anchor

	Anticipated Graduation Term
	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

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

Anchor

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

Anchor

	UID
	UID

SID-> SID_Enrollments-> UID

USF ID of Student

Daily

Last Name

Anchor

	Last Name
	Last Name

SID-> SID_Person_Demo-> NAME_LAST

Last Name of Student

Daily

First Name

Anchor

	First Name
	First Name

SID-> SID_Person_Demo->NAME_FIRST

First Name of Student

Daily

Hours Left to Graduate

Anchor

	Hours Left to Graduate
	Hours Left to Graduate

Banner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATE

Number of hours remaining to graduate for the students in the cohort based on the selected filters.

Daily

Current Cohort #

Anchor

	Current Cohort #
	Current Cohort #

Computed

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

: Internal vs External


	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

Anchor

	Total Records Returned
	Total Records Returned

Computed

Number 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 updated.

Daily

Advisor Name

Anchor

	Advisor Name
	Advisor Name

Banner->Sgradvr

Banner->Spriden->SPRIDEN_FIRST_NAME

Banner->Spriden->SPRIDEN_LAST_NAME

First name concatenated with Last Name

Daily

Advisor Type

Anchor

	Description
	Description

Banner->Sgradvr->ADVR_CODE

Restricted to only Priority 1 Assigned Advisor and Priority 2 Assigned Advisor

Daily

Student Count

Anchor

	Student Count
	Student Count

Banner->Sgradvr

Count of number of students who have been assigned to that specific advisor

Daily

Student Name

Anchor

	Student Name
	Student Name

SID-> SID_Person_Demo-> NAME_LAST

SID-> SID_Person_Demo-> NAME_FIRST

Last name concatenated with First Name

Daily

Major Change

Anchor

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

Anchor

	Advisor Assignment Date
	Advisor Assignment Date

Banner->Sgradvr->ACTIVITY_DATE

Date when a student was most recently assigned to a particular advisor

Daily

Graduation Application Status

Anchor

	Graduation Application Status
	Graduation Application Status

Banner->Shrdgmr->SHRDGMR_DEGS_CODE

Applied (Advisor), Applied (Student), Awarded, Denied, None

Daily

Recent Major Change Date

Anchor

	Recent Major Change Date
	Recent Major Change Date

The most recent date of major change

Daily

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 changed

Daily

Advised Students

Anchor

	Advised Students
	Advised Students

Computed

Count of students who have been assigned to that specific dvisor

Daily

Advisor UID

Anchor

	Advisor UID
	Advisor UID

UID of Advisor

Daily

Students with Degree Plan %

Anchor

	Students with Degree Plan %
	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 %

Anchor

	Estimated Graduates in 4 Years %
	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

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_TERM

Course term on the DegreeWorks Planner

Daily

Registration Open

Anchor

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

Anchor

	Hold
	Hold

Computed

Student's concatenated list of holds from Banner

Daily

Degree

Anchor

	Degree
	Degree

DegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREE

Student degree on the DegreeWorks Planner

Daily

Planned Hours

Anchor

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

Anchor

	Course Credit Hours
	Course Credit Hours

DegreeWorks->Rad_Class_Dtl->RAD_CREDITS

Total credit hours taken by the student for the term

Daily

Reg Begin Date

Anchor

	Reg Begin Date
	Reg Begin Date

Banner->Sfrwctl->SFRWCTL_BEGIN_DATE

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_DATE

Last date the student is eligible to register for the term

Daily

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

Daily

Course Term

Anchor

	Course Term
	Course Term

Banner->Shrtckn->SHRTCKN_TERM_CODE

Term when the student completed the course

Daily

Subject

Anchor

	Subject
	Subject

Banner->Shrtckn->SHRTCKN_SUBJECT_CODE

Subject code of the course taken

Daily

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_FINAL

Final 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

...

Versions Compared

Old Version 147

New Version 148

Key

Report : FIF_Major_Changes