search

ut-effectiveness / utDataStoR

https://ut-effectiveness.github.io/utDataStoR/
Other
0 stars 0 forks source link

Add_fte_total_current.sql to utDataStoR #17

Closed andreabringhurst closed 1 week ago

andreabringhurst commented 3 months ago

AAdd fte_total_current to utDataStoR to replace fte_off_edify have the new query report both ug, gr, and total fte by term, have it use snapshot data and do not hard code terms.

Correct the problems with fte_off_edify, it is pulling from the student level and not the course level like fte_total_current will.

When reporting FTE it is often reported in 3 ways, undergraduate fte, graduate fte and total fte. Writing 1 query for all 3 of these requests makes the most sense and means that there are less queries to manage in utDataStoR.

Add a query for total fte that is for current, one for census and one for eot this will mirror what we are doing with headcount. There is a headcount_current, headcount_census and headcount_eot.

andreabringhurst commented 1 week ago

This issue will be done as soon as the https://github.com/ut-effectiveness/utDataStoR/pull/22 Pull request is approved.