SRTLOAD Process

 Problem Description : 

Instructions for loading prospects via the SRTLOAD

 Resolution : 

To load data to temporary tables:

SRTLOAD – This is used to load the file into the temporary tables in Banner(see page 37)

SRIPREL – this is used to load the recruits into the permanent tables in Banner. (see page 43)

1. Query the form to display the Prospects. Hit F7 and then F8

2.Highlight the prospect you would like to match 

1.Click Options

2.Click Match (This will display the Associate Person with an ID form)

3.Make sure that the Generated ID is marked and click the Associate Person with and Id link at the bottom on the page.

4.This will bring up the common Match screen. Follow the normal steps in Matching a prospect. This will take you back to the SRIPREL screen

5.Click Options

6.Create Recruit/Applicant

SRTPURG – This is the form that you purge the data from the temporary tables. This needs to be done after all of the prospects have been loaded into the permanent tables

SRAPRED – This is the form that you will set up each semester. What ever fields are on this form is what is loaded into Banner. 

 Revision Date : 11/14/2011