.
 

Enterprise Systems

banner-enterprise

     
  • Archive Parent Portal Requests
  • Auxiliary Services IDMS Feed
  • Auxiliary Services IDMS Feed for New FTIC
  • Build Curriculum View
  • Build Reporting Table
  • Capture Change of Major
  • Capture Students Moving to Junior Classification
  • Create File for Students Moving to Junior Classification
  • Create Suspension Overrides for Re-admits
  • Delete General Student Records
  • Distribution List Maintenance
  • Insert Post Baccalaureate Records
  • Maintain Active/Inactive Status
  • Maintain Matriculation Term
  • Maintain Student County Data
  • Manage Term Status
  • Medicat Feed
  • Petition Tracking E-mails
  • Record Cleanup
  • Send Initial Email to Physical Therapy Students
  • Send ISQ E-mails to Students
  • Send Reminder Email to Physical Therapy Students
  • Set Expected Graduation Dates
  • Set General Education Satisfied
  • Student Attributes
  • Student Directory Information
  • Students with Partnership Codes
  • General Student

    Archive Parent Portal Requests


    Students can create invitations for their parents to create a UNF account for use in accessing the Parent Portal. This process archives those requests once the account has been created or if the request is greater than 30 days old.

     

    Technical Notes: 

    Technical Notes
       AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSP5100
      Package   wksgpar
      Procedure   p_archive_par

     



    Auxiliary Services IDMS Feed


    Create file of Banner data to be sent to Auxiliary Services for import into the IDMS system. The file contains all active employees and registered students.

     

     Technical Notes:  

       

    AppWorx Chain

        

    NINS_T2_FEED

     

    Job

     

    WSG1210

     

    Package

     

    wksgout

     

    Procedure

     

    p_auxsvcs_idms_feed



    Auxiliary Services IDMS Feed for New FTIC


    Create file of Banner data to be sent to Auxiliary Services for import into the IDMS system. The file contains all FTIC who are affected by the First Year Housing Requirement so that meal plan information can be recorded before students are registered.

     

     Technical Notes:  

       

    AppWorx Chain

        

    NINS_T2_FEED

     

    Job

     

    WSG1212

     

    Package

     

    wksgout

     

    Procedure

     

    p_ftic_idms_feed



    Build Curriculum View


    In an effort to support systems outside of Banner, the valid curriculum is built as a view that is accessible by external systems.  This nightly process, selects the active curriculum rules (SOACURR) for the current term.  These records are then inserted into a local table (WTSBCUR) that is used by the view (ZVBSAPP).

     

    Technical Notes:

    Technical Notes
        AppWorx Chain      NSTU_REPORT_EXTRACT
      Job   WSU5110
      Package   wksocur
      Procedure   p_build_curr


    Build Reporting Table


    In order to facilitate the Report by Curriculum in Banner Self-Service, a table (WTSTRPT) containing the necessary information is built on a nightly basis.  The first step is to delete the table before inserting new records.  All active students (using view WVSGACR) who have not received a degree and who are not deceased are inserted into the table.  The UNF hours, transfer hours, gender, athlete, and honors information is also collected for inserting into the table.  Next the view WVSGACA is used to extract the past several years of admission data.  Additional admissions-related fields are extracted to support the Admissions report.  And finally, graduation data (using view WVSGACG) are extracted to facilitate the report on graduated students.

     

    Technical Notes:

    Technical Notes
        AppWorx Chain      NSTU_REPORT_EXTRACT
      Job   WSU5100
      Package   wksurpt
      Procedure   p_build


    Capture Change of Major


    In order to assist the ‘Transfer of Records’ from one college to another when a student changes their major (and college), the major changes are captured on a nightly basis.  This process selects the primary curriculum for students who have an active General Student record (SGASTDN) who are seeking a bachelor’s degree.  Each student’s curriculum is compared to their prior curriculum to see if it is different.  If it is different then the curriculum is recorded in the Change of Major table.  This information can be viewed in Banner Employee Self-Service UNF Administrative Applications Transfer of Records application.

     

    Technical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG5335
      Package   wksgmjr
      Procedure   p_capture_updates


    Capture Students Moving to Junior Classification


    In order to facilitate the ‘Transfer of Records’ from the Academic Center for Excellence to the upper division advising offices, students are captured when they attain junior classification.  This weekly (Friday) process selects all students with an Active General Student (SGASTDN) record with an undergraduate level and with a student type of FTIC (B, E) or Transfer (J, U) whose classification for the previous term is freshmen or sophomore and whose classification for the current term is junior.  A record is inserted into a UNF table that is used for reporting.

     

    Technical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_WEEKLY_PROCESSES
      Job   WSG5330
      Package   wksgcls
      Procedure   p_track_junior_rollover


    Create File for Students Moving to Junior Classification


    In order to facilitate the ‘Transfer of Records’ from the Academic Center for Excellence to the upper division advising offices, students are captured when they attain junior classification.  This weekly (Friday) process selects all students with an Active General Student (SGASTDN) record who are also on the UNF table created by the Capture Students Moving to Junior Classification process.  A file is created containing a GPA designation of ‘Acceptable GPA’ or ‘Unacceptable GPA’ (based on college and GPA requirement), college description, program, major, student ID, student name, and Institutional GPA.  Only students who are not in an AA program are selected. An email is sent to the Rolling Junior GPA distribution list notifying the recipients that a file is available for viewing. 

     

    For Limited Access and Selective Admissions programs, this weekly (Friday) process selects all students with an Active General Student (SGASTDN) record who have a Limited Access (AA-LA) or Selective Admission (AA-SA) program code with a future Active General Student (SGASTDN) Record with a baccalaureate program code.  The process first checks to see if the student is on the UNF table created by the Capture Students Moving to Junior Classification process.  If they are not, then the process checks to see if there is an application for a baccalaureate degree for the student.  If either of these is true, then the student will be included.  A file is created containing a GPA designation of ‘Acceptable GPA’ or ‘Unacceptable GPA’ (based on college and GPA requirement), college description, program, major, new college, new program, new major, student ID, student name, and Institutional GPA.  An email is sent to the Rolling Junior GPA distribution list notifying the recipients that a file is available for viewing. 

     

    Technical Notes:

    Technical Notes
        AppWorx Chain      NSTU_WEEKLY_PROCESSES
      Job  

    WSG1330

    WSG1335

      Package   wksgcls
      Procedure  

    p_junior_gpa_list

    p_junior_gpa_limited_access



    Create Suspension Overrides for Re-admits


    When students are re-admitted and their academic status for the last term attended is Suspension (SU), an academic standing override will be placed on the new General Student (SGASTDN) record.  This will be done by inserting an Academic Probation (P2) status in the Academic Standing Override field and the application term in the Academic Status Override Term.  The population will include students being re-admitted for a current or future term.

     

    Technical Notes: 

      

    AppWorx Chain

        

    NSTU_GENERAL_STUDENT

     

    Job

     

    WSG5360

     

    Package

     

    wksgsts

     

    Procedure

     

    p_susp_over



    Delete General Student Records


    When a student is admitted, a General Student record (SGASTDN) is created.  If the student does not register, then their admission is cancelled.  When the admission is cancelled using the process then the status for the General Student record is changed to Inactive (IS).  This nightly process will delete all of these inactive records since they are no longer needed.  Associated elements, attributes, curriculum, athlete, and assigned advisor records are also removed. The end-term on previous curriculum records are reset when the deleted curriculum leaves the last remaining record as ended. 

     

    Additionally, this process deletes element, attribute, athlete, and assigned advisor records where there is no General Student record.

     

    Technical Notes:  

    Technical No
        AppWorx Chain      NSTU_ADMISSIONS
      Job   WSA5410
      Package   wksaadm
      Procedure  

    p_delete_general_student



    Distribution List Maintenance


    There are a variety of distribution lists that are updated on a weekly (Friday) basis. 

     

    Athletics

    The process selects the university email address for all students with an active Athletic Compliance (SGASPRT) record with a term that is greater than or equal to the current term. 

     

    Honors

    The process selects the university email address for all students with a record on the Student Institutional Reporting Requirements (elements) form with a University Honors-Enrolled (NAUY) code in element 1 or Interdisciplinary-Enrolled (NAIY) code or Honors in Major-Enrolled (NAMY) code in element 2 with a term that is greater than or equal to the current term. 

     

    International Students

    The process selects the university email address for all students with a visa code of F1 or J1 on the International Information (GOAINTL) form and registration with a term that is greater than or equal to the current term.

     

    Active Students

    The process selects the university email address for all students with an active General Student (SGASTDN) record. 

     

    Current Students

    The process selects the university email address for all students with an active General Student (SGASTDN) record and registration (at least one course must be gradable) with a term that is equal to the current term.

     

    Current Graduate Students

    The process selects the university email address for all students with an active General Student (SGASTDN) record with a level code of Graduate (GR) and registration (at least one course must be gradable) with a term that is equal to the current term.

     

    Active Graduate Students

    The process selects the university email address for all students with an active General Student (SGASTDN) record with a level code of Graduate (GR). 

     

    Pending Account Deletion

    The process select the university email address for student who do not have active General Student (SGASTDN) records for the next term, whose maximum active General Student (SGASTDN) record has an effective term that is less than less than current term, and whose last enrolled term was less than or equal to current term minus one year.

     

    Technical Notes:

    Technical Notes
        AppWorx Chain      NSTU_WEEKLY_PROCESSES
      Job  

    WSG5650 - Athletics

    WSG5655 - Honors

    WSG5660 - International Students

    WSG5665 - Active Students

    WSG5670 - Current Students

    WSG5675 - Current Graduate Students

    WSG5680 - Active Graduate Students

    WSG5685 - Pending Account Deletion

      Package   wksgdst
      Procedure  

    p_dist_list



    Insert Post Baccalaureate Records


    Once a student graduates, they will continue to have an active General Student record (SGASTDN) which allows them to register for courses.  This nightly process checks to see if students are registered for courses but do not have a SGASTDN record with an effective term that is greater than their graduation term.  If this is the case and the student has a campus code of Main Campus (MC), a new SGASTDN record is inserted with a student type of Post Baccalaureate.

     

    Technical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG5303
      Package   wksgsts
      Procedure   p_check_post_grad


    Maintain Active/Inactive Status


    A student will continue to have an active General Student record (SGASTDN) until they break continuous enrollment.  Breaking continuous enrollment is defined as having not attended in three terms.  This nightly process checks all active students to see if they have broken continuous enrollment and sets their General Student record to Inactive (IN).

     

    Additionally this process will inactivate any students who have graduated and have a particular campus code on their general student record. This process also sends a report of inactive students who have active registration.

     

    Technical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG5302
      Package   wksgsts
      Procedure   p_check_stst_status


    Maintain Matriculation Term


    It is important to verify that each student’s matriculation term is correct.  This nightly process will update matriculation terms for students without a matriculation term and for those with a matriculation term.  First, all students who have General Student records (SGASTDN) where the matriculation term is NOT blank and DO NOT have any academic history or registration will have their matriculation changed to blank (NULL).  Next, for all students where the matriculation term is blank (NULL) and DO have academic history or registration will have their matriculation term set to the minimum term from academic history or registration (whichever is earliest).

      

    Technical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG5304
      Package   wksgsts
      Procedure   p_maint_matric


    Maintain Student County Data


    In order to ensure that the county data is accurate, this nightly process reviews mailing and permanent addresses whose county code is blank (NULL), non-USA, and non-Florida.  

    Set Florida County Code

    If the following criteria are met, then the county will be updated with the county on the Zip/Postal Code table for that zip code. 

    • county code is blank (NULL)
    • state code is Florida (FL)
    • address zip code is found on the Zip/Postal Code (GTVZIPC) validation table 

    Set Non-Florida County Code

    If the following criteria are met, then the county is set to non-Florida (NFLA).

    • county code is blank (NULL) or not non-Florida (NFLA)
    • the state is not Florida  

    Set Non-USA County Code

    If the following criteria are met, then the county is set to non-USA (NUSA).

    • county code is blank (NULL) or not non-USA (NUSA)
    • state code is blank (NULL) or state code is not blank (NULL)
    • state code is not a state
    • nation code is not blank (NULL) 

    Technical Notes:   

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG5610
      Package   wksgdem
      Procedure   p_update_county


    Manage Term Status


    This job maintains a table of status and semester types for each term defined in Term Code Validation (STVTERM).  Statuses are classified as past, current and future. Semesters are classified as spring, summer, fall and winter.  This table is used in UNF programs to assist with the transition to multiple term codes being current at once.

     

    Technical Notes:

       AppWorx Chain    NSTU_TERM_STATUS_MGMT
      Job   WSG5380
      Package   wksgpro
      Procedure   p_term_status_mgmt


    Medicat Feed


    Create file of Banner data for import into the Medicat system. The file contains all active employees and active students.

     

    Technical Notes:

       AppWorx Chain    NSTU_GENERAL_STUDENT
      Job   WSG1150
      Package   wksgout
      Procedure   p_medicat


    Petition Tracking E-mails


    Students may submit a petition to waive university policy.  The petition must be reviewed and either approved or denied by Academic Affairs.  This nightly process sends emails to students and advisors as to the status of the student’s petition request.  Emails are only sent for petitions that had activity for that day.

     

    Technical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG1500
      Package   wksgeml
      Procedure  

    p_advisor_petition_email

    p_student_petition_email



    Record Cleanup


    In an effort to maintain accurate data, this process will delete or update data as described below:

    • Delete Registration Data

      Delete any records with a registration status of 'DD' (drop-delete) with a registration status date less than today's date 

    • Set Status on SGASTDN

      1. Update the status to "IS" on Active General Student records where there is no academic history, no registration, and matriculation term is NULL

      2. Update the status to "IS" on General Student records where there is no academic history, no registration, matriculation term is NULL, and student has a cancelled Admission Application
      3. Delete Student Attribute records where there is no academic history, no registration, matriculation term is NULL, and student has a cancelled Admission Application 
    • Delete Curriculum

    1. Delete LEARNER Curriculum Records when no matching General Student Record exists

    2. Delete ADMISSIONS Curriculum Records when no matching Application Record exists

    3. Delete RECRUIT Curriculum Records when no matching Recruit Record exists

    • Create Curriculum

    1. Create LEARNER Curriculum records when there is a General Student record with no matching curriculum

    2. Create ADMISSIONS Curriculum records when there is an Admissions record with no matching curriculum

    •  Delete Transfer Course Degree Data

    Delete transfer course associations to a UNF degree if the coursework has not been applied to the the outcome record in Degrees and Other Formal Awards (SHADEGR) form

    • Find Orphans

    Find records from various tables when there is no General Person Identification (SPAIDEN) record

     

    Technical Notes: 

    Technical Notes

       

    AppWorx Chain

       

    NSTU_GENERAL_STUDENT

     

    Job

     

    WSG5370

     

     

    Package

     

    wksgpro

     

    Procedure

     

    p_record_cleanup

     



    Send Initial Email to Physical Therapy Students


    Graduate students in the Physical Therapy department are required to complete professional behavioral assessments three times while at UNF; during the fall semester of their first year, the summer semester of their second year, and during their last clinical internship. During the assessment period, this nightly process sends an initial invitation email to each Physical Therapy graduate student for each assessment term. Students who are required to complete an assessment for that term will receive the emails 14 days after the begin date of the assessment period.

     

    Technical Notes:

     

    UC4 Chain

        

    NSTU_GENERAL_STUDENT

    Job

     

    WSG1515

    Package

     

    wksgpba

    Procedure

     

    p_initial_notify_student



    Send ISQ E-mails to Students


    Students in distance learning or hybrid courses complete their instructional satisfaction questionnaires (ISQ) online through Student Self-Service.  During the ISQ evaluation period, this job will send emails to these students who have incomplete ISQs.  If it is the first day of the evaluation period, students will receive a notification email.  Otherwise students will receive reminder emails for the last 7 days of the evaluation period.

     

    Technical Notes: 

    AppWorx Chain              NSTU_GENERAL_STUDENT     
    Job   WIS5005
    Package   wkisisq
    Procedure   p_isq_emails


    Send Reminder Email to Physical Therapy Students


    Graduate students at Physical Therapy department are required to complete professional behavioral assessments three times while at UNF; during the fall semester of their first year, the summer semester of their second year, and during their last clinical internship. During the assessment period, this nightly process sends a reminder email to Physical Therapy graduate students who have not completed the assessment 14 days before the end date of each assessment term.


     Technical Notes:

    UC4 Chain

        

    NSTU_GENERAL_STUDENT

    Job

     

    WSG1520

    Package

     

    wksgpba

    Procedure

     

    p_remind_student



    Set Expected Graduation Dates


    The expected graduation date can be viewed on the General Student form (SGASTDN).  This nightly process selects all active students whose expected graduation date is blank (NULL), occurs in the past, or is not defined as an end date on the Term Code Validation
    table (STVTERM). The process then updates each record in the selection with an expected graduation date, which is based on the current academic year and is calculated as follows:

     

    Classification for Expected Graduation Date
          Classification       Years 
      Doctoral (DR)   5
      Freshmen (F1, F2, F3)   4
      Sophomore (S1, S2, S3)   3
      Junior (JR)   2
      Senior (SR) with cumulative hours greater than or equal to 120 hours   0
      Senior (SR) with cumulative hours less than 120 hours    1
      All Others   2

      

    These years are added to the current academic year and then the code for summer (50) is appended. Using STVTERM, the end date for the term created is used as the expected graduation date.

     

    Note: The current academic year is equal to the next calendar year for fall term.

      

    Technical Notes:  

    echnical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG5301
      Package   wksgsts
      Procedure  

    p_set_graduation _dates



    Set General Education Satisfied


    When a student has satisfied General Education requirements, it may be indicated on the electronic transcript from another institution.  This nightly process evaluates the indicators from the electronic transcript to see if the General Education requirement is satisfied.  If the General Education requirement is satisfied, a record with a GENS code may be updated or inserted into the Academic Non-Course (SHANCRS) table.

     

    Technical Notes:   

    echnical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_GENERAL_STUDENT
      Job   WSG5340
      Package   wksgsts
      Procedure  

    p_set_gened



    Student Attributes


    Student attributes are used in a variety of places in Banner. Including, but not limited to, Registration, CAPP, Classification rules, and fee processing. Banner uses these attributes to affect the different behavior based on the attribute.  There are three automated processes that run nightly through AppWorx to add attributes to the student's record: Primary Attribute Process, Element Attribute Process, and University Requirements Attribute Process. 

     

    The following is a list of attributes, their description, and the process that puts the attribute on the student's record.  All attributes are generated electronically.

     

    Student Attributes

    Attribute

    Description

    Process

    AAOR

    Admissions Orientation Fee

    Primary Attribute Process

    AASP

    Special Student

    Primary Attribute Process

    ADDR

    Doctoral Student

    Primary Attribute Process

    AFPP

    Academic Potential Program

    Primary Attribute Process

    AFWW

    Week of Welcome Assessment

    Daily Registration Process

    APPB

    Post baccalaureate

    Primary Attribute Process

    ATJR     Upper-Level for Registration Primary Attribute Process

    IAHA

    International Athlete Hlth Ins

    Daily Registration Process

    IAHS

    International Student Health

    Daily Registration Process

    NAIY

    Interdisciplinary Honors-Enrol

    Element Attribute Process

    NAMY

    Honors in Major-Enrolled

    Element Attribute Process

    NAUC

    University Honors-Complete

    Element Attribute Process

    NAUY

    University Honors-Enrolled

    Element Attribute Process

    NSLC

    National Student Loan Clearing

    Non-Automated Process

    RA30

    30 Upper Level Hours

    Primary Attribute Process

    RADT

    Undergraduate Differential Tuition

    Daily Registration Process

    RAID

    ID card Assessment

    Daily Registration Process

    RAIS

    Assess In-State Fees

    Element Attribute Process

    RAOT

    Registered On-Time

    Non-Automated Process

    RAPP

    Florida Pre-Paid

    Daily Registration Process

    RAPD Florida Pre-Paid Differential Plan Daily Registration Process
    RAPL Florida Pre-Paid Local Fee Plan Daily Registration Process

    RARS

    Residency

    Primary Attribute Process

    RDMR Discount Market Rate Daily Registration Process (for Modules)
    RHNA      Nurse Anesthetist Fee Daily Registration Process

    UFLE

    Foreign Language Exempt

    University Requirements Attribute Process

    UGE%

    General Education Catalog

    University Requirements Attribute Process

    USME

    Summer Requirement Exempt

    University Requirements Attribute Process

    VAAE

    AA Earned at a state school

    University Requirements Attribute Process

     

    Tables and Form used with Student Attributes

    STVATTS - Student Attribute Validation Table

    SGRSATT - Student Attribute Table

    SGASADD - Student Attribute Form

    Primary Attribute Process

     The process selects students with an Active General Student (SGASTDN) record, academic standing (SHATERM) records, and hours and GPA (SHATERM) record with any change since the last time the process ran.

     

    The following attributes are processed.

    Classification

    These attributes are used along with the Student Classification Rules defined on SGACLSR to determine a student's classification.

    1. Doctoral Student (ADDR)

      The process checks the student program on SGASTDN to see if it is one of the Doctoral Programs (COE-DEDD, COH-DNP, and COH-DPT).


    2. Special Student (AASP)

      The process checks the student admit type on SGASTDN to see if it is one of the following: SN (Special-No Prior Degree), ZD (Senior Citizen-Prior Degree), ZN (Senior Citizen-No Prior Degree), TS (Transient), DB (Dually Enrolled IB), or DE (Dually Enrolled).


    3. Post baccalaureate (APPB)

      The process checks the student admit type on SGASTDN to see if it is one of the following:  ‘PB’ (Post Baccalaureate) or ‘PG’ (Graduate Applicant).


    4. 30 Upper Level Hours (RA30)

      The process calculates the number of upper level hours at UNF and number of upper level transfer hours where the student type on SGASTDN is not ‘G’ (Graduate), ‘H’ (Dual Enrolled), or ‘P’ (Post baccalaureate).  If this number is greater than or equal to 30 then the attribute is added.  In conjunction with the classification rules (SGACLSR), if the student has at least 90 cumulative credit hours and this attribute then the student will have senior class standing.


    5. Upper-Level for Registration (ATJR)

      The process checks the student admit type on SGASTDN to see if it is one of the following:  ‘UJ’ (Upper Level Transfer (CC)) or ‘UU’ (Upper Level Transfer (Other)) and that the admit term on SGASTDN is equal to the process term.  If the student meets these conditions then the attribute is added.  In conjunction with the classification rule (SGACLSR) the student will have junior class standing regardless of actual number of transfer hours due to incomplete transcripts.

    Registration Restrictions  

    1. Academic Potential Program (AFPP)
      The process checks the student admit type on SGASTDN to see if it is a ‘BP’ (FTIC-APP).

    Fees

    1. Admissions Orientation Fee (AAOR)
      The process checks the student type on SGASTDN to see if it is one of the following:  ‘B’ (Beginner-FTIC), ‘E’ (Early Admit-Prior to High School Graduation), ‘J’ (Transfer from a Florida public Community College) or ‘U’ (Other Undergraduate Transfer) and that the student’s level on SGASTDN is undergraduate (UG).  This attribute is applied to the student’s record for their first term to enforce payment of the fee.  This applies to student who matriculated in Fall 2005 and after. 

    Residency

    1. Residency(RARS)
      For students who matriculate prior to Fall 2012 the process is as follows:
      The process finds the number of hours required for the program on SMAPROG (Program Requirements) and divides that number by 4 to get 25 percent of the total program hours. This number is the required hours to meet residency. AA program hours are set at 60 so the calculated required hours are reset to 30.  Program hour requirements for Post baccalaureate students and students enrolled in the RN-BSN program is 30 credit hours.  The process calculated the total number of upper level credit hours earned at UNF.  This number must be greater than or equal to 30.  The process calculates the total number of credit hours earned at UNF.  This number must be greater than or equal to the 25 percent of total required program hours calculated in the first step.  If both of these conditions are met then the attribute is applied to the student’s record. 

      For students who matriculate in Fall 2012 forward the process is as follows:
      The process finds the number of hours required for the program on SMAPROG (Program Requirements) and divides that number by 4 to get 25 percent of the total program hours.  This number is the required hours to meet residency.  AA program hours are set at 60 so the calculated required hours are reset to 30.  Program hour requirements for Post baccalaureate students and students enrolled in the RN-BSN program is 30 credit hours.  In addition, upper level undergraduate credit hours obtained while enrolled in an approved UNF study abroad program will be counted in the hours calculation for residency purposes. The process calculates the total number of credit hours earned at UNF plus the approved UNF study abroad hours.  This number must be greater than or equal to the 25 percent of total required hours calculated in the first step.  If the student meets this condition then the attribute is applied to the student's record.

    Technical Notes:

    echnical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_ADVISING
      Job  

    WSG5400

      Package   wksgatr
      Procedure  

    p_attr_updates

     

    Element Attribute Process

    This process select students with a record on the Student Institutional Reporting Requirements (SGAUSDF) form with any change since the last time the process ran.  

    1. University Honors-Enrolled (NAUY)
      The process checks Element 1 for a code of NAUY and adds an attribute with the same name.  
    2. University Honors-Complete (NAUC)
      The process checks Element 1 for a code of NAUC and adds an attribute with the same name. 
    3. Interdisciplinary Honors-Enrol (NAIY)
      The process checks Element 2 for a code of NAIY and adds an attribute with the same name. 
    4. Honors in Major-Enrolled (NAMY)
      The process checks Element 2 for a code of NAIY and adds an attribute with the same name. 
    5. Assess In-State Fees (RAIS)
      The process checks Element 9 for a code of IACB (LAC Scholars living off-campus), IALS (LAC Scholars living on-campus), IAIF (In-State tuition), or ANEX (International Exchange Student) and adds the RAIS attribute.  This attribute entitles the student to pay in-state fees.    

    Technical Notes:

    echnical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_ADVISING
      Job  

    WSG5405

      Package   wksgatr
      Procedure  

    p_element_update

     

    University Requirements Attribute Process

    The process selects students with an Active General student (SGASTDN) record, students with FLNT, SUMR, or any code that begins with GEN on the Academic Non-Course (SHANCRS) form in the CAPP Non-Course Requirement field, an AA degree on the Prior College (SOAPCOL) form in the Degree Details block, and transfer hours and GPA (SHATERM) with any change since the last time the process ran. 
    1. AA Earned at a state school (VAAE)
      The process checks the institution code on SOAPCOL (Prior College) in the Prior College block and determines if it is an SUS institution or Florida Community College.  The process checks for an AA degree in the Degree Details block and checks to see if the primary indicator is checked.  If the student’s record meets all of these conditions then the attribute is added to the student’s record. 
    2. Foreign Language Exempt (UFLE)
      The process checks SHANCRS (Academic Non-Course) in the CAPP Non-Course Requirement field for a FLNT code and a ‘Y’ in the Satisfied field.  If the student’s record meets all of these conditions then the attribute is added to the student’s record. 
    3. Summer Requirement Exempt (USME)
      The process checks SHANCRS (Academic Non-Course) in the CAPP Non-Course Requirement field for a SUMR code and a ‘Y’ in the Satisfied field.  If the student’s record meets this conditions then the attribute is added to the student’s record.

      If these conditions are not met then the process determines the first term that the student entered an SUS institution.  It calculates the last term prior to the student's first SUS term.  The number of transfer hours earned prior to the first SUS term is calculated.  If this number is greater than or equal to 60 then the student is exempt.  The attribute is added to the student’s record.  

       

      If the student is still not exempt and the student matriculated at UNF as an FTIC or transfer student (student type on SGASTDN is B, E, J, or U) between summer 2005 and spring 2011 then an additional check is performed as follows:


      Determine the student’s high school graduation date by looking at SWAHSCH (High School Transcript form) where the Transcript Used for Admission Decision box is checked.  The process determines the student's first term as an FTIC (student type on SGASTDN is B or E) or Transfer student (student type on SGASTDN is J or U).  The process calculates the number of hours in accelerated mechanisms (AP, IB, CLEP and other exam credit) prior to matriculation and dual enrolled credit hours (transfer credit hours earned prior to high school graduation).  If the total number of hours is greater than or equal to 9 then the student is exempt.  The attribute is added to the student’s record.  
    4.  

    5. General Education Catalog (UGE%)
      The General Education Catalog is based on the student’s catalog term and number of transfer hours.  The process gets the catalog term for the student from SGASTDN.  The process checks to see if the student has an AA degree from a Florida public university or community college.  If the student meets this condition then they do not receive a General Education catalog attribute.  The process then checks to see if there is an override on SHANCRS (Academic Non-Course).  An override can exempt, satisfy or override the General Education catalog.  An override will be one of the following codes in the CAPP Non-Course Requirement field with a corresponding Status:
      CAPP Non-Course Requirement
      CAPP Non-Course Requirement   Status     Attribute
      GENSYGeneral Education Satisfied (UGES)
      GENXEGeneral Educaiton Exempt (UGEX)
      GEN%OGeneral Education Catalog (UGE%)

      If the previous conditions are not met then the process calculates the number of transfer hours the student has prior to matriculation or the first term in which the student was admitted to a particular student type. Then based on the student’s catalog term (retrieved in the first step) and the number of transfer hours, a General Education catalog is assigned using the following criteria:

      General Education Catalog
      Catalog Term Hours  Catalog 
      Less than 198508NAUGEB
      Greater than or equal to 198508 and less than 198708     Less than 60UGEA
      Greater than or equal to 198508 and less than 198708Greater than or equal to 60UGEB
      Greater than or equal to 198708 and less than 199308Less than 60UBEC
      Greater than or equal to 198708 and less than 199308Greater than or equal to 60UGED
      Greater than or equal to 199308 and less than 199608Less than 60UGEE
      Greater than or equal to 199308 and less than 199608Greater than or equal to 60UGEF
      Greater than or equal to 199608 and less than 199908Less than 60UGEG
      Greater than or equal to 199608 and less than 199908Greater than or equal to 60UGEH
      Greater than or equal to 199908 and less than 200908Less than 60UGEI
      Greater than or equal to 199908 and less than 200908Greather than or equal to 60     UGEH
      Greater than or equal to 200908 and less than 201208
      Less than 60UGEJ
      Greater than or equal to 200908 and less than 201208
      Greather than or equal to 60UGEH
      Greater than or equal to 201208 and less than 201408Less than 60UGEK
      Greater than or equal to 201208 and less than 201408    Greater than or equal to 60

      UGEH    

      All others NAUGEL
        

    Technical Notes:

    echnical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_ADVISING
      Job  

    WSG5460

      Package   wksgatr
      Procedure  

    p_check_univ_reqs

     

    Daily Registration Process

    There are a series of processes that are executed every day during the registration period.  

    1. Week of Welcome Assessment (AFWW)
      The process selects active students (student status of ‘AS’ on SGASTDN) with an admit term of summer or fall for the current year and an admit code of ‘BP’ (FTIC-APP), ‘BE’ (Early Action), or ‘BF’ (FTIC).   If the Week of Welcome attribute does not already exist then it is added.   
    2.   
    3. International Athlete Hlth Ins (IAHA) or International Student Health (IAHS)
      The process selects active students (student status of ‘AS’ on SGASTDN) who have a visa code on GOAINTL (International Information) of ‘F1’,’F2’,’FO’,’J1’,’J2, or ’JO’ and a medical code on GOAMEDI (General Medical Information) of ‘I1’ (Insurance) where the Disability Service code is not ’IS’ (Insurance Satisfied).  If the attribute does not already exist, then the attribute is added.  
        • If student is an Athlete (SGASPRT), add IAHA attribute
        • If student is not an Athlete, add IAHS attribute

       

      This process runs for two weeks following drop/add for Fall and Spring terms to handle late changes in students' insurance status.   
    4.  

    5. ID Card Assessment (RAID)   

      The process selects active students (student status of ‘AS’ on SGASTDN) with at least one of the following criteria:

       

      • Active employees (except for college work study, student assistant, and graduate assistant)
      • Existing ID card assessment
      • Dual enrolled (admit type on SGASTDN of ‘DB’ (Dually Enrolled IB) or ‘DE’ (Dually Enrolled)) 
      • Enrolled in the OCT (On Campus Transition) or ELP (English Language Proficiency) programs
       

      These students are exempt from paying the ID card assessment and will receive this attribute.   

    6.  

    7. Undergraduate Differential Tuition (RADT)
      The process selects active students (student status of ‘AS’ on SGASTDN) who were designated as Florida Prepaid prior to 2008 and do not already have the attribute.  The RADT attribute is added to these students.  The process then selects students who were active (student status of ‘AS’ on SGASTDN) during Summer 2007 and did not break continuous enrollment through Summer 2009.  The RADT attribute is added to these students.  The students who receive this attribute are exempt from paying the additional tuition.
    8.   
    9.  Florida Pre-Paid (RAPP)
      The process selects active students (student status of ‘AS’ on SGASTDN) who are also designated as Florida Prepaid and do not already have the attribute.  The RAPP attribute is added to these students.  The students who receive this attribute are exempt from paying the additional tuition.
    10.  

    11. Florida Pre-paid Local Fees (RAPL)
      The process selects active students (student status of ‘AS’ on SGASTDN) who are also designated as having purchased the Florida Prepaid Local Fee and do not already have the attribute.  The RAPL attribute is added to these students.  The students who receive this attribute are exempt from the local differential tuition fees.
    12.  

    13. Florida Pre-Paid Differential Plan (RAPD)
      The process selects active students (student status of ‘AS’ on SGASTDN) who are also designated as having purchased the Florida Prepaid Differential Plan between 2008 and 2009 and do not already have the attribute.  The RAPT attribute is added to these students.  The students who receive this attribute are receiving a further reduction in the differential tuition fees.  
    14.  

    15. Discount Market Rate (RDMR)
      The process selects students who have a Partnership Code indicated on a local UNF table (WTEAPCD).  Partnership Codes are added to the table from the application if it is included.  If the student does not enter the Partnership Code then the Administrator can enter the code through a Banner Self-Service application.  The RDMR attribute is added to these students.  The students who receive this attribute are receiving a discount on tuition.  If a student is no longer eligible to receive the discount, then a new effective term is added using the Banner Self-Service application thus causing the attribute to be removed effective the indicated term. 
    16.  

    17. Nurse Anesthetist Fee (RHNA)
    18. This process select students with a declared major in one of the Nurse Anesthetist programs. Students in the Nurse Anesthetist program are assessed a fee each semester.  The RHNA attribute is added to any student in these programs for the parameter term. Students who receive this attribute will have additional fees assessed. If a student is no longer in the program, then the attribute is remove.

       

     

     

    Technical Notes:

    echnical Notes:  

    Technical Notes
        UC4 Chain     

    NSTU_DAILY_REGISTRATION_FALL

    NSTU_DAILY_REGISTRATION_SUMMER

    NSTU_DAILY_REGISTRATION_SPRING

    NSTU_DAILY_REG_FALL_MODULE_1

    NSTU_DAILY_REG_FALl_MODULE_2

    NSTU_DAILY_REG_SUMMER_MODULE_1

    NSTU_DAILY_REG_SUMMER_MODULE_2

    NSTU_DAILY_REG_SPRING_MODULE_1

    NSTU_DAILY_REG_SPRING_MODULE_2

    NSTU_GENERAL_STUDENT (WSG5417 only)

      Job  

    WSF5003 - Set Late Admit Appointments

    WSG5410 - Set Week of Welcome Attribute – (Fall only)

    WSG5415 - Set International Heath Insurance Attribute

    WSG5417 - Set International Heath Insurance Attribute Late

    WSF5401 - Set Audit Mode for Senior Citizens

    WSG5420 - Set ID Card Exemption Attribute

    WSG5440 - Set Differential Tuition Exemption Attribute

    WSG5443 - Set Differential Tuition Plan Exemption Attribute

    WSG5445 - Set Florida Pre-Paid Attribute

    WSG5275 - Set Tuition Responsibility (QF) Information Hold

    WSG5280 - Set Tax Form (QT) Information Hold

    WSG5447 - Set Florida Pre-Paid Attribute for Local Fees

    WSG5432 - Set Nurse Anesthetist Attribute

    WSF5004 - Registration Time Tickets for Students Attending Orientation - (Fall and Summer only)

    WSF5006 - Fall Registration Time TIckets for Students Attending Orientation - (Summer only)

    WSF5008 - Assign Appointments for Late Admis (Modules only)

      Package  

    WSF5003 - wksfapt

    WSG5410 - wksgatr

    WSG5415 - wksgatr

    WSG5417 - wksgatr

    WSF5401 - wksfreg

    WSG5420 - wksgatr

    WSG5440 - wksgatr

    WSG5443 - wksgatr

    WSG5445 - wksgatr

    WSG5275 - wksghld

    WSG5280 - wksghld

    WSG5447 - wksgatr

    WSG5432 - wksgatr

    WSF5004 - wksfapt

    WSF5006 - wksfapt

    WSF5008 - wksfapt

      Procedure  

    WSF5003 – p_set_late

    WSG5410 – p_set_afww

    WSG5415 – p_set_iahs

    WSG5417 – p_set_iahs_late

    WSF5401 – p_set_auditmode

    WSG5420 – p_set_raid

    WSG5440 – p_set_radt

    WSG5443 - p_set_rapd

    WSG5445 – p_set_rapp

    WSG5275 – p_qf_hold

    WSG5280 – p_qt_hold

    WSG5447 - p_set_rapl

    WSG5432 - p_set_rhna

    WSF5004 – p_set_orient_appointment  

    WSF5006 – p_set_orient_summer_ftic

    WSF5008 - p_set_late_appointment_modules

     

    Non-Automated Process

    The following attributes are added to the student’s record by running a Banner job. 
    1. Registered On-Time (RAOT)
      The process selects students from SFAREGS (Student Course Registration) for a given term and adds the attribute.  This will prevent the student from being assessed a late fee.  There are two Banner Jobs:  WSG5425 and WSG5428 (for summer B).   
    2. National Student Loan Clearing (NSLC)
      The process selects students with a time status of 00 on SFAREGS (Student Course Registration) Time Status tab who do not have a withdrawn enrollment status on SFAREGS, Enrollment Information block. In addition, students in the EPI, ELP, or OCT programs are also selected.  Then the NSLC attribute is added to the student's record.  This will exclude the student from being included in the National Student Loan Clearing House extract.  The Banner Job is WSG5430. 


    Student Directory Information


    Directory information is the information available about a student that is not considered harmful or an invasion of privacy if disclosed. While FERPA and state law protect the privacy of educational records, directory information is not treated as confidential and may be disclosed by the university without student consent unless the student requests non-disclosure. At UNF, the following has been designated as directory information:

    • Name
    • Address
    • Telephone number
    • Dates of attendance
    • Admitted College / Majors
    • Degrees Awarded
    • Classification (freshman, sophomore, etc)
    • Participation in officially recognized activities and sports
    • Honors
    • Weight/ Height of Athletes

    This weekly process (Sunday) selects all students with an active General Student (SGASTDN) record for the current term.  A table (WTSGDIR) is updated with the above information (excluding the last three items) where the Enrollment Services Records Office uses it in a Cognos directory information report.

     

    Technical Notes: 

    echnical Notes:  

    Technical Notes
        AppWorx Chain      NSTU_DIRECTORY_INFORMATION
      Job  

    WSG1200

      Package   wksgout
      Procedure  

    p_student_info



    Students with Partnership Codes


    In order to accurately provide the Discount Market Rate to students whose employer has an agreement with Academic Partnership, this process will put the qualifying students into a local table (WTEAPCD).  The table is then used to process the attributes for the students.

     

    Technical Notes: 

    echnical Notes: 

    Technical Notes
        AppWorx Chain     NSTU_GENERAL_STUDENT
      Job  

    WSG5130

      Package   wksgpro
      Procedure  

    p_partnership_students