.
 

Enterprise Systems

 

Globe and planet

     

Test Scores

ACT and SAT Test Score Process


An automated process runs twice a week at 9:10 am (Tuesday and Friday) to process test scores through UC4 (job scheduling software). Test Score requests are generated in three different ways: Manual Request using a Banner Self-Service application, 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 (SOATEST) form. 


Generate Test Score Requests

  

The following processes are run to generate score requests:

  1. Delete any existing files
  2. Generate ACT and SAT Request File using Admissions Checklist
    1. Generate Request
      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).
    2. Build Request File
      Select all files from the Generate Test Score Requests Table (SWBTSTA) and create file. File is saved to the specified path and file name.
    3. Clean Request File
      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.
     
  3. Send file to NWRDC

Retrieve and Load Test Scores 

 

The following processes are then run to retrieve each of the test score files and load them into the Banner system:

  1. NERDC Job Submission to get files
  2. WSO2020 – Move files to a location for processing by Banner jobs.
  3. WSA5620 – Run a series of Banner jobs in the following order to load each file:
    1. Electronic Prospect Load (SRTLOAD)
    2. Electronic Prospects Pre Match Processing (WSA5634)
    3. Electronic Prospect Match (SRRSRIN)
    4. Electronic Prospect Post Match Processing (WSA5635)*
    5. Migrate Electronic Prospects (SRRPREL)*
    6. Electronic Prospect Purge (SRTPURG)*
     
  4. WSO2021 – Remove the files used for processing from the temporary directory and move the original files to a final back up directory.
  5. WSU5010 – Fix test score name and addresses.

*These processes are run every day in order to pick up records that were manually matched after going into suspense.

 

Technical Notes:

 

UC4 Chain

 

NSTU_ACT_SAT_TESTSCORE_PROCESS

NSTU_ACT_SAT_SUSPENSE

NSTU_ACT_TESTSCORE_LOAD

NSTU_ACT_TESTSCORE_LOAD

 

Job

 

WSO2020

WSA5634

WSA5620

WSA5635

WSO2021

WSU5010

 

Package

 

WSA5634, WSA5635 - WKSABRM

WSU5010 - WKSGDEM

 

Procedure

 

WSA5634 - p_set_srtemal_preferred

WSA5635 - p_parent_data_cleanup, p_remove_email_emp_stu

WSU5010 - p_fix_case

 

 



AP Test Score Process


The following nightly processes are run to load Advanced Placement (AP) scores into the Banner system:

  1. WSO2015 – Retrieve all available AP files from the ETS server via SFTP using a Java program.  Then delete files that have been previously stored in the backup and copy all others to a temporary location for processing.
  2. WSO2010 – Decrypt all received files.
  3. WSO2020 – Combine all received files into one file for processing.
  4. ADM_LOAD_AP_SCORES_M – Load into Banner (ARP process must be run in order to view them in Banner).
  5. WSO2021 – Remove the file used for processing from the temporary directory and move the original files to a final back up directory.

Technical Notes:

 

UC4 Chain

 

NSTU_TEST_SCORES

NSTU_AP_TESTSCORE_LOAD

 

Job

 

WSO2015

WSO2010

WSO2020

WSO2021

 

Package

 

n/a

 

Procedure

 

n/a



GMAT Test Score Process


The following nightly processes are run to load Graduate Management Admission Test (GMAT) scores into the Banner system:

  1. WSO2017 – Retrieve all available GMAT files from the PearsonVue server, deleting those that have been previously stored in the backup and copying all others to a temporary location for processing.  A java downloader program supplied by PearsonVue is used to create the files nightly via HTTPS, however, new scores are only made available in the files once per week and contain scores for the previous week (Sunday at midnight through Saturday at 11:59pm).
  2. WSO2020 – Combine all received files into one file for processing and move it to a location for processing by Banner jobs.
  3. WSA5620 – Run a series of Banner jobs in the following order to load the file:
    1. Electronic Prospect Load (SRTLOAD)
    2. Electronic Prospects Pre Match Processing (WSA5634)
    3. Electronic Prospect Match (SRRSRIN)
    4. Electronic Prospect Post Match Processing (WSA5635)
    5. Migrate Electronic Prospects (SRRPREL)
    6. Electronic Prospect Purge (SRTPURG)
     
  4. WSO2021 – Remove the file used for processing from the temporary directory and move the original files to a final back up directory.

Technical Notes:

 

UC4 Chain

 

NSTU_TEST_SCORES

NSTU_GMAT_TESTSCORE_LOAD

 

Job

 

WSO2017

WSO2020

WSA5634

WSA5620

WSA5635

WSO2021  

 

Package

 

WSA5634, WSA5635 - WKSABRM

 

Procedure

 

WSA5634 - p_set_srtemal_preferred

WSA5635 - p_parent_data_cleanup, p_remove_email_emp_stu



GRE Test Score Process


The following nightly processes are run to load Graduate Record Examinations (GRE) scores into the Banner system:

  1. WSO2016 – Retrieve all available GRE files from the ETS server via SFTP using a Java program.  Then delete files that have been previously stored in the backup and copy all others to a temporary location for processing.  Although this process runs nightly, new files are only created twice a week on Wednesday and Friday after 3pm.
  2. WSO2010 – Decrypt all received files.
  3. WSO2020 – Combine all received files into one file for processing and move it to a location for processing by Banner jobs.
  4. WSA5620 – Run a series of Banner jobs in the following order to load the file:
    1. Electronic Prospect Load (SRTLOAD)
    2. Electronic Prospects Pre Match Processing (WSA5634)
    3. Electronic Prospect Match (SRRSRIN)
    4. Electronic Prospect Post Match Processing (WSA5635)
    5. Migrate Electronic Prospects (SRRPREL)
    6. Electronic Prospect Purge (SRTPURG)
     
  5. WSO2021 – Remove the file used for processing from the temporary directory and move the original files to a final back up directory.

Technical Notes:

 

UC4 Chain

 

NSTU_TEST_SCORES

NSTU_GRE_TESTSCORE_LOAD

 

Job

 

WSO2016

WSO2010

WSO2020

WSA5634

WSA5620

WSA5635

WSO2021

 

Package

 

WSA5634, WSA5635 - WKSABRM

 

Procedure

 

WSA5634 - p_set_srtemal_preferred

WSA5635 - p_parent_data_cleanup, p_remove_email_emp_stu



Set Test Score Purpose Codes


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.  

 

This process will assign a test identifier of TIUG (Test Indicator Undergraduate) or TIGR (Test Indicator Graduate) with a score indicating the test to be used.

 

Students will be selected if the following conditions are met.

  • admissions application exists for a current or future term
  • student does not have a test identifier for the level of the admissions application or student has a test identifier code for an unofficial score and an official score has recent activity
The TIUG code will be applied by selecting an SAT or ACT and if both exist, the highest score will be selected using a score conversion.  The TIGR code will be applied using the last taken graduate exam.  If both an unofficial and official score exists in the same month and year, the official will be selected.  

 

The process then selects students with activity on the test indicator codes or for any tests that are used for the test indicator codes since the last time the process ran.  The process updates the Purpose code based on the best score for each component of the test indicated by the TIUG or TIGR.

 

Technical Notes: 

Technical Notes
    UC4 Chain      NSTU_TEST_SCORES
  Job   WSO5010
  Package   wksotst
  Procedure   p_adm_tst_check