I'm going into a legacy database to pull data and I'm having some problems (ODBC -connection to "rmsprod" failed.).  The name of the database is ~ORMSDBS97A.  This database was owned by an employee that is no longer with Enron.  Problem is that Jeff Gossett's team, Kathy Reeve's team, John Postlethwaite's team, Stacey White's team and Global ops used this database to query for daily reporting regarding traders VAR.  Either we need front end that can save query out for front end or we need a similar database for NETCO.  I'm neutral, however I think a similar database hook up would be quicker than front end solution.

Also, have Jeff and Stacey been able to create the benchmark report on test portfolio's?
Frank


 -----Original Message-----
From: 	Hare, Bill D.  
Sent:	Sunday, January 13, 2002 3:40 PM
To:	Hare, Bill D.; Sanvido, Terry; Brackett, Debbie R.; Hayden, Frank; Jaquet, Tammy; McLaughlin Jr., Errol; Moorer, Torrey; Rodriguez, Bernice; Sweitzer, Tara; Theriot, Kim S.; Winfree, O'Neal D.; Dupuy, Mark; Gillis, Brian; Heal, Kevin; McKeel, Richard; Reeves, Kathy; Seib, Dianne; Vander velde, Nikole; Anderson, Diane; Bowen, Bob; Campos, Sylvia A.; Garcia, Clarissa; Hilliard, Marlene; Hunter, Larry Joe; Price, Wade R.; Richardson, Stacey; Schrab, Mark L.; Severson, Russ; Spears, Christopher; Sullivan, Patti; Wallumrod, Ellen; Wynne, Rita; Chitradurga, Sundar; Cinelli, Steve; Elwood, Richard; Franks, Shawn; Greig, Iain; Harmon, Kenneth M.; Hunter, Wade; Johnson, Jeff; Nolte, Ron; Ramesh, Ganapathy; Saleem, Aftab; Allen, Thresa A.; Aucoin, Evelyn; Bentley, Corry; Clemons, Amy; Dahlke, Andrea; Denton, Rhonda L.; Evans, Casey; Robinson, Rhonda; Stevens, Mechelle; Pena, Matt; Schomer, Chris; Rao, Ramesh; Henry, Jane Hilburn; Warner, John; Rodriguez, Bernice; Smith, Regan M.
Subject:	RE: Estate Testing Sunday

I have confirmed the Customer Number in Global Counterparty is 3000022659.

Bill

 -----Original Message-----
From: 	Hare, Bill D.  
Sent:	Sunday, January 13, 2002 1:52 PM
To:	Hare, Bill D.; Sanvido, Terry; Brackett, Debbie R.; Hayden, Frank; Jaquet, Tammy; McLaughlin Jr., Errol; Moorer, Torrey; Rodriguez, Bernice; Sweitzer, Tara; Theriot, Kim S.; Winfree, O'Neal D.; Dupuy, Mark; Gillis, Brian; Heal, Kevin; McKeel, Richard; Reeves, Kathy; Seib, Dianne; Vander velde, Nikole; Anderson, Diane; Bowen, Bob; Campos, Sylvia A.; Garcia, Clarissa; Hilliard, Marlene; Hunter, Larry Joe; Price, Wade R.; Richardson, Stacey; Schrab, Mark L.; Severson, Russ; Spears, Christopher; Sullivan, Patti; Wallumrod, Ellen; Wynne, Rita; Chitradurga, Sundar; Cinelli, Steve; Elwood, Richard; Franks, Shawn; Greig, Iain; Harmon, Kenneth M.; Hunter, Wade; Johnson, Jeff; Nolte, Ron; Ramesh, Ganapathy; Saleem, Aftab; Allen, Thresa A.; Aucoin, Evelyn; Bentley, Corry; Clemons, Amy; Dahlke, Andrea; Denton, Rhonda L.; Evans, Casey; Robinson, Rhonda; Stevens, Mechelle; Pena, Matt; Schomer, Chris; Rao, Ramesh; Henry, Jane Hilburn; Warner, John; Rodriguez, Bernice; Smith, Regan M.
Subject:	RE: Estate Testing Sunday

I have confirmed the Vendor Number in Global Counterparty is 3000024197,  we are still waiting for the SAP Customer Job to complete.

Bill  

 -----Original Message-----
From: 	Hare, Bill D.  
Sent:	Sunday, January 13, 2002 9:44 AM
To:	Sanvido, Terry; Brackett, Debbie R.; Hare, Bill D.; Hayden, Frank; Jaquet, Tammy; McLaughlin Jr., Errol; Moorer, Torrey; Rodriguez, Bernice; Sweitzer, Tara; Theriot, Kim S.; Winfree, O'Neal D.; Dupuy, Mark; Gillis, Brian; Heal, Kevin; McKeel, Richard; Reeves, Kathy; Seib, Dianne; Vander velde, Nikole; Anderson, Diane; Bowen, Bob; Campos, Sylvia A.; Garcia, Clarissa; Hilliard, Marlene; Hunter, Larry Joe; Price, Wade R.; Richardson, Stacey; Schrab, Mark L.; Severson, Russ; Spears, Christopher; Sullivan, Patti; Wallumrod, Ellen; Wynne, Rita; Chitradurga, Sundar; Cinelli, Steve; Elwood, Richard; Franks, Shawn; Greig, Iain; Harmon, Kenneth M.; Hunter, Wade; Johnson, Jeff; Nolte, Ron; Ramesh, Ganapathy; Saleem, Aftab; Allen, Thresa A.; Aucoin, Evelyn; Bentley, Corry; Clemons, Amy; Dahlke, Andrea; Denton, Rhonda L.; Evans, Casey; Robinson, Rhonda; Stevens, Mechelle; Pena, Matt; Schomer, Chris; Rao, Ramesh; Henry, Jane Hilburn; Warner, John; Rodriguez, Bernice; Smith, Regan M.
Subject:	Estate Testing Sunday

I have completed the setup of the two Counterparties with the exception of SAP ID's.  I am waiting for the SAP run to complete and will resend this message with the SAP Customer and Vendor Numbers when the SAP job completes.
Bill
  I have setup two External Counterparties for the Estate Test today (Sunday) as follows: 
	1) CP ID#167032 
	- External Gas/Power 1 (with good credit) 
	- Address Number 193019 
	- SAP Customer ID   [Bill D. Hare]  3000022659
	- SAP Vendor ID  3000024197    
	- 1 wire will be shared; Partner Bank Niumber 0011 
	- ERMS Code; EXTERNALGAS1W 
	- Financial Link 
	- Power-Houston Link 
	- Person Contact Link; Test Estate 
	- Operational Effective Date; 12/01/2001 
	- Fax Number; 713-646-8876 
	- Address Roles 
	ENA 
	o Financial Invoice, Financial Payment, Financial Confirm 
	o Natural Gas Physical Invoice, Natural Gas Physical Payment, Natural Gas Physical Confirmation 
	o Power Financial Invoice, Power Financial Payment, Power Financial Confirmation 
	o Service Physical Invoice, Service Physical Payment 
	EPMI 
	o Power Physical Invoice, Power Physical Payment, Power Physical Confirmation 

	2) CP ID# 167034 
	- External Gas/Power 2 (with Bad credit) 
	- ERMS Code; EXTERNALGAS2PW