PS Query & SQL

 View Only
  • 1.  ACTS Tuition and Fees

    Posted 3 hours ago

    Hello everyone,
    We have been working with our Institutional Research department to complete our ACTS reporting requirements. When I was asked to provide the Tuition and Fee amounts, I did just that - actual tuition and fees for each student for the year. Apparently, that was not what the ACTS data was supposed to include. Here's the explanation of the request:


    "ACTS wants the actual charge (before aid) for the students if they enrolled full-time for the full academic year. If they withdrew or became part-time, please provide the estimated charge as if they stayed full-time. And if the estimated amounts are not available, please fill in the general tuition and fees."

    We have 5 different undergraduate tuition rates and most graduate programs have their own tuition rates. 

    Does anyone have a query or an expression that would produce the actual tuition and fees if the student remained full time for the full year, and an imputed tuition and fee amount if the student enrolled for less than full time or ceased attending during the year? 

    Oh, and BTW - no duplicates. 



    ------------------------------
    Robert Bode M.B.A.
    Director of Financial Aid and MilitaryVeteran Student Services
    University of Wisconsin - River Falls
    robert.bode@uwrf.edu
    ------------------------------
    Alliance 2026 Registration is Open!


  • 2.  RE: ACTS Tuition and Fees

    Posted 3 hours ago

    I just heard a version of this today, and think we might use the budget amounts on table STDNT_BUDGET_IT.

     

     

    Stephen Forrest

     

    Institutional Research Analyst the Third

    University Decision Support

    Enrollment Management Research Group

    Office of the Provost

    Southern Methodist University

    sforrest@smu.edu

    214-768-4015

     

    "The only reason we put the data in, is to take the data out."

     

     

     

     




    Alliance 2026 Registration is Open!


  • 3.  RE: ACTS Tuition and Fees

    Posted 3 hours ago
    Hi Stephen, 

    I'm coming to that conclusion as well. At first I thought they were asking for the initial tuition and fees, so I put together a nice little query that pulled tuition and fees as of the census date. But I was assuming they still wanted the tuition and fees charged. That no longer seems to be the case. 

    Maybe this could be done with a Union? Actual tuition and fees for the students who stayed full time for the whole year, and budgeted tuition and fees for those who didn't? 

    I shouldn't have to think this hard at 4:00 on a Friday afternoon. 

    Thanks!

     

    Robert

     




    Alliance 2026 Registration is Open!