Eaglesoft User Removal: Step-by-step Account Management Guide

Managing user accounts in Patterson Dental's Eaglesoft practice management software is essential for maintaining HIPAA compliance, protecting patient records, and controlling software license limits. When dental practices undergo staff turnover or structural restructuring, administrators often need to deactivate or remove multiple user profiles at once.

Unlike generic software platforms, Eaglesoft doesn't include a single "remove all users" button due to strict data integrity safeguards and relational database dependencies tied to patient charting, financial ledger entries, and clinical notes. Instead, practice administrators must follow specific database workflows, security permission adjustments, and security setup protocols to clean up user lists safely without corrupting historical clinical data or violating regulatory record retention laws.

Understanding Eaglesoft User Architecture

Eaglesoft stores user credentials and security rights within its underlying database structure, typically powered by Pervasive PSQL. Every user profile linked in the system has historical associations tied to patient records, treatment plans, appointment scheduling, and financial adjustments.

Because of these hard links, deleting a user outright from the database backend can cause orphaned records or break audit trails required by dental board regulations. Understanding how the application manages permissions helps you decide whether to deactivate, reassign, or purge accounts.

Security Levels vs. Individual User Profiles

Eaglesoft relies on tiered security groups rather than isolated permissions for every single employee. Before touching user lists, you'll want to inspect how your practice assigns security levels:

• Administrator Level: Grants full access to practice setup, user creation, fee schedules, and sensitive financial reports.
• Clinical Level: Restricts access to patient charts, clinical notes, and periodontal charting while blocking financial adjustments.
• Front Desk Level: Focuses on scheduling, patient registration, insurance verification, and basic ledger management.

When you're cleaning up accounts, you aren't just deleting names; you're modifying active login tokens that consume concurrent workstation licenses and pose potential security vulnerabilities if left active for departed staff.

Preparing for User Cleanup

Jumping straight into mass user modifications without preparation risks locking out active staff or losing track of who performed specific financial transactions. Follow this preparation checklist before altering user statuses.

Step 1: Run an Active User Audit

Go to File > Setup > Security > User inside Eaglesoft to generate a complete roster of every active and inactive login. Export or print this list so you have a baseline reference of who currently has access to the system.

Step 2: Verify Patient and Ledger Associations

Check if departing users have open appointments, unfinalized clinical notes, or pending insurance claims attached to their user ID. In Eaglesoft, financial transactions like cash drawer entries or daily deposits are permanently stamped with the logged-in user's credentials. Reassigning or closing these out prevents daily balancing discrepancies at end-of-day closeouts.

Step 3: Perform a Full Database Backup

Never make bulk changes to user lists or run utility scripts without a verified, recent backup of your Eaglesoft database. Use the built-in backup utility via the Patterson Dental Service Center or your local IT provider to secure a restore point before proceeding.

Step-by-Step User Deactivation and Cleanup

Because Eaglesoft protects historical data integrity, you cannot simply select fifty users and delete them in one click. Here is how to systematically clean up your user database.

Method 1: Manual Deactivation via Security Setup

For most practices handling routine turnover, manual deactivation is the safest and most compliant approach.

1. Log into Eaglesoft with full administrator rights.
2. Navigate to File on the main menu, select Setup, then click Security, and choose User.
3. Highlight the username of the staff member you want to remove.
4. Uncheck the Active status box or check the box labeled Inactive depending on your specific Eaglesoft version.
5. Change their password to a secure, randomized temporary string to prevent any accidental login attempts.
6. Click Save to update the profile.

Deactivating preserves historical reporting and patient chart audit trails while immediately revoking software access and freeing up your concurrent license count.

Method 2: Reassigning Security Roles in Bulk

If you are replacing an entire front desk or clinical shift, you can streamline permissions by moving multiple users into a deactivated security template rather than deleting them individually.

1. Navigate to File > Setup > Security > Security Level.
2. Create a custom restricted group named "Terminated Staff" with all permission checkboxes cleared.
3. Reassign departing user profiles to this restricted security level.
4. This instantly strips away viewing and editing privileges across all modules, serving as an effective interim step before complete archival.

Handling Advanced Database-Level Cleanups

When dealing with legacy databases containing hundreds of ghost accounts accumulated over decades, standard UI deactivation becomes tedious. Some advanced administrators look to backend database tools to purge old records.

However, direct SQL queries or third-party manipulation of the Pervasive database tables (such as the User table) without official software vendor guidance can violate your software support agreement and cause database corruption. If your database is severely bloated with obsolete user records, contact Patterson Dental Support to request an authorized database cleanup utility or professional script execution.

Common Pitfalls and Troubleshooting

Practices tackling user cleanups often run into specific software roadblocks. Knowing how to resolve them saves hours of troubleshooting.

• License Limit Errors: If deactivating users doesn't free up workstation licenses, verify that the users aren't still logged into active sessions on auxiliary workstations or background server services. Restarting the Eaglesoft server service usually clears stuck session tokens.
• Orphaned Appointments: If you receive error messages when trying to deactivate a user who was primary provider or hygienist on future appointments, open the appointment book, filter by that provider, and reassign those future slots to active staff members first.
• Audit Trail Failures: Never delete user ID rows directly from backend database tables if those IDs are referenced in historic transaction tables. Doing so will cause crash errors when running end-of-month financial reports.

Frequently Asked Questions

Can I delete a user who has historical patient chart notes attached to their ID?

No. Eaglesoft retains user associations on clinical and financial records to maintain legal accountability and audit trails. Instead of deleting the user, you must mark the account as inactive and restrict their login permissions.

Does deactivating an Eaglesoft user free up my software license?

Yes. Deactivating an active user profile revokes their authentication token, freeing up that specific concurrent user license for another active staff member to log into the practice network.

What should I do if an inactive user needs to be audited later?

Inactive user profiles remain in the database backend for reporting purposes. When you run historical production or collection reports, you can still filter or view data tied to inactive usernames, ensuring complete financial transparency.

Is it safe to use third-party SQL scripts to delete users in Eaglesoft?

No. Running unapproved SQL scripts directly against the Pervasive database can corrupt relational links between patient records and financial ledgers, instantly voiding your software support agreement with Patterson Dental. Always use the built-in interface setup tools.