Enrollment Transactions Log and issues with ps_enrl_req_detail

Hello everyone,

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:
Semester A:
Week1: 15
Week2: 18
Semester B
Week1: 25
Week2: 2

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.

How can do i set the alarm clock windows 10 alarm it is very simple idea.