1 / 2

Settlement & Billing Extract

Settlement & Billing Extract. Interchanged Fields. Settlement & Billing Extract. Migration Timeline 09/21/2006 – Production Migration of changes to PR 40042_06 Lodestar Batch Extracts 09/22/2006 – Production Stabilization begin date

noah-lowe
Download Presentation

Settlement & Billing Extract

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Settlement & Billing Extract Interchanged Fields 01/09/2007

  2. Settlement & Billing Extract • Migration Timeline • 09/21/2006 – Production Migration of changes to PR 40042_06 Lodestar Batch Extracts • 09/22/2006 – Production Stabilization begin date • 09/22/2006 – 10/22/2006 – Market testing/review of stabilization files • 11/10/2006 – Go live • 11/11/2006 – First set of Load, Generation and Settlement & Billing extracts produced from ODS • Interchanged columns • All Settlement & Billing Extracts posted 11/14 - 11/19 (no extracts run/posted 11/11-11/13 to introduce lag) had the Generation_Unit_Code and Transaction_Date fields interchanged in the Settlement_Interval CSV file. • Generation_Unit_Code is stored as VARCHAR(64) and Transaction_Date is stored as DATE. Therefore, when the Generation_Unit_Code attempted to insert into the Transaction_Date field, the record would fail to load into the database. • Issue not found in internal or market testing. • This data is sent to QSEs representing generation. • Logic corrected prior to the production of this extract on 11/20/2006 using DDL version 10, which was posted on 10/14/2002. 01/09/2007

More Related