Directions for loading SAT scores
Problem Description :
used to load SAT scores
Resolution :
Update 11/13/2015 by Laura Hayes for the new procedures.
Steps to Upload SAT Scores:
1.Go to CollegeBoard and download file. Save file to N:\ADM\Webform_uploads\SAT – be sure it has a .txt extension
1.
Click on the following URL to navigate to the College Board SAT Suite of Assessments reporting login page: https://hedreports.collegeboard.org/login
2.
Log into your account, and navigate to the Download Center
3.
Navigate to the scores data file, and click the download link
4.
Save the file to a secure location on your PC or network
2.Open My Computer.. go to N:\ ADM\Webform_uploads\SAT folder
3.Double click on the SAT_upload.bat file
4.When “adm@pebbles password:”comes up on the screen, enter the password (admbanXX) for Pebbles
5.The screen will display all the request files uploaded for Banner processing and display “Press any key to continue” Leave this screen open so you can see the files that need to be processed in Banner. (Just minimize it)
6.Once the file is loaded the .txt file will be moved to an archived directory.
Bring up Banner INB screen to run the process to import the requests into the Recruit module.
7.Enter SRTLOAD in the GO TO Menu
Process: SRTLOAD ctrl pg dn
Printer: DATABASE -- ctrl pg dn
Par Values:
01 /tmp/filename.txt filename must be exactly like the file name you placed in the folder
02 SAT15
05 G
06 201602 (change term as needed)
07 US
08 A
12 W
14 MA
15 WEB
16 1MA
17 HOME
18 N
22 U
CTRL Pg down to Submission and SAVE
You can look at your .lis and .log files through review output to be sure there are no errors
8. Next run SRRSRIN from GJAPCTL
01 SAT15
02 Blank
03 A FOR ALL
04 Y
05 BLANK
Ctrl pagedown and save
9.Next Run SRRPREL from GJAPCTL
01 SAT15
02 BLANK
03 A
04 BLANK
Ctrl pagedown and save
**RUN AGAIN AFTER MATCHING ALL SUSPENSES
10.Next step is To Go SRIPREL to match and create recruit/applicant.
Look for any with a matching status of S
Matched and Load Status should be already Matched and loaded on the majority
1.Query the form to display the Prospects. Hit F7 the F8.
2.Highlight the prospect you would like to match
0.Click Options
1.Click Match (This will display the Associate Person with an ID form)
2.Make sure that the Generated ID is marked and click the Associate Person with and ID link at the bottom on the page
3.This will bring up the common Match screen. Follow the normal steps in Matching a prospect (DOB, SS#, address, phone # or email).
4.Click Options
5.Create recruit/Applicant
1. Next step is SORCPLN – This the form that will add the SAT test scores to SOATEST
2.N
3.I
4.N
5.Ctrl page down and save
Check a few to make sure test scores are added
5.After checking that the scores are added, Go To SRTPURG to purge the records (In the SRTPURG form, change 1. Electronic Prospect Code from WEB to SAT). This is the form that you purge the data from the temporary tables. This needs to be done after all of the scores been loaded into the permanent tables.
01 SAT15
06 Leave Blank
07 C
6. When finished processing all of the files shown, click on the window again and press any key to close it. IMPORTANT: Do not DOUBLE CLICK on the rcrfrm_upload program again until you have processed ALL of the files in Banner.
Revision Date : 11/13/2015