...
Tab 2: FIF Matrix
The display on this tab provides the estimated 4-year graduation matrix by original college and current college. The values in each cell of the Estimated 4-Year Graduation % Matrix table represent the percent of students in the selected cohort who started in the original college and are now in the current college (Original College is by row and Current College is by column).
...
Tab 2: Four Year Completions
...
...
Report : FIF_Detail |
---|
The FIF_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.
...
Graduation Application Status Date
...
Report : FIF_Progress Report |
---|
...
Students Addressed Distribution: Internal vs External
...
Report : FIF_Major_Changes |
---|
...
Report Elements
...
...
Element | Source (System->Table->COLUMN) | Description | Frequency of Update | 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||||||||||||
Academic Standing
| Select Cohort |
| Banner | -> SgrchrtStudents 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 | ||||||||
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 | ||||||||||
->Shrttrm->SHRTTRM_ASTD_CODE_END_OF_TERM | The student's academic standing as of the end of the term. | Daily | |||||||||||
Actual Gap
| Computed | The 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
| Banner-> Shrdgmr | Graduation 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 %
| Computed | Actual 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
| Banner->Sgradvr->ACTIVITY_DATE | Date 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
| Banner->Sgradvr Banner->Spriden->SPRIDEN_FIRST_NAME Banner->Spriden->SPRIDEN_LAST_NAME | The advisor's first name concatenated with last name | Daily | ||||||||||
Advisor Type
| Banner->Sgradvr->ADVR_CODE | Restricted to only Priority 1 Assigned Advisor and Priority 2 Assigned Advisor. | Daily | ||||||||||
Advisor UID
| The UID of the advisor. | Daily | |||||||||||
Anticipated 4-Year Graduations by Term
| Banner-> Advisor_TrackStudent-> ANTICIPATEDGRADTERM | 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 | ||||||||||
Anticipated Graduation Term
| Banner->Advisor_TrackStudent->ANTICIPATEDGRADTERM | The 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
| Banner-> Sgbstdn-> SGBSTDN_ | ||||||||||||
CAMP_CODE | |||||||||||||
The | |||||||||||||
campus of the student's most recent enrollment. | Daily | ||||||||||||
Campus Original
| |||||||||||||
| |||||||||||||
| |||||||||||||
SID- | 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 | ||||||||||
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:
| 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|||||||||
> Sid_Enrollments-> HOMECAMPUS | The campus where the student was enrolled when he or she first entered the cohort. | Annual | |||||||||||
Certification Status
| The status of certification toward the FIF requirement. Selections are:
| Daily | |||||||||||
College Current
| Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1 | The college of the student's most recent enrollment. | Daily | ||||||||||
College Original
| SID-> Sid_Enrollments-> COLLEGE | The college where the student was enrolled when he or she first entered the cohort. | Annual | ||||||||||
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
| 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
| DegreeWorks->Rad_Class_Dtl->RAD_CREDITS | The total credit hours taken by the student for the term. | Daily | ||||||||||
Course Number
| Banner->Shrtckn->SHRTCKN_CRSE_NUMB | The course number of the course taken. | Daily | ||||||||||
Course Term
| Banner->Shrtckn->SHRTCKN_TERM_CODE | The term in which the student completed the course. | Daily | ||||||||||
Current Cohort #
| Computed | The total number of students in the cohort by college. | Daily | ||||||||||
Data Refreshed on
| Date that the report data was refreshed overall. | Daily | |||||||||||
Degree
| DegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREE | The student's degree as shown on the DegreeWorks Planner. | Daily | ||||||||||
Degree Awarded
| Banner-> Shrdgmr | This 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
| 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
| Banner-> Sgbstdn-> SGBSTDN_DEPT_CODE | The department of the student's most recent enrollment. | Daily | ||||||||||
Department Original
| SID-> Sid_Enrollments-> DEPARTMENT | The department where the student was enrolled when he or she first entered the cohort. | Annual | ||||||||||
Estimated 4-Year Graduation #
| Computed | Number of students who have graduated or are working towards graduation in the specified time. | Daily | ||||||||||
Estimated 4-Year Graduation %
| Computed | Estimated number of graduates as a percentage of the total FIF cohort. | Daily | ||||||||||
Estimated Gap
| Computed | 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 | ||||||||||
Estimated Graduates in 4 Years %
| Computed | The 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
| Banner->Shrtckg->SHRTCKG_GRDE_CODE_FINAL | The student's final grade for the course . | Daily | ||||||||||
First Name
| SID-> SID_Person_Demo->NAME_FIRST | First Name of | |||||||||||
student. | Daily | ||||||||||||
Gender
| 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:
| |||||||||
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 |
| 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 | ||||||||||
| 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 | ||||||||||
Graduation Application Status
| Banner->Shrdgmr->SHRDGMR_DEGS_CODE | A 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
| 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:
| Daily | ||||||||||
Hold
| Computed | The student's concatenated list of holds from Banner. | Daily | ||||||||||
Hours Left to Graduate
| Banner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATE | The number of hours remaining to graduate for the students in the cohort based on the selected filters. | Daily | ||||||||||
Last Name
| SID-> SID_Person_Demo-> NAME_LAST | Last Name of student. | Daily | ||||||||||
Last Refreshed Date
| Date that the student record was last updated. | Daily | |||||||||||
Major Change
| Computed | The 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
| Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1 | The student's most recently selected major. | Daily | ||||||||||
Major Original
| SID-> Sid_Enrollments-> MAJOR | The major the student selected when he or she first entered the cohort. | Annual | ||||||||||
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 | The number of students who are not expected to graduate in 4 years as a percentage of the FIF cohort. | Daily | ||||||||||
Planned Hours
| DegreeWorks->Dap_Plancrs_Dtl->DAP_CREDITS | The total planned credit hours for the term per degree for the student as listed on the DegreeWorks Planner. | Daily | ||||||||||
Planner Term
| DegreeWorks->Dap_Plancrs_Dtl->DAP_TERM | The course term as listed on the DegreeWorks Planner. | Daily | ||||||||||
Potential Years to Graduate
| Banner-> Advisor_TrackStudent-> POTENTIALYEARTOGRAD | The 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
| The date of the student's most recent change of major. | Daily | |||||||||||
Reg Begin Date
| Banner->Sfrwctl->SFRWCTL_BEGIN_DATE | The first date the student is eligible to register for the term. | Daily | ||||||||||
Reg End Date
| Banner->Sfrwctl->SFRWCTL_END_DATE | The last date the student is eligible to register for the term. | Daily | ||||||||||
Registration Open
| Computed | Indicates whether or not a student can register for the term based on the registration start and end dates (SFRWCTL). | Daily | ||||||||||
Return Status
| Banner-> Advisor_TrackStudent-> ISSTUDENTNOTRETURNING | The status of students indicated as Returning, Not Returning, or Pending Review as identified by users in SSM-FIF. | Daily | ||||||||||
Section Number
| Banner->Shrtckn->SHRTCKN_SEQ_NO | The section number of the course taken . | Daily | ||||||||||
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
| The last date that any of the fields in the FIF tab in SIS have been changed. | Daily | |||||||||||
Student Active
| Banner-> Sgbstdn-> SGBSTDN_STST_CODE | This 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
| Banner->Sgradvr | Count of the number of students who have been assigned to the specific advisor. | Daily | ||||||||||
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
| SID-> SID_Person_Demo-> NAME_LAST SID-> SID_Person_Demo-> NAME_FIRST | Student's last name concatenated with first name. | Daily | ||||||||||
Student UID
| SID-> SID_Enrollments-> UID | USF ID of the student. | Daily | ||||||||||
Students Addressed %
| Computed | Students are considered addressed if they:
| |||||||||||
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). | |||||||||||
Students with Degree Plan %
| Computed | The 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
| Banner->Shrtckn->SHRTCKN_SUBJECT_CODE | The subject code of the course taken. | Daily | ||||||||||
Total Records Returned
| Computed | The number of records returned in the report. | |||||||||||
Working Towards Graduation | Computed | The 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 |
...