Now the real challenge will be to get the hospital to buy the additional 5 or so licenses..
Tell your hospital adminstrators that you can also use FileMaker to input all the patient data, all their symptom data, all the meds they are on, all the diagnoses that they have, every med distributed to any patient, all the known side-effects and interaction-effects of each med, all the doctors and who their patients are, all the nursing staff and their assignments, all the room numbers and beds, and:
• Effortlessly run a report for any given patient listing symptoms, diagnosis, degree to which their symptom list matches that of other patients with the same diagnosis, meds they are on (with red flags for any med interfering or accentuating the effect of any other med they are on), (also red flags for any symptom that matches the list of side effects of meds they are on), when was their intake, how long they've been in treatment, who is their doctor, who is their nurse, who in the past has been their doctor, who in the past has been their nurse, have they ever been in the hospital for other reasons, what other diagnoses do they have, what other doctors do they have, and so on;
• Effortlessly run a report for any given medication listing manufacturer, schedule, price to hospital, FDA status and date, every recipient, their diagnosis, the doctor, the start date, the dosage, their symptoms (with red flags for symptoms that match known side-effects of the med, and other flags for symptoms that match known interaction-effects with other meds that the same patient is taking), how long they've been taking it, patient outcome, and so on;
• For any doctor, their patient list, the rooms and beds they are in, their symptoms, the meds they are on now, the meds they have been on in the past, their symptoms, current status, etc; Oh and what the heck: for any doctor, their alma mater, current salary, status or rank in the hospital, all the patients they've ever had, sorted if you so desire by diagnostic category or outcome or etc;
• For any given month, the new diagnoses, broken down by major categories, sorted by doctor, intake date, prior med history summary, current status, meds they are on, prognosis. Optionally sorted by sex, age, extent to which they are marked overweight, whether they smoke.
• In comparing a trial run of Lot #78 with Control Placebo glucose IV, display a list view of recipients broken down by date of diagnosis and within that, age, and within that, sex, and within that, outcome at 3 weeks and, within that, outcome at 12 weeks. Click button to show detailed info on any given recipient. Also run alternative report sorted by sex and within each sex by date of diagnosis and within that, age, etc etc. And other variantions.
• For any given month, all the expenses incurred by the hospital, broken down by category; subreport on materials usage by broad category (patient provision vs institutional use) and within that, blah blah blah; payroll: by job title, status where applicable, 401K, withholding allowances, base salary, check amt, etc;
• For any given week, after inputting desired personnel, the dates and times at which they have indicated they are free to attend a meeting, sorted by maximum overlap of availability weighted by people most necessary for intended scheduled meeting.
(Dear God I would oh so love to do a hospital database. ::_drool_:: )
WARNING: FileMaker is addictive. I used to be a social worker.
