Versions Compared

Key

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

...

Return Status Potential Years to GraduateAnticipated Graduation TermCertification Status Degree Plan AvailableDegree AwardedStudent Active Student UID Last Name First Name DailySelect Cohort Select Cohort> SgrchrtCampus Original College Original Department Original Major Original Campus Current College CurrentDepartment Current Major CurrentGender Actual Graduated Actual Graduated %Actual Gap Estimated 4-Year Graduation # Estimated 4 Year Graduation %Estimated Gap Anticipated 4 Year Graduations by TermNot Expected to Graduate in 4 YearsCurrent Cohort # Students Addressed %

Students Addressed Distribution: Internal vs External

Total Records Returned Data Refreshed on Last Refreshed Date Advisor Name Advisor Type Student Count Student Name Major Change Advisor Assigned Date Graduation Application Status Recent Major Change Date SSM Activity Date Advisor UID Students with Degree Plan % Estimated Graduates in 4 Years % Graduation Application Status DatePlanner TermRegistration OpenHoldDegreePlanned HoursCourse Credit HoursReg Begin DateReg End Date Academic Standing Course Term Subject Course Number Final GradeFinal grade the student earned for the course Section Concentration1Concentration1Concentration1 Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1Concentration1_2DailyPreferred If by student usf a '' students have further set a 'preffered' account then pulled as well go along with '' the '' then
Element

Source

(System->Table->COLUMN)

DescriptionFrequency of Update
Anchor
Not Expected to Graduate in 4 YearsNot Expected to Graduate in 4 YearsComputedStudents 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
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
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
Anchor
Potential Years to GraduatePotential Years to GraduateBanner-> 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
Anchor
Anticipated Graduation TermAnticipated Graduation TermBanner->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
Anchor
Certification StatusCertification 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 
Anchor
Degree Plan AvailableDegree Plan AvailableBanner->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
Anchor
Degree AwardedDegree AwardedBanner-> 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
Anchor
Student ActiveStudent ActiveBanner-> 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
Anchor
UIDUIDSID-> SID_Enrollments-> UIDUSF ID of the student.Daily
Anchor
Last NameLast NameSID-> SID_Person_Demo-> NAME_LASTLast Name of student.Daily
Anchor
First NameFirst NameSID-> SID_Person_Demo->NAME_FIRSTFirst Name of student.

 Academic Standing

Anchor

Select Cohort

Academic Standing
Academic Standing

Banner-

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
Anchor
Campus OriginalCampus Original

SID-> Sid_Enrollments-> HOMECAMPUS

The campus where the student was enrolled when he or she first entered the cohort.Annual
Anchor
College OriginalCollege OriginalSID-> Sid_Enrollments-> COLLEGEThe college where the student was enrolled when he or she first entered the cohort.Annual
Anchor
Department OriginalDepartment OriginalSID-> Sid_Enrollments-> DEPARTMENTThe department where the student was enrolled when he or she first entered the cohort.Annual
Anchor
Major OriginalMajor OriginalSID-> Sid_Enrollments-> MAJORThe major the student selected when he or she first entered the cohort.Annual
Anchor
Campus CurrentCampus CurrentBanner-> Sgbstdn-> SGBSTDN_CAMP_CODEThe campus of the student's most recent enrollment.Daily
Anchor
College CurrentCollege CurrentBanner-> Sgbstdn> SGBSTDN_COLL_CODE_1The college of the student's most recent enrollment.Daily
Anchor
Department CurrentDepartment CurrentBanner-> Sgbstdn-> SGBSTDN_DEPT_CODEThe department of the student's most recent enrollment.Daily
Anchor
Major CurrentMajor CurrentBanner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1The student's most recently selected major.Daily
Anchor
GenderGender Banner→ Spbpers->SPBPERS_SEXThe gender of the student. This is used as a filter to view data for males only or females only.  Daily 
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
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
Anchor
Actual GapActual GapComputedThe 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
Anchor
Estimated GraduatesEstimated GraduatesComputedNumber of students who have graduated or are working towards graduation in the specified time.Daily
Anchor
Estimated 4 Year Graduation %Estimated 4 Year Graduation %Computed Estimated number of graduates as a percentage of the total FIF cohort.Daily
Anchor
Estimated GapEstimated GapComputed The number of additional students who need an anticipated graduation term before the end of the fourth year to meet the target graduation rate.Daily
Anchor
Anticipated 4 Year Graduations by TermAnticipated 4 Year Graduations by TermBanner-> Advisor_TrackStudent-> 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
>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-> 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 #




Data Refreshed on

Anchor
Data Refreshed on
Data Refreshed on

 Date that the report data was refreshed overall.Daily

