Please change the connection in Access to estrmsp_ded from rmsprod_ded or rmsprod.
 
Some of the issues have been addressed in the data grabber part of the web site and in RisktRAC. This effort was started in September and yet to be completed. 
 
It is prefered to have one source of data going out to all, instead of multiple copies of the Access database. We welcome feedback - and reasonable time to incorporate these changes into the web functionality
 
This group did not design the Access database. In fact, I personally have not even seen it. We will be in the midst of NETCO test database setup, NETCO data cleanup, user creations, RisktRAC migration, Web migration and Unix migration to the new hardware next week. If we have the time, we will certainly help in correcting issues related to the Access database.
 
Regards,
Ramesh
 
 

-----Original Message----- 
From: Hayden, Frank 
Sent: Sun 1/13/2002 4:39 PM 
To: Hare, Bill D.; Sanvido, Terry; Brackett, Debbie R.; White, Stacey W.; Gossett, Jeffrey C.; Reeves, Kathy; Postlethwaite, John; Ramesh, Ganapathy 
Cc: 
Subject: RE: Estate Testing Sunday



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