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