Advising Survey Invitations

As part of the Advising Sign-In System, students are sent an email with a brief message from the VP of Undergraduate Studies inviting them to participate in a survey regarding their most recent visit with the Advising Unit.  The email contains a web link to a Websurveyor survey based upon the unit with which they had contact and the type of contact (email, phone, walkin).

There is an Advising Survey Dates application in UNF Administrative Applications to set up the survey period.  Students are selected if their visit occurs within the survey period.  If the student is selected, they will get an email with a link to the survey.  Students receive only one invitation during a feedback period.  The invitation is sent no sooner than 24 hours and no later than 48 hours from the time of the first visit during a feedback period.  There are separate emails depending on the type of advising visit, walk-in or remote session.

 

Technical Notes: 

Technical Notes

	UC4 Chain		NSTU_ADVISING
	Job		WSM5000
	Package		wksmsrt
	Procedure		p_survey_invite

Osprey Maps

The Osprey Maps System is a tracking system to monitor degree progression for undergraduate students. Each Osprey Map consists of Schedule courses and Mile Marker courses.

 

 

Initial Hours

Each undergraduate student will have a Map Term assigned to them based on their attempted hours.  All students’ initial hours are based on their maximum student type and first term as that student type.  All FTICs (student type of B or E) will be set to zero. Transfer students (student type of J or U) with less than 60 attempted hours will be set to their number of attempted hours.  Transfer students with more than 60 attempted hours will be set to 61.  This nightly process calculates each student’s attempted hours and inserts this number into a UNF table in the Osprey Map system.  The students’ attempted hours determine which Map Term they are evaluated against at any given time.    

 

Technical Notes: 

Technical Notes

	UC4 Chain		NSTU_ADVISING; NSTU_MONTHLY_PROCESSES
	Job		WSM5060
	Package		wksmacr
	Procedure		p_initial_hours

 

Set Status

Each undergraduate student will have one of the following statuses: On-Track, Off-Track, Off-Track In-Progress.  The status is set according to the Map Term that the student is in (see Initial Hours) with regard to completion of any mile markers that occur prior to that Map Term.  This nightly process selects all students in the UNF table (see Initial Hours) who have not already received a degree and who are not deceased then determines their Status for each mile marker and an overall Status. For each mile marker, a record is inserted into a UNF table.  A separate table holds the overall status.

 

Technical Notes: 

Technical Notes

	UC4 Chain		NSTU_ADVISING; NSTU_MONTHLY_PROCESSES
	Job		WSM5061
	Package		wksmacr
	Procedure		p_set_status

 

Set Holds and/or Send Emails

As part of the Osprey Map System, the administrator can set up a program to place a hold or send emails to students.  There are separate holds and email text for Off-Track and Off-Track In-Progress statuses.  This Banner job will process all active programs for the input term and college where an auto hold or auto email is indicated for each status.  Students with the indicated statuses will receive a hold and/or email (whichever is indicated).  The hold and email information is available in the Osprey Map application when selecting the Control Information button.   

 

Technical Notes:

Technical Notes

	UC4 Chain		None
	Job		WSM5062
	Package		wksmacr
	Procedure		p_set_holds_emails

 

Set Status for Student

There are occasions when an advisor may make changes to a student’s degree evaluation and will want to update the Osprey Map at the same time.  This is a Banner job that the advisors can run for a single student to update their status for the Osprey Map.  This is the same process as ‘Set Status’ described above but for a single student.

 

Technical Notes:

Technical Notes

	UC4 Chain		None
	Job		WSM5063
	Package		wksmacr
	Procedure		p_set_status_single

 

Off-Track Report

This report select all students in the UNF table (see Set Status) with a General Student (SGASTDN) record for the input term and college who do not have a future General Student (SGASTDN) record with a different major and writes each off-track or off-track in-progress mile marker to a file.  The user is then able to retrieve this file from their ‘Y’ drive.      

 

Technical Notes:

	UC4 Chain		None
	Job		WSM1025
	Package		wksmacr
	Procedure		p_off_track_report

 

Matriculation Report

This report selects all students with a matriculation term equal to the input term and college on the General Student (SGASTN) record who also have a Map status.  The report writes the student information to a file.  The user is then able to retrieve this file from their ‘Y’ drive.    

 

Technical Notes:

Technical Notes

	UC4 Chain		None
	Job		WSM1026
	Package		wksmacr
	Procedure		p_matric_report

 

On-Track Report

This report selects all students in the UNF Table (see Set Status) with a term equal to the input term, an active Map for the input college who do not have a future major change, who are not suspended and whose Map Status is "On-Track" . The report writes the student information to a file.  The user is then able to retrieve this file from their ‘Y’ drive.    

 

Technical Notes: 

	UC4 Chain		None
	Job		WSM1027
	Package		wksmacr
	Procedure		p_on_track_report

 

All Statuses Report

This report selects all students in the UNF Table (see Set Status) with a term equal to the input term, an active Map for the input college who do not have a future major change and who are not suspended. The report writes the student information to a file.  The user is then able to retrieve this file from their ‘Y’ drive.       

 

Technical Notes: 

	UC4 Chain		None
	Job		WSM1028
	Package		wksmacr
	Procedure		p_all_status_report

 

Mile Marker Rules not in CAPP

The reports selects all areas and rules defined in Osprey Maps that do not exists in the CAPP rule table for an area and rule.  The report writes the information to a file.  The user is then able to retrieve this file from their ‘Y’ drive.   

 

Technical Notes:

Technical Notes

	UC4 Chain		None
	Job		WSM1029
	Package		sql only

 

Required Courses and Prerequisites

As part of the CCEC Engineering Accreditation, a .net program was created for their course review.  This process creates a table with required courses and their prerequisites which is then used to generate the courses with their prerequisites and post requisites for review.  Required courses are determined by areas that are defined in a Banner Self-Service application, Areas for Required Courses.

 

Technical Notes: 

	UC4 Chain		NSTU_MONTHLY_PROCESSES
	Job		WSM5040
	Package		wksmpro
	Procedure		p_required_courses

Student Adjustment Records

As part of CAPP, adjustments (SMASLIB) can be made to students’ records.  These adjustments can include adjustments to the requirements, substitutions, and waivers.  In order to facilitate the advising offices, all active students will have a record on the adjustment table even if there are no adjustments.  This weekly (Friday) process deletes all records from the student adjustment table where no adjustment, substitution, or waiver data exists.  Then, new records are added for all active students who do not already have a student adjustment record. 

Technical Notes:

Technical Notes

	UC4 Chain		NSTU_WEEKLY_PROCESSES
	Job		WSM5080
	Package		sql only

Tutoring Sign-in System Maintenance

Students who did not sign out from the Tutoring Sign-in system are automatically signed out the next day. The sign-out time is set to one minute after the sign-in time. Additionally, the tutoring appointment table is cleared of all records where the student actually attended the appointment.

 

Technical Notes: 

Technical Notes

	UC4 Chain		NSTU_ADVISING
	Job		WSM5005
	Package		sql only