.
 

Enterprise Systems

banner-enterprise

     

Advising

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

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

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

    AppWorx 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
    AppWorx Chain      None
  Job   WSM1029
  Package   sql only

 



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