||CUSTOM SOLUTIONS OVERVIEW
Medical A group of doctors
wanted to track patients, surgery types, pre-op, post-op, and follow
up visits. The patient
data was located in a remote main surgery database. We developed
a solution to import data from the main surgery database enabling
the staff to manipulate data
and then export back to main surgery database. Letters are generated
based on search criteria of patient name, surgery date, and years
since last follow up.
Training A certification training organization
wanted to track students, registrations, certification classes,
and students approaching certification expiration. The organization also sends reminder
notices of training expiration as well as upcoming training events. The
database solution also serves as contact management.
Inspections / Surveys Water
utilities and facility managers needed to track water uses within
a building, or groups of buildings, for plumbing code compliance and water
conservation measures. The database solution also tracks service connections
to the main water distribution system. Reports are generated by building,
groups of buildings, water use, compliance, and date of inspection.
This solution meets regulatory requirements.
Backflow Prevention Assembly
Testing Water utilities, facilities, and
private sector contractors needed to track backflow prevention
assemblies installed within a building, or groups of buildings.
The database solution tracks initial and annual test dates as well as repairs,
replacements, past due testing. Also tracks assemblies installed
at the main water distribution system. Generate reports by serial
number, type of assembly, size, manufacturer, applicability with
codes and regulations, and by test date. Also generates certified
test reports. This solution meets regulatory requirements.
Invoicing / Inventory
/ Training A retail
organization needed to track customer training, registrations,
and related product sales.
They also set up remote classes to include tuition, housing, and
miscellaneous expenses. As invoice line items are changed or deleted,
products are added back or deducted from inventory. Reports are
generated indicating inventory levels above or below reorder levels.
The organization also presents services and products at shows
around the country. Sales from the shows are also tracked.
High Frequency Water Meters A water utility
was planning to change from manual reading of water meters to
automatic meter reading via radio frequency. They were concerned with accuracy of data
such as customer account information, old meter numbers and
readings relative to new meter information. We developed a
database solution that
imports and exports new water meter data from a Pocket PC hand
held barcode scanner to an Excel file. The solution acts as
a link between the Excel file and the scanner.