ISO New England - ss

ss_genericss

Generic Standard Settlement

Current Status
Report Name	Change Summary	Effective Date	Description	Template	Sample
ss_genericss	Existing. This is not an actual report file. This is only a sample generic file showing all columns being populated. It is used as a guide when creating Standard Settlement files.	03.01.2008	PDF	XLTX	CSV

SS_GENERICSS - Generic Standard Settlement Report - Rev 0 SS_<report_name>_<customer id>_<settlement date>_<version>.CSV Date: mm/dd/yyyy and Version: mm/dd/yyyy hh:mm:ss GMT Availability: Determined by associated market service
REPORT COLUMN	DESCRIPTION
CALCULATION
Trading Date	Specific period for which the data is reported in form MM/DD/YYYY.
Trading Interval	Specific hour for which the information is reported. Numeric from 1 - 24 (For daylight-saving crossover days: the long day extra hour = 02X, the short day removes hour 02).
DUNS Number	Number used to identify the "entity responsible for the customer's bill".
DUNS Name	Name associated with DUNS Number.
Asset ID	Numerical identifier for the asset.
Asset Name	Name of the asset.
Location ID	Numerical identifier for the location related to the specific standard settlement item.
Location Name	Name of the location.
Calculation Description	Description of the calculation.
Rate	Rate associated with Total Asset Dollars.
Quantity	Quantity associated with Total Asset Dollars.
Total Asset Dollars	Total dollars calculated for the asset, as determined by the specific standard settlement item.
Allocation Share	Percentage of the asset for which the customer is responsible, as determined by the specific standard settlement item.
Customer Dollars	Total dollars calculated for the customer, as determined by the specific standard settlement item.
Comments	Comments associated with each record, as determined by the specific standard settlement item.
ALLOCATION
Trading Date	Specific period for which the data is reported in form MM/DD/YYYY.
Trading Interval	Specific hour for which the information is reported. Numeric from 1 - 24 (For daylight-saving crossover days: the long day extra hour = 02X, the short day removes hour 02).
DUNS Number	Number used to identify the "entity responsible for the customer's bill".
DUNS Name	Name associated with DUNS Number.
Asset ID	Numerical identifier for the asset.
Asset Name	Name of the asset.
Location ID	Numerical identifier for the location related to the specific standard settlement item.
Location Name	Name of the location.
Allocation Description	Detail of the method used to distribute dollars associated with the specific standard settlement item.
Total Allocation Factor	Sum of the customer allocation factor(s).
Customer Allocation Factor	Customer value as determined by the method used to distribute dollars associated with the specific standard settlement item.
Total Dollars	Sum of the calculated credits or charges being allocated.
Customer Dollars	(Customer Allocation Factor/Total Allocation Factor) x Total Dollars
Comments	Comments associated with each record, as determined by the specific standard settlement item.

Current Status

SS_GENERICSS - Generic Standard Settlement Report - Rev 0