...
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. |
...