.
 

Enterprise Systems

banner-enterprise

     
  • Advising Survey Invitations
  • Osprey Maps
  • Student Adjustment Records
  • Tutoring Sign-in System Maintenance
  • 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