[Sqg-program] QA tips for SQG program
Perrigan, Glen
Glen.Perrigan@dep.state.fl.us
Tue, 1 Apr 2003 10:06:30 -0500
This is a multi-part message in MIME format.
------_=_NextPart_001_01C2F860.466F991C
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Attached are instructions put together by Irene a couple of years ago. =
This
is the process she uses when checking the data each year. Not all of =
this
will apply. Use the "check data" function on the main screen of the sqg
program database. Also use "count of facilities report" under the =
"summary
report" in the main screen. There are others reports under summary =
reports
that will be helpful. Check them out.=20
=20
Also under reindex and validate in the main screen you can check for =
possible
duplicate data (warning: this could take some time so be prepared). =
Also,
don't forget to look at the sqg program reference cd. There are sops for =
data
management that will be helpful. Glen
=20
Instructions for Processing County SQG database disks
6/21/00
Irene Gleason
=20
1. READ COVER LETTER AND INSERT DISK
Check letter for assessment role number (how many SQG facilities in =
county)
and verification number (number of facilities verified - via phone and
on-site visits). If numbers aren't given contact county program
administrator).
Ensure disk label has county name, SQG program, and the year on it.=20
=20
2. RUN VIRUS SCAN
Run the scan with a current version of McAfee or some other virus =
protection
software. Don't want bugs!
=20
3. UNZIP FILE
Open the file from the A: drive with WinZip. Three files should unzip.
Extract these 3 files to Network Neighborhood/Perrigan_g/sqg. Close =
WinZip.
=20
4. CHECK AND LOAD DATA
Open SQG database. Right click on DEP egret. Choose Run (r) Check (r) =
Errors
(r) File (r) Yes (print headers). Enter county name for file name =
(limit 8
characters). Use network neighborhood desk top icon to open the file =
that
was just created. It will be in Perrigan_g/sqg under the county name as =
a
.txt file. If any "odd" errors (check with Glenn for definition of odd) =
are
found print and attach to county's letter.
=20
Go back to SQG database (should be back behind the egret). Choose Run =
(r)
Load (r) Errors (r) File (r) Yes (print headers). Enter county name for =
file
name and the number 1 (again limit to 8 characters). Use network =
neighborhood
desk top icon to open the file that was just created. It will be in
Perrigan_g/sqg under the county name with a #1 following as a .txt file. =
If
any "odd" errors are found print and attach to county's letter. Exit =
to
main screen with egret.
=20
5. REINDEX AND REVALIDATE
Choose Reindex/Revalidate (r) Yes(r) Quit and NOT Update Any Data. =20
=20
6. SUMMARY REPORT
Choose Summary Report (r) Count of Facilities. Enter amount assessed =
(on
county letterhead). Pick Location County by using drop down screen and =
enter
6/1/1999 and today's date for Verification Date Range. =
Save/Continue(r)
Preview the Output (r) Print Now (r) Screen (r) Yes (deleted records
included). If numbers on the report differ from number given on cover
letter note that in the spreadsheet.
=20
7. LOG IN SPREADSHEET
Open Excel spreadsheet from Network Neighborhood/Perrigan_g/sqg. The =
file
should be the only Excel spreadsheet in the directory. Enter the =
assessment
role and the verification numbers from the letter. If the verification
number in the database differs from what was given on the letter note =
that
difference by putting the database number in parenthesis as an attached =
not
to the cell. Also note in the cell how many of the verifications were
on-site and how many were phone contacts.=20
=20
=20
-----Original Message-----
From: Page_Cook@doh.state.fl.us [mailto:Page_Cook@doh.state.fl.us]=20
Sent: Wednesday, March 26, 2003 9:22 AM
To: sqg-program@lists.dep.state.fl.us
Subject: [Sqg-program] QA tips for SQG program
=09
=09
Does anyone have any tips on QA'ing the SQG database data prior to
sending it to DEP? Anything written to help organize the process or any
suggestions that can be offered would be appreciated.
Thanks-=20
Paige Cook=20
Palm Beach County=20
------_=_NextPart_001_01C2F860.466F991C
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D734575514-01042003>Attached are instructions put together by =
Irene a=20
couple of years ago. This is the process she uses when checking the data =
each=20
year. Not all of this will apply. Use the "check data" function on the =
main=20
screen of the sqg program database. Also use "count of facilities =
report" under=20
the "summary report" in the main screen. There are others reports under =
summary=20
reports that will be helpful. Check them out. </SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D734575514-01042003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D734575514-01042003>Also=20
under reindex and validate in the main screen you can check for possible =
duplicate data (warning: this could take some time so be prepared). =
Also, don't=20
forget to look at the sqg program reference cd. There are sops for data=20
management that will be helpful. Glen</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D734575514-01042003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D734575514-01042003>
<H1 style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times New Roman" =
color=3D#000000=20
size=3D5>Instructions for Processing County SQG database =
disks</FONT></H1>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times =
New Roman"=20
color=3D#000000>6/21/00</FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times =
New Roman"=20
color=3D#000000>Irene Gleason</FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><?xml:namespace =
prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:p><FONT face=3D"Times New =
Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><B=20
style=3D"mso-bidi-font-weight: normal"><FONT face=3D"Times New =
Roman"><FONT=20
color=3D#000000>1.<SPAN=20
style=3D"mso-tab-count: =
1"> &nbs=
p;=20
</SPAN>READ COVER LETTER AND INSERT =
DISK<o:p></o:p></FONT></FONT></B></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times =
New Roman"=20
color=3D#000000>Check letter for assessment role number (how many SQG =
facilities=20
in county) and verification number (number of facilities verified =
– via phone=20
and on-site visits).<SPAN style=3D"mso-spacerun: yes"> </SPAN>If =
numbers=20
aren’t given contact county program administrator).</FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times =
New Roman"=20
color=3D#000000>Ensure disk label has county name, SQG program, and the =
year on=20
it. </FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in; mso-list: l0 =
level1 lfo1; tab-stops: list .5in"><FONT=20
face=3D"Times New Roman"><FONT color=3D#000000><B=20
style=3D"mso-bidi-font-weight: normal"><SPAN style=3D"mso-list: =
Ignore">2.<SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'">  =
; =20
</SPAN></SPAN></B><B style=3D"mso-bidi-font-weight: normal">RUN VIRUS=20
SCAN</B></FONT></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times =
New Roman"=20
color=3D#000000>Run the scan with a current version of McAfee or some =
other virus=20
protection software.<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>Don’t want=20
bugs!</FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in; mso-list: l0 =
level1 lfo1; tab-stops: list .5in"><FONT=20
face=3D"Times New Roman"><FONT color=3D#000000><B=20
style=3D"mso-bidi-font-weight: normal"><SPAN style=3D"mso-list: =
Ignore">3.<SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'">  =
; =20
</SPAN></SPAN></B><B style=3D"mso-bidi-font-weight: normal">UNZIP=20
FILE</B></FONT></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times =
New Roman"=20
color=3D#000000>Open the file from the A: drive with WinZip.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>Three files should unzip.<SPAN =
style=3D"mso-spacerun: yes"> </SPAN>Extract these 3 files to =
Network=20
Neighborhood/Perrigan_g/sqg.<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>Close=20
WinZip.</FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal=20
style=3D"MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in; mso-list: l0 =
level1 lfo1; tab-stops: list .5in"><FONT=20
face=3D"Times New Roman"><FONT color=3D#000000><B=20
style=3D"mso-bidi-font-weight: normal"><SPAN style=3D"mso-list: =
Ignore">4.<SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'">  =
; =20
</SPAN></SPAN></B><B style=3D"mso-bidi-font-weight: normal">CHECK AND =
LOAD=20
DATA</B></FONT></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT =
color=3D#000000><FONT=20
face=3D"Times New Roman">Open SQG database. Right click on DEP =
egret.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>Choose <I=20
style=3D"mso-bidi-font-style: normal">Run </I></FONT><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Check </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Errors </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> File </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Yes</FONT></I><FONT face=3D"Times New Roman"> =
(print=20
headers).<SPAN style=3D"mso-spacerun: yes"> </SPAN>Enter county =
name for=20
file name (limit 8 characters).<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>Use network neighborhood desk top icon to open the file that was =
just=20
created.<SPAN style=3D"mso-spacerun: yes"> </SPAN>It will be in=20
Perrigan_g/sqg under the county name as a .txt file.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>If any “odd” =
errors (check with Glenn=20
for definition of odd) are found print and attach to county’s=20
letter.</FONT></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT =
color=3D#000000><FONT=20
face=3D"Times New Roman">Go back to SQG database (should be back behind =
the=20
egret).<SPAN style=3D"mso-spacerun: yes"> </SPAN>Choose <I=20
style=3D"mso-bidi-font-style: normal">Run </I></FONT><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Load </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Errors </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> File </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Yes</FONT></I><FONT face=3D"Times New Roman"> =
(print=20
headers).<SPAN style=3D"mso-spacerun: yes"> </SPAN>Enter county =
name for=20
file name and the number 1 (again limit to 8 characters). Use network=20
neighborhood desk top icon to open the file that was just created.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>It will be in Perrigan_g/sqg =
under the=20
county name with a #1 following as a .txt file.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>If any “odd” =
errors<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>are found print and attach to =
county’s=20
letter.<SPAN style=3D"mso-spacerun: yes"> </SPAN>Exit to main =
screen with=20
egret.</FONT></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><B=20
style=3D"mso-bidi-font-weight: normal"><FONT face=3D"Times New Roman"=20
color=3D#000000>5.<SPAN=20
style=3D"mso-tab-count: =
1"> &nbs=
p;=20
</SPAN>REINDEX AND REVALIDATE</FONT></B></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT =
color=3D#000000><FONT=20
face=3D"Times New Roman">Choose <I=20
style=3D"mso-bidi-font-style: normal">Reindex/Revalidate</I> </FONT><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN></I><FONT=20
face=3D"Times New Roman"> <I style=3D"mso-bidi-font-style: =
normal">Yes</I></FONT><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Quit and NOT Update Any Data</FONT></I><FONT=20
face=3D"Times New Roman">.<SPAN style=3D"mso-spacerun: yes"> =20
</SPAN></FONT></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><B=20
style=3D"mso-bidi-font-weight: normal"><FONT face=3D"Times New Roman"=20
color=3D#000000>6.<SPAN=20
style=3D"mso-tab-count: =
1"> &nbs=
p;=20
</SPAN>SUMMARY REPORT</FONT></B></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT =
color=3D#000000><FONT=20
face=3D"Times New Roman">Choose <I style=3D"mso-bidi-font-style: =
normal">Summary=20
Report </I></FONT><I style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Count of Facilities.</FONT></I><FONT=20
face=3D"Times New Roman"><SPAN style=3D"mso-spacerun: yes"> =
</SPAN>Enter=20
amount assessed (on county letterhead).<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>Pick Location County by using drop down screen and enter 6/1/1999 =
and=20
today’s date for Verification Date Range.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN><I=20
style=3D"mso-bidi-font-style: normal">Save/Continue</I></FONT><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Preview the Output </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Print Now </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Screen </FONT></I><I=20
style=3D"mso-bidi-font-style: normal"><SPAN=20
style=3D"FONT-FAMILY: Symbol; mso-ascii-font-family: 'Times New Roman'; =
mso-hansi-font-family: 'Times New Roman'; mso-char-type: symbol; =
mso-symbol-font-family: Symbol"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Symbol">®</SPAN></SPAN><FONT=20
face=3D"Times New Roman"> Yes </FONT></I><FONT face=3D"Times New =
Roman">(deleted=20
records included).<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>If numbers=20
on the report differ from number given on cover letter note that in the=20
spreadsheet.</FONT></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><B=20
style=3D"mso-bidi-font-weight: normal"><FONT face=3D"Times New Roman"=20
color=3D#000000>7.<SPAN=20
style=3D"mso-tab-count: =
1"> &nbs=
p;=20
</SPAN>LOG IN SPREADSHEET</FONT></B></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3D"Times =
New Roman"=20
color=3D#000000>Open Excel spreadsheet from Network=20
Neighborhood/Perrigan_g/sqg.<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>The=20
file should be the only Excel spreadsheet in the directory.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>Enter the assessment role and =
the=20
verification numbers from the letter.<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>If the verification number in the database differs from what was =
given on=20
the letter note that difference by putting the database number in =
parenthesis as=20
an attached not to the cell.<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>Also=20
note in the cell how many of the verifications were on-site and how many =
were=20
phone contacts. </FONT></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT =
face=3D"Times New Roman"=20
color=3D#000000> </FONT></o:p></P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
Page_Cook@doh.state.fl.us [mailto:Page_Cook@doh.state.fl.us] =
<BR><B>Sent:</B>=20
Wednesday, March 26, 2003 9:22 AM<BR><B>To:</B>=20
sqg-program@lists.dep.state.fl.us<BR><B>Subject:</B> [Sqg-program] QA =
tips for=20
SQG program<BR><BR></FONT></DIV>
<P><FONT face=3DArial size=3D2>Does anyone have any tips on QA'ing the =
SQG=20
database data prior to sending it to DEP? Anything written to =
help=20
organize the process or any suggestions that can be offered would be=20
appreciated.</FONT></P>
<P><FONT face=3DArial size=3D2>Thanks-</FONT> <BR><FONT face=3DArial =
size=3D2>Paige=20
Cook</FONT> <BR><FONT face=3DArial size=3D2>Palm Beach County</FONT>=20
</P></BLOCKQUOTE></BODY></HTML>
=00
------_=_NextPart_001_01C2F860.466F991C--