Mediadent SQL 

MediaDent SQL Practice Management® is built on the strongest tools offered from the Microsoft® Visual Studio Development Suite. Relying on a native Microsoft® SQL database engine gives the product unsurpassable speed for data access making it the fastest product on the market. MediaDent SQL Practice Management® is designed and developed with the multi-user, and multi-location operations in mind. It runs on Windows NT, 2000, and XP Microsoft® platforms. MediaDent SQL Practice Management® also utilizes Crystal® Reports to generate virtually any report or graph presentation. MediaDent SQL Practice Management® delivers the most scalable and cost effective solutions in the healthcare industry. Our latest Practice Navigator ^TM allows multi-location operations access to all data company-wide. All staff and administrative function can be fulfilled from the corporate office or any other individual practice. Secured sites eliminate privacy issues and allow patients access to their accounts, dental history, appointments, and doctors. Access to all data and records has never been this simple through this incredibly easy to learn Windows Explorer user interface. You won't believe how easy it is to use!

Practice Management

Click image for larger view Easy to use interface. Straightforward approach makes it easy to learn. all patient information is just a click away.

Appointment Book

Click image for larger view

• Easy to use interface.
• Straightforward approach makes it easy to learn.
• All patient information is just a click away.
• Hot and Hold list give the most flexibility in scheduling and re-scheduling.
• Easy to use Quick Fills reduce the steps in scheduling the most common multiple line item appointments, (like recall) for patient visits.
• Auto recall appointment scheduling: with one click find the first available recall appointment for patients based on recall frequency.
• Track broken and cancelled appointments to reduce future "no shows".
• Pre-blocking capabilities allow staff to maximize production.
• Ideal-Day scheduling setup.
• User defined color-coding for appointment statuses reduces instances of appointments not being confirmed.
• "Waiting for Doctor" status is great for clinical staff to alert the Doctor that the patient is ready to be seen.

The One-Click System That Lets You Practice By The Book

Go ahead: double, even triple your appointments. Its a snap for MediaDent SQL Practice Management®. The 'one click' appointment book keeps all patient information up-to-date for each appointment. The result? Doctors and staff continue to spend their time focused on the clinical and business activities important to your growing practice, not keeping up with increasing piles of paperwork, or worse yet, correction problems created when you can't keep up with all the details.

MediaDent SQL Practice Management®'s 'one-click' system makes it easy to track patient and dentist schedules. You can check for openings by doctor, hygienist, available time or units. MediaDent SQL Practice Management® speeds checkout, including the processes of procedure entry, insurance and payment processing, and generating walkout statements. At any time and with just a single click you can view the entire office's activity at a glance: current office status, patients in the office, daily or weekly appointment schedules.

MediaDent SQL Practice Management® means dramatic improvements in the efficiency of the most critical aspects of your practice. You can easily block practice time for specific procedures, plans, or special cases. MediaDent SQL Practice Management® gives you an instant look at any patient's status, including each patients history of broken or canceled appointments. It automates confirmation notifications as well as cancellations. The 'drag and drop' function makes it easy for dentists to work with several patients simultaneously, keeping track of multiple patients including color-coded status and medical alerts and operatories on the same screen. Because this is how you want to run your practice, everything flows directly from the appointment book.

Microsoft® SQL Server

• Faster Database Engine and Data Access.
• Scalable-Network can grow with you.
• More Stable Network Environment.
• Secure Data Center.
• Redundancy and Data Replication.
• Lower Total Cost of Ownership.
• Reduced Operational Costs.
• Superior Performance.
• Remote Network Administration.

Accounting According to Accepted Principles

Click image for larger view

MediaDent SQL Practice Management® is the result of four years of research and development by experts in accounting and financial management software. It is the only dental practice management product designed according to Generally Accepted Accounting Principles (GAAP), the accounting industry standard. That not only means a more capable and flexible system, but insightful financial reports that are accurate, timely and useful. This makes possible instant Aging and Accounts Receivable. It provides a detailed picture of your receivables for any period of client payment history you choose day, month, or year, even a period in the past. A feature that is unique to MediaDent SQL Practice Management®.

 
Click images for larger view

Comprehensive, Flexible System

