{\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{\widctlpar\adjustright 
\fs20\cgrid \snext0 Normal;}{\*\cs10 \additive Default Paragraph Font;}{\s15\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright \f1\fs20\cf1 \sbasedon0 \snext15 Body Text;}}{\info{\author R Terry}{\operator R Terry}{\creatim\yr2004\mo7\dy18\hr17\min44}
{\revtim\yr2004\mo7\dy18\hr18\min4}{\version2}{\edmins19}{\nofpages3}{\nofwords499}{\nofchars2849}{\*\company R Houtzaager-Terry P/L}{\nofcharsws3498}{\vern113}}\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 \sb120\nowidctlpar\tx90\tqr\tx8640\adjustright \fs20\cgrid {\f1\fs16\cf1\cgrid0 C:\\
MEDREC\\DATA\\medrec.mdb}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Sunday, July 18, 2004}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx90\tqr\tx8640\adjustright {\f1\fs16\cf1\cgrid0 Table: Data_Recall_Reviews}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Page: 1}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb653\nowidctlpar\tx90\adjustright {\f11\fs24\cgrid0 \tab }{\b\f1\fs16\ul\cf1\cgrid0 Columns}{\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 Review_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\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 }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Doctor_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 8}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Method_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Length_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Type_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Long)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 4
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 50}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Interval}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Integer)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 2}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Unit_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Integer)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 2}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 End}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Integer)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 2}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Last_Date}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Date/Time}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 8}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Trigger_recall}{\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 Trigger_period}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Trigger_Method}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Memo}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 50}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Dealt_With}{\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 Overdue}{\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 Deleted}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Yes/No}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1
\par 
\par }\pard\plain \s15\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright \f1\fs20\cf1 {(ideally one shouldn\rquote t need a desc}r{iption} field, {as the recall description should be part of a the coding system } and pointed to by the description_ID, {\endash 
 I origianally intended to use this method but reverted to just savin}g the description of the recall due to immature coding systems)
\par 
\par \pard \s15\nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright This table was a hybrid, as when I designed the program I allowed active problems to have a review-interval set \endash  ie that if one had hypertension, then one could get the 
system to remind you the BP should be checked every 6 months etc. In practice I found this approach whilst theoretically sound, to be a pain in the bum and difficult to police/mark off/co-ordinate. This is where the trigger-stuff came in which I do
nt use at all).{
\par }\pard\plain \sb120\nowidctlpar\tx90\tqr\tx8640\adjustright \fs20\cgrid {\f11\fs24\cgrid0 
\par (This is used by the recalls maintenance program  and is generated on the fly. (the nurse does this and  sends out the recalls etc \endash  the program simply brings up a grid of recalls due and you can click on them and do things (see the png\rquote s I
\rquote ve attatched).
\par 
\par }{\f1\fs16\cf1\cgrid0 C:\\MEDREC\\DATA\\medrec.mdb}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Sunday, July 18, 2004}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx90\tqr\tx8640\adjustright {\f1\fs16\cf1\cgrid0 Table: Data_Recalls_General_Due}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Page: 2}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb653\nowidctlpar\tx90\adjustright {\f11\fs24\cgrid0 \tab }{\b\f1\fs16\ul\cf1\cgrid0 Columns}{\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 Due}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Date/Time}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 8}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Days_Due}{\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 Review_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 }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Patient_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 }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Title}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 3}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 FirstName}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 20}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Surname}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 25}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Street}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 255}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Town/Suburb}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 25}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Postcode}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 4}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Phone_H}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 17}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Age}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 4}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 DOB}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Date/Time}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 8}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Doctor_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 2}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description_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 }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 50}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Length}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 15}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Contact_by}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 15}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Action}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 255}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Action_Date}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Date/Time}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 8}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Action_Memo}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 50}{\f1\fs21\cf1\cgrid0 
\par }{\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 }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 File}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 255}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb120\nowidctlpar\tx90\tqr\tx8640\adjustright {\f11\fs24\cgrid0 
\par }{\f1\fs16\cf1\cgrid0 C:\\MEDREC\\DATA\\medrec.mdb}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Sunday, July 18, 2004}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx90\tqr\tx8640\adjustright {\f1\fs16\cf1\cgrid0 Table: lu_Recall_ReviewLength}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Page: 3}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb653\nowidctlpar\tx90\adjustright {\f11\fs24\cgrid0 \tab }{\b\f1\fs16\ul\cf1\cgrid0 Columns}{\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 Length_ID}{\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\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 15}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb120\nowidctlpar\tx90\tqr\tx8640\adjustright {\f11\fs24\cgrid0 
\par }{\f1\fs16\cf1\cgrid0 C:\\MEDREC\\DATA\\medrec.mdb}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Sunday, July 18, 2004}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx90\tqr\tx8640\adjustright {\f1\fs16\cf1\cgrid0 Table: lu_Recall_ReviewMethod}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Page: 4}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb653\nowidctlpar\tx90\adjustright {\f11\fs24\cgrid0 \tab }{\b\f1\fs16\ul\cf1\cgrid0 Columns}{\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 Method_ID}{\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\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 15}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb120\nowidctlpar\tx90\tqr\tx8640\adjustright {\f11\fs24\cgrid0 
\par }{\f1\fs16\cf1\cgrid0 C:\\MEDREC\\DATA\\medrec.mdb}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Sunday, July 18, 2004}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx90\tqr\tx8640\adjustright {\f1\fs16\cf1\cgrid0 
\par }{\f1\cf1\cgrid0 (This table is redundent in this database as previously mentioned above \endash  it flagged the entry in the recalls table as either a true recall, or a opportunistic review.)
\par }{\f1\fs16\cf1\cgrid0 
\par Table: lu_Recall_ReviewType}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Page: 5}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb653\nowidctlpar\tx90\adjustright {\f11\fs24\cgrid0 \tab }{\b\f1\fs16\ul\cf1\cgrid0 Columns}{\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 ReviewType_ID}{\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\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 10}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb120\nowidctlpar\tx90\tqr\tx8640\adjustright {\f11\fs24\cgrid0 
\par This  next table was used to learn how often to recall things eg if the description was Annual Checkup, it learned the default interval was 12/12 etc. If the user put in stuff they reviewed eg Carotid Doppler, the system took the 
first review interval to be the default interval, and in theory kept an eye on this type of review to present the most commonly used interval for this type of review.
\par 
\par }{\f1\fs16\cf1\cgrid0 C:\\MEDREC\\DATA\\medrec.mdb}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Sunday, July 18, 2004}{\f1\fs21\cf1\cgrid0 
\par }\pard \nowidctlpar\tx90\tqr\tx8640\adjustright {\f1\fs16\cf1\cgrid0 Table: lu_RecallFor}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Page: 6}{\f1\fs21\cf1\cgrid0 
\par }\pard \sb653\nowidctlpar\tx90\adjustright {\f11\fs24\cgrid0 \tab }{\b\f1\fs16\ul\cf1\cgrid0 Columns}{\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 Description_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\tx735\tx5055\tqr\tx8439\adjustright {\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Description}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Text}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 50}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Default_interval}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Integer)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 2}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Default_Interval_Units}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Default_Appointment_length_ID}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 Number (Byte)}{\f11\fs24\cgrid0 \tab }{\f1\fs16\cf1\cgrid0 1}{\f1\fs21\cf1\cgrid0 
\par }}