Well, I'm back from South America, no-one missed me I'm sure as I've not been
contributing to the list.
However I would like a summary from someone as to what is happening.
Ian et Al,
I briefly noted (prehaps not accurately as I've only scanned some posts,
debate on prescribing again.
As this list should know I have a complete and brilliantly fast and automated
script writer which has been in constant use since 1995. Im not sure why the
list wants to continually re-invent the wheel.
If interested I enclose some script table definitions. Note that the way drug
data is saved means that individual drug names/generic data/formatulations
etc ARE NOT SAVED ON A PER-PATIENT PRESCRIPTION BASIS, but simply to a table
in the database which starts with nothing in it and expands as the doctor
prescribes (Script_Rx_Details). As we use a limited number of drugs it should
never get very big. This table itself could be normalised further but in
practical terms I never found the need to do that.
Also I noted comments on MIMS stuff. Remember I did negotiate an exclusive
contract with MIMS for us around data - ie free provision of data for use in
gnuMed for demonstration purposes on an ongoing basis, the provision being
for 6 month old data.
I gave up on finalising this because of seeming lack of interest at the time,
but would be willing to try and complete if there is any interest.
It may also interest the list to know that I'm sitting on a software
evaulation committee at the moment, evaluating AU medical software for
recommendation for use by Newcastle GP's. We now have an operational closed
broadband network, the software will be usedeventuallyt probably by all GP's,
our hospital based after hours clinics, nursing homes etc, and will be
accessable from anywhere including home etc. Sad to see gnuMed is not
included. I guess when the project is completed that will remove some 400+
GP's from the loop of ever being likely to use gnuMed.
Sadly I feel the software programs being looked at are pretty dumb, shit
really, however that is what is out there, and doctors know no better.
Regards
Richard
{\rtf1\ansi\ansicpg1252\uc1 \deff0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}
{\f11\fswiss\fcharset0\fprq2{\*\panose 00000000000000000000}MS Sans Serif;}{\f47\froman\fcharset238\fprq2 Times New Roman CE;}{\f48\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f50\froman\fcharset161\fprq2 Times New Roman Greek;}
{\f51\froman\fcharset162\fprq2 Times New Roman Tur;}{\f52\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f53\fswiss\fcharset238\fprq2 Arial CE;}{\f54\fswiss\fcharset204\fprq2 Arial Cyr;}{\f56\fswiss\fcharset161\fprq2 Arial Greek;}
{\f57\fswiss\fcharset162\fprq2 Arial Tur;}{\f58\fswiss\fcharset186\fprq2 Arial Baltic;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;
\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{\widctlpar\adjustright
\fs20\cgrid \snext0 Normal;}{\s1\keepn\nowidctlpar\tx735\tx5055\tqr\tx8439\outlinelevel0\adjustright \f1\cf1 \sbasedon0 \snext0 heading 1;}{\*\cs10 \additive Default Paragraph Font;}{\s15\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright \b\i\f1\fs28\cf1
\sbasedon0 \snext15 Body Text;}}{\info{\author Dr R Terry}{\operator Dr R Terry}{\creatim\yr2005\mo11\dy28\hr8\min14}{\revtim\yr2005\mo11\dy28\hr8\min41}{\version5}{\edmins26}{\nofpages5}{\nofwords461}{\nofchars2633}{\*\company R Houtzaager-Terry P/L}
{\nofcharsws3233}{\vern89}}\margl1440\margr1440 \widowctrl\ftnbj\aenddoc\hyphcaps0\viewkind1\viewscale75 \fet0\sectd \psz1\linex0\sectdefaultcl {\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang
{\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang{\pntxta )}}{\*\pnseclvl5\pndec\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang
{\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl8\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}\pard\plain
\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright \fs20\cgrid {\b\f1\fs28\ul\cf1\cgrid0 H:\\data\\database\\medrec.mdb}{\b\f11\fs28\ul\cgrid0 \tab }{\b\f1\fs28\ul\cf1\cgrid0 Monday, November 28, 2005
\par
\par }\pard\plain \s15\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright \b\i\f1\fs28\cf1 The tables storing all the data is {Data_Script_Items} and {Data_Script_}Item_Dates, all the others are look up tables that don\rquote
t grow that big. The script saves data by patterns hence tables don\rquote t really ever grow that big.
\par \pard\plain \nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright \fs20\cgrid {\b\f1\fs28\cf1\cgrid0
\par Table: data_script_AIA
\par }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
\par }\pard\plain \s1\keepn\nowidctlpar\tx735\tx5055\tqr\tx8439\outlinelevel0\adjustright \f1\cf1 Comment::Displays list of Australian authority indications for drug
\par \pard\plain \widctlpar\adjustright \fs20\cgrid {
\par }\pard \nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs28\cgrid0 \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Authority_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
Indication}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Memo}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 -\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 valid}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 1\line }{\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Display_Indications
\par }{\f11\fs28\cgrid0 \tab
\par }{\f1\fs24\cgrid0 Comment: generated on the fly to display indications for restricted drug use
\par }{\f11\fs28\cgrid0 \line \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Indication}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Memo}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 -\line }{\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Instruction_Habits
\par
\par }{\f1\fs24\cgrid0 Comment:: used to \lquote auto-fill\rquote script with most likely way drug usually used on per Dr basis
\par }{\f11\fs28\cgrid0 \line \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Instruction_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Drug}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 100\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Doctor_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 2\line }{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Formulation}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 60\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Weighting}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line
\par \page
\par }{\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Instructions
\par }{\f11\fs28\cgrid0 \tab
\par \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
Instruction_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Instruction}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0
\tab }{\f1\fs28\cf1\cgrid0 60\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Unit_time}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 AM}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 5\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Lunch}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 5\line
}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 PM}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 5\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Bed}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 5\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 PRN}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Byte)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line
\par }{\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Item_Dates}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 \line }{\f11\fs28\cgrid0 \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 ScriptDate_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Start_Date}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Date/Time}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 8\line }{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Last_Date}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Date/Time}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 8\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Consult_Last_Prescribed}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Deleted}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line
\par \page }{\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Items}{\f11\fs28\cgrid0 \tab
\par
\par }{\f1\fs24\cf1\cgrid0 Comment: This is the main data table for patients prescription information. Note this is mainly pointers to other tables hence data storage is extremely economical
\par }{\f1\fs28\cf1\cgrid0 \line }{\f11\fs28\cgrid0 \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 ScriptItem_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Consult_ID}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4
\par \tab Brand_ID\tab Number (Long) 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Rx_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Instruction_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 PrescribedFor_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 ScriptDate_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Authority_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Print_Status}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Suppress_Reason}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line }{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Repeats}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Integer)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 2\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Quantity}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Number (Integer)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 2\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Incr_Quantity_via_Auth}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
1\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 S8}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Current_Medication}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Deleted}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line }{
\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Prescribed_For}{\f11\fs28\cgrid0 \tab
\par }{\f1\fs28\cf1\cgrid0
\par }{\f1\fs24\cgrid0 Comment: used to \lquote auto-fill\rquote script with most likely condition drug prescribed for
\par
\par }{\f11\fs28\cgrid0 \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns
\par }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 PrescribedFor_ID}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Prescribed_For}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 50\line }{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Ozcode}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line
\par \page
\par
\par
\par }{\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Prescribed_for_Habits
\par
\par }{\f1\fs24\cgrid0 Comment: used to \lquote auto-fill\rquote script with most likely condition drug prescribed for}{\f11\fs28\cgrid0 \tab
\par
\par \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
PrescribedFor_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Drug}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 100\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Doctor_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 2\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 weighting}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \line }{\f1\fs28\cf1\cgrid0 }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_RxDetails
\par }{\f11\fs28\cgrid0 \tab
\par }{\f1\fs24\cgrid0 Comment: This is a \lquote pattern table\rquote
, here of generic drug name + usual formation etc. Note this means in practice that the table never gets terribly big. When patients drug is recorded it uses the Rx_ID from here, and Brand_ID from next table and saved to }{\f1\fs24\cf1\cgrid0
Data_Script_Items
\par }{
\par }{\f11\fs28\cgrid0 \tab }{\b\f1\fs28\ul\cf1\cgrid0 Columns\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Type}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Size\line }{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Rx_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Brand_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number(long)}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Generic}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 255\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
Active}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 50\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Active_units}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 20\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 per_volume}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 20\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 per_vol_units}{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 20\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 unit_volume}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0
20\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 unit_vol_units}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 20\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Formulation}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 60\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 ClassCodes}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 50\line }{
\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Section}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Integer)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 2\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 SubSection}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line }{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Valid}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line }{\f11\fs28\cgrid0
\tab }{\f1\fs28\cf1\cgrid0 Weighting}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number (Long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line
\par }{\b\f1\fs28\cf1\cgrid0 Table: Data_Script_Brands
\par }{\f1\fs28\cf1\cgrid0 \tab Brand_ID}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Number(long)}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 4\line \tab Brand_Name}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Text}{\f11\fs28\cgrid0 \tab }{
\f1\fs28\cf1\cgrid0 50\line \tab Deleted}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 Yes/No}{\f11\fs28\cgrid0 \tab }{\f1\fs28\cf1\cgrid0 1\line
\par }}_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
