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:
| 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:
| 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:
| 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:
| 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:
| 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:
| 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:
| 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:
| 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:
| UC4 Chain |
NSTU_ADVISING |
| Job |
WSM5005 |
| Package |
sql only |
