Banner Prospect

SRRSRIN,SRRPREL and TOAD report

Banner Prospect processing can happen in batches through two Banner baseline jobs, SRRSRIN and SRRPREL. 1) SRRSRIN (Electronic Prospect Match) – matches prospects to existing Banner records.

2) SRRPREL (Migrate Electronic Prospects) – will move the temporary record into permanent Banner Prospect tables.

SRRSRIN:

  1. Go to GJAPCTL and enter SRRSRIN in Process Field. Next Block or ALT + Page Down.
  2. In Printer field, enter DATABASE. Next Block or ALT + Page Down.
  3. Parameter 01: Enter the code for the Prospect group you are processing. Example: APRO = Alamo Promise 4) Parameter 02: Leave blank
  4. Parameter 03: Enter A for All (Your results will show all statuses)
  5. Parameter 04: Enter N for Dup Processing (job will then mark records that are duplicates) 7) Parameter 05: Leave Blank; Next Block or ALT + Page Down.
  6. You should be in Submission block. You can check the Save and create a Parameter set in order not to fill out the information the next time you run the job.

 

  1. Check the status of your job submission by going to the Related tab.
  2. Make sure that you are still on the job you are checking on GJAPCTL; Example: Process will say SRRSRIN 11) Select Review Output.

 

  1. You will be in the Review page. If the process number is highlighted in red, then the job is not finished.
  2. If the Number is not highlighted red when you tab, then the job is finished.
  3. If job is finished click, the menu button by the number.

An Available Files box will appear.

  1. Your file should be the last run, so click on the last page arrow button where the page numbers appear. 16) Highlight the last lis file to see your results.

Your results will appear. SRRSRIN will let you know how many records were matched with an ID, are brand new or are Suspended.

You will now run SRRPREL:

  1. Go to GJAPCTL and enter SRRPREL in Process Field. Next Block or ALT + Page Down.
  2. In Printer field, enter DATABASE. Next Block or ALT + Page Down.
  3. Parameter 01: Enter the code for the Prospect group you are processing. Example: APRO = Alamo Promise 4) Parameter 02: Leave blank

5) Parameter 03: Enter M for Matched (The job will only load the Matched records) 6) Parameter 04: Leave Blank; Next Block or ALT + Page Down.

  1. You should be in Submission block. You can check the Save and create a Parameter set in order not to fill out the information the next time you run the job.

 

  1. Check the status of your job submission by going to the Related tab.
  2. Make sure that you are still on the job you are checking on GJAPCTL; Example: Process will say SRRPREL 10) Select Review Output.

An Available Files box will appear.

11) Your file should be the last run, so click on the last page arrow button where the page numbers appear. 12) Highlight the last lis file to see your results.

Your results will appear. SRRPREL will let you know how many loaded through the job and will need to be looked at manually by our staff.

You will log into Toad in order to run the workload file for the Prospect records.

  1. Select the PROD_S Database
  2. Your User name should already appear and you will enter your password that corresponds to your Banner Prod password.

 

  1. Once in Toad, select File. A drop down menu will appear. 4) Then select the folder titled Angie

5) Select SRIPREL_LOADS. 6) Click Open button

7) Make sure your cursor is at the end of the script. 8) Click F9 on your keyboard.

 

  1. When your results appear, click on the export icon.

 

  1. Name the file something that will let you know it is the AlamoPromise prospect file. Include the date you ran the script.
  2. Click OK button to have csv file appear.

 

  1. Place filters on file.
  2. On PLEDGE_DATE column, filter for the yesterday. If Monday, you will filter for Friday, Saturday and Sunday. 13) On LOAD_STATUS, filter for blanks.
  3. On PROCESS_STATUS, filter for N (New) and S (Suspended).

 

  1. Open a blank excel.
  2. Copy your filtered records from the AlamoPromise file. 17) Paste the records into the blank excel sheet.
  3. Save file as name you will know for AlamoPromise Prospect records. Include the dates the file covers, not the date the file was created.
  4. Email the file to Admissions ESP for work distribution.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.