Degree

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




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 

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

Current Cohort #Current Cohort #ComputedThe number of students in the cohort based on the selected filters. 
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
 
Anchor
Students Addressed DistributionStudents Addressed DistributionComputedInternal 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. 
Anchor
Data Refreshed onData Refreshed on Date that the report data was refreshed overall.Daily
Anchor
Last Refreshed DateLast Refreshed Date Date that the student record was last updated.Daily
Anchor
Advisor NameAdvisor Name

Banner->Sgradvr

Banner->Spriden->SPRIDEN_FIRST_NAME

Banner->Spriden->SPRIDEN_LAST_NAME

The advisor's first name concatenated with last nameDaily
Anchor
Advisor TypeAdvisor TypeBanner->Sgradvr->ADVR_CODERestricted to only Priority 1 Assigned Advisor and Priority 2 Assigned Advisor.Daily
Anchor
Student CountStudent CountBanner->SgradvrCount of the number of students who have been assigned to the specific advisor.Daily
Anchor
Student NameStudent Name

SID-> SID_Person_Demo-> NAME_LAST

SID-> SID_Person_Demo-> NAME_FIRST

Student's last name concatenated with first name.Daily
Anchor
Major ChangeMajor ChangeComputedThe value (Yes or No) is based on the student's major having changed from when he or she first entered the cohort.Daily
Anchor
Advisor Assignment DateAdvisor Assignment DateBanner->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
Anchor
Graduation Application StatusGraduation Application StatusBanner->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
Anchor
Recent Major Change DateRecent Major Change Date The date of the student's most recent change of major.Daily
Anchor
SSM Activity DateSSM Activity Date The last date that any of the fields in the FIF tab in SIS have been changed.Daily
Anchor
Advisor UIDAdvisor UID The UID of the advisor.Daily
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
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
Anchor
Graduation Application Status DateGraduation 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 Date” is used.
  • If graduation application status (SHRDGMR_DEGS_CODE) is Denied then “Recent Activity Date” is used.
Daily
Anchor
Planner TermPlanner TermDegreeWorks->Dap_Plancrs_Dtl->DAP_TERMThe course term as listed on the DegreeWorks Planner.Daily
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
HoldHoldComputedThe student's concatenated list of holds from Banner.Daily
Anchor
DegreeDegreeDegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREEThe student's degree as shown on the DegreeWorks Planner.Daily
Anchor
Planned HoursPlanned HoursDegreeWorks->Dap_Plancrs_Dtl->DAP_CREDITSThe total planned credit hours for the term per degree for the student as listed on the DegreeWorks Planner.Daily
Anchor
Course Credit HoursCourse Credit HoursDegreeWorks->Rad_Class_Dtl->RAD_CREDITSTotal credit hours taken by the student for the term Daily
Anchor
Reg Begin DateReg Begin DateBanner->Sfrwctl->SFRWCTL_BEGIN_DATEFirst date the student is eligible to register for the termDaily
Anchor
Reg End DateReg End DateBanner->Sfrwctl->SFRWCTL_END_DATELast date the student is eligible to register for the termDaily
Anchor
Academic StandingAcademic StandingBanner->Shrttrm->SHRTTRM_ASTD_CODE_END_OF_TERM Academic standing of the student as of the end-of-termDaily 
Anchor
Course TermCourse TermBanner->Shrtckn->SHRTCKN_TERM_CODE Term when the student completed the courseDaily 
Anchor
SubjectSubjectBanner->Shrtckn->SHRTCKN_SUBJECT_CODE Subject code of the course takenDaily 
Anchor
Course NumberCourse NumberBanner->Shrtckn->SHRTCKN_CRSE_NUMB Course number of the course taken Daily
Anchor
Final GradeFinal GradeBanner->Shrtckg->SHRTCKG_GRDE_CODE_FINAL

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




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
















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 UID

Anchor
UID
UID

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













ComputedThe 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
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). 
Total Records Returned
Anchor
Total Records Returned
Total Records Returned
ComputedNumber of records returned in the report. 












Student Count
Anchor
Student Count
Student Count
Banner->SgradvrCount of the number of students who have been assigned to the specific advisor.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
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





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





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
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
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 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_TERMThe course term as listed on the DegreeWorks Planner.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
Hold
Anchor
Hold
Hold
ComputedThe student's concatenated list of holds from Banner.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




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








 Subject
Anchor
Subject
Subject
Banner->Shrtckn->SHRTCKN_SUBJECT_CODE The subject code of the course taken.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->

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

Daily
Anchor
Concentration1_2Concentration1_2Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1_2

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

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

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


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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

...