• Instant Aging and Accounts Receivable provides a detailed picture of your receivables for any period of client payment history you choose day, month, or year, even a period in the past. Another feature unique to MediaDent SQL Practice Management®.
• Estimated Production lets you set goals for each member of the practice and your staff.
• Daily Cash Flow compares productivity to production estimates.
• Reports make it easy for management to track production; collection and procedures completed all the details critical for operating a financially sound practice.

 
Click images for larger view

Resolves the Insurance Dilemma

• MediaDent SQL Practice Management® tracks insurance plan benefits, including managed care capitation plans, with unparalleled accuracy. You bill insurer and patient correctly every time, eliminating the biggest problem with receivables and collections, inaccurate billing and negative patient feedback.
• Filing claims electronically means filing immediately. Cut processing time by two to three weeks. Your office can file claims with insurance companies in well-organized batches to speed processing and payment turnaround from the carriers.
• Automated links allow you to query insurance companies for patient coverage information.
• MediaDent SQL Practice Management® automatically and continuously tracks the status of all your claims.

Efficiencies of the Paperless Office

• Your staff works from the MediaDent SQL Practice Management® screens, eliminating the need to print out reports. Collections and Aging, Outstanding Claims, Patient Recall -- your staff has all the information one click away on a single screen to perform each important task.
• Plus, MediaDent SQL Practice Management® introduced the dental industry's first interface with the Internet in 1998. Confirm appointments, issue recalls and send statements via e-mail. All offer significant savings for the office and added convenience for many of your patients.

 
Click image for larger view

Simplifies Fee Scheduling and Plan Development

• How often do you face the daunting prospect of restructuring your fees? MediaDent SQL Practice Management® gives you the tools to analyze your billing practices at a glance, and make targeted adjustments. Starting from scratch to create a fee schedule is a thing of the past.
• Your practice can deal with any number of insurance plans and types of coverage hassle-free. The system automates the organization of all coverage and benefit information for each carrier and every patient, including managed care patients.

Simplifies Payment to Providers by Collection

• MediaDent SQL Practice Management® gives you the ability to track lab costs by provider and prints this cost out on the Collections by Provider report.
• MediaDent SQL Practice Management® gives you the ability to add 'Memo Credits' to your fee schedules. This is extremely useful for large managed care practices where reduced fees cause collections by provider to be misstated.
• MediaDent SQL Practice Management® can import enrollment files for PPO and Capitation plans and verify the enrollment so you know you are receiving the proper monthly stipends.

Comprehensive Lab Case Tracking

• MediaDent SQL Practice Management® tracks all lab cases by lab, by patient and by appointment. With the Work Lab Cases screen you can receive lab work and enter the actual cost, call patients that do not have an appointment, call labs for patients that have appointments but you have not received the lab work.

The World's Most Advanced Dental Charting System

Click image for larger view

MediaDent SQL Practice Management®'s Charting is our most advanced charting software ever. It is a highly capable, 32-bit system with unmatched tooth placement display. MediaDent SQL Practice Management®'s Charting provides on-screen restorative and periodontal charts with all materials, tools and pathologies. It allows you to place the tooth in its exact location.

• Charts demonstrate actual placement and results of exams. Rotate the teeth for colorful, graphic, easy-to-understand demonstrations to patients. Exact charting significantly enhances the patient medical record over traditional charting methods.
• MediaDent SQL Practice Management®'s Charting displays and tracks any procedure. Choose your tool, your pathology and any material, and demonstrate the treatment. Its all on display in the chart.

Click image for larger view

• MediaDent SQL Practice Management®'s Charting records your every activity effortlessly. Use your mouse to chart progress. It is so advanced it responds to your voice commands, demonstrating the procedure as you perform it. While you are entering your examination, MediaDent SQL Practice Management®'s Charting creates a suggested treatment plan based on the way you practice. As soon as you are finished examining the patient, is instantly available to present to the patient, complete with costs, insurance and patient estimates , and insurance claim codes; another feature unique to MediaDent SQL Practice Management®.
• MediaDent SQL Practice Management®'s Charting is fully integrated. Every exam, procedure and treatment plan in incorporated into the patient record and is accessible at a single click. As a result, it dramatically increases patient acceptance of treatment plans.

