Award Management Feed to Banner Finance - issue with rejected, declined or any variance of pulling the award back from student.

Theodore VanPatten

Our current feed is turned off, so we do have an IT person that understands the API Calls programming. Our issue is with the scholarships we have to pull back from students regardless of reasons. Our current process is entering a number 1 in the award amount and previously we entered a zero, come to find out that is not the correct way of doing it. The correct way is to change the category to the rejected, declined, or pulled back reason. I am looking for someone to talk to that has a working interface file between Award Management and Banner Finance.

Please contact me directly.
Theodore “Ted” Van Patten
vanpatt@scf.edu
Manager, Constituent Database & Data Services
State College of Florida Foundation
941-752-5336
PO Box 1849, Bradenton, FL 34206

Theodore VanPatten

I am looking for someone to talk to that has a working interface file between Award Management and Banner Finance.

Crystal Bruce

Hi Theodore VanPatten‍ , sorry you haven't gotten any responses yet. Let me see what I can find out on my end, if there is anyone that we can find that can assist. Thanks!

Victor Swindell

I've set up my own system to transfer BAM Data to Banner and Banner Data to BAM.
in short (I have a longer more detailed version of these for programmers)

• I use the BAM Fund Disbursements API to extract ‘Offers’ for the award terms we are processing. This API call has to be updated each award cycle.
• I then take that file and import it into a custom banner table to process.
• I have a two SQL Script that reads this table for annual awards…ignore anything that has already added with the same amount… add new ones to banner, updates anything with a changed amount into RPRAWARD
• This uses the Banner RP_AWARD API
• I have a similar process for term based awards RPRATRM using the rp_award_schedule api
• The script also generates reports of what has been done.
• I have another process that looks at those awards that came from BAM in the last x-days that have been accepted, canceled or declines, and creates exports them into a file.
• I use the BAM FundUpdater API to push these into BAM
  
  
  

Your team is going to have to spec out what you want to achieve.

Because Banner is our database of record ), as well the fact that other financial award are in Banner other that scholarships. we wanted all the student choices to happen in Banner (Accept, Decline, Cancel)

If you are using Atomic UC4...there is a document and code in BAM ...where the API's are listed.

Site → Settings → Import and Export Tools

At the bottom is a link to the API Documentation

at the bottom of the Fund Disbursements API is a link to ISU Documentation with Atomic UC4 complete with code

If your IT Person wants my expanded Notes on this process… just reach out to me.

Victor C. Swindell

Programmer/Analyst III

Swindellvc@cofc.edu

Division of Information Technology

College of Charleston

843.953.7522