Open andreabringhurst opened 3 months ago
This issue is waiting for the next enhancements to utDataStoR. The sql needs to be rewritten. I don't have any code from banner. I only have code from DSCIR. The code needs to use attempted hours, and the level has to come from the level of the course (not the level of the student).
After reviewing fte_off_edify.sql here are my concerns: it is using student level instead of course level when calculating the fte it is pulling the student level from sgbstdn when it should be pulling the course level from ssbsect.
This needs to be rewritten.