PS Query & SQL

 View Only
  • 1.  Term Specific Financial Aid Award Adjustments

    Posted 07-08-2025 09:45 AM

    Hello!

    Has anyone had to look for term specific financial aid award adjustments and successfully been able to do so?  I'm having trouble trying to isolate the adjustment of the award down to the term level.

    STDNT_AWRD_ACTV doesn't have STRM. If I try to connect STDNT_AWRD_ACTV.DISBURSEMENT_ID to DISB_ID_TBL.DISBURSEMENT_ID in order to isolate the term the adjustment occurred in then the issue is STDNT_AWRD_ACTV.DISBURSEMENT_ID isn't recorded when it is a manual adjustment to the award, so I get no results.

    There has to be a way to see which term the adjustment occurred in, right?

    Thanks in advance for any help!



    ------------------------------
    Brian Carroll
    Associate Director, Business and Systems Analysis
    Cornell University
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------
    Alliance 2026 Registration is Open!


  • 2.  RE: Term Specific Financial Aid Award Adjustments

    Posted 07-08-2025 12:04 PM

    Hello Brian,

     

    I see what you mean about STDNT_AWDR_ACTV – disbursement id is populated only when the action is authorize or disburse.

     

    Have you tried adding in STDNT_PKG_DISB to your query?  That record has both Disbursement ID and STRM.  It's the record that supports what we see behind the "Disbursement" link on Assign Awards to a Student.

     

     

    I hope this helps.  Please let me know what additional questions you have.

     

    Cheers,

    Jessica

     

     

    Jessica M Holler
    System Integration Analyst | Enrollment Systems | DePaul University

    25 E. Jackson Blvd., Room 1646 | Chicago, IL 60604 | (312) 362-6651 | jshisler@depaul.edu

     

    Jessica M Holler
    System Integration Analyst | Enrollment Systems | DePaul University

    25 E. Jackson Blvd., Room 1646 | Chicago, IL 60604 | (312) 362-6651 | jshisler@depaul.edu

     




    Alliance 2026 Registration is Open!