.
 

Enterprise Systems

banner-enterprise

     

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

   

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

   

 UC4Chain

    

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

  

UC4 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 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 curriculum, attributes, advisor and athletic records are also removed. Associated elements for the Honors Program are retained if another General Student record exists (the term will be updated if the existing General Student record is greater than the record being deleted). All other elements are removed. The end-term on previous curriculum records are reset when the deleted curriculum leaves the last remaining record as ended.


When an Application is cancelled manually and the General Student record is removed, the element, attribute, advisor and athletic records remain. This process deletes any element and advisor records where there is no General Student record. Attribute and athletic records are removed once the term has passed and there is no General Student record. 

 

 

Technical Notes:  

Technical No
    UC4 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
    UC4 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
    UC4 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
    UC4 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
    UC4 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
    UC4 Chain      NSTU_GENERAL_STUDENT
  Job   WSG5610
  Package   wksgdem
  Procedure   p_update_county


Manage Residency Tracking Records


This job creates, cancels and completes initial classification records in the Residency Tracking application.

Students with an incomplete residency status on their application are selected for creation. Undergraduate students are selected at the time of admission while graduate students and senior citizens are selected when the application is created. If the student submitted their application electronically, any information provided with their residency affidavit is attached to their residency tracking record when it is created. Tracking records are canceled when the attached admissions application no longer exists or has a latest decision that makes the application inactive.

Applications that no longer have an incomplete residency code will have their corresponding tracking record updated with a decision based on the in-state indicator on the residency code.

 

Technical Notes:

 

UC4 Chain

 

NSTU_GENERAL_STUDENT

 

Job

 

WSG5720

 

Package

 

wksgpro

 

Procedure

 

p_manage_resd_track_rec

 



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:

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

   UC4 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
    UC4 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 

  • Delete Parent Data  

Delete records on the Guardian Information form (SOAFOLK) for students that have multiple parents associated with the same address type, telephone type and email type codes

 

Technical Notes: 

Technical Notes

   

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

UC4 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
    UC4 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
    UC4 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 UC4 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 degree on the General Student record (SGASTDN) to see if it is a doctoral degree.


  2. Special Student (AASP)

    The process checks the student admit type on the General Student record (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 the General Student record (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 earned at UNF and the number of upper level transfer hours where the student type on the General Student record (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 Student 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 the General Student record (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 the General Student record (SGASTDN) is equal to the process term.  If the student meets these conditions then the attribute is added.  In conjunction with the Student Classification Rules (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 the General Student record (SGASTDN) to see if it is a ‘BP’ (FTIC-APP).

Fees

  1. Admissions Orientation Fee (AAOR)
    The process checks the student type on the General Student record (SGASTDN) to see if it is one of the following:  ‘J’ (Transfer from a Florida public Community College) or ‘U’ (Other Undergraduate Transfer).  The process checks to make sure the student has not already paid the orientation fee.  If the student meets the conditions then the attribute is added.  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 the Program Requirements form (SMAPROG) 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 calculates 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 the Program Requirements form (SMAPROG) 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
    UC4 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.  

  3. University Honors-Complete (NAUC)
    The process checks Element 1 for a code of NAUC and adds an attribute with the same name. 
  4.  

  5. Interdisciplinary Honors-Enrolled (NAIY)
    The process checks Element 2 for a code of NAIY and adds an attribute with the same name. 
  6.  

  7. Honors in Major-Enrolled (NAMY)
    The process checks Element 2 for a code of NAIY and adds an attribute with the same name. 
  8.  

  9. 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), ANEX (International Exchange Student), or IACM (Academic Common Market) and adds the RAIS attribute.  This attribute entitles the student to pay in-state fees.    

Technical Notes:

echnical Notes:  

Technical Notes
    UC4 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 the Prior College (SOAPCOL) form in the Prior College block and determines if it is an SUS institution or Florida State 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.  

  3. Foreign Language Exempt (UFLE)
    The process checks the Academic Non-Course (SHANCRS) form 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. 
  4.  

  5. Summer Requirement Exempt (USME)
    The process checks the Academic Non-Course (SHANCRS) form 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 the General Student record (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 the High School Transcripts Self-Service application where the Transcript Used for Admission column is 'Y'.  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.  
  6.  

  7. 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 the General Student record (SGASTDN).  The process checks to see if the student has an AA degree from a Florida public university or state 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 the Academic Non-Course form (SHANCRS).  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:
  8.  

    CAPP Non-Course Requirement
    CAPP Non-Course Requirement   Status     Attribute
    GENS Y General Education Satisfied (UGES)
    GENX E General Educaiton Exempt (UGEX)
    GEN% O General 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 200908Greater 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
    Greater 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
    UC4 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 students with an active General Student record (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 Health Insurance (IAHA) or International Student Health Insurance (IAHS)
    The process selects students with an active General Student record (SGASTDN) who have a visa code on the International Information form (GOAINTL) of ‘F1’,’F2’,’FO’,’J1’,’J2, or ’JO’ and a medical code on the General Medical Information form (GOAMEDI) 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 students with an active General Student record (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
    • Module term students
     

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

     
  6.  

  7. Undergraduate Differential Tuition (RADT)
    The process selects students with an active General Student record (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 with an active General Student record (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 students with an active General Student record (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 students with an active General Student record (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 students with an active General Student record (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 the Student Course Registration (SFAREGS) form 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.  

  3. National Student Loan Clearing (NSLC)
    The process selects students with a time status of 00 on the Student Course Registration (SFAREGS) form 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
    UC4 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
    UC4 Chain     NSTU_GENERAL_STUDENT
  Job  

WSG5130

  Package   wksgpro
  Procedure  

p_partnership_students