- 2 Posts
- 19 Views
Enrollment Transactions Log and issues with ps_enrl_req_detail
A while ago, I was asked to produce a report that shows the change in number of enrolled students by day in a previous semesters. The sysadmin then gave me ps_enrl_req_detail record to try my luck with.
But that table is cursed, below are some of the issues I am facing:
1- Drop transaction timestamp is older than enrol transaction timestamp.
2- Sometime student is enrolled with W or WA but there is a D transaction for that course
3- Certain financial drop transactions are not showing in this table. the sysadmin then gave me ps_audit_stdt_enrl to check.
Is there is any better record to consider? or this is the only record?
the whole idea is to create some sort of comparison like the below:
So we can see that in week 1 of Semester A, we had less students than semester B, but week 2 we had more students in semester A than semester B.