duplicates

Tue, 28 Sep 2004 13:19:15 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C4A587.A9551A59
Content-Type: text/plain;
	charset="iso-8859-1"

Hi,

I am running a Quiz extract and I am using the SET NODUPLICATES command.
However, I am getting duplicates anyhow. What might I be doing wrong?

To clarify further, I run an extract with claim detail information. The
claim detail information has the treating physician's FEIN. I access the
subfile that is created and link it to our physician file to get detailed
physician info. There could be multiple entries in the claim file for each
physician obviously, but I was hoping they would not be duplicated in my
physician detail extract. Actually, it works for all but one physician (this
is a small sample only). I checked that database and do not have duplicates
in the physician table.

Thanks,
-Kristina
Ext. 2459

------_=_NextPart_001_01C4A587.A9551A59
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C4A55D.C0841640">
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:DrawingGridHorizontalSpacing>2.85 =
pt</w:DrawingGridHorizontalSpacing>
  =
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>=

 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
@font-face
	{font-family:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:647 0 0 0 159 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
span.EmailStyle15
	{mso-style-type:personal-compose;
	mso-ansi-font-size:10.0pt;
	mso-ascii-font-family:"Century Gothic";
	mso-hansi-font-family:"Century Gothic";
	mso-bidi-font-family:Arial;
	color:#333399;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
</head>

<body lang=3DEN-US style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Hi,<o:p></o:p></spa=
n></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

I
am running a Quiz extract and I am using the SET NODUPLICATES command. =
However,
I am getting duplicates anyhow. What might I be doing =
wrong?<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

To
clarify further, I run an extract with claim detail information. The =
claim
detail information has the treating physician&#8217;s FEIN. I access =
the subfile that
is created and link it to our physician file to get detailed physician =
info. There
could be multiple entries in the claim file for each physician =
obviously, but I
was hoping they would not be duplicated in my physician detail extract. =
Actually,
it works for all but one physician (this is a small sample only). I =
checked
that database and do not have duplicates in the physician =
table.<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Thanks,<o:p></o:p><=
/span></font></span></p>

<p class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail=20
Signature&quot; <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><=
span
class=3DEmailStyle15><font size=3D2 color=3D"#333399"><span =
style=3D'font-size:10.0pt;
mso-bidi-font-size:12.0pt'>-Kristina<o:p></o:p></span></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Ext.
2459</span></font></span><font color=3D"#333399"><span =
style=3D'color:#333399;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><font
color=3D"#333399"><span style=3D'color:#333399'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

</div>

</body>

</html>

------_=_NextPart_001_01C4A587.A9551A59--