Synchronization Management

Manage data synchronization between the employee (pegawai) database and the Global ID system.

Current Sync Status

Loading sync status...

Sync Operations

Sync Operation Descriptions:

  • Initial Sync: Syncs all records from pegawai database. Use when setting up the system for the first time.
  • Incremental Sync: Syncs only new records and handles soft deletes. Use for regular updates.
  • Refresh Status: Updates the current synchronization status display.
  • Preview Next G_ID: Shows what the next generated G_ID will be.

Database Management

Database Management Descriptions:

  • Generate Dummy Data: Populates the database with realistic test data for development and testing purposes. Supports both valid and invalid KTP records for testing validation logic.
  • Reset G_ID Sequence: Manually reset the G_ID sequence to start from a specific point (default: G025AA00). Useful for testing or when you want to restart numbering.
  • Validation Rules Toggle: Loading...
  • Clear All Data: Deletes all records from global_id, global_id_non_database, and pegawai tables. Automatically resets G_ID sequence to G025AA00. Table structure remains intact.
  • Reinitialize Tables: Executes the SQL schema file (create_schema_sqlserver.sql) to create/recreate the g_id database and all tables with proper structure including passport_id fields.
⚠️ Warning: Clear All Data is destructive and cannot be undone. Reinitialize Tables will create the database schema if it doesn't exist.

Detailed Statistics

Loading detailed statistics...