Complete, Integrated Practice Management

• MediaDent SQL Practice Management® allows instant access to comprehensive patient records, including registration and demographics, insurance coverage and appointment details. The system provides account balances and aging details, including the breakdown between what is owed by the patient and the insurance carrier, and keeps a record of all reminders and notes. It even allows you to access the patients complete medical record online.
• Is your practice driven by its clinical activities? MediaDent SQL Practice Management® allows the front desk and operatories to work together at unprecedented levels of efficiency. Graphical and convenient charting streamlines record keeping in the operatory and makes it easy for the office staff to track the working, examination, and planning status of every patient. The system generates a comprehensive treatment proposal that combines the graphical tooth placement along with treatment plan displays to increase not only office efficiency, but also patient compliance, understanding and acceptance.
• MediaDent SQL Practice Management® not only accommodates the appointment book-based practice, but also streamlines it by eliminating hand-written appointments and delivering one-click access to comprehensive appointment information. MediaDent SQL Practice Management® helps you block practice time; it automates confirmation notifications and keeps you up-to-date on canceled appointments. It gives you a multitude of ways to look at your appointment schedules.

The Speed of a Server Based SQL Server from Anywhere

MediaDent SQL Practice Management® moves from a file-based database application to a server-based application. This moves the resource intensive functions from the workstation to the server. Large beta testers have seen improvements in functions like Aging. What used to take an hour to produce a report now only takes two minutes. These type of gains are a direct result to using to Microsoft® SQL Server.

• Faster Database Engine and Data Access.
• Scalable-Network can grow with you.
• More Stable Network Environment.
• Secure Data Center.
• Redundancy and Data Replication.
• Lower Total Cost of Ownership.
• Reduced Operational Costs.
• Superior Performance.
• Remote Network Administration.

MediaDent SQL Practice Management® has all of the outstanding functionality found in most competitive products, but also offers the added performance of client/server technology as well as the added power and functionality of a SQL Server. Why does client/server design offer additional performance? Let us take a moment to look at this concept.

In a traditional program, the application is loaded on the client and the data is loaded onto the server. The data is put on the server so that everyone uses and updates the same set of data. When a client puts in a request for the data, the request travels through the network from the client to the server. Once it reaches the server, large quantities of data are sent back across the network to the client from where the query is run. This process can take a significant amount of time when the database size is large. There are many opportunities for data request collisions if more than one client is requesting the same data. When a collision occurs, the database application must lock one of the users out to avoid database corruption. Locking increases the amount of time it takes a user to complete a requested operation.

In a client/server program, most of the work is done on the server. When a client puts in a request for data, the request is sent to the server. The server takes the request and performs the processing using the data on the server. Once it is completed, the server sends only the requested information back to the client. Since much less data is traveling across network lines, there is less chance for a collision with other potential requests. This decreases network traffic significantly and speeds things up for the user.

Performance Enhancing Stored Procedures

• Data processing is fast; thanks to the use of stored procedures. In database management systems (DBMSs), a stored procedure is a group of operational code statements, named and executed as a unit. Stored procedures are maintained on the server. This means that when the client invokes the stored procedure, only the name of the stored procedure is sent across network lines. All the code is executed on the server.
• Stored procedures are also maintained in a precompiled state. The server doesnt have to spend time compiling the code when the request is made. The request executes immediately. Both of these stored procedure features contribute to an even faster processing capability.

Rock-Solid Reliability

• One of the most important criteria in a database management system is reliability particularly when your entire enterprise depends on it. Thats why SQL Server uses transaction logging. Transaction logging means that the transaction is logged before a database modification is attempted. If something happens during the operation, like a power outage, the database uses the log to revert back to its last consistent state of operation.
• Without transaction logging, an event like a power outage could cause corruption and necessitate database restoration from the last backup. Information entered after the backup was made would have to be re-keyed. Transaction logging is one reason SQL Server application should be used when it is absolutely critical that the database not be brought down.

Integrated Security

• In order to access MediaDent SQL Practice Management® data, the user must pass through three levels of security. The first level is authentication. Through Windows 2000/2003 the user enters a login to initially gain access to the system.
• The second level of security is database permission validation and is handled through SQL Server when the user fires up MediaDent SQL Practice Management®. In this stage, MediaDent SQL Practice Management® transparently enters a second login. SQL Server uses this login to determine which databases and tables the user has rights to access and utilize.
• The third level of security is application permission validation and is handled by MediaDent SQL Practice Management®. This third login is used to determine which practices (in a multi practice installation) and which menu items the user has permission to access. If the user does not have a required permission, that practice or menu item will not appear in the users interface.

Enterprise-Wide Scalability

• Database Size -- MediaDent SQL Practice Management® has the capacity to grow to a terabyte size (1,000,000 megabyte) database. Manually adjusting the size of the database as it grows is not necessary due to SQL Servers dynamic self-management.
• Concurrency -- MediaDent SQL Practice Management® does not have a ceiling on the number of users that it can handle and is limited only by the hardware and SQL Server. Microsoft states that SQL Server can handle over 4000 concurrent users generating up to 18 million database queries per day.

Open Database

MediaDent SQL Practice Management® data is stored on the server in a SQL Server database. During normal use, data is accessed via the MediaDent SQL Practice Management® client software. However, if you have the necessary security clearance, you can access the data directly using other tools such as Access, Excel or Word from the client machine.

This means that you can search the database for new relationships, compose new reports or export the data to another application like Excel right from your desktop. Microsoft products are designed to integrate seamlessly, so accessing the data with Microsoft Office is easy. You can also access the data with other products by using ODBC (Open Database Connectivity). ODBC is a standard created by the SQL Access Group that allows different databases to talk to each other through a common protocol. So whether you are using a Microsoft tool or not, you have multiple means to access the data stored on the server.

The benefits of MS SQL Server 2005 do not stop there. MS SQL Server 2005 is web aware. Meaning it can be accessed by virtually any method today. Our software can connect to a MS SQL database through the Internet with no complicated setup issues. This allows several offices to connect, view, and edit data, including a corporate office, in real time, without long distance phone bills or midnight updates where youre always a day behind. Through all this and the other offices data appears right next to your own thanks to the Practice Navigator. Along with easy, simple connectivity comes security. Microsoft SQL Server 2005 introduces significant new security enhancements, not only offering the highest level of security available in the industry, but also making it much easier to achieve that higher level of confidence and safety to the integrity of your data. To start with, SQL Server 2005 installs with a much higher level of default security, taking advantage of the integrated security of Windows® 2000/2003 or Windows SBS 4.5 right out of the box. This makes server lock down in production environments easier and faster.

For more information about the benefits and robust features of Microsoft® SQL Server, visit Microsofts SQL website at http://www.microsoft.com/sql/

Software Integration

Desktop
MediaDent SQL Practice Management® integrates seamlessly with all Microsoft Office components. You can export a MediaDent SQL Practice Management® report into an Excel worksheet for analysis with just a click of a button. You can move the report into Word for elaboration or modification. Use Mail to send the report where its needed.

Dental Specific
MediaDent SQL Practice Management® integrates seamlessly with all industry leading Digital X-ray and Imaging software packages such as: MediaDent, Schick CDR, Vipersoft, DICOM Imaging Suite, Trophy, Dexus and the list goes on and on.

Ease of Use

Intuitive Functionality
It is estimated that Microsoft Windows is the operating system on over 90% of the desktops in business today. That makes Windows the most common user interface in the world. MediaDent SQL Practice Management® looks and feels familiar to users because it was developed using 100% Microsoft tools which translates into a reduced learning curve.

Practice Navigator
The Practice Navigator brings several functions into one screen. In addition to all system files, detailed information about a patient is a very easy search. Everything from Accounts and Appointments to Ticklers and Treatment Plans, even Family Members and charting, are easy to get to and edit. The System Files menu from previous versions is not a menu any longer. All of its items are included in the Practice Navigator under System Files.  The Practice Navigator works like many other Windows applications, such as Windows Explorer. There is tree style navigation on the left of the screen, while information pertaining to the selected item is displayed in the right side of the screen.

Pick Lists
Simply choose an entry with the keyboard or the mouse to have it automatically entered in the field. Other search fields are also available. For example, you can quickly find a patient by entering ID, name, or Social Security Number.

Drill Down Capability
Drill downs make it easier to get to information from where you are. Some forms have field name labels that are italicized. You can click on these with your mouse to bring up the property screen for whatever item it is that your mouse is directly over with one simple click.

Custom Reports Using Crystal Reports
Crystal Reports is an excellent reporting tool that is extremely popular. It integrates seamlessly with MediaDent SQL Practice Management®. As with the Access reporting tool mentioned earlier, you can save reports designed with Crystal Reports and enter them as a MediaDent SQL Practice Management® menu item(s).

Custom Reports Using Online Analytical Processing (OLAP)
MediaDent SQL Practice Management® users have yet another reporting option available: Online Analytical Processing or OLAP. SQL Server supports OLAP. It allows you to report on any or all of the data collected with MediaDent SQL Practice Management®. Through Online Analytical Processing, you can literally comb through the data to find associations, sequences or patterns that may otherwise go undiscovered.

E-Business Solutions

Internet Integration without Coding
MediaDent SQL Practice Management® recognizes e-mail and web addresses as a data type. This means that MediaDent SQL Practice Management® can store customer and vendor e-mail and Web addresses. If you have Internet Explorer, when you click on a Web address, the Web page will appear. In addition, if you have Microsoft Exchange, Outlook, or any other MAPI-compliant e-mail system, a new addressed e-mail message is created when you click on an e-mail address.

All reports can be output as an HTML file so you can easily publish the report to an intranet or the Internet.

Internet Integration with Coding
MediaDent SQL Practice Management® uses SQL Server to store the underlying databases. These databases can be easily integrated with the Web with Microsofts Active Server Pages. MediaDent Practice Management has written a foundation using Active Server Pages that can be easily customized to your exact specifications. These foundation measures can provide unparalleled Internet Integration.

Patients can review account history, edit personal demographic, medical history, insurance coverage, employment, make payments, reprint statements, confirm appointments, search for and request appointments, to name just a few.

MediaDent SQL Practice Management® can make the necessary additions/changes for you or you can use your own ASP/Web Developer.

Single-Source E-Business Solutions
MediaDent Practice Management recognizes that electronic commerce has come of age. According to independent forecasts, electronic commerce will top more than $300 billion by the year 2002. That is up from $8 billion in 1997. Unquestionably, access to the database that stores patient and account information is absolutely essential to e-business. We are committed to providing you with the best e-commerce solutions available that comply with the HIPAA standards.

As a result, we are re-introducing our e-commerce products that were originally introduced in 1998 (Years ahead of the competition). They use emerging standard tools. The MediaDent SQL Practice Management® e-business solutions are based on the BizTalk framework. BizTalk is an industry initiative started by Microsoft that is supported by a wide range of organizations. BizTalk is a community of standards users who share the goal of driving the rapid, consistent adoption of XML (Extensible Markup Language) to enable electronic commerce and application integration.

MediaDent SQL Practice Management® is conforming to the BizTalk Framework when publishing schemas in XML and using XML messages. This allows companies to easily integrate MediaDent SQL Practice Management® with other software programs and to adapt it for electronic commerce using XML.

Multiple Locations

Multiple Practices
The Practice Navigator in MediaDent SQL Practice Management® lists all the practices in the tree view. Switching and searching between practices is a snap. In addition the Appointment Book and all Working Screens (i.e.: Work Collections, Work Outstanding Claims, Work Recall, etc.) all have a location selection feature that allows users at any site to be working in multiple practices simultaneously.

MediaDent SQL Practice Management® provides a tremendous advantage if you require a wide area network (WAN) due to remote locations. Because of the very low bandwidth required per client to access the SQL Server, excellent performance can be achieved with an Internet connection.

When using an Internet connection, security is maintained through what is called a virtual private network (VPN). In a VPN, data is sent in packets from one server to another via the Internet. These packets are encrypted and can only be decoded by the intended receiving server. This prevents the possibility of your data being viewed by unwelcome eyes. This means that users in New York and San Francisco can both be working simultaneously in MediaDent SQL Practice Management® for the cost of an Internet connection.

MediaDent SQL Practice Management® can be configured to run in numerous wide area network configurations, consult with your MediaDent Practice Management Sales Representative or your Value Added Reseller for the solution and technology that is right for you and your organization.