Pro feature

Repair proposals

Read-only repair statements (SITS Marvin, Banner SQL, Workday Studio) generated from your audit findings. Copy, apply externally, then mark the proposal as applied — the audit log captures every step.

Enterprise

Total proposals

Systems

SITS, BANNER, WORKDAY, TECHONE, SALESFORCE, DYNAMICS

Entities

Applied

Proposal queue

8 proposals across 6 source systems.

SITS
F03-Student-domicile-present
Student
domicile
StudentView submission
Domicile is required for HESA Student stream but is NULL on 12 records since the recent SITS load. Source row has the country in `STU_HOME_COUN` but it didn't map.
SQL UPDATE tap to copy
```
UPDATE INS_STU SET STU_DOMICILE = COALESCE(STU_DOMICILE, STU_HOME_COUN) WHERE HUSID IN (...);
```
undo: UPDATE INS_STU SET STU_DOMICILE = NULL WHERE HUSID IN (...);
Banner
BANNER-INTEGRITY-FK-orphan
ModuleEnrolment
ModuleEnrolment references a deleted ModuleInstance — orphan after the SSRXMEA purge in March. Re-link to the current instance for the same module+term.
SQL UPDATE tap to copy
```
UPDATE SFRSTCR SET SFRSTCR_CRN = ... WHERE PIDM=842091 AND TERM_CODE='202609';
```
undo: Restore PRE-VALUE snapshot for SFRSTCR row.
Workday
WD-NATIVE-grade-scale-mismatch
AssessmentResult
Grade letter 'P' submitted for a module configured with the percentage scale. Either re-grade or override the grade-scale binding for that course-section.
Workday business process tap to copy
```
Initiate 'Override Grading Basis' BP for course section CS-CMP1041-A.
```
undo: Roll back the BP via the audit trail.
TechOne
TECHONE-FIN-NATIVE-orphan-charge
Charge
Charge has no corresponding student account in T1_AR_CUSTOMER. Likely a SITS-side delete that didn't propagate. Cancel the charge or re-create the customer.
SQL UPDATE tap to copy
```
UPDATE T1_AR_CHARGE SET STATUS='CANCELLED' WHERE CHARGE_ID=88421;
```
undo: UPDATE T1_AR_CHARGE SET STATUS='OPEN' WHERE CHARGE_ID=88421;
Salesforce
SALESFORCE-EDU-NATIVE-duplicate-contact
Contact
Two Contact rows for the same applicant (same email, same DoB). Merge into the master record and re-parent the Opportunities.
Salesforce merge tap to copy
```
Use the standard Contact Merge UI on the two records, keeping the older sf-id.
```
undo: Salesforce keeps a 30-day merge audit trail; revert from there if needed.
Dynamics
DYNAMICS365-EDU-NATIVE-stale-lead
Lead
Lead older than 12 months with no activity. Either disqualify or re-engage via the marketing journey.
Dataverse update tap to copy
```
Update statecode=1 (Disqualified) statuscode=6 (Lost) on the lead row.
```
undo: Set statecode=0 statuscode=1 to re-open.
SITS
F03-Engagement-startdate-future
Engagement
startDate
Engagement startDate is 2027-09-15 — a year too far. Almost certainly a 4-digit-year typo. Set to 2026-09-15.
SQL UPDATE tap to copy
```
UPDATE INS_ENG SET STARTDATE=DATE '2026-09-15' WHERE HUSID='2026100119';
```
undo: UPDATE INS_ENG SET STARTDATE=DATE '2027-09-15' WHERE HUSID='2026100119';
SITS
F12-SCJ-without-RDM
StudentCourseSession
Legacy-scar: SCJ row exists with no matching RDM row. Either back-fill the RDM or void the SCJ — historical merge artefact.
SQL UPDATE tap to copy
```
INSERT INTO RDM (...) SELECT ... FROM ... WHERE SCJ_CODE='RD2026/00187';
```
undo: DELETE FROM RDM WHERE SCJ_CODE='RD2026/00187';