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, and athletic records are also 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 records remain.  This process deletes any element 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, 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).

 

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

Petition Tracking Emails

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 Orphans 

Delete records from various tables when there is no General Person Identification record

Technical Notes:  

Technical Notes

	AppWorx Chain		NSTU_GENERAL_STUDENT
	Job		WSG5370
	Package		wksgsts
	Procedure		p_record_cleanup

Send ISQ Emails 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

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) or occurs in the past then updates the record with an expected graduation date.  The expected graduation date is based on the current term 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 year part of the current term.  Then the code for summer (05) is appended to the year.  Using the Term Code Validation table (STVTERM), the end date for the term created is used as the expected graduation date.

 

Note: If the current term is a fall term, then an additional year is added to the current 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
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
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 required hours.  Then the total number of upper level credit hours earned at UNF is calculated.  This number must be greater than or equal to 30.  The process also 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), subtracts 60 and multiplies by .75 to get 75 percent of the upper level hours required.  The total number of upper level credit hours earned at UNF is calculated.  This number must be greater than or equal to the 75 percent of total required upper level program hours calculated in the first step.  AA program hours are set at 60 so the calculated program hours are reset to 45.  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 upper level hours calculation for residency purposes.  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. 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
   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 198508	NA	UGEB
   Greater than 198508 and less than 198708	Less than 60	UGEA
   Greater than 198508 and less than 198708	Greater than or equal to 60	UGEB
   Greater than 198708 and less than 199308	Less than 60	UBEC
   Greater than 198708 and less than 199308	Greater than or equal to 60	UGED
   Greater than 199308 and less than 199608	Less than 60	UGEE
   Greater than 199308 and less than 199608	Greater than or equal to 60	UGEF
   Greater than 199608 and less than 199908	Less than 60	UGEG
   Greater than 199608 and less than 199908	Greater than or equal to 60	UGEH
   Greater than 199908 and less than 200908	Less than 60	UGEI
   Greater than 199908 and less than 200908	Greather than or equal to 60	UGEH
   Greater than 200908 and less than 201208	Less than 60	UGEJ
   Greater than 200908 and less than 201208	Greather than or equal to 60	UGEH
   All Others	Less than 60	UGEK
   All Others	Greater than or equal to 60	UGEH

      

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

 

3. 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.   

    
4.  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.
  
5. 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.

 

6. 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.

 

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

 

 

Technical Notes:

echnical Notes:  

Technical Notes

	AppWorx Chain		NSTU_DAILY_REGISTRATION_FALL NSTU_DAILY_REGISTRATION_SUMMER NSTU_DAILY_REGISTRATION_SPRING 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 WSF5004 - Registration Time Tickets for Students Attending Orientation - (Fall and Summer only)  WSF5006 - Fall Registration Time TIckets for Students Attending Orientation - (Summer 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 WSF5004 - wksfapt WSF5006 - 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 WSF5004 – p_set_orient_appointment   WSF5006 – p_set_orient_summer_ftic

 

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 select students from SFAREGS (Student Course Registration) Enrollment Information block.  If student has an Acceptance indicator equal to the input parameter, an SSN on SPAPERS (General Person) that begins with ‘000’, is greater than ‘800000000’, or is blank, 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