printing out the scripts onto the standard script letterhead, and hand
signing each one. I didn't want to be mucking around with digital
signatures.
The pharmacy have access to the csv files, as they are the ones generating
them from their database of owing prescriptions. I was planning on only
giving them a web interface that will upload and verify the file contents as
they are logged on to do the upload. If the file doesn't conform it is
rejected.
_____
From: dave [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September 2004 3:59 PM
To: CF-Talk
Subject: RE: Looping
well there are a lot more then 1 type of degree ;)
if u must know i have an A.H.T, L.A.T & a teaching degree for veterinary
surgery & ecc.
there are lots of things u can do, maybe im getting lost on exactly what ur
trying to do.
if u wanna call me tomorrow, id be more than happy to see what i can do.
off hand, i wouldn't trust a pharmacy to have the access to the files.
maybe think about making this program and getting a pocket pc and have a
runner go up and have them enter a code into it at the pharmacy or
something.
i would also check with a lawyer about the legality of using a secured
digital signature instead of hand signing each one. That way the oncologist
could do it from home, the park, whatever. That would make it fairly easy to
do.
would be a kick ass prodject to do with flex in an RIA
---------- Original Message ----------------------------------
From: "Brant Winter" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 20 Sep 2004 15:54:09 +1000
>If you do indeed have 3 medical degrees ( not sure how one can have 3 but
>anyway ) you may be aware of the situation of the dispensation of drugs
from
>a pharmacy in an oncology environment.
>
>
>
>Cancer patient are treated based on chemotherapy regimes know as protocols.
>The protocols are a series of drug treatments and radio therapy treatments
>delivered over time, usually weeks / months. We are seeing up to 80
patients
>per day, and as a result do not physically have the time in the day to
>generate pharmacy scripts for patients over a period of say 6 weeks. So
>instead we fill out a treatment sheet for the patient, this treatment sheet
>outlines the exact treatment, and drug cycles the patient will have over
the
>time they are with us.
>
>
>
>So how all this works:
>
>
>
>Patients treatment sheet is sent to the pharmacy, pharmacist dispenses
drugs
>based on the doctors treatment sheet ( that we sign each time ). At the end
>of the week, the pharmacy sends down a paper copy of our "owing scripts".
We
>then take these 300 ( approx ) pages, and sit there until the early hours
of
>the morning writing the scripts one by one in a script writing package.
>
>
>
>I though, if the pharmacy could generate the owing list of drugs, why
>couldn't we have them as an electronic file. The best they could do was a
>csv file ( a limitation of the antiquated dispensing software most
>pharmacies use ), so I figure, if I can write something in ColdFusion to
>accept the upload of this file, secure within our network, the pharmacy
>could upload the file, our doctors could then log into the site, press a
>button the generate an electronic version of their owing scripts, and press
>print to generate a 300 page print job, and wala you have scripts without
>having to pen them manually.
>
>
>
>I am open to suggestions from anyone with multiple medical degrees on this
>one !
>
>
>
>
>
> _____
>
>From: dave [mailto:[EMAIL PROTECTED]
>Sent: Monday, 20 September 2004 3:28 PM
>To: CF-Talk
>Subject: Re: Looping
>
>
>
>without answering your ? i will tell u this
>i have 3 medical degrees and ur dipping into something quite serious here
>and i wouldnt be trusting my ass to a csv file!!
>i would start thinking but writing this to a db with every error catcher u
>can find. Cause if there is a prob, its u they come after and they dont
mess
>around
>
>---------- Original Message ----------------------------------
>From: "Brant Winter" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>Date: Mon, 20 Sep 2004 15:32:43 +1000
>
>>Now that I have gotten myself to the point I needed to be at this morning
>>when I started on this again, I can ask the question I needed to ask 6
>hours
>>ago !
>>
>>
>>
>>I have all of this data, each row has patient details, doctors details,
and
>>a drug type, qty, dosage etc. I need to generate "electronic"
prescriptions
>>from this data.
>>
>>
>>
>>The basic rules for writing a script are:
>>
>>
>>
>>3 Drugs per script only
>>
>>No drug can be prescribed twice in one day
>>
>>Dangerous Drugs, and Authority drugs are on separate scripts again
>>
>>
>>
>>My intention was to use the cfhttp tag to get the csv data and loop
>through
>>it, starting with the first entry I would make a structure, this would
>>resemble an actual piece of paper being a script. This structure would
have
>>elements being Doctors name, Prescriber Number, Patient Name etc etc, and
>>for each of the three drugs on this one piece of paper ( structure ) I
>would
>>have an array within the structure. Once I built up the structure, I could
>>then dump it into DB tables for retrieval later on.
>>
>>
>>
>>The hardest parts I am stumbling on are:
>>
>>Grabbing the patients and looping through the rest of the data. 200 lines
>of
>>data = "" drugs. Do I start the loop, and then try and match the patient
>>name to the other 200 rows, count how many occurrences there are on that
>>same day from the first row of data ??? If there are 1 - 3 drugs for this
>>patient I only need one structure, but if there are 4 - 6 drugs I now need
>2
>>structures.
>>
>>
>>
>>Araghaghagha just thinking about it doing my head in !
>>
>>
>>
>>----------------------------------------------------------------
>>The information transmitted is intended only for the person or entity to
>which it is addressed and may contain confidential and/or privileged
>material. Any review, retransmission, dissemination or other use of, or
>taking of any action in reliance upon, this information by persons or
>entities other than the intended recipient is prohibited. If you received
>this in error, please contact the sender and delete the material from any
>computer. It is the responsibility of the recipient to ensure that the
>onward transmission, opening or use of this message and any attachments
will
>not adversely affect its systems or data. Please carry out such virus and
>other checks, as you consider appropriate. To the fullest extent allowed by
>law, no responsibility is accepted by Haematology & Oncology Clinics of
>Australasia for any virus damage caused by this message.
>>
>>
>
> _____
>
>
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
