Element | Source (System->Table->COLUMN) | Description | Frequency of Update |
---|
Select Cohort Anchor |
---|
| Select Cohort |
---|
| Select Cohort |
---|
|
| 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. | 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 |
Actual Graduated Anchor |
---|
| Actual Graduated |
---|
| Actual Graduated |
---|
|
| Banner-> Shrdgmr | Graduation status of Awarded for Bachelor level degrees in Banner | Daily |
Actual Graduated % Anchor |
---|
| Actual Graduated % |
---|
| Actual Graduated % |
---|
|
| Computed | Actual Graduated students as a percentage of FIF Cohort | Daily |
Actual Gap | Computed | Additional students who need to graduate within 4 years to meet the target graduation rate | Daily |
Estimated Graduates Anchor |
---|
| Estimated Graduates |
---|
| Estimated Graduates |
---|
|
Estimated to Graduate in 4 Years | 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 Reviewas 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. | Daily |
Scholarship Status Anchor |
---|
| Scholarship Status |
---|
| Scholarship Status |
---|
|
| Banner-> Advisor_TrackStudent-> SCHOLARSHIPSTATUS | Scholarship Status as selected in SSM-FIF. | 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 |
Certification Status Anchor |
---|
| Certification Status |
---|
| Certification Status |
---|
|
| Banner-> Advisor_TrackStudent-> PRECERTIFICATIONSTATUS | 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 |
Hours Left to Graduate Anchor |
---|
| Hours Left to Graduate |
---|
| Hours Left to Graduate |
---|
|
| | | 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 | 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 | SID-> SID_Enrollments-> UID | USF ID of Student | Daily |
Last Name | SID-> SID_Person_Demo-> NAME_LAST | Last Name of Student | Daily |
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 | 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 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 |
---|
|
| 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 | Banner->Sgradvr Banner->Spriden->SPRIDEN_FIRST_NAME Banner->Spriden->SPRIDEN_LAST_NAME | 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 |
Student Count Anchor |
---|
| Student Count |
---|
| Student Count |
---|
|
| Banner->Sgradvr | Count of number of students who have been assigned to that specifor advisor | Daily |
Student Name | SID-> SID_Person_Demo-> NAME_LAST SID-> SID_Person_Demo-> NAME_FIRST | Last name concatenated with First Name | Daily |
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 | | 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 | 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 | 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 | Computed | Indicates whether or not a student has a registration hold | Daily |
Degree | | | |
Planned Hours Anchor |
---|
| Planned Hours |
---|
| Planned Hours |
---|
|
| | | |
Course Credit Hours Anchor |
---|
| Course Credit Hours |
---|
| Course Credit Hours |
---|
|
| | | |
Reg Begin Date Anchor |
---|
| Reg Begin Date |
---|
| Reg Begin Date |
---|
|
| | | |
Reg End Date | | | |
Registration Open Anchor |
---|
| Registration Open |
---|
| Registration Open |
---|
|
| | | |
Hold Flag | | | Campus Current Anchor |
---|
| Campus Current | Campus Current | | | | College Current Anchor |
---|
College Current | College Current | | | | Department Current Anchor |
---|
Department Current | Department Current | | | |