{\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 }}