Message-ID: <23767908.1075845332386.JavaMail.evans@thyme>
Date: Fri, 23 Mar 2001 12:18:00 -0800 (PST)
From: yan.wang@enron.com
To: tara.piazze@enron.com, nate.blackburn@enron.com, matt.smith@enron.com, 
	justin.o'malley@enron.com
Subject: Duplicate DRN descriptions
Cc: chris.gaskill@enron.com, colin.tonks@enron.com, eddie.zhang@enron.com, 
	chris.hyde@enron.com, jay.reitmeyer@enron.com, lindon.chiu@enron.com, 
	kim.alexander@enron.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Bcc: chris.gaskill@enron.com, colin.tonks@enron.com, eddie.zhang@enron.com, 
	chris.hyde@enron.com, jay.reitmeyer@enron.com, lindon.chiu@enron.com, 
	kim.alexander@enron.com
X-From: Yan Wang <Yan Wang/ENRON@enronXgate>
X-To: Tara Piazze <Tara Piazze/NA/Enron@ENRON>, Nate Blackburn <Nate Blackburn/NA/Enron@Enron>, Matt Smith <Matt Smith/NA/Enron@ENRON>, Justin O'Malley <Justin O'Malley/NA/Enron@ENRON>
X-cc: Chris Gaskill <Chris Gaskill/Corp/Enron@Enron>, Colin Tonks <Colin Tonks/ENRON@enronXgate>, Eddie Zhang <Eddie Zhang/ENRON@enronXgate>, Chris Hyde <Chris Hyde/ENRON@enronXgate>, Jay Reitmeyer <Jay Reitmeyer/HOU/ECT@ECT>, Lindon Chiu <Lindon Chiu/ENRON@enronXgate>, Kim d Alexander <Kim d Alexander/ENRON@enronXgate>
X-bcc: 
X-Folder: \Smith, Matt\Smith, Matt\Inbox
X-Origin: SMITH-M
X-FileName: Smith, Matt.pst

All:

As you all know that the DRN within a pipeline should be unique, the DRN_description should be too. Otherwise
it will cause aggregation errors in our reports, values with the same DRN_description within a pipeline are all summed 
together. I have created a query called qry_Mulri_DRN_Names in the Access database O:\Fundy_ops\ReportSetting.mdb (Access 2000),
You can run this query to find out how many duplicates there are, and which pipeline they are. If you entered those duplicates,
you can work with Hyde or Eddie to have them corrected. Please also pay special attention when you enter new DRN and their 
descriptions. The rule is No Duplicate DRN or DRN descriptions are allowed within the same pipeline.
When in doubt, you can always run the query mentioned above to check duplicates. 

Let me know if you have questions. Thanks.


Yan x33228