Removing enrollments from our external DB - good process steps

Our moodle is configured to consume from an external DB. 

The DBs looks like this 

(1) external_enrollment_DB -> (2) moodle side enrollments DB  -> (3) moodle DB

• The 1 to 2 sync does not automatically happen because I did not give the user in the (2) DB delete permissions.

• As a result - I have to manually remove records from (2) and then (3) consumes from it, removing enrollments from courses. 

Enrollments are not automatically removed from the moodle side (3) when removed from the external DB (1).  My other customer wants them to hang around for billing reasons.

When I get a request to remove enrollments, I have three step process

1. Open Genius SIS - to get the username required for SQL statement, step 2
2. Open MySQL Workbench and go to (2). 
3. I build a simple edit query on the table in (2) and manually delete the record(s).

No guessing, no fussing.  A consistent process of removing these records accurately.