STCS issue

[BereaSchool]

Hi Josh,
I ran a query on stcs table and noticed that Course Drops are not populating the table. The last drops to populate the stcs was back in 2015. When we run course registration reports in the sql our data is incorrect because all drops are still being listed as either 'A' or 'N' and the student appears in the course count. I'm sorry we didn't catch this earlier, but our staff has always told me that our sql reports registration numbers were always incorrect. Please advise.

[nomadicjosh]

Ouch. Is this report saved as a Saved Query. If so, can you please let me know what the name of it is? Thanks.

[BereaSchool]

This was a while a go, but I ran 'select * from stcs' and the last D recorded was 2014-09-26

[nomadicjosh]

Ok, I will take a look at it.

[nomadicjosh]

I sent a message to Luke last Sunday, and I am still waiting for a response.