Step 1: Put the file in the appropriate location for processing
The following directories exist for specific Personnel in the PA Program:
M: \\banjobs\edu
N: \\filer\cims\edu\data
O: \\filer\cims\edu\print
The M drive is the location where the excel spreadsheet should be placed. The MUST be named PA_vouchers.csv.
This file should have no first row indicating the header names. The fcolumn are as follows:
| TERM | Preceptor ID | Student ID | Stipend Amt | Voucher Amount | |
The TERM is represented by the term code in the standard Banner format such as 202140.
The Stipend amount is a dollar amount in this sort of format: 600 representing $600.00
The Voucher amount should be in format as follows: 1 Credits or 2 Credits, etc..
Step 2: Run the Banner job to load the spreadsheet into a Banner table
From the Banner Main Screen, type PASR001 to run the job to load the data into the appropriate Banner table.
This will bring up the following screen:
Click on the Go button in the upper right corner. This will bring up the following screen:
Click the down arrow (show above in the red circle) 2 times. This will move your cursor to the Submission section of the screen. In order to submit this job, you click on the save button in the lower right corner of the screen while your cursor is in the submission block
When you have successfully submitted the job, a green box will appear in the upper right corner of the screen with a job submission number. Note the number will not match the number below.
This will run the job to load the data. You will receive an email with a log file in your inbox when the job is complete that looks like this:
