NOTICE_EXTRACTS_WHOLESALE Archives

Notice_Extracts_Wholesale

NOTICE_EXTRACTS_WHOLESALE@LISTS.ERCOT.COM
Options: Use Forum View

Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
R-A100411-03 REMINDER: Reports and Extracts - File Naming Convention Changes
From:
ERCOT Client Services <[log in to unmask]>
Date:
Fri, 28 Oct 2011 14:44:23 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (7 kB) , text/html (35 kB) 
NOTICE DATE:  October 28, 2011

NOTICE TYPE:  R-A100411-03 REMINDER: Reports and Extracts

SHORT DESCRIPTION:  Report Changes - Mapping Status Reject Report and 867 RCSO Report

INTENDED AUDIENCE:  LSEs and TDSPs

DAY AFFECTED:  Monday, October 31, 2011

LONG DESCRIPTION:  In support of the Texas Market Link (TML) decommission efforts and to be more consistent with all current Market Information System (MIS) postings, ERCOT is implementing a file naming convention change to the following two reports.
Mapping Status Reject Report:
Current filename:  rpt.(06-29-2010 06:01:52 ).MSRej_0629060001.csv
New filename:  rpt.00000217.16digitduns.yyyymmdd.HHMMSS.MSReject.csv

867 Received on Cancelled Service Orders (RCSO) Report:
Current filename:  rpt.(06-25-2010 12:07:14 ).867RCSO_06252010.csv
New filename:  rpt.00000226.16digitduns.yyyymmdd.HHMMSS.867RCSO.csv

In addition to the file naming convention changes above, the 867 RCSO report will include the changes listed below:

The following column names will be abbreviated:


*         Service Order Status will be reflected as SO Status

*         Service Order Sub-Status will be reflected as SO Sub-Status

*         Scheduled Meter Read Date will be reflected as SMRD

*         Blank Columns will be removed

The record add times for the report currently captures data from Friday 00:00:00 through Friday at 23:59:59.  Beginning with the October 31 posting, the data set will contain data from Sunday at 00:00:00 through Saturday at 23:59:59. The report will continue to post weekly on Mondays by 13:00.

ADDITIONAL INFORMATION:  The Mapping Status Reject and 867 Received on Cancelled Service Orders reports are both located on the Markets Tab/Retail Landing Page in the Certified Reports and Extracts portlet on the MIS.

CONTACT:  If you have any questions, please contact your ERCOT Account Manager.  You may also call the general ERCOT Client Services phone number at (512) 248-3900 or contact ERCOT Client Services via email at [log in to unmask]<mailto:[log in to unmask]>.
If you are receiving email from an ERCOT distribution list that you no longer wish to receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.
JR/DH

From: ERCOT Client Services
Sent: Friday, October 21, 2011 9:30 AM
To: [log in to unmask]; [log in to unmask]
Cc: [log in to unmask]; [log in to unmask]; [log in to unmask]; 1 ERCOT Client Service Reps
Subject: R-A100411-02 REMINDER: Reports and Extracts - File Naming Convention Changes


NOTICE DATE:  October 21, 2011

NOTICE TYPE:  R-A100411-02 REMINDER: Reports and Extracts

SHORT DESCRIPTION:  Report Changes - Mapping Status Reject Report and 867 RCSO Report

INTENDED AUDIENCE:  LSEs and TDSPs

DAY AFFECTED:  Monday, October 31, 2011

LONG DESCRIPTION:  In support of the Texas Market Link (TML) decommission efforts and to be more consistent with all current Market Information System (MIS) postings, ERCOT is implementing a file naming convention change to the following two reports.
Mapping Status Reject Report:
Current filename:  rpt.(06-29-2010 06:01:52 ).MSRej_0629060001.csv
New filename:  rpt.00000217.16digitduns.yyyymmdd.HHMMSS.MSReject.csv

867 Received on Cancelled Service Orders (RCSO) Report:
Current filename:  rpt.(06-25-2010 12:07:14 ).867RCSO_06252010.csv
New filename:  rpt.00000226.16digitduns.yyyymmdd.HHMMSS.867RCSO.csv

In addition to the file naming convention changes above, the 867 RCSO report will include the changes listed below:

The following column names will be abbreviated:


*         Service Order Status will be reflected as SO Status

*         Service Order Sub-Status will be reflected as SO Sub-Status

*         Scheduled Meter Read Date will be reflected as SMRD

*         Blank Columns will be removed

The record add times for the report currently captures data from Friday 00:00:00 through Friday at 23:59:59.  Beginning with the October 31 posting, the data set will contain data from Sunday at 00:00:00 through Saturday at 23:59:59. The report will continue to post weekly on Mondays by 13:00.

ADDITIONAL INFORMATION:  The Mapping Status Reject and 867 Received on Cancelled Service Orders reports are both located on the Markets Tab/Retail Landing Page in the Certified Reports and Extracts portlet on the MIS.

CONTACT:  If you have any questions, please contact your ERCOT Account Manager.  You may also call the general ERCOT Client Services phone number at (512) 248-3900 or contact ERCOT Client Services via email at [log in to unmask]<mailto:[log in to unmask]>.
If you are receiving email from an ERCOT distribution list that you no longer wish to receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.
DP/DG


From: ERCOT Client Services
Sent: Tuesday, October 04, 2011 10:40 AM
To: [log in to unmask]; [log in to unmask]
Cc: [log in to unmask]; [log in to unmask]; [log in to unmask]; 1 ERCOT Client Service Reps
Subject: R-A100411-01: Reports and Extracts - File Naming Convention Changes


NOTICE DATE:  October 4, 2011

NOTICE TYPE:  R-A100411-01: Reports and Extracts

SHORT DESCRIPTION: Report Changes - Mapping Status Reject Report and 867 RCSO Report

INTENDED AUDIENCE:  LSEs and TDSPs

DAY AFFECTED:  Monday, October 31, 2011

LONG DESCRIPTION:  In support of the Texas Market Link (TML) decommission efforts and to be more consistent with all current Market Information System (MIS) postings, ERCOT is implementing a file naming convention change to the following two reports.
Mapping Status Reject Report:
Current filename:  rpt.(06-29-2010 06:01:52 ).MSRej_0629060001.csv
New filename:  rpt.00000217.16digitduns.yyyymmdd.HHMMSS.MSReject.csv

867 Received on Cancelled Service Orders (RCSO) Report:
Current filename:  rpt.(06-25-2010 12:07:14 ).867RCSO_06252010.csv
New filename:  rpt.00000226.16digitduns.yyyymmdd.HHMMSS.867RCSO.csv

In addition to the file naming convention changes above, the 867 RCSO report will include the changes listed below:

The following column names will be abbreviated:


*         Service Order Status will be reflected as SO Status

*         Service Order Sub-Status will be reflected as SO Sub-Status

*         Scheduled Meter Read Date will be reflected as SMRD

*         Blank Columns will be removed

The record add times for the report currently captures data from Friday 00:00:00 through Friday at 23:59:59.  Beginning with the October 31 posting, the data set will contain data from Sunday at 00:00:00 through Saturday at 23:59:59. The report will continue to post weekly on Mondays by 13:00.

ADDITIONAL INFORMATION:  The Mapping Status Reject and 867 Received on Cancelled Service Orders reports are both located on the Markets Tab/Retail Landing Page in the Certified Reports and Extracts portlet on the MIS.

CONTACT:  If you have any questions, please contact your ERCOT Account Manager.  You may also call the general ERCOT Client Services phone number at (512) 248-3900 or contact ERCOT Client Services via email at [log in to unmask]<mailto:[log in to unmask]>.
If you are receiving email from an ERCOT distribution list that you no longer wish to receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.
JR/DP

############################

To unsubscribe from the NOTICE_EXTRACTS_WHOLESALE list:
write to: mailto:[log in to unmask]
or click the following link:
http://lists.ercot.com/SCRIPTS/WA-ERCOT.EXE?SUBED1=NOTICE_EXTRACTS_WHOLESALE&A=1

ATOM RSS1 RSS2