PS Query & SQL

 View Only

Queries, Checklists, and Things that go Bump in the Night 

01-19-2025 04:08 PM

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


#PSQuery
#FinancialAid
#ISIR
#Expressions
#Ellen_Fishman
#Theresa_Allen

Attachment(s)
pptx file
Alliance Presentation.pptx   5.97 MB   1 version
Uploaded - 01-19-2025
rtf file
query RPT_FA_AID_QUALIFIER SQL.rtf   2 KB   1 version
Uploaded - 01-19-2025
rtf file
query RPT_FA_ISIR_COMPARE SQL.rtf   3 KB   1 version
Uploaded - 01-19-2025
rtf file
query RPT_FA_ISIR_COMPARE_EFC_ASSIGN SQL.rtf   2 KB   1 version
Uploaded - 01-19-2025
rtf file
query RPT_FA_ISIR_COMPARE_EFC_CMP SQL.rtf   2 KB   1 version
Uploaded - 01-19-2025
docx file
Run Controls and Jobset ISIR Compare.docx   249 KB   1 version
Uploaded - 01-19-2025
docx file
SQL UASQ_GET_ISIR_TXN_NBR.docx   11 KB   1 version
Uploaded - 01-19-2025
docx file
SQL UASQ_UPDT_PKG_RATING_CMP_VAL1.docx   11 KB   1 version
Uploaded - 01-19-2025
docx file
SQL UASQ_UPDT_PKG_UA_VAR_CHAR13.docx   11 KB   1 version
Uploaded - 01-19-2025

Related Entries and Links

No Related Resource entered.