search

dsu-effectiveness / utValidateR

Validate Data Elements in Warehouse and Reporting Pipelines
Other
0 stars 0 forks source link

This needs to be checked #100

Open cdemkegit opened 3 weeks ago

cdemkegit commented 3 weeks ago

https://github.com/dsu-effectiveness/utValidateR/blob/2e3a57d78de31a7d8faa881c3349564a757a90cc/data-raw/checklist.R#L330

this can be filled out later

cdemkegit commented 3 weeks ago

@JoyBaule Can you give me more information on this issue and how to fix it. Mostly I need to know what it is intended to check. It looks like it was never working in the first place.

@andreabr-dixie Do you know if this has ever been working or is it broken just now?

this is attached to the DataStewardAudits

andreabr-dixie commented 3 weeks ago

@cdemkegit @JoyBaule I don't think it was ever working. I don't think I have ever seen any errors.

JoyBaule commented 3 weeks ago

@cdemkegit @andreabr-dixie I have looked through this some more, I think what happened is that the reporting element for g_18a wasn't fully implemented or was in the process of being worked on and fell through the cracks. Also, because we hadn't run a graduation snapshot from Edify until this year, this error wasn't on the radar like some of our more well known audit report errors like student type. That is not to say that USHE didn't ever return this issue in a FIX file during the graduation submission cycle previously because this is actually a common error which returns about a dozen records each year and requires a closer look with Julie's input. I think the idea in utValidateR was to address it in earnest but again, best intentions/time/turnover, etc.

JoyBaule commented 3 weeks ago

@cdemkegit the official error from USHE states that the number of credit hours earned is less than the number of credit hours required. For example a student is awarded a bachelors for a degree that requires 120 credit hours but actually only has 118 credit hours. There are a number of reasons for this, sometimes it is a data entry error or a student repeated a class after graduation. Finally, this year we had a couple awards awarded posthumously. If we can get the audit report to show the errors Julie can provide an explanation ahead of the first file submission to lessen the error/FIX load. We do this often with the census and end of term snapshots and can apply a mutate statement ahead of file submission.