Attached is an example of a SQL script one of our customers is running to pull their AwardLetter data out of PowerFAIDs.

Here is a key to help explain some of the parameters in the code:

Alternate_id = Student id

Stu_Award_year_token = unique to each student’s financial aid year

stu_award_token = unique to individual award

poe_token = identifies specific academic term