Student Data Migration Management System

Dashboard Overview

Total Master Records

0 Unique Students

Confirmed Migrated

Fully verified records

Status: Missing

Not in Migrated Grades

In Migrated Grades

Matched grade in SIS

Migration Issues & Classifications Filtered View

Duplicate Semester

Requires semester term reassignment

Student Not Uploaded in SIS

Check Migrated Grades workflow available

Student Not Present in SIS

Student ID missing from SIS master registry

Different College Already In Session

College session association conflict

Pending Migration Review

Records awaiting migration or confirmation

Quality Checkers & SIS Alignment Validation

College Checker Mismatches

Colleges ≠ Uploaded College

Course Checker Mismatches

Course ≠ Uploaded Course

Curriculum Checker Mismatches

Curriculum ≠ Uploaded Curriculum

Unresolved SIS Matches

Conflict or missing SIS student records

Conflicting SIS Registry Records

Multiple distinct records for same student ID

SIS Student Registry 0 records (0 unique)

Migrated Grades Loaded 0 records in SIS database

Upload Master File (.xlsx)

Processes academic records in the background. Match keys and SIS checkers are computed automatically.

	Session	Student ID	Student Name	Semester	Subject	Subject Name	Grade	Migration Status	Status	College Check	Course Check	Curriculum Check	SIS Match	Action
Loading Master File records...

Showing 0 of 0 records

Upload Migrated Grades (.xlsx)

Upload grades already migrated in SIS. Master File records with matching keys automatically update to Existing in Grades Migrated in SIS.

Session	Student ID	Student Name	Semester	Subject Code	Subject Name	Grade	Match Key	Import Date	Action
Loading Migrated Grades...

Showing 0 of 0 records

Upload Active & Inactive SIS Students (.xlsx)

Import SIS registry data. Supports multiple legitimate student records while preventing identical duplicates and flagging conflicts.

Student ID	Student Name	College	Course	Curriculum	Semester Name	Institute Email	Import Date	Action
Loading SIS Students...

Showing 0 of 0 records

Import History & Background Jobs

ID	Filename	Dataset	Total Rows	Imported	Skipped	Rejected	Status	Upload Timestamp	Action
Loading import history...

Showing 0 of 0 records

System Audit Trail

ID	Action	Affected Table	Record Identifier	Changes (Prev / New)	User	Timestamp
Loading audit logs...

Showing 0 of 0 logs

Migration Progress Logs

High-level stakeholder overview of grades migration progress across Academic Sessions and Year Levels / Semesters

Open Standalone View Export to Excel / CSV

Total to Migrate

Master File grade records

Grades Migrated

Successfully recorded in SIS

Pending To Migrate

Remaining to be transferred

Completion Rate

0.0%

Total Master File Grades per Academic Session & Year Level Total Grades to Migrate

Academic Year / Session	Y1S1	Y1S2	Y1 Summer	Y2S1	Y2S2	Y2 Summer	Y3S1	Y3S2	Y3 Summer	Y4S1	Y4S2	TOTAL
Loading matrix...

Migration Progress Breakdown (Migrated vs Not Migrated & %) Detailed Progress Log

Academic Session	Y1S1			Y1S2			Y1 Summer			Y2S1			Y2S2			Y2 Summer			Y3S1			Y3S2			Y3 Summer			Y4S1			Y4S2			TOTAL SESSION
Academic Session	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%	Migrated	Not Migrated	%
Loading breakdown...

Danger Zone

Permanent data purge operations and SQLite database VACUUM optimization

Irreversible Data Operations

Deleting data from these modules will permanently remove records from the database. SQLite VACUUM will automatically execute after each purge operation to defragment the database file and return freed disk space to the operating system immediately.

SQLite Database Storage & Health

Database File Size Loading...

Unallocated / Freelist Space Loading...

Pages & Freelist Loading...

Total Across Tables 0 records

Purge Entire Database (Full Reset) Highest Impact

Delete All Data & Perform VACUUM

Wipes every table in the database: Master File, Migrated Grades, Students in SIS, Import History & Row Results, and System Audit Logs. Auto-increment sequences are reset and SQLite VACUUM is performed to shrink the .db file back to initial zero-state size.

Master File Academic Records

0 records

Deletes all academic subject and student records from the Master File dataset, along with manual SIS match mappings. Automatically runs VACUUM.

Migrated Grades in SIS

0 records

Deletes all grades imported from SIS and resets matching status flags on Master File records back to MISSING. Automatically runs VACUUM.

Students in SIS Registry

0 records

Deletes all active and inactive SIS student profiles and unlinks derived SIS verification checkers from the Master File. Automatically runs VACUUM.

Import History & Logs

0 records

Deletes import batch metadata, error summaries, and row-level verification audit details. Existing records are unlinked from import IDs. Automatically runs VACUUM.

System Audit Trail

0 records

Clears historical audit trail entries, manual match resolution logs, and semester correction histories. Automatically runs VACUUM.

Upload Master File (.xlsx)

Upload Migrated Grades (.xlsx)

Upload Active & Inactive SIS Students (.xlsx)

Import History & Background Jobs

System Audit Trail

Migration Progress Logs

Danger Zone

Irreversible Data Operations

SQLite Database Storage & Health

Delete All Data & Perform VACUUM

Master File Academic Records

Migrated Grades in SIS

Students in SIS Registry

Import History & Logs

System Audit Trail

Master File Record Details

Migrated Grade Record Details

Resolve SIS Student Match

Duplicate Semester Correction

Check Migrated Grades

Check Unregistered SIS Students Against Migrated Grades

Matching Records 0

Unmatched Records 0

Update Migration Status

Check Semester vs Migrated Grades

Import Results Summary

Confirm Deletion

Processing...