DDH Software, LLC Making a big world smaller

Patient Database

Author:Daniel Levy MD [Send Author Email]

December 04, 2009
July 26, 2010
Description:A Patient Database for HandBase that can be used as a mobile point of care database. It can also be used for group sign-out and daily billing. See detailed explaination in my older Applet named: PATIENT MOBILE ROUNDS
Has Data:No
Has Forms:No
Filters:Built in to the checkbox/views system. Views: By Ward - sorts your active patients by ward. Alphabetical Acitve - Sorts your Active Patients Alphabetically by name. Seen Patients - Use this to export the patients that you have seen that day for billing. Don't forget to uncheck everything befor the start of a new day. New Patient - This is used to isolate the new patients which can be copied to a separte database and emailed to your partners in a group practice. Encrypt to maintain HIPAA compliance. Sign Off - Isolates the patients you signed off on, can be exported and sent to your partners to maintain their lists. Inactive - At the end of the day, move the patients you signed off on the the Inactive list. When the patients are readmitted, change them to active. Call for follow-up - If you type the words "Call for follow-up" which are also as a pull-down in the History Fields, this view isolates those records, if the patient needs follow-up phone calls. You can export to text and send it to your staff.
Sorting:Built in to the checkbox/views system. See Above.
Comments:I developed this applet and my Cardiology group and we have been using it successfully for many years. Send me an email if you are interested to learn how my group uses this system. Most of the fields have useful pull down menus. The checkboxes are used in conjunction with the views for group sign-out and billing functions. I would love to hear your feedback!!! DLevyMD@optonline.net
Version:HanDBase v.4.x Enhanced or greater
File:rocket_rounds.pdb          Downloads: This Month 47 / Total* 2123
Note:MAC Users will need to enter the filename rocket_rounds.pdb when saving this file.
* since October 1, 2000.

Other Titles from Daniel Levy MD

06/03/2008 Patient Mobile Rounds [Medical]
My Cardiology Group has been using the Patient Mobile Rounds Applet successfully for the past 4 years and it has revolutionized and transformed our practice! The power of it comes from the way we utilize a three check box system in conjunction with "Views" to isolate patients into categories. By using an "empty shell" identical database for group emailing, we keep "wirelessly synchronized". It also generates our daily bills. We have carefully chosen which fields export in each view. For example, we generate a daily bill by exporting relevant fields from the "Seen Patients" view. By exploiting the fact that smaller HanDbase databases can be sent as email attachments, we keep all of our databases perfectly synchronized on our devices wirelessly, via a group email system. Our Cardiology group has been using following HanDbase system for the past 3 years. Our database contains about 8,000 patients! Because it provides "point of care" information, it has streamlined patient care for us. By sharing critical patient information digitally, we all have up to date patient information right on our cell phones!!! The system is simple to use and teach to others. I have taught it to physicians with no prior mobile computing or database experience. To keep it as simple as possible we have decided not to use forms, to avoid an extra layer of complexity. For Physicians using this system, data entry is almost self explanatory. HIPPA compliance can be maintained with the built in encryption feature. ACTIVE VS. INACTIVE PATIENTS: An “Active Patient” is a patient that you (or your group) are actively following. An “Inactive Patient” is one that you (or your group) is not longer following, however, you want to retain the information for when you need to follow the patient again. When you open a new record, the first field is a pop up field to delineate "Active Vs Inactive" patients (Active: Yes or No). SEEN CHECK BOX: After you seen a patient and deliver care, check the “SEEN” check box. Scroll down to the “Level of Visit” which has a pull down menu of frequently used CPT Codes (which you can edit if needed). Add information to the “History field” (there are 2 of them, each has a 2000 character capacity). If you are in a group practice, new information you added to the history field of an established patient can be copied and pasted to an email, to update your colleagues, so that they can copy/paste the new information to that patients History field in their database. NEW PATIENTS: Tap the “New Record” Icon to open a new record. Enter the patient’s name, MR# (Medical Record Number), SSN (Social Security Number) if needed, and DOB (Date of Birth) which is a Calendar, which then gives the patient’s age automatically. In the History fields, I recommend adding dates to major events for future reference. There is an extensive pull down menu for the first history field of common medical terms which could, of course, be edited to suit the users needs. Check the Seen box and the New box. Fill in the “Referring MD” and add your frequent refers to the pull down menu. The “Diagnosis” field has a pull down menu to add frequently used Diagnosis with ICD-9 codes. The “level of visit” pull down menu can be edited to suit you practice needs. The “AUTOMATICALLY ENTERED DATES” are set to when the field was first added and when the field was last modified. The “Seen 1st by” is helpful in a group practice. SIGN OFF BOX: If you a signing off or discharging a patient, check the “Sign Off” Box. Do not change the “Active” Field until after you do your billing (see below). You can create a list of the “Sign Offs” by going to the “Sign Off” view. Tap “Actions -> Export records to text. Choose a file name (such as “Today’s Outs”) and select a folder. You now have a text document of your “sign off” list which you can email to colleagues. DAILY BILL: The daily bill is generated by changing view to the “Seen Patients” view. This view only shows you the patients with the “SEEN” check box checked. Tap “Actions -> Export records to text. Choose a file name (such as “Dr. Smith’s daily bill) and select a folder. You now have a text document of your daily bill which you can email to your billing system. SENDING NEW PATENTS TO A COLLEAGUE: If you are in a group practice, you can email the new patients in database form to your colleagues so that they can "absorb" these new patients into their patient list. Go to the ”Today's New Patients” View. Tap “Action -> Copy records to…” then tap the “For Emailing” Database. Make sure the For Emailing Database was initially empty (Action ->Delete Records). The For Emailing Database can now be emailed to your colleagues as an email attachment. Encryption can be used for HIPPA compliance. When the email is received, the records from the emailed database are then moved to the main database on the receiver's device (Action ->Move records to...). This system can replace telephone signouts. MOVING ACTIVE PATIENTS TO INACTIVE: After you created your daily bill, change to “Today’s Outs” view. Open the individual records and tap the Active field (the 1st field) to change the "Yes" to "No". FINDING INACTIVE PATIENTS AND MOVING THEM TO ACTIVE: Change to the “INACTIVE” view. Tap Action ->Find. You can choose to search by patient's Name, MR #, SSN. Open the record and tap the Active field (the 1st field) to change the "No" to "Yes". Note that all the RED buttons of the Form contain useful pull-down menus.