21 Apr 2001, 03:23 UTC
=?ANSI_X3.4-1968?Q?RE:_APPROVED:_ENPOWER_(VOLUME=3FMANAGEMENT=3FSYS?= =?ANSI_X3.4-1968?Q?TEM,_CR#397)_-_Alter_Cp=5FCharge=5FHeader_table.?=
- From
- Charlene Fricker charlene.fricker@enron.com
- Date
- Fri, 20 Apr 2001 20:23:00 -0700 (PDT)
Implemented in PWRDEVN, PWRTESTN, and PWRTESTP. --Charlene x53487
Quoted or forwarded from earlier messages
> -----Original Message----- > From: Yu, Emily Y. > Sent: Friday, April 20, 2001 9:31 AM > To: Fricker, Charlene; Invedy, Tantra > Cc: 'enron-la@razorfish.com'; Docwra, Anna; > 'jim.meyer@razorfish.com' > Subject: APPROVED: ENPOWER (VOLUME MANAGEMENT SYSTEM, CR#397) - > Alter Cp_Charge_Header table. > > > ------------------------------------------------------------------- > ENPOWER, VOLUME MANAGEMENT SYSTEM, CR# 397 > Ref: ENPOWER, VMS, CR#397 > ------------------------------------------------------------------- > Charlene, > The database change has been APPROVED for implementation in PWRDEVN, > PWRTEST, PWRTESTP. > > The DBA, Charlene Fricker, will send an email notification when the > change has been completed. > > If you have any comments or questions, or need additional changes, > please contact Emily Yu at x30538. > > Proposed Implementation Date: 04/20/2001. > > Business Overview: > Alter Cp_Charge_Header table. > 1. Add column Interchange_Id, varchar2(40 ), null. > > The source of the data in the Interchange Id column is a market-given > sub-location field. BUT, it is also used for coordinating a > wheel-through import/export schedule pair. For some other charge > codes, it is not used (NULL). It is never generated by VMS itself, but > merely passed from the Schedule Interface. > > To view the DB Change DOCUMENT, click on the following link: > http://hrweb.enron.com/crserver/dart/report/reportViewer.asp?id1=ENPOW > ER&id2=VMS&id3=397&rptType=CR&rptName=RPT_CR_DOC > > To view the DB Change Document DIAGRAM, click on the following link: > http://dart.enron.com/file/fileView.asp?id1=ENPOWER&id2=VMS&id3=397 > >