...
Campus Cafe financial aid award codes must be configured and each code must be tried to a transaction code.
A default “0” F/A Link Token; other codes and years and other fields do not need to be set, just one record with a “0” token is all that is needed.
If no “0” token is added, then F/A Uploads will treat every upload as a new award disbursement to the billing batch and will not take prior disbursed amounts into consideration for subsequent debit/credit adjustments.
Configure Process (Non-PowerFaids)
...
award status: The state of the award. C = Canceled; D = Declined; P = Pending; V = Verified
sched_amt: The total dollar value of the award encompassing all individual disbursement(s) (do not include a dollar sign or a comma)
disb_amt: The gross dollar value of the individual disbursement disbursed to the student and to be applied to the student's ledger (do not include a dollar sign or a comma). If the award contains multiple disbursements, list each disbursement as a separate row. The sched_amt representing the overall award total would be the same for each row.
net_amount: The net (after loan origination fees) dollar value of the individual disbursement disbursed to the student and to be applied to the student's ledger (do not include a dollar sign or a comma). If the award contains multiple disbursements, list each disbursement as a separate row. The sched_amt representing the overall award total would be the same for each row.
isDL: Whether the award represents a federal direct loan. Y = Yes; N = No If to N, the process puts the net award amount as the gross award amount regardless of what is on the spreadsheet.
id_number: The Campus Cafe ID number of the student.
token: This is set to 0 for all disbursements for Non-PowerFaids schools
award_type: The Campus Cafe award code
award_year: A four digit number representing the federal financial aid year
award_semester: The Campus Cafe numerical code representing the semester to apply the award
social_sec_number: The student's social security number (this field must be filled in)
| Note |
|---|
If a student has a SSN leading in a Zero, remove the zero from the spreadsheet; if the student does not have a SSN on file then use the student's ID number with no leading zeros. Example: 097374743 would be input as 97374743, after removing the zero. This can be done by highlighting the SSN column, and changing its format to "Number" and it should automatically get rid of the leading zero. |
...
Generate a listing of students from the Student Finder and use the Action Items to Export the ID numbers to the SSRS Reports. This will be the listing of students that will pull into the report in the correct format.
Use the Parameters at the top of the report page to select the ISIR Award Year, Semester, and Award Codes, then export the report. It is recommended to use the .csv export to download the file.
Set the Disb_Amt and Net_Amounts to the correct disbursement Gross and Net amounts for the awards needed disbursed.
Delete all columns including and after the "delete" column. These columns are for reference use only.
Save the file to the exact file format that is set up under the Custom Control Settings; please review "Configure Process Section" for the default file naming and file type; .xlsx is what is recommended above.
Upload the file in Café Web through Upload F/A Awards Page, and select the semester you are disbursing on.