DEVBUZZ Homepage Handheld Computers Help Physicians Eliminate Billing Delays
 
Web www.devbuzz.com
  HOME PAGE
  All Articles
  Advertise
  Consulting

 Development
  Discuss - Forums
  Still in the box?
  .Compact Framework
  Code Snippets
  SQL Server CE
  Database
  MS Resources
 Stores
  Developer Controls
  Pocket PC Hardware
  Pocket PC Software
  Pocket PC Books
  .NET CF Books
  Book Reviews
  SPB SW Discounts
  RESCO SW Discounts
 DEVBUZZ Info
  About Us
  Help
  Join our email list
  Links & Ratings
  Press & Comments
  Pocket PC version
  Software Reviews
  Hardware Reviews
 Authors
  Authors
  Article Guide
  Competitions
 Resources
  Developers
  Register
  Login

  SPB Discounts!
 Columnists
  Rick Winscot
 Past Blast
  Personal Media Ctr
  Gizmobility
  eVB Legacy
  Old news
  Hosted Software
  Wireless
  Newsletters
  Carl Davis
  Upton Au

 Pocket PC Registry
  Join the registry
  View current list
 Current Poll
Are you converting to .NET Compact Framework?
Yes, it has changed my life!
No, I'm sticking with eVB
.NET CF what's that`?

Current results
3431 votes so far
 Recent Forum Threads [goto forums]

Get Computername
read... (67 hits)


Great aid to development productivity
read... (82 hits)


ThreadingTimer sample code
read... (143 hits)


Multithreading with .NET CF
read... (194 hits)


Moving from eMbedded Visual Basic to Visual Basic .NET
read... (166 hits)


.NET Compact Framework 2.0 Service Pack 2
read... (226 hits)


Transfer Data from SQL Server 2000 to SQL Server Compact Edition
read... (298 hits)


This protocol version is not supported
read... (236 hits)


Converting Lowercase to uppercase wont work
read... (203 hits)


Direct access to MS SQL Server 2000
read... (374 hits)


Creating SDF file in Desktop
read... (513 hits)


Winsock in CF.NET
read... (316 hits)


Using Pocket Outlook to submit HTML page form with MAILTO action
read... (420 hits)


Missing file "System.Data.PocketPC.asmmeta.dll"
read... (268 hits)


HP iPAQ hw6915 Serial Port Issue
read... (309 hits)


Info on the recent forum changes
read... (341 hits)


SqlServer tools from Redgate
read... (383 hits)


Arrow keys and Hardware navigation button
read... (393 hits)


O2 XDA lls pin sync cable to comport
read... (322 hits)


Creating dynamic folders on Pocket PC OS
read... (299 hits)

Custom Windows Mobile software development.
LBS Challenge 2007
LBS Challenge Eight previous NAVTEQ Global LBS Challenge® participants have received venture capital funding and nine past LBS Challenge winners have launched commercial applications on major wireless carriers. Register your non-commercial LBS application in the 2007 NAVTEQ Global LBS Challenge in one of three regions: Americas, Europe-Middle East-Africa (EMEA) or Asia-Pacific(APAC). You could win a share of $2 million in prizes. This could be your year.
Dream. Develop. Win.

Pocket PC Software | Software Reviews

Handheld Computers Help Physicians Eliminate Billing Delays
Written by Frank Yacano  [author's bio]  [read 24438 times]
Edited by Derek

Discuss this article   Windows CE 3.0   

Page 1  Page 2 

Automating Routine Tasks

Sher also created several macros in Access that automate housekeeping tasks both on his desktop database as well as on the handheld. One of these macros is used to update the tables that provide content for the drop down lists on the form. The desktop database contains tables of surgeon names, medical facilities, procedures, diagnoses, and other parameters. During synchronization, as new case records are downloaded from the handheld, the macro automatically updates the desktop database tables with the new data. The tables are then uploaded back to the handheld to update the list tables.

The macro procedure also scans through all records to eliminate duplicate entries. For example, if he worked with a new surgeon several times in one day, the macro picks the doctor's name once from the handheld records and adds it to the Physician table in the desktop database

A second macro periodically cleans out old case records from the desktop database and dumps them to an archives file. Matching records are also deleted from the handheld. The tables of physicians, facilities, procedures, and other parameters remain intact even though the records have been removed.

Sher also solved the problem of how to keep track of records that have not been billed, while avoiding duplicate billings. He created a field in his desktop database called "Billing Flag," which defaults to zero when a new case record is entered from the handheld billing application during synchronization. A third macro prints new billing forms from database records that have zeros in the Billing Flag. The macro then changes the flag to a 1 to mark the record as billed. On the next synchronization, these newly billed records are backwritten to the handheld so they are not billed again.

The solution is also much more flexible than working with paper forms. Drop down lists can be modified in seconds by simply updating the database table. In addition, the drag and drop functionality of the handheld application allows the easy creation of new fields to meet the needs of the billing company as well as the physician.

Maximizing Billing Efficiency

Sher recently presented the handheld application to his group of over 100 anesthesiologists. He reports that enthusiasm was very high, and his Pocket PC application is now being evaluated as a solution for the entire group.

The ultimate goal is to migrate the practice to a real time wireless billing solution using handheld devices. Another SYWARE product called mEnable allows real time interactive access to server databases from a handheld PC. Physicians will be able to tap in billing data from the operating room or any other convenient location, and the records will go directly to the billing company for immediate processing. As Sher points out, "Every day you save on billing is real money."

Related links: SYWARE's Visual CE.

Previous Page

Back to Software Reviews | [Article Index]

 

Back to the top of the page.
Chris De Herrera's Windows CE Website Windows CE News & Information Source
Copyright ©2000-2007 by DEVBUZZ.COM, Inc., NJ. USA.MSDEVELOP