{\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;}{\f16\froman\fcharset238\fprq2 Times New Roman CE;}{\f17\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f19\froman\fcharset161\fprq2 Times New Roman Greek;}
{\f20\froman\fcharset162\fprq2 Times New Roman Tur;}{\f21\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f22\fswiss\fcharset238\fprq2 Arial CE;}{\f23\fswiss\fcharset204\fprq2 Arial Cyr;}{\f25\fswiss\fcharset161\fprq2 Arial Greek;}
{\f26\fswiss\fcharset162\fprq2 Arial Tur;}{\f27\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{
\nowidctlpar\widctlpar\adjustright \fs20\cgrid \snext0 Normal;}{\*\cs10 \additive Default Paragraph Font;}}{\info{\author Dr R Terry}{\operator Dr R Terry}{\creatim\yr2003\mo4\dy7\hr8\min43}{\revtim\yr2003\mo4\dy7\hr8\min50}{\version2}{\edmins7}
{\nofpages1}{\nofwords174}{\nofchars994}{\*\company R Houtzaager-Terry}{\nofcharsws1220}{\vern71}}\paperw11904\paperh16836\margl1440\margr1440 \widowctrl\ftnbj\aenddoc\hyphcaps0\viewkind4\viewscale100 \fet0\sectd \psz9\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 \sb120\nowidctlpar\tx90\tqr\tx8640\adjustright \fs20\cgrid {\f1\fs16\cf1\cgrid0 H:\\data\\database\\medrec.mdb}{\f11\fs24\cgrid0 \tab }{
\f1\fs16\cf1\cgrid0 Monday, April 07, 2003}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx90\tqr\tx8640\adjustright {\f1\fs16\cf1\cgrid0 Table: Data_Allergies}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Page: 1}{\b\f1\fs21\ul\cf1\cgrid0 
\par }\pard \sb120\nowidctlpar\tx735\tx5055\tx7287\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Name}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Type}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Size}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb58\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Allergy_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Long)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 4}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Attributes: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Fixed Size, Auto-Increment}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Consult_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Long)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 4}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 points to date last  recorded}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Consult_First_Noted}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Long)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 4}{\f1\fs21\cf1\cgrid0 

\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 points to date first recorded}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 ClaDesc}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 50}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 mims class description 'kept because could change exact wording}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 ClaCode}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Integer)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 2}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 mims class code}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Drug}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 75}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 mims brand name noted with allergy}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Generic}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 255}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 generic names}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Reaction}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 255}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 description of the clinical reaction}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Type}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 0 = mrDrug_Allergy 1 = mrDrug_Sensitivity defaults to 0
\par }{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0          }{\f1\fs16\cf1\cgrid0 Definate}{\f11\fs24\cgrid0 \tab                                    }{\f1\fs16\cf1\cgrid0 Yes/No}{\f11\fs24\cgrid0 \tab                                                                }{\f1\fs16\cf1\cgrid0 1
}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 if yes the allergy is certain}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f1\fs16\cf1\cgrid0             Generic_Specific_Reaction}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Yes/No}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 if yes specific to that drug}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0         }{\f1\fs16\cf1\cgrid0 Ozcode}{\f11\fs24\cgrid0 \tab        }{\f1\fs16\cf1\cgrid0 Number (Long)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 4}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 disease code}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb200\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Deleted}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Yes/No}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx1455\tx3615\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description: }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 If true the record has been marked deleted from patients record by user}{\f1\fs21\cf1\cgrid0 
\par }{\cgrid0 \tab }{\f1\fs21\cf1\cgrid0 
\par }}