An automated process runs twice a week at 9:10 am (Tuesday and Friday) to process test scores through AppWorx. Test Score requests are generated in three different ways: Manual Request (SWATSTA), automatically generated using the Admissions Checklist, and unsolicited from student. All test scores are received from a state repository at Northwest Regional Data Center (NWRDC). All test scores can be viewed in Banner on the Test Score Information (SWATEST) form. Test scores are not available outside of Banner.
Select all students with an Admission Request type of SAT or ACT Scores (TSTS) on the Application Checklist on the Admissions Applications (SAAADMS) form where the Entry Term is greater than or equal to the current term and the Received Date is blank (NULL) or a previous request has been unfilled for three days. A record is inserted into the Generate Test Score Requests Table (SWBTSTA).
Select all files from the Generate Test Score Requests Table (SWBTSTA) and create file. File is saved to the specified path and file name.
Update First Request and Last Request dates on checklist for generated requests. Insert all records in the Generate Test Score Requests table into the Generate Historical Test Score Requests table. Delete records from the Generate Test Score Requests table.
Prepare for new run of the automated transaction receive process by cleaning up temporary values
Delete records in tables used during the matching process and error logging (gwrfpeo, gwrspeo, gwrsrun, swrpmch, swttrps, swrterr, swbttyp where swbttyp_type in ‘SUSPEND’, ‘NO_SSN’, AP_SUSPEN’)
Delete records in the unapplied acknowledgement table that are 180 days old (swruack where swrrule_business_area = ‘UACK PURGE’ and swrrule_rule = ‘PURGE TIME’)
Creates new records into the zero tables of SAT and GMAT if additional tests exists
Delete any duplicate records for SAT and ACT from SWRSAT0 and SWRACT0
ACT data in the SWRACT0 table is inserted into the following tables:
SHBHEAD - EDI Master Header Table
SHRHDR4 – EDI Document Header Table
SHRIDEN – EDI Identification Table
SWRACT1 – ACT Interface Table
If data is successfully inserted, then it is deleted from the SWRACT0 table. Error messages are logged as necessary.
CLAST data in the SWRCLT0 table is inserted into the following tables:
SWRCLT1 – CLAST Interface Table
If data is successfully inserted, then it is deleted from the SWRCLT0 table. Error messages are logged as necessary.
GMAT data in the SWRGMT0 table is inserted into the following tables:
SWRGMT1 – GMAT Interface Table
If data is successfully inserted, then it is deleted from the SWRGMT0 table. Error messages are logged as necessary.
GRE data in the SWRGRE0 table is inserted into the following tables:
SWRGRE1 – GMAT Interface Table
If data is successfully inserted, then it is deleted from the SWRGRE0 table. Error messages are logged as necessary.
SAT data in the SWRSAT0 table is inserted into the following tables:
SWRSAT1 – SAT Interface Table
If data is successfully inserted, then it is deleted from the SWRSAT0 table. Error messages are logged as necessary.
Create ‘receive’ transaction and steps for each new electronic transcript. Inserts records into SWBOTRN – Open Transactions from SHBHEAD, SHRHDR4, and SWBOTRN (where transaction number is NULL)
Selects ‘required values’ step values and inserts error records where the values are not within the desired range for each type of data (test scores, dates, high school codes, post secondary codes, course numbers, etc.)
For certain types of transactions validates translatable values for each document sequence number as follows:
130, 146 - date of birth, graduation date
1, 2, 3, 4, 5, 130 – state code
130 – session begin date, session end date, class rank date, nation code
130 and Post secondary – student level, honor code for degree, date code
130, 131 – rank date
1 – grade level for ACT
3 – nation code for GMAT
4 – nation code for GRE
5 – grade level and nation code for SAT
147 – follow up action code and reject reason
146 or 130 and post secondary – eligible to return date
Validates translatable values for each document sequence number for each AP test score (date of birth, educational level, test dates, test scores, recruit term, course term, rules, scores within range, ) in the EDI table (SHBHEAD)
Checks all CLAST component test names are valid
Determines if student already exists in Banner
Insert records that are not an exact match into SWRPMCH table from SWTTRPS and GWRFPEO; update step on SWROTRS to ‘MATCH’
For records that do not have a match, a person record is created
Update the ‘MATCH’ step in SWROTRS to ‘Y’; updates pidm on SWBOTRN and SHBHEAD for the document sequence number; update biographical information where applicable; if multiple exact matches occur, then change ‘MATCH’ step to ‘N’ for further review as potential match
Update evaluatable step to ‘Y’ for high school transcript
Determines if transcript request can be processed
Determines if test scores can be processed
Call appropriate “evaluate” procedure depending on transaction type and loads data to appropriate tables
Archive records from the following tables:
SWBOTRN – Open Transactions
SWROTRS – Steps of Open Transactions
SWRO147 – Transcript Request Acknowledgments
SWBOSRQ – Open (not completed) transcript requests (Open Send Requests)
Records are copied to the following tables (in order)
SWBCTRN – Completed Transactions
SWRCTRS – Transaction Steps for completed transactions
SWRC147 - Transcript Request Acknowledgments
SWBCSRQ - Closed Transactions for sent transcript requests
Purge EDI records for each document sequence number
For any records (SPRIDEN) created since the last processing date, fix the last name, first name, and middle name to proper case. In addition, fix the street line 1, street line 2, city, and zip code. (wksgdem.p_fix_case)
Process all students to determine if they can receive a CLAS Exemption. This includes both SAT and ACT scores. In addition, some courses may be used to exempt parts of the CLAS. See the University Requirements College Level Academic Skills (CLAS) Requirement Exemption process for detailed information. (wp_clast_exemption_upd_db)
Alias - COM_DELETE_FILES_IN_AGENT_M
UNFFTPP (File Transfer – Passive FTP)
UNFSUBM (NERDC Job Submission)
WSU5010 - Fix test score name and addresses
The following nightly processes are run to load Advanced Placement (AP) scores into the Banner system:
WSO2015, WSO2010, WSO2020, WSO2021
The following nightly processes are run to load Graduate Management Admission Test (GMAT) scores into the Banner system:
WSO2017, WSO2020, WSA5620, WSO2021
The following nightly processes are run to load Graduate Record Examinations (GRE) scores into the Banner system:
WSO2016, WSO2010, WSO2020, WSA5620, WSO2021
Students take the Math Placement Test and the three Writing Placement Tests (WPC – Concepts, WPG – Grammar, and WPS – Clarity) in Blackboard. The scores are moved from Blackboard into a temporary table. This nightly process selects all math and writing placement test scores from the temporary table and inserts or updates them into the Test Score Information (SWATEST) form in Banner. Once the test scores are updated or inserted they are deleted from the temporary table.
The University of North Florida must report which test was used for admission. On the Test Score Information (SWATEST) form there is a Purpose field that UNF is using to identify which test was used for admission. The user must enter a Test identify of TIUG (Test Indicator Undergraduate) or TIGR (Test Indicator Graduate) with a Score indicating the test to be used. The codes are as follows:
A for ACT
S for SAT
G for GRE
H for Unofficial GRE
R for Revised GRE
P for Revised Unofficial GRE
B for GMAT
C for Unofficial GMAT
M for Miller
This nightly process selects students with activity on the Test Score Information form since the last time the process ran. The process then updates the Purpose code based on the best score for the test indicated by the Test identifier of TIUG and TIGR.
This nightly process updates test dates for ACT and SAT scores. The process selects all students whose ACT and SAT test dates are the same. The ACT date is updated to the 15th of the month and the SAT date is updated to the 1st of the month. A file is created and sent to the Y drive of users on the distribution list. An email is sent to the distribution list (sortest-chg-file) to alert them that the file is available.
Copyright © 2012 University of North Florida1 UNF Drive | Jacksonville, FL 32224 | Phone: (904) 620-1000
Contact | Emergency | Privacy | RegulationsDisability Accommodations