PS Query & SQL

Some of the topics to be covered include:

• Assignment and completion of checklist items when new ISIRs load after packaging. The checklist items hold award letter viewing/printing and disbursements, as well as alert processing staff that the student’s aid package must be reviewed.
• Designing queries that change filter criteria based on user-entered prompts. For example, at certain times of the year we may want to display all students meeting criteria; at other times only those who are enrolled for the term.
• Using expressions in queries to construct checklist item codes that have the aid year embedded in them.

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=3697e148-d728-4f33-a880-2fe9665acfb8