Reset Operational Data

Clears patients, visits, admissions, sessions, bookings, stock transactions, billing, payments, transfers, reports, and logs while keeping setup/master data.

Back to Setup
Danger: This removes live operational data from the whole system. Users and setup/master data are kept.
Kept Tables
  • admission_floors
  • admission_room_types
  • admission_rooms
  • assistants
  • branches
  • channeling_rooms
  • doctor_assistants
  • doctors
  • insurance_companies
  • medicine_generics
  • medicine_therapeutics
  • medicines
  • opd_billing_catalog_items
  • pharmacy_department_medicine_prices
  • pharmacy_department_transfer_rules
  • pharmacy_suppliers
  • radiology_doctor_modalities
  • radiology_doctors
  • radiology_service_prices
  • radiology_services
  • roles
  • rooms
  • specializations
  • system_settings
  • test_categories
  • tests
  • users
Tables To Clear
  • admission_charge_items (0 rows)
  • admission_department_bookings (0 rows)
  • admission_deposits (0 rows)
  • admission_final_bills (0 rows)
  • admission_room_allocations (0 rows)
  • admissions (0 rows)
  • audit_logs (30 rows)
  • consultation_invoices (0 rows)
  • csrf_tokens (0 rows)
  • lab_bill_items (0 rows)
  • lab_bills (0 rows)
  • medical_records (0 rows)
  • membership_divisions (0 rows)
  • membership_grama_divisions (0 rows)
  • membership_member_profiles (0 rows)
  • opd_bill_extra_items (0 rows)
  • opd_consultation_visits (0 rows)
  • patient_allergies (0 rows)
  • patients (0 rows)
  • pharmacy_bills (0 rows)
  • pharmacy_department_stock_batches (0 rows)
  • pharmacy_department_transfer_items (0 rows)
  • pharmacy_department_transfer_request_items (0 rows)
  • pharmacy_department_transfers (0 rows)
  • pharmacy_dispense_items (0 rows)
  • pharmacy_dispense_sequences (0 rows)
  • pharmacy_dispenses (0 rows)
  • pharmacy_expiry_updates (0 rows)
  • pharmacy_grn_items (0 rows)
  • pharmacy_grn_returns (0 rows)
  • pharmacy_grns (0 rows)
  • pharmacy_open_stock_headers (0 rows)
  • pharmacy_open_stock_items (0 rows)
  • pharmacy_open_stock_returns (0 rows)
  • pharmacy_po_items (0 rows)
  • pharmacy_price_adjustments (0 rows)
  • pharmacy_purchase_orders (0 rows)
  • pharmacy_sales_return_items (0 rows)
  • pharmacy_sales_returns (0 rows)
  • pharmacy_stock_adjustments (0 rows)
  • prescription_medicines (0 rows)
  • prescription_tests (0 rows)
  • prescriptions (0 rows)
  • radiology_invoice_sequences (1 rows)
  • radiology_invoices (0 rows)
  • radiology_session_slots (0 rows)
  • radiology_sessions (0 rows)
  • referrals (0 rows)
  • session_slots (0 rows)
  • sessions (0 rows)
  • tbl_member_dependants (0 rows)
  • tbl_members (0 rows)
  • test_branch_prices (0 rows)
  • test_package_branch_prices (0 rows)
  • test_package_items (96 rows)
  • test_packages (15 rows)
  • user_sessions (0 rows)
Run Reset Destructive