SQL Show which entries are missing

I'm trying to create an exception report in MSSQL.

In our Payroll software we have two processes that we do every week. We calculate how much leave an employee has accrued and taken, and then we need to reset the leave accrued so they may accrue more next week without hitting the limit. This is all done in a single table called PRLH. This is a smaller version of the table without the clutter. This reset process needs to be done weekly without fail, otherwise it's a huge task to fix it. (I spent 4.75 hours today fixing a mistake our payroll officer did when she forgot to reset it 5 weeks ago).

PRLH

PRLV

| PRCo | LeaveCode | AccType |
| 3 | ALH | R |
| 4 | FLY | F |

PRCo is a company number. PREndDate only applies when Type is either 'U' or 'A'and it is the Week Ending date (for us it's always Tuesday) otherwise if it's type 'R' it's null, ActDate is the date that it actually occurred, the ActDate with Type R should always be on a Tuesday. Type is either 'R', 'U', 'A' (Reset, Usage, Accrual).

What I'm looking for is a statement which will show me any combination of PRCo, PREndDate and LeaveCode where ActDate doesn't exist with the type R for the last Tuesday, though I want to exclude it if the LeaveCodes AccType is 'F'. This will be run every Wednesday/Thursday. I've been using this formula in it for the to get me the Tuesday